1.MyBatis优点
(1)封装了JDBC大部分操作,减少了开发人员的工作量
(2)半自动化的操对于编写SQL语句灵活度更高
(3)Java代码与SQL语句分离,降低维护难度
(4)自动映射结果集,减少重复的编码工作
(5)开源社区十分活跃,文档齐全,学习成本低
2.引入MyBatis依赖
在pom.xml文件中添加MyBatis的场景启动器mybatis-spring-boot-starter
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
3.填写配置文件application.properties
配置Mapper文件对应的XML文件路径
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
4.启动类增加Mapper扫描
在启动类中添加对Mapper包的扫描@MapperScan,Spring Boot在启动的时候会自动加载包路径下的Mapper接口。代码如下所示:
@SpringBootApplication
@MapperScan("ltd.newbee.mall.dao") //添加@Mapper注解
public class NewbeeMallApplication {
//启动spring应用
public static void main(String[] args) {
SpringApplication.run(NewbeeMallApplication.class, args);
}
}
也可以直接在每个Mapper接口上面添加@Mapper注解。但是如果Mapper接口数量较多,在每个Mapper接口上加注解是比较烦琐的。
5.Spring Boot整合MyBatis进行数据库的增、删、改、查
5.1创建测试表
SQL语句如下:
DROP TABLE IF EXISTS tb_user;
CREATE TABLE tb_user (
id int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
name varchar(100) NOT NULL DEFAULT '' COMMENT '登录名',
password varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8;
insert into tb_user (id,name,password)
value (1,'C','123456'),
(2,'C++','123456'),
(3,'Java','123456'),
(4,'Python','123456'),
(5,'R','123456'),
(6,'C#','123456');
5.2创建实体类
根据建的数据库一一对应在entity包下创建一个实体类User中,代码如下:
public class User {
private Integer id;
private String name;
private String password;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
5.3创建Mapper接口
新建dao包并在dao包中新建UserDao接口,并定义增删改查四个方法,代码如下:
package ltd.newbee.mall.dao;
import ltd.newbee.mall.entity.User;
import java.util.List;
public interface UserDao {
/**
* 返回数据列表
*
* @return
*/
List<User> findALLUsers();
/**
* 添加
*
* @param User
* @return
*/
int insertUser(User user);
/**
* 修改
*
* @param User
* @return
*/
int updUser(User user);
/**
* 删除
*
* @param id
* @return
*/
int delUser(Integer id);
}
5.4创建Mapper接口的映射文件
在resources目录下新建mapper目录,并在mapper目录下新建Mapper接口的映射文件UserMapper.xml,再进行映射文件的编写。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--定义映射文件与Mapper接口的对应关系。将UserMapper.xml文件与对应的UserDao接口类之间的关系定义出来-->
<mapper namespace="ltd.newbee.mall.dao.UserDao">
<!--配置表结构和实体类的对应-->
<resultMap type="ltd.newbee.mall.entity.User" id = "UserResult">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="password" column="password"/>
</resultMap>
<!--按照对应的接口方法,编写增、删、改、查方法的具体SQL语句-->
<select id="findALLUser" resultMap="UserResult">
select id,name,password from tb_user order by id desc
</select>
<insert id="insertUser" parameterType="ltd.newbee.mall.entity.User">
insert into tb_user(name, password) VALUES (#{name},#{password})
</insert>
<update id="updUser" parameterType="ltd.newbee.mall.entity.User">
update tb_user set name=#{name},password=#{password} where id=#{id}
</update>
<delete id="delUser" parameterType="int">
delete from tb_user where id=#{id}
</delete>
</mapper>
5.5编写controller类对MyBatis进行功能测试
package ltd.newbee.mall.controller;
import ltd.newbee.mall.dao.UserDao;
import ltd.newbee.mall.entity.User;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
public class MyBatisController {
@Resource
UserDao userDao;
//查询所有记录
@GetMapping("/users/mybatis/queryALL")
public List<User> queryALL(){
return userDao.findALLUsers();
}
//新增一条记录
@GetMapping("/users/mybatis/insert")
public Boolean insert(String name,String password){
if (StringUtils.isEmpty(name)||StringUtils.isEmpty(password)){
return false;
}
User user = new User();
user.setName(name);
user.setPassword(password);
return userDao.insertUser(user) > 0;
}
//修改一条记录
@GetMapping("/users/mybatis/update")
public Boolean update(Integer id,String name,String password){
if (id==null||id<1||StringUtils.isEmpty(name)||StringUtils.isEmpty(password)){
return false;
}
User user = new User();
user.setId(id);
user.setName(name);
user.setPassword(password);
return userDao.updUser(user) >0;
}
//删除一条记录
@GetMapping("/users/mybatis/delete")
public Boolean delete(Integer id){
if (id==null||id<1){
return false;
}
return userDao.delUser(id) >0;
}
}
5.6测试结果
5.6.1增
http://localhost:8080/users/mybatis/insert?name=quiz&password=1234567
返回true
数据库新增成功
5.6.2删
http://localhost:8080/users/mybatis/delete?id=7
返回true
数据库删除成功
5.6.3改
http://localhost:8080/users/mybatis/update?id=2&name=update&password=654321
返回true
数据库修改成功
5.6.4查
http://localhost:8080/users/mybatis/queryALL
返回下图