SpringBootMyBatisElementUI简单增删改查分页

结构

项目结构

依赖

<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>
    <!--springboot集成Junit 的启动依赖-->
    <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>

    <!-- 阿里巴巴的Druid数据源依赖启动器 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.10</version>
    </dependency>

    <!-- MyBatis依赖启动器 -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.0</version>
    </dependency>
    <!-- MySQL数据库连接驱动 -->
    <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) 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值