7.Limit分页、注解、执行流程、注解CRUD、Lombok

最新推荐文章于 2023-05-30 11:08:12 发布

RedeeMi

最新推荐文章于 2023-05-30 11:08:12 发布

阅读量361

点赞数

分类专栏： # mybatis 文章标签： lombok

本文链接：https://blog.csdn.net/qq_52316911/article/details/113753747

版权

文章目录
1.limit分页

2.注解

3.mybatis执行流程

4.注解CRUD

5.Lombok

1.Limit分页
语法：

SELECT * from user limit startIndex,pageSize;
SELECT * from user limit 0,2;

package com.redeemi.dao;

import com.redeemi.pojo.User;

import java.util.List;
import java.util.Map;

public interface UserMapper {

    //根据id查询用户
    User getUserById(int id);

    List<User> getUserByLimit(Map<String, Integer> map);

}

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.redeemi.dao.UserMapper">

    <select id="getUserById" resultMap="UserMap"
    parameterType="int">
        select * from mybatis.user where id = #{id}
    </select>

    <!--结果集映射-->
    <resultMap id="UserMap" type="User">
        <!--colunm 数据库中的字段，property实体中的属性-->
        <!--<result column="id" property="id"></result>-->
        <!--<result column="name" property="name"></result>-->
        <result column="pwd" property="password"></result>
    </resultMap>

    <select id="getUserByLimit" parameterType="map"
            resultType="User" resultMap="UserMap">
      select * from mybatis.user limit #{startIndex},#{pageSize}
    </select>

</mapper>

test类

@Test
public void getByLimit(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    Map<String, Integer&g