SpringBoot-Mybatis四层架构与分页

目录

一.连接数据库 添加端口号

二.添加mappers 写mybatis

三.创建demo

四.添加实体类

五.添加dao

六.添加conterller 

七.添加service

---

一.连接数据库 添加端口号

#配置端口号
server:
  port: 8888
spring:
  # 配置数据源信息
  datasource:
    # 配置数据源类型
    type: com.zaxxer.hikari.HikariDataSource
    # 配置连接数据库信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/practice?characterEncoding=utf-8&useSSL=false
    username: root
    password: 123456
mybatis-plus:
  mapper-locations: classpath:mappers/*.xml
  type-aliases-package: demo.entity

二.添加mappers

2.1添加UserMapper.xml 然后其中写sql语句

<?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="demo.dao.UserMapper">
    <resultMap id="userResult" type="User">
        <result column="id" property="id"/>
        <result column="user_name" property="userName"/>
        <result column="passwd" property="passwd"/>
        <result column="create_date" property="createDate"/>
    </resultMap>
    <sql id="sql_temp">
        select id,user_name,passwd,create_date from t_user
    </sql>
    <select id="selectAll" resultMap="userResult">
    <include refid="sql_temp"></include> limit #{pageIndex},#{pageSize}
    </select>
</mapper>

三.创建demo启动类

@SpringBootApplication
@MapperScan("demo.dao")
public class Demo {
        public static void main(String[] args) {
            SpringApplication.run(Demo.class,args);
        }
    }

四.添加实体类

@AllArgsConstructor
@NoArgsConstructor
@Data
public class User {
    private Long id;
    private String userName;
    private  String passwd;
    private String createDate;

}

五.添加dao

public interface UserMapper{
    List<User> selectAll(int pageIndex,int pageSize);
}

六.添加conterller 

@RequestMapping("/user")
@RestController
public class UserController {
    @Autowired
    private IUserService userService;

    @RequestMapping("/list")
    public List<User> findUserList(int pageIndex,int pageSize){
        return userService.queryIserList(pageIndex,pageSize);
    }

}

七.添加service

@Service
public class UserServiceImpl  implements IUserService {
//实例化Dao对象
    @Autowired(required = false)
    private UserMapper userMapper;


    @Override
    public List<User> queryIserList(int pageIndex,int pageSize) {
        List<User> list = userMapper.selectAll((pageIndex-1)*pageSize,pageSize);
        return list;
    }
}

public interface IUserService {
    List<User> queryIserList(int pageIndex,int pageSize);
}