SpringBoot详细整合mybatis，整合分页插件

1.首先使用eclipse或IDEA创建一个SpringBoot项目（这个就不详细说了）

2.创建完项目之后,添加pom.xml文件

 <!--mysql数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

3.修改resource下的application.properties，修改为application.yml，并配置数据

server:  #服务
  port: 8081 #端口 
spring:
  datasource: #数据库链接信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/fruit?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai
    username: root
    password: root


mybatis:
  mapper-locations: classpath:mapper/*.xml  #对应mapper映射xml文件的所在路径
  type-aliases-package: com.test.entry   #对应实体类的路径
  configuration:
    map-underscore-to-camel-case: true  #是否开启驼峰命名

4.接下来就可以写代码了，项目的结构

mapper和mapper.xml

@Repository
public interface UserMapper {
    //添加用户
    int addUser(int userId,String userName,String password,String name,String userTelephone);
}

<?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.ooo.mapper.UserMapper">

    <!--注意：
1.namespace中需要与使用@Mapper的接口对应
2.UserMapper.xml文件名称必须与使用@Mapper的接口一致
3.标签中的id必须与@Mapper的接口中的方法名一致，且参数一致
-->
    <!--添加用户-->
    <insert id="addUser" >
        insert into sys_user(user_id,user_name,password,name,user_telephone)
        values (#{userId},#{userName},#{password},#{name},#{userTelephone})
    </insert>
</mapper>

Service和实现

public interface UserService {
    //添加用户
    int addUser(int userId,String userName,String password,String name,String userTelephone);

}


@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;
    @Override
    public int addUser(int userId, String userName, String password, String name, String userTelephone) {
        int i = userMapper.addUser(userId, userName, password, name, userTelephone);
        if (i > 0) {
            return 1;
        }else {
            return -1;
        }
    }
}

controller

@RestController
@RequestMapping("/user")
public class Demo {
    @Autowired
    private UserService userService;

    //添加用户
    @RequestMapping("/adduser")
    public int add(int userId,String userName,String password,String name,String userTelephone) throws Exception {
        int i = userService.addUser(userId, userName, password, name, userTelephone);
        if (i>0){
            return 1;
        }else {
          return -1;
        }
    }
}

5，然后在修改项目的启动类，使用@MapperScan扫描接口

@MapperScan("com.ooo.mapper")  //使用MapperScan批量扫描所有的Mapper接口；
@SpringBootApplication
public class DemoApplication {

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

}

6，大功告成，然后启动项目，浏览器输入http://localhost:8081/user/adduser?userId=17&userName=1008&password=8988&name=王宝宝&userTelephone=15297660288查看

Mybatis分页

1、首先引入依赖

<dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper-spring-boot-starter</artifactId>
   <version>1.4.1</version>
</dependency>

 JSONObject json = new JSONObject();
//在查询之前使用下面的分页
PageHelper.startPage(pageNum,pageSize);
List<Student> student= studentMapper.queryCs();
json.put("data",student);

//如果想要查看分页的信息可以添加PageInfo
 PageInfo pageInfo = new PageInfo(taskList);
//返回数据为pageInfo
 json.put("data",pageInfo);