有时候做方案，需要模拟一些业务上的一些场景来验证方案的可行性，基本上每次都是到处百度如何集成springboot+mybatis+thymeleaf这些东西的集成平时基本上一年也用不了一次，虽然比较简单，奈何我真得记不住详细的每一步，因此每次都是从零开始，我一直在想，把时间浪费在这种重复的事情是没有意义的，所以这篇文章记录一下，以后再也不到处百度来接拼凑了。
springboot中集在mybatis和thymeleaf，简单实现一下新增和查询功能，后续有需要再往上补。
图片
jdk版本:1.8
开发工具：Intellij iDEA 2020.1
springboot:2.3.9.RELEASE
主要引入了springboot、thymeleaf、mybais、mysql、jdbc以及热部署和lombda相关的依赖；
<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-thymeleaf</artifactId></dependency><dependency><groupId>ognl</groupId><artifactId>ognl</artifactId><version>3.1.26</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId><optional>true</optional></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.4</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency>
配置文件这里新增了三处配置，分别是thymeleaf、数据库连接、mybatis;
#thymeleaf配置spring.thymeleaf.cache=falsespring.thymeleaf.suffix=.html spring.thymeleaf.prefix=classpath:/templates/spring.thymeleaf.servlet.content-type=text/html spring.thymeleaf.encoding=utf-8#数据库连接配置spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3307/happy_home?serverTimeznotallow=Asia/Shanghaispring.datasource.username=root spring.datasource.password=root#mybatis配置mybatis.mapper-locatinotallow=classpath:/mapper/*.xml mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
图片
前端代码
1、resources/static目录下，新增静态文件index.html;
<!DOCTYPE html><html lang="en"><head><metacharset="UTF-8"><title>Title</title></head><body><divid="testContent"><form id="registeForm"name="registe"method="post"action="/person//registe"enctype="multipart/form-data"target="_self">登陆名：<input name="loginNo"type="text"/><br/>姓名：<input name="userName"type="text"/><br/>性别：<input name="sex"type="radio"value="男"/>男<input name="sex"type="radio"value="女"/>女<br/>手机号码：<input name="phoneNumber"type="text"/><br/>身份证号：<input name="IDCard"type="text"/><br/>地址：<input name="address"type="text"/><br/>门牌号：<input name="houseNumber"type="text"/><br/><inputtype="submit"value="提交"id="submitForm"></form></div></body></html>
2、resources/templates目录上，新增home.html文件；
<!DOCTYPE html><html lang="en"xmlns:th="http://www.thymeleaf.org"><head><metacharset="UTF-8"/><title>主页</title><scripttype="text/javascript"src="https://code.jquery.com/jquery-3.1.1.min.js"></script></head><body><div>ID:<span id="personId"data-th-text="${id}"></span></div><divid="personInfo"><p>登陆名:<span></span></p><p>姓名:<span></span></p><p>性别:<span></span></p><p>手机号码:<span></span></p><p>身份证号:<span></span></p><p>地址:<span></span></p><p>门牌号:<span></span></p></div></body><scripttype="text/javascript">var id=$('#personId').text();$.ajax({
url:'http://localhost:8080/person/'+id,method:'get',success:function(res){
console.log(res)$('#personInfo p')[0].append(res.loginNo);$('#personInfo p')[1].append(res.userName);$('#personInfo p')[2].append(res.sex);$('#personInfo p')[3].append(res.phoneNumber);$('#personInfo p')[4].append(res.idcard);$('#personInfo p')[5].append(res.address);$('#personInfo p')[6].append(res.houseNumber);}
})</script></html>
@Controller@RequestMapping("/person")publicclass PersonController {@Autowiredprivate IPersonService personService;@PostMapping("/registe")publicString registe(Person person,Model model){Integerid=this.personService.registe(person);model.addAttribute("id",id);return"home";}@GetMapping("/{id}")@ResponseBodypublicPerson getPerson(@PathVariable("id")Integerid){
Person person=this.personService.get(id);returnperson;}
}
publicinterface IPersonService {Integerregiste(Person person);Person get(Integerid);}
@Servicepublicclass PersonServiceImpl implements IPersonService {@Autowiredprivate PersonDao personDao;@OverridepublicIntegerregiste(Person person){
this.personDao.insert(person);returnperson.getId();}@OverridepublicPerson get(Integerid){
Person persnotallow=personDao.selectById(id);returnperson;}
}
@Mapperpublicinterface PersonDao {Integerinsert(Person person);Person selectById(Integerid);}
<?xml versinotallow="1.0"encoding="utf-8"?><!DOCTYPE mapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.fanfu.dao.PersonDao"><resultMap id="personMap"type="com.fanfu.entity.Person"><resultcolumn="user_name"property="userName"></result><resultcolumn="login_no"property="loginNo"></result><resultcolumn="sex"property="sex"></result><resultcolumn="phone_number"property="phoneNumber"></result><resultcolumn="address"property="address"></result><resultcolumn="house_number"property="houseNumber"></result><resultcolumn="ID_card"property="IDCard"></result><resultcolumn="id"property="id"></result></resultMap><insertid="insert"parameterType="com.fanfu.entity.Person"keyProperty="id"keyColumn="id"useGeneratedKeys="true">insertintosys_person(user_name,login_no,phone_number,sex,ID_card,address,house_number)values(#{userName}, #{loginNo}, #{phoneNumber}, #{sex}, #{IDCard}, #{address}, #{houseNumber})</insert><selectid="selectById"resultMap="personMap">select*fromsys_personwhereid=#{id}</select></mapper>
@Slf4j@Datapublicclass Person {
privateIntegerid;private String userName;private String loginNo;private String phoneNumber;private String sex;private String IDCard;private String address;private String houseNumber;}