spring boot使用mybatis,以及分页组件

pom.xml

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

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.29</version>
</dependency>

 

application.properties

spring.datasource.url= jdbc:mysql://localhost:33062/test?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false

mybatis.typeAliasesPackage=com.example.demo.domain
mybatis.mapperLocations=classpath:mapper/*.xml
mybatis.configuration.map-underscore-to-camel-case=true

实体类

Mapper类

import com.example.demo.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;


import org.springframework.stereotype.Component;

import java.util.List;

@Component
@Mapper
public interface UserMapper {
    List<User> selectAll();
    User findByUsername(@Param("username")String username);
}

resources/mapper/UserMapper.xml

<?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">

<!-- namespace为命名空间，应该是mapper接口的全称-->
<mapper namespace="com.example.demo.mapper.UserMapper">
    <resultMap id="BaseResultMap" type="com.example.demo.domain.User">
        <id column="id" jdbcType="INTEGER" property="id" />
        <result column="username" jdbcType="VARCHAR" property="username" />
        <result column="password" jdbcType="VARCHAR" property="password" />
        <result column="nick_name" jdbcType="VARCHAR" property="nickName" />
        <result column="sex" jdbcType="INTEGER" property="sex" />
        <result column="register_date" jdbcType="TIMESTAMP" property="registerDate" />
    </resultMap>


    <parameterMap id="User" type="com.example.demo.domain.User"/>

    <sql id="Base_Column_List">
        id, username, password, nick_name,sex,register_date
    </sql>

    <select id="findByUsername" resultMap="BaseResultMap" parameterType="java.lang.String">
        select
        <include refid="Base_Column_List" />
        from user
        where username = #{username}
    </select>
    <select id="selectAll"  resultType="com.example.demo.domain.User">
        select
        <include refid="Base_Column_List" />
        FROM USER
    </select>



</mapper>

service使用

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
    public List<User> selectAll(){
        return userMapper.selectAll();
    }
}

 

---

分页组件

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

配置

pagehelper.auto-dialect=true
pagehelper.close-conn=false
pagehelper.reasonable=true

使用

 public List<User> selectAllByPage(int pageNum,int pageSize){
        PageHelper.startPage(pageNum,pageSize,true);
        List<User> userList= userMapper.selectAll();
        PageInfo pageInfo=new PageInfo(userList);
        return pageInfo.getList();
    }