转载：https://www.freesion.com/article/75141011937/

目录

1.准备工作

1.1.安装EasyCode和Lombok插件

1.2.创建一个springboot项目

1.3.准备数据库表

1.4.在IDEA配置连接数据库

2.生成代码

2.1.IDEA中生成代码

2.2.修改pom.xml文件（导入需要的依赖）

2.3.修改application.yml文件

2.4.在dao接口添加@Mapper注解

3.测试

4.常见问题

4.1.“Test Connection”按钮为灰色

4.2.org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

 

1.准备工作

1.1.安装EASYCODE和LOMBOK插件

 

安装完成后，重启idea，才能生效。

1.2.创建一个SPRINGBOOT项目

application.properties修改为application.yml

1.3.准备数据库表

DROP TABLE IF EXISTS `account`;

 

CREATE TABLE `account` (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',

  `login_name` varchar(255) DEFAULT NULL COMMENT '登录名',

  `login_pwd` varchar(255) DEFAULT NULL COMMENT '登录密码',

  `name` varchar(255) DEFAULT NULL COMMENT '真实姓名',

  `mobile` varchar(128) DEFAULT NULL COMMENT '手机号',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户账号表';

 

/*Data for the table `account` */

 

insert  into `account`(`id`,`login_name`,`login_pwd`,`name`,`mobile`) values (1,'admin','admin','管理员','18312345678');

1.4.在IDEA配置连接数据库

2.生成代码

2.1.IDEA中生成代码

2.2.修改POM.XML文件（导入需要的依赖）

 

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>2.3.0.RELEASE</version>

<relativePath/> <!-- lookup parent from repository -->

</parent>

<groupId>com.example</groupId>

<artifactId>demo</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>demo</name>

<description>Demo project for Spring Boot</description>


<properties>

<java.version>1.8</java.version>

</properties>


<dependencies>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>


<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

<scope>test</scope>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-devtools</artifactId>

<optional>true</optional>

</dependency>


<!-- springboot与mybatis的整合包 -->

<dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

<version>2.1.1</version>

</dependency>


<!-- mysql驱动包 -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>6.0.6</version>

</dependency>

<!-- 引入lombok用来简化实体类 -->

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

<optional>true</optional>

</dependency>


</dependencies>


<build>

<plugins>

<plugin>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-maven-plugin</artifactId>

</plugin>

</plugins>

</build>


<repositories>

<repository>

<id>spring-milestones</id>

<name>Spring Milestones</name>

<url>https://repo.spring.io/milestone</url>

</repository>

<repository>

<id>spring-snapshots</id>

<name>Spring Snapshots</name>

<url>https://repo.spring.io/snapshot</url>

<snapshots>

<enabled>true</enabled>

</snapshots>

</repository>

</repositories>

<pluginRepositories>

<pluginRepository>

<id>spring-milestones</id>

<name>Spring Milestones</name>

<url>https://repo.spring.io/milestone</url>

</pluginRepository>

<pluginRepository>

<id>spring-snapshots</id>

<name>Spring Snapshots</name>

<url>https://repo.spring.io/snapshot</url>

<snapshots>

<enabled>true</enabled>

</snapshots>

</pluginRepository>

</pluginRepositories>


</project>

2.3.修改APPLICATION.YML文件

1.application.yml文件内容如下：

 

1. server:
   
   port: 8080
   
   spring:
   
   datasource:
   
   url: jdbc:mysql://localhost:3306/demo?useUnicode=true&autoReconnect=true&useSSL=false&serverTimezone=Asia/Shanghai
   
   username: user
   
   password: user
   
   driver-class-name: com.mysql.cj.jdbc.Driver
   
   hikari:
   
   pool-name: demo
   
   connection-timeout: 60000
   
   maximum-pool-size: 10
   
   connection-init-sql: SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
   
   mybatis:
   
   mapper-locations: classpath:/mapper/*Dao.xml
   
   

   
   2.4.在DAO接口添加@MAPPER注解

@Mapper

public interface AccountDao {

……

}

3.测试

http://localhost:8080/account/selectOne.do?id=1

4.常见问题

4.1.“TEST CONNECTION”按钮为灰色

【解决方法】通过Download下载驱动。

4.2.ORG.APACHE.IBATIS.BINDING.BINDINGEXCEPTION: INVALID BOUND STATEMENT (NOT FOUND)

processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.example.demo.dao.AccountDao.queryById] with root cause

 

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.example.demo.dao.AccountDao.queryById

       at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.3.jar:3.5.3]

 

 

mybatis:
  mapper-locations: classpath:/mapper/*Dao.xml

 

一键生成代码的完整项目下载地址：http://www.zrscsoft.com/sitepic/12098.html