结构
依赖
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.0.RELEASE</version>
</parent>
<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-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.13</version>
</dependency>
</dependencies>
SpringBoot配置文件application.properties
spring.datasource.url=jdbc:mysql://localhost:3306/xm114?serverTimezone=UTC&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.min-idle=20
spring.datasource.druid.max-active=50
spring.datasource.druid.initial-size=30
mybatis.type-aliases-package=com.aaa.lmj.entity
mybatis.mapper-locations=classpath:/mapper/*.xml
pagehelper.reasonable=true
实体类entity
public class Emp {
private int emp_id;
private String emp_name;
private String gender;
private String email;
private int d_id;
private int dept_id;
private String dept_name;
@Override
public String toString() {
return "Emp{" +
"emp_id=" + emp_id +
", emp_name='" + emp_name + '\'' +
", gender='" + gender + '\'' +
", email='" + email + '\'' +
", d_id=" + d_id +
", dept_id=" + dept_id +
", dept_name='" + dept_name + '\'' +
'}';
}
public int getEmp_id() {
return emp_id;
}
public void setEmp_id(int emp_id) {
this.emp_id = emp_id;
}
public String getEmp_name() {
return emp_name;
}
public void setEmp_name(String emp_name) {
this.emp_name = emp_name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getD_id() {
return d_id;
}
public void setD_id(int d_id) {
this.d_id = d_id;
}
public int getDept_id() {
return dept_id;
}
public void setDept_id(int dept_id)