mybatis 学习记录

ゝ一世哀愁。 2023-02-20 12:29 54阅读 0赞

**打印sql配置：**

#配置mybatis打印sql
    mybatis:
      configuration:
        log-impl: org.apache.ibatis.logging.log4j2.Log4j2Impl
    
        #全局配置下划线到驼峰的映射
        map-underscore-to-camel-case: true
    
    
    #mapper层debug模式
    logging:
      level:
        com.modules.service: debug

**使用@select 注解模式注意：sql前后一定要写 <script></script>标签，否则if等标签都不解析**

/**
         *用户分页列表
         */
        /*@Results(
                id = "userMap",
                value = {
                        @Result(column = "id",property = "id",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "open_id",property = "openId",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "union_id",property = "unionId",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "avatar",property = "avatar",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "nickname",property = "nickname",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "age",property = "age",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "sex",property = "sex",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "user_name",property = "userName",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "user_tel",property = "userTel",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "wx_address",property = "wxAddress",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "real_province",property = "realProvince",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "real_city",property = "realCity",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "real_area",property = "realArea",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "status",property = "status",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "type",property = "type",javaType = Integer.class,jdbcType = JdbcType.INTEGER),
                        @Result(column = "token",property = "token",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "remark",property = "remark",javaType = String.class,jdbcType = JdbcType.VARCHAR),
                        @Result(column = "create_time",property = "createTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
                        @Result(column = "update_time",property = "updateTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
                        @Result(column = "last_login_time",property = "lastLoginTime",javaType = Date.class,jdbcType = JdbcType.TIMESTAMP),
                }
        )*/
        @Select({
                "<script>",
                "select * from g_user ",
                "<where>",
                "<if test='requestPageBean.params != null'>",
                "<if test='requestPageBean.params.userName != null and requestPageBean.params.userName != \"\"'> and user_name like concat('%',#{requestPageBean.params.userName},'%')</if>",
                "<if test='requestPageBean.params.nickname != null and requestPageBean.params.nickname != \"\"'> and nickname like concat('%',#{requestPageBean.params.userName},'%')</if>",
                "</if>",
                "</where>",
                "order by create_time desc limit #{requestPageBean.limitStart,jdbcType=INTEGER},#{requestPageBean.pageSize,jdbcType=INTEGER}",
                "</script>"
        })
        List<UserDto> pageList(@Param("requestPageBean") RequestPageBean<UserDto> requestPageBean);