spingBoot整合mybatis+generator+pageHelper

环境/版本一览：

开发工具：Intellij IDEA 2018.1.4
springboot: 2.0.4.RELEASE
jdk：1.8.0_40
maven:3.3.9
alibaba Druid 数据库连接池：1.1.9

额外功能：

PageHelper 分页插件
mybatis generator 自动生成代码插件

开始搭建：

创建项目：

spingBoot整合mybatis+generator+pageHelper

看一下文件结构：

spingBoot整合mybatis+generator+pageHelper

查看一下pom.xml：

补齐依赖：

按 Ctrl+C 复制代码

项目不使用application.properties文件而使用更加简洁的application.yml文件：
将原有的resource文件夹下的application.properties文件删除，创建一个新的application.yml配置文件，
文件的内容如下：

注意application.yml 要放在resource的一级目录下，否则会找不到，报错。 spingBoot整合mybatis+generator+pageHelper

application.yml

按 Ctrl+C 复制代码

使用mybatis generator 自动生成代码：

配置pom.xml中generator 插件所对应的配置文件 ${basedir}/src/main/resources/generator/generatorConfig.xml

spingBoot整合mybatis+generator+pageHelper

generatorConfig.xml :

按 Ctrl+C 复制代码

点击run-Edit Configurations

spingBoot整合mybatis+generator+pageHelper

运行 :
注意！！！同一张表一定不要运行多次，因为mapper的映射文件中会生成多次的代码，导致报错，切记

spingBoot整合mybatis+generator+pageHelper

最后生成的文件及结构：

spingBoot整合mybatis+generator+pageHelper

UserMapper:

按 Ctrl+C 复制代码

User :

 1 package com.denwgei.springbootmybatis.model;
 2 
 3 import java.util.Date;
 4 
 5 public class User {
 6     private Integer id;
 7 
 8     private Integer userId;
 9 
10     private String userName;
11 
12     private String passWord;
13 
14     private String state;
15 
16     private String type;
17 
18     private Date updateTime;
19 
20     private Date createTime;
21 
22     public Integer getId() {
23         return id;
24     }
25 
26     public void setId(Integer id) {
27         this.id = id;
28     }
29 
30     public Integer getUserId() {
31         return userId;
32     }
33 
34     public void setUserId(Integer userId) {
35         this.userId = userId;
36     }
37 
38     public String getUserName() {
39         return userName;
40     }
41 
42     public void setUserName(String userName) {
43         this.userName = userName == null ? null : userName.trim();
44     }
45 
46     public String getPassWord() {
47         return passWord;
48     }
49 
50     public void setPassWord(String passWord) {
51         this.passWord = passWord == null ? null : passWord.trim();
52     }
53 
54     public String getState() {
55         return state;
56     }
57 
58     public void setState(String state) {
59         this.state = state == null ? null : state.trim();
60     }
61 
62     public String getType() {
63         return type;
64     }
65 
66     public void setType(String type) {
67         this.type = type == null ? null : type.trim();
68     }
69 
70     public Date getUpdateTime() {
71         return updateTime;
72     }
73 
74     public void setUpdateTime(Date updateTime) {
75         this.updateTime = updateTime;
76     }
77 
78     public Date getCreateTime() {
79         return createTime;
80     }
81 
82     public void setCreateTime(Date createTime) {
83         this.createTime = createTime;
84     }
85 }

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.dengwei.day01springboot.dao.UserMapper" >
  <resultMap id="BaseResultMap" type="com.dengwei.day01springboot.model.User" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="user_id" property="userId" jdbcType="INTEGER" />
    <result column="user_name" property="userName" jdbcType="VARCHAR" />
    <result column="pass_word" property="passWord" jdbcType="VARCHAR" />
    <result column="state" property="state" jdbcType="VARCHAR" />
    <result column="type" property="type" jdbcType="VARCHAR" />
    <result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
    <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
  </resultMap>
  <sql id="Base_Column_List" >
    id, user_id, user_name, pass_word, state, type, update_time, create_time
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from user
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from user
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.dengwei.day01springboot.model.User" >
    insert into user (id, user_id, user_name, 
      pass_word, state, type, 
      update_time, create_time)
    values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, 
      #{passWord,jdbcType=VARCHAR}, #{state,jdbcType=VARCHAR}, #{type,jdbcType=VARCHAR}, 
      #{updateTime,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP})
  </insert>
  <insert id="insertSelective" parameterType="com.dengwei.day01springboot.model.User" >
    insert into user
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="userId != null" >
        user_id,
      </if>
      <if test="userName != null" >
        user_name,
      </if>
      <if test="passWord != null" >
        pass_word,
      </if>
      <if test="state != null" >
        state,
      </if>
      <if test="type != null" >
        type,
      </if>
      <if test="updateTime != null" >
        update_time,
      </if>
      <if test="createTime != null" >
        create_time,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="userId != null" >
        #{userId,jdbcType=INTEGER},
      </if>
      <if test="userName != null" >
        #{userName,jdbcType=VARCHAR},
      </if>
      <if test="passWord != null" >
        #{passWord,jdbcType=VARCHAR},
      </if>
      <if test="state != null" >
        #{state,jdbcType=VARCHAR},
      </if>
      <if test="type != null" >
        #{type,jdbcType=VARCHAR},
      </if>
      <if test="updateTime != null" >
        #{updateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null" >
        #{createTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.dengwei.day01springboot.model.User" >
    update user
    <set >
      <if test="userId != null" >
        user_id = #{userId,jdbcType=INTEGER},
      </if>
      <if test="userName != null" >
        user_name = #{userName,jdbcType=VARCHAR},
      </if>
      <if test="passWord != null" >
        pass_word = #{passWord,jdbcType=VARCHAR},
      </if>
      <if test="state != null" >
        state = #{state,jdbcType=VARCHAR},
      </if>
      <if test="type != null" >
        type = #{type,jdbcType=VARCHAR},
      </if>
      <if test="updateTime != null" >
        update_time = #{updateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null" >
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.dengwei.day01springboot.model.User" >
    update user
    set user_id = #{userId,jdbcType=INTEGER},
      user_name = #{userName,jdbcType=VARCHAR},
      pass_word = #{passWord,jdbcType=VARCHAR},
      state = #{state,jdbcType=VARCHAR},
      type = #{type,jdbcType=VARCHAR},
      update_time = #{updateTime,jdbcType=TIMESTAMP},
      create_time = #{createTime,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>

项目启动类：

package com.denwgei.springbootmybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.denwgei.springbootmybatis.Dao")
public class SpringbootmybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootmybatisApplication.class, args);
    }
}

注意：@MapperScan("com.winter.mapper")这个注解非常的关键，这个对应了项目中mapper（dao）所对应的包路径，很多同学就是这里忘了加导致异常的

新建service层：

IUserService :

1 package com.denwgei.springbootmybatis.service;
2 
3 import com.denwgei.springbootmybatis.model.User;
4 import com.github.pagehelper.PageInfo;
5 
6 public interface IUserService {
7     public PageInfo<User> queryAll(int pageNum, int pageSize);
8 }

impl ：UserService :

按 Ctrl+C 复制代码

userController :

按 Ctrl+C 复制代码

启动springBoot的启动程序：

spingBoot整合mybatis+generator+pageHelper

启动成功：

spingBoot整合mybatis+generator+pageHelper

好的，试试吧！！！！

有个错误说下

mybatis Field xxxMapper in xxxx required a bean of type 'XXXMapper' that could not be found.

原文: https://blog.csdn.net/j754379117/article/details/71639043/

方法1:application类加注释:@MapperScan(basePackages = { "xxx.xxx.mapper" }, sqlSessionFactoryRef = "sqlSessionFactory")，表示扫描xx.xx.mapper包下的所有mapper。方法2:直接在你生成出来的xxxMapper.java类上加@Mapper标签。

分类: springBoot

标签: springBoot+mybatis+generator+helper

秒客网

spingBoot整合mybatis+generator+pageHelper

spingBoot整合mybatis+generator+pageHelper

环境/版本一览：

额外功能：

开始搭建：

创建项目：

项目启动类：

mybatis Field xxxMapper in xxxx required a bean of type 'XXXMapper' that could not be found.

相关文章