mybatis 学习记录

打印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);