官方文檔: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.4
16.1、整合測試
1、導入 MyBatis 所需要的依賴
<dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.4</version>
</dependency>
2、配置數據庫連接信息(不變)
spring:datasource:username: rootpassword: 123456#?serverTimezone=UTC解決時區的報錯url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8driver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSource#Spring Boot 默認是不注入這些屬性值的,需要自己綁定#druid 數據源專有配置initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true#配置監控統計攔截的filters,stat:監控統計、log4j:日志記錄、wall:防御sql注入#如果允許時報錯 java.lang.ClassNotFoundException: org.apache.log4j.Priority#則導入 log4j 依賴即可,Maven 地址:https://mvnrepository.com/artifact/log4j/log4jfilters: stat,wall,log4jmaxPoolPreparedStatementPerConnectionSize: 20useGlobalDataSourceStat: trueconnectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
MybatisPlus,3、測試數據庫是否連接成功!
4、創建實體類,導入 Lombok!
lombok的maven坐標
<dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.16.12</version>
</dependency>
package com.zy.anquan.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
//@Data 生成getter,setter ,toString等函數
// @NoArgsConstructor 生成無參構造函數
// @AllArgsConstructor //生成全參數構造函數
public class User {private int id;private String name;private String pwd;
}
5、創建mapper目錄以及對應的 Mapper 接口
//@Mapper : 表示本類是一個 MyBatis 的 Mapper
@Mapper
@Repository
public interface UserMapper {List<User> queryUserList();User queryUserById(int id);int addUser(User user);int updateUser(User user);int deleteUser(int id);}
springboot2。6、對應的Mapper映射文件
<?xml version="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.kuang.mapper.DepartmentMapper"><select id="queryUserList" resultType="User">select * from user;</select><select id="queryUserById" resultType="User" parameterType="int">select * from user where id = #{id};</select><insert id="addUser" parameterType="User">insert into user(id,name,pwd) values(#{id},#{name},#{pwd});</insert><update id="updateUser" parameterType="User">update user set name=#{name},pwd=#{pwd} where id=#{id};</update><delete id="deleteUser" parameterType="int">delete from user where id = #{id};</delete>
</mapper>
7、maven配置資源過濾問題
<resources><resource><directory>src/main/java</directory><includes><include>**/*.xml</include></includes><filtering>true</filtering></resource>
</resources>
或者 在yaml中配置
mybatis:type-aliases-package: com.kuang.pojomapper-locations: classpath:/mybatis/mapper/*.xml
8、編寫Controller 進行測試!
@RestController
public class UserController {
@Autowiredprivate UserMapper userMapper;@GetMapping("/queryUserList")public List<User> queryUserList(){List<User> users = userMapper.queryUserList();for (User user : users) {System.out.println(user);}return users;}@GetMapping("/addUser")public String addUser(){userMapper.addUser(new User(6,"阿毛","123456"));return "ok";}@GetMapping("/updateUser")public String udpateUser(){userMapper.updateUser(new User(6,"阿毛","111111"));return "ok";}@GetMapping("/deleteUser")public String deleteUser(){userMapper.deleteUser(5);return "ok";}
}
springboot版本、啟動項目訪問進行測試!
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态