MyBatis Plus

小灰灰 2022-01-28 14:17 250阅读 0赞

# [MyBatis Plus][] #

参考官网：https://mp.baomidou.com/

quickly start：

Entity：

@TableName("user")
    public class User implements Serializable {
    
        /** 用户ID */
        private Long id;
    
        /** 用户名 */
        private String name;
    
        /** 用户年龄 */
        private Integer age;
    
        @TableField(exist = false)
        private String state;
    }

Dao层：

/**
     * User 表数据库控制层接口
     */
    public interface UserMapper extends BaseMapper<User> {
        @Select("selectUserList")
        List<User> selectUserList(Pagination page,String state);
    }

配备的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">
    <mapper namespace="com.baomidou.springmvc.mapper.system.UserMapper">
    
        
        <sql id="Base_Column_List">
            id, name, age
        </sql>
    
        <select id="selectUserList" resultType="User">
            SELECT * FROM sys_user WHERE state=#{state}
        </select>
    </mapper>

Service层：

/**
     *
     * User 表数据服务层接口实现类
     *
     */
    @Service
    public class UserService extends ServiceImpl<UserMapper, User>{
        public Page<User> selectUserPage(Page<User> page, String state) {
            page.setRecords(baseMapper.selectUserList(page,state));
            return page;
        }
    }

参考：https://www.cnblogs.com/fingerboy/p/6657118.html

posted @ 2019-03-26 13:51 [toov5][] 阅读(...) 评论(...) [编辑][Link 1] 收藏

[MyBatis Plus]: https://www.cnblogs.com/toov5/p/10599692.html
[toov5]: https://www.cnblogs.com/toov5/
[Link 1]: https://i.cnblogs.com/EditPosts.aspx?postid=10599692