一.環(huán)境準備
我這里用的是
- jdk1.8
- IntelliJ IDEA
- maven 3.3.9
上面環(huán)境安裝及配置請自己百度
二 建庫嗅骄、建表
我用的navicat premium工具手動建的表
建表.jpg
建表sql語句
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` int(15) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
三 編寫代碼
1. 我的項目結構如下：
項目結構.jpg
- lombok插件安裝
lombok插件安裝.jpg
3. application.yml配置文件
server:
port: 80
spring:
datasource:
url: jdbc:mysql://localhost:3306/yourDB?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
username: root
password: XXXX
mybatis:
mapper-locations: classpath:mapping/*.xml
type-aliases-package: com.zlq.demo.pojo
configuration:
map-underscore-to-camel-case: true
logging:
level:
com.zlq.demo: debug
4. maven依賴
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.zlq.dev</groupId>
<artifactId>mybatis-demo-zlq</artifactId>
<version>1.0.0-SNAPSHOT</version>
<!--添加spring-boot-starter-parent主要是統(tǒng)一版本管理胳挎，通常的依賴不用鞋<version></version>-->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.6.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--不用引入jdbc依賴了，此依賴默認包含spring-boot-starter-jdbc-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.1</version>
</dependency>
<!--web項目-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--省了寫getter/setter toString 構造函數和equals hashCode等-->
<!--idea需要裝lombok插件掸读，idea插件安裝請百度-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.8</version>
</dependency>
<!--測試環(huán)境-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
</dependencies>
</project>
5. 實體類 User
//@Data lombok插件帶的注解（不用寫getter/setter toString等）
//@NoArgsConstructor 無參構造函數
//@AllArgsConstructor
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User implements Serializable{
private String id;
private String name;
private String password;
private String address;
}
6. Dao層 User接口 UserDao
//帶上這個注解spring boot啟動類上就不用帶@MapperScan了
@Mapper
public interface UserDao {
//通過id查詢用戶
public User get(String id);
//查詢所用用戶
public List<User> findAll();
//修改用戶信息串远，通過id
public int update(User user);
//增加用戶信息
public int insert(User user);
//刪除用戶
public int delete(String id);
}
7. Service層 UserService
@Service
public class UserService {
@Autowired
private UserDao userDao;
//通過id查詢用戶
public User get(String id) {
return userDao.get(id);
}
//查詢所用用戶
public List<User> findAll() {
return userDao.findAll();
}
//增加用戶
public int insert(User user) {
return userDao.insert(user);
}
//更新用戶
public int update(User user) {
return userDao.update(user);
}
//刪除用戶
public int delete(String id) {
return userDao.delete(id);
}
}
8. Controller層 UserController
@RestController
@RequestMapping("user")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("{user_id}")
public User getUser(@PathVariable("user_id") String id){
return userService.get(id);
}
@GetMapping
public List<User> findAllUser(){
return userService.findAll();
}
@PostMapping
public int addUser(@RequestBody User user){
return userService.insert(user);
}
@PutMapping
public int updateUser(@RequestBody User user){
return userService.update(user);
}
@DeleteMapping("{id}")
public int deleteUser(@PathVariable("id") String id){
return userService.delete(id);
}
}
9. UserMapper.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.zlq.demo.dao.UserDao">
<select id="get" parameterType="string" resultType="user">
SELECT id,name,password,address
FROM t_user WHERE id=#{id}
</select>
<select id="findAll" resultType="user">
SELECT id,name,password,address FROM t_user
</select>
<update id="update" parameterType="user">
UPDATE t_user
<set>
<if test="name!= null">
name = #{name},
</if>
<if test="password!= null">
password = #{password},
</if>
<if test="address!= null">
address = #{address},
</if>
</set>
WHERE id = #{id}
</update>
<insert id="insert" parameterType="user" useGeneratedKeys="true" keyProperty="id">
INSERT INTO t_user
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null and id != ''">
id,
</if>
<if test="name!= null">
name,
</if>
<if test="password!= null">
password,
</if>
<if test="address!= null">
address,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null and id != ''">
#{id},
</if>
<if test="name!= null">
#{name},
</if>
<if test="password!= null">
#{password},
</if>
<if test="address!= null">
#{address},
</if>
</trim>
</insert>
<delete id="delete" parameterType="string">
DELETE FROM t_user WHERE id=#{id}
</delete>
</mapper>
到這里基礎環(huán)境和項目已經搞定。
四 項目測試
1. 用idea自帶的restful工具測試
restful測試工具.jpg
2.增加一個用戶
添加用戶.jpg
成功增加一條數據
成功執(zhí)行添加一條數據.jpg
其它接口也都能運行儿惫，就不一 一測試澡罚。
OK！搞定手工肾请！
拜拜留搔！
