中国纳溪门户网站建设项目环境影响电子商务网站前台建设常用的技术有
前言
有时候做方案，需要模拟一些业务上的一些场景来验证方案的可行性，基本上每次都是到处百度如何集成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=false
spring.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?serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root
#mybatis配置
mybatis.mapper-locations=classpath:/mapper/*.xml
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
前端代码
1、resources/static目录下，新增静态文件index.html;
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><title>Title</title>
</head>
<body>
<div id="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/><input type="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><meta charset="UTF-8"/><title>主页</title><script type="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>
<div id="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>
<script type="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>
后端代码
1、PersonController.java
@Controller
@RequestMapping("/person")
public class PersonController {@Autowiredprivate IPersonService personService;@PostMapping("/registe")public String registe(Person person, Model model) {Integer id = this.personService.registe(person);model.addAttribute("id", id);return "home";}@GetMapping("/{id}")@ResponseBodypublic Person getPerson(@PathVariable("id") Integer id) {Person person = this.personService.get(id);return person;}
}2、IPersonService.java
public interface IPersonService {Integer registe(Person person);Person get(Integer id);
}3、PersonServiceImpl.java
@Service
public class PersonServiceImpl implements IPersonService {@Autowiredprivate PersonDao personDao;@Overridepublic Integer registe(Person person) {this.personDao.insert(person);return person.getId();}@Overridepublic Person get(Integer id) {Person person=personDao.selectById(id);return person;}
}4、PersonDao.java
@Mapper
public interface PersonDao {Integer insert(Person person);Person selectById(Integer id);
}5、PersonMapper.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE mapper PUBLIC "-//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"><result column="user_name" property="userName"></result><result column="login_no" property="loginNo"></result><result column="sex" property="sex"></result><result column="phone_number" property="phoneNumber"></result><result column="address" property="address"></result><result column="house_number" property="houseNumber"></result><result column="ID_card" property="IDCard"></result><result column="id" property="id"></result></resultMap><insert id="insert" parameterType="com.fanfu.entity.Person" keyProperty="id" keyColumn="id" useGeneratedKeys="true">insert into sys_person(user_name, login_no, phone_number, sex, ID_card, address, house_number)values (#{userName}, #{loginNo}, #{phoneNumber}, #{sex}, #{IDCard}, #{address}, #{houseNumber})</insert><select id="selectById" resultMap="personMap">select *from sys_personwhere id = #{id}</select>
</mapper>6、Person.java
@Slf4j
@Data
public class Person {private Integer id;private String userName;private String loginNo;private String phoneNumber;private String sex;private String IDCard;private String address;private String houseNumber;
}