整合MyBatis
官方文档:http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/
Maven仓库地址:https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter/2.1.1
整合测试
1、导入 MyBatis 所需要的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
2、配置数据库连接信息
spring:
datasource:
username: root
password: 123
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8&characterEncoding=utf-8&useUnicode=true&
driver-class-name: com.mysql.cj.jdbc.Driver
#整合mybatis
mybatis:
type-aliases-package: com.xuyuan.pojo
mapper-locations: classpath:/mybatis/mapper/*.xml
3、测试数据库是否连接成功!
4、创建实体类,导入 Lombok!
User.java
package com.xuyuan.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Integer id;
private String name;
private String pwd;
}
5、创建mapper目录以及对应的 Mapper 接口
usermapper。java
package com.xuyuan.mapper;
import com.xuyuan.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface usermapper {
// 获取所有部门信息
List<User> quertList();
//通过id查用户
User queryid(Integer id);
//增
int addUser(User user);
//删
int delete(Integer id);
//改
int updata(User user);
}
6、对应的Mapper映射文件
在resources下创建mybatis 下创建mapper 下创建
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.xuyuan.mapper.usermapper">
<!-- 查全部 -->
<select id="quertList" resultType="User">
select *from mybatis.user
</select>
<!-- 拿id查-->
<select id="queryid" resultType="User">
select *from mybatis.user where id=#{id}
</select>
<!-- 增加-->
<insert id="addUser" parameterType="User">
insert into mybatis.user (id,name,pwd)values (#{id},#{name},#{pwd})
</insert>
<!--删除-->
<delete id="delete" parameterType="User">
delete from mybatis.user where id=#{id}
</delete>
<!--改-->
<update id="updata" parameterType="User">
update mybatis.user set name =#{name},pwd=#{pwd} where id=#{id}
</update>
</mapper>
7、maven配置资源过滤问题
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
8、编写部门的 UserController 进行测试!
package com.xuyuan.controller;
import com.xuyuan.mapper.usermapper;
import com.xuyuan.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.xml.ws.Action;
import java.util.List;
@RestController
public class userController {
@Autowired
private usermapper usermapper;
@GetMapping("/quertList")
public List<User> quertList(){
List<User> userList = usermapper.quertList();
for (User user : userList) {
System.out.println(user);
}
return userList;
}
@GetMapping("/queryid")
public String queryid(){
User queryid = usermapper.queryid(4);
System.out.println(queryid);
return "ok";
}
@GetMapping("/addUser")
public String addUser(){
usermapper.addUser(new User(8,"楠楠","1231"));
return "ok";
}
@GetMapping("/delete")
public String delete(){
usermapper.delete(7);
return "ok";
}
@GetMapping("/updata")
public String updata(){
usermapper.updata(new User(8,"楠楠","1231"));
return "ok";
}
}
上一个项目的实现
我们增加一个员工类再测试下,为之后做准备
1、新建一个pojo类 Employee ;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Employee {
private Integer id;
private String lastName;
private String email;
//1 male, 0 female
private Integer gender;
private Integer department;
private Date birth;
private Department eDepartment; // 冗余设计
}
2、新建一个 EmployeeMapper 接口
//@Mapper : 表示本类是一个 MyBatis 的 Mapper
@Mapper
@Repository
public interface EmployeeMapper {
// 获取所有员工信息
List<Employee> getEmployees();
// 新增一个员工
int save(Employee employee);
// 通过id获得员工信息
Employee get(Integer id);
// 通过id删除员工
int delete(Integer id);
}
3、编写 EmployeeMapper.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.kuang.mapper.EmployeeMapper">
<resultMap id="EmployeeMap" type="Employee">
<id property="id" column="eid"/>
<result property="lastName" column="last_name"/>
<result property="email" column="email"/>
<result property="gender" column="gender"/>
<result property="birth" column="birth"/>
<association property="eDepartment" javaType="Department">
<id property="id" column="did"/>
<result property="departmentName" column="dname"/>
</association>
</resultMap>
<select id="getEmployees" resultMap="EmployeeMap">
select e.id as eid,last_name,email,gender,birth,d.id as did,d.department_name as dname
from department d,employee e
where d.id = e.department
</select>
<insert id="save" parameterType="Employee">
insert into employee (last_name,email,gender,department,birth)
values (#{lastName},#{email},#{gender},#{department},#{birth});
</insert>
<select id="get" resultType="Employee">
select * from employee where id = #{id}
</select>
<delete id="delete" parameterType="int">
delete from employee where id = #{id}
</delete>
</mapper>
4、编写EmployeeController类进行测试
@RestController
public class EmployeeController {
@Autowired
EmployeeMapper employeeMapper;
// 获取所有员工信息
@GetMapping("/getEmployees")
public List<Employee> getEmployees(){
return employeeMapper.getEmployees();
}
@GetMapping("/save")
public int save(){
Employee employee = new Employee();
employee.setLastName("kuangshen");
employee.setEmail("qinjiang@qq.com");
employee.setGender(1);
employee.setDepartment(101);
employee.setBirth(new Date());
return employeeMapper.save(employee);
}
// 通过id获得员工信息
@GetMapping("/get/{id}")
public Employee get(@PathVariable("id") Integer id){
return employeeMapper.get(id);
}
// 通过id删除员工
@GetMapping("/delete/{id}")
public int delete(@PathVariable("id") Integer id){
return employeeMapper.delete(id);
}
}