Mybatis注解@Select结合@Results使用

最新推荐文章于 2024-03-26 15:58:01 发布

原创最新推荐文章于 2024-03-26 15:58:01 发布 · 5.1k 阅读

3 ·

CC 4.0 BY-SA版权

Mybatis 专栏收录该内容

16 篇文章

订阅专栏

本文探讨了MyBatis中@Result注解在多表联查场景下的应用，通过具体代码示例展示了如何精确映射不同数据库字段别名到Java实体属性，解决字段命名冲突问题，提高SQL查询的灵活性与准确性。

部署运行你感兴趣的模型镜像

该方式是否可以解决不同数据库字段别名的不同写法问题，如果是多表联查（多表有命名一样的字段）， @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();
        }
    }
}

您可能感兴趣的与本文相关的镜像