1,必要的依賴(lài)：

<parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.0.0.RELEASE</version></parent><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><!-- 指定一下jdk的版本 ，這里我們使用jdk 1.8 ,默認(rèn)是1.6 --><java.version>1.8</java.version></properties><!-- spring-boot-starter-web: MVC,AOP的依賴(lài)包.... --><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter</artifactId></dependency><!-- 測(cè)試 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>1.1.1</version></dependency><!-- mysql 依賴(lài) --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency>
</dependencies> ?

?

2, mysql 數(shù)據(jù)庫(kù) testdb 下有張user 表：

3，表對(duì)應(yīng)的實(shí)體類(lèi):

import lombok.Data;
@Data //相當(dāng)于@Setter @Getter public class User {private int id;private String username;private String sex;private Date birthday;private String address; }

4,mapper 接口(dao)

??

package com.baiyue.mappers;import java.util.List; import java.util.Map; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import com.baiyue.entity.User;public interface UserMapper {void insertUser(User user);User selectUserById(int id);List<User> selectAllUser();// 模糊查詢(xún)的List<User> selectUserNameLike(String username);List<User> selectByName(String username);void deleteUserById(int id);// 多參數(shù) 傳遞方式1// public void updateUserById(@Param("id")int id,@Param("username")String// username);// 多參數(shù) 傳遞方式2void updateUserById(Map<String, Object> map);// 使用注解 字符串替換 不用寫(xiě)根據(jù)id查 根據(jù)username查 根據(jù)address 查@Select("select * from user where ${column} = #{value}")List<User> findByColumn(@Param("column") String column, @Param("value") String value);// resultMap 結(jié)果映射 只想輸出部分的屬性User selectUserByIdMap(int id);// 動(dòng)態(tài)sql SELECT * FROM testdb.user where username='Linda' and sex='male';List<User> selectUsers(Map<String, String> map);void update(String username, String sex, int age);}

5，mapper.xml

<?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.baiyue.mappers.UserMapper"><!-- 根據(jù) id 查詢(xún) user 表中的數(shù)據(jù) id:唯一標(biāo)識(shí)符，此文件中的id值不能重復(fù) resultType:返回值類(lèi)型，一條數(shù)據(jù)庫(kù)記錄也就對(duì)應(yīng)實(shí)體類(lèi)的一個(gè)對(duì)象 parameterType:參數(shù)類(lèi)型，也就是查詢(xún)條件的類(lèi)型 --><select id="selectUserById" resultType="User" parameterType="int"><!-- 這里和普通的sql 查詢(xún)語(yǔ)句差不多，對(duì)于只有一個(gè)參數(shù)，后面的 #{id}表示占位符，里面不一定要寫(xiě)id,寫(xiě)啥都可以，但是不要空著，如果有多個(gè)參數(shù)則必須寫(xiě)pojo類(lèi)里面的屬性 -->select * from user where id = #{id}</select><insert id="insertUser" parameterType="com.baiyue.entity.User">insert intouser(id,username,sex,birthday,address)value(#{id},#{username},#{sex},#{birthday},#{address})</insert><select id="selectAllUser" resultType="com.baiyue.entity.User">select * from user</select><select id="selectUserNameLike" parameterType="java.lang.String"resultType="com.baiyue.entity.User">select * from user where username like '%${value}%'</select><select id="selectByName" parameterType="java.lang.String"resultType="com.baiyue.entity.User">select * from user where username = #{username}</select><delete id="deleteUserById" parameterType="int">delete from user whereid=#{id}</delete><update id="updateUserById" parameterType="java.util.Map">update user setusername=#{username} where id=#{id}</update><!-- resultMap --><resultMap id="userResultMap" type="com.baiyue.entity.User"><id property="id" column="id" /><result property="username" column="username" /><result property="address" column="address" /></resultMap><select id="selectUserByIdMap" resultMap="userResultMap"parameterType="int"><!-- 數(shù)據(jù)庫(kù)address 對(duì)應(yīng)address_city -->select id,username,address from user where id =#{id}</select><select id="selectUsers" resultType="com.baiyue.entity.User" parameterType="java.util.Map" >select * from user where username =#{username}<if test="sex != female">AND sex =#{sex}</if></select></mapper>

6,配置文件鏈接mapper 和 mapper.xml

spring:datasource:url: jdbc:mysql://127.0.0.1:3306/testdbusername: rootpassword: 123456driver-class-name: com.mysql.jdbc.Driver# mybatis mybatis:mapper-locations: classpath:com/baiyue/mapping/*Mapper.xmltype-aliases-package: com.baiyue.entity

7, service 層

package com.baiyue.service;import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;import com.baiyue.entity.User; import com.baiyue.mappers.UserMapper; import com.github.pagehelper.PageInfo;@Service public class UserService {@Autowiredprivate UserMapper userMapper;public void insertUser(User user) {userMapper.insertUser(user);};public User selectUserById(int id) {User user = userMapper.selectUserById(id);return user;};public List<User> selectAllUser() {List<User> list = userMapper.selectAllUser();return list;};// 模糊查詢(xún)的public List<User> selectUserNameLike(String username) {List<User> list = userMapper.selectUserNameLike(username);return list;};public List<User> selectByName(String username) {List<User> list = userMapper.selectByName(username);return list;};public void deleteUserById(int id) {userMapper.deleteUserById(id);};// 多參數(shù) 傳遞方式1// public void updateUserById(@Param("id")int id,@Param("username")String// username);// 多參數(shù) 傳遞方式2public void updateUserById(Map<String, Object> map) {userMapper.updateUserById(map);};// 使用注解 字符串替換 不用寫(xiě)根據(jù)id查 根據(jù)username查 根據(jù)address 查List<User> findByColumn(String column, String value) {List<User> list = userMapper.findByColumn(column, value);return list;};// resultMap 結(jié)果映射 只想輸出部分的屬性public User selectUserByIdMap(int id) {User user = userMapper.selectUserByIdMap(id);return user;};// 動(dòng)態(tài)sql SELECT * FROM testdb.user where username='Linda' and sex='male';public List<User> selectUsers(Map<String, String> map) {List<User> list = userMapper.selectUsers(map);return list;};public void update(String username, String sex, int age) {userMapper.update(username, sex, age);};}

8,controller 層：

@RestController public class Mybatis {@Autowiredprivate UserService userService;@RequestMapping("/insertUser")public String insertUser(){User user = new User();user.setUsername("chris");user.setSex("male");userService.insertUser(user);return "success";}}

7，啟動(dòng)類(lèi),要加上mapper 的掃包：

@SpringBootApplication
@ComponentScan("com.baiyue.*") //因?yàn)橛幸恍゜ean 不在當(dāng)前包或者子包下面，所以@SpringBootApplication 會(huì)有些bean 掃不到 @MapperScan("com.baiyue.mappers") public class App {public static void main(String[] args) {SpringApplication.run(App.class, args);} }

?

在集成mybatis的基礎(chǔ)上，使用分頁(yè)插件：

<!-- springboot 整合 pagehelper --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.2.5</version></dependency>

service 層添加方法：

//使用pageHelper 分頁(yè)插件 page是頁(yè)碼 size 是個(gè)數(shù)public PageInfo<User> selectUserByPagehelper(int page,int size){PageHelper.startPage(page, size);//底層會(huì)將sql 分裝，直接搜索條件中的頁(yè)數(shù)，以及數(shù)量List<User> list = userMapper.selectAllUser(); //前后都是一樣的代碼可以用AOP進(jìn)行封裝PageInfo<User> pageInfo = new PageInfo<>(list);return pageInfo;}

controller 層：

@RequestMapping("/selectUserByPagehelper")public PageInfo<User> selectUserByPagehelper(int page,int size){User user = new User();PageInfo<User> pageInfo = userService.selectUserByPagehelper(page, size);return pageInfo;}

?

轉(zhuǎn)載于:https://www.cnblogs.com/pickKnow/p/11189729.html

總結(jié)

以上是生活随笔為你收集整理的SpringBoot 集成Mybatis的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。