Mybatis注解@Select结合@Results使用

最新推荐文章于 2024-08-23 02:14:31 发布

码上得天下

最新推荐文章于 2024-08-23 02:14:31 发布

阅读量4.9k

点赞数 1

分类专栏： Mybatis

本文链接：https://blog.csdn.net/meser88/article/details/102668462

版权

Mybatis 专栏收录该内容

16 篇文章 1 订阅

订阅专栏

该方式是否可以解决不同数据库字段别名的不同写法问题，如果是多表联查（多表有命名一样的字段）， @Result可以准确定位sql中具体相关表的字段呢？回家测试一下！！！

public interface TestMapper {

    @Select("SELECT " +
            "t1.APPLY_NO," +
            "t1.CARD_IS_LONG_VALID," +
            "t1.SPELL_NAME ,"+
            "t1.EDUCATION  , " +
            "t1.MARITAL_STATUS "+
            "FROM " +
            "identity_info t1 " +
            "WHERE " +
            " t1.apply_no  = #{applyNo}")
    @Results({
            @Result(property = "applyNo", column = "APPLY_NO"),
            @Result(property = "cardIsLongValid", column = "CARD_IS_LONG_VALID"),
            @Result(property = "spellName", column = "SPELL_NAME"),
            @Result(property = "education", column = "EDUCATION"),
            @Result(property = "maritalStatus", column = "MARITAL_STATUS")

    })
    Map queryBasicInfo(Map paramMap);

    @SelectProvider(type = SelectBasicInfo.class,method = "selectBasicInfo")
    List<Map> selectBasicInfo(Map paramMap);
    public class SelectBasicInfo{
        public  String selectBasicInfo(){
            return new SQL(){
                {
                    SELECT("APPLY_NO as applyNo");
                    SELECT("CARD_IS_LONG_VALID  as cardIsLongValid");
                    SELECT("SPELL_NAME as spellName   ");
                    SELECT("EDUCATION as education   ");
                    SELECT("MARITAL_STATUS as maritalStatus   ");
                    FROM("identity_info");
                    WHERE("apply_no = #{applyNo} ");
                    WHERE("MARITAL_STATUS = '1' ");
                    ORDER_BY("created_date desc");
                }
            }.toString();
        }
    }
}