MyBatis查询结果映射方法例子

最新推荐文章于 2024-06-14 10:07:40 发布
最新推荐文章于 2024-06-14 10:07:40 发布
阅读量1k 收藏 1
点赞数 1
分类专栏： MyBatis 文章标签： mybatis java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/smith789/article/details/103898550
版权

高级结果映射

MyBatis可以轻松的将一对一、一对多的查询结果映射成复杂的组合关系。

表结构

customer_login是客户表。
customer_inf是客户信息扩展表。
customer_login_log是客户登录日志表。
customer_login和customer_inf的关系是1：1.
customer_login和customer_login_log的关系是1：N。
假设有个需求是联查这3个表联查的结果映射到一个JavaBean:CustomerLoginDTO中：

public class CustomerLoginDTO {

    private CustomerLogin customerLogin;
    private CustomerInf customerInf;
    private List<CustomerLoginLog> customerLoginLog = new ArrayList<>();

    public CustomerLogin getCustomerLogin() {
        return customerLogin;
    }

    public void setCustomerLogin(CustomerLogin customerLogin) {
        this.customerLogin = customerLogin;
    }

    public CustomerInf getCustomerInf() {
        return customerInf;
    }

    public void setCustomerInf(CustomerInf customerInf) {
        this.customerInf = customerInf;
    }

    public List<CustomerLoginLog> getCustomerLoginLog() {
        return customerLoginLog;
    }

    public void setCustomerLoginLog(List<CustomerLoginLog> customerLoginLog) {
        this.customerLoginLog = customerLoginLog;
    }
}

public class CustomerLogin implements Serializable {
    private Integer customerId;

    private String loginName;

    private String password;

    private Byte userStats;

    private Date modifiedTime;

    private static final long serialVersionUID = 1L;

    getter & setter
}

public class CustomerInf implements Serializable {
    private Integer customerInfId;

    private Integer customerId;

    private String customerName;

    private Byte identityCardType;

    private String identityCardNo;

    private String mobilePhone;

    private String customerEmail;

    private String gender;

    private Integer userPoint;

    private Date registerTime;

    private Date birthday;

    private Byte customerLevel;

    private BigDecimal userMoney;

    private Date modifiedTime;

    private static final long serialVersionUID = 1L;

    getter & setter
}

public class CustomerLoginLog implements Serializable {
    private Integer loginId;

    private Integer customerId;

    private Date loginTime;

    private String loginIp;

    private Byte loginType;

    private static final long serialVersionUID = 1L;

    getter & setter
}

3张表关联查询的sql如下：

SELECT
	a.customer_id AS a_customer_id,
	a.login_name AS a_login_name,
	a.PASSWORD AS a_password,
	a.user_stats AS a_user_stats,
	a.modified_time AS a_modified_time,
	b.customer_inf_id AS b_customer_inf_id,
	b.customer_name AS b_customer_name,
	b.identity_card_type AS b_identity_card_type,
	b.identity_card_no AS b_identity_card_no,
	b.mobile_phone AS b_mobile_phone,
	b.customer_email AS b_customer_email,
	b.gender AS b_gender,
	b.user_point AS b_user_point,
	b.register_time AS b_register_time,
	b.birthday AS b_birthday,
	b.customer_level AS b_customer_level,
	b.user_money AS b_user_money,
	b.modified_time AS b_modified_time,
	c.login_id AS c_login_id,
	c.customer_id AS c_customer_id,
	c.login_time AS c_login_time,
	c.login_ip AS c_login_ip,
	c.login_type AS c_login_type 
FROM
	customer_login a
	LEFT JOIN customer_inf b ON a.customer_id = b.customer_id
	LEFT JOIN customer_login_log c ON a.customer_id = c.customer_id 
WHERE
	a.customer_id = 1

one to one

查询的结果放到：

public class CustomerLoginOneToOne  implements Serializable {
    private Integer customerId;

    private String loginName;

    private String password;

    private Byte userStats;

    private Date modifiedTime;

    private static final long serialVersionUID = 1L;

    private CustomerInf customerInf;

    getter and setter
}

方法1：自动映射

<select id="testOneToOne1" parameterType="java.lang.Integer" resultType="com.sss.pojo.CustomerLoginOneToOne">
    select
        a.customer_id as customerId,
        a.login_name as loginName,
        a.password as password,
        a.user_stats as userStats,
        a.modified_time as modifiedTime,
        b.customer_id as "customerInf.customerId",
        b.customer_inf_id as "customerInf.customerInfId",
        b.customer_name as "customerInf.customerName",
        b.identity_card_type as "customerInf.identityCardType",
        b.identity_card_no as "customerInf.identityCardNo",
        b.mobile_phone as "customerInf.mobilePhone",
        b.customer_email as "customerInf.customerEmail",
        b.gender as "customerInf.gender",
        b.user_point as "customerInf.userPoint",
        b.register_time as "customerInf.registerTime",
        b.birthday as "customerInf.birthday",
        b.customer_level as "customerInf.customerLevel",
        b.user_money as "customerInf.userMoney",
        b.modified_time as "customerInf.modifiedTime"
  from customer_login a
  left join customer_inf b on a.customer_id = b.customer_id
        where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToOne testOneToOne1(Integer customerId);
}

方法2：嵌套的resultMap

<resultMap id="testOneToOne2Map" type="com.sss.pojo.CustomerLoginOneToOne">
    <id property="customerId" column="a.customerId"></id>
    <result property="loginName" column="a.loginName"></result>
    <result property="password" column="a.password"></result>
    <result property="userStats" column="a.userStats"></result>
    <result property="modifiedTime" column="a.modifiedTime"></result>
    <result property="customerInf.customerId" column="b.customerId"></result>
    <result property="customerInf.customerInfId" column="b.customerInfId"></result>
    <result property="customerInf.customerName" column="b.customerName"></result>
    <result property="customerInf.identityCardType" column="b.identityCardType"></result>
    <result property="customerInf.identityCardNo" column="b.identityCardNo"></result>
    <result property="customerInf.mobilePhone" column="b.mobilePhone"></result>
    <result property="customerInf.customerEmail" column="b.customerEmail"></result>
    <result property="customerInf.gender" column="b.gender"></result>
    <result property="customerInf.userPoint" column="b.userPoint"></result>
    <result property="customerInf.registerTime" column="b.registerTime"></result>
    <result property="customerInf.birthday" column="b.birthday"></result>
    <result property="customerInf.customerLevel" column="b.customerLevel"></result>
    <result property="customerInf.userMoney" column="b.userMoney"></result>
    <result property="customerInf.modifiedTime" column="b.modifiedTime"></result>
</resultMap>

<select id="testOneToOne2" parameterType="java.lang.Integer" resultMap="testOneToOne2Map">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime",
        b.customer_id as "b.customerId",
        b.customer_inf_id as "b.customerInfId",
        b.customer_name as "b.customerName",
        b.identity_card_type as "b.identityCardType",
        b.identity_card_no as "b.identityCardNo",
        b.mobile_phone as "b.mobilePhone",
        b.customer_email as "b.customerEmail",
        b.gender as "b.gender",
        b.user_point as "b.userPoint",
        b.register_time as "b.registerTime",
        b.birthday as "b.birthday",
        b.customer_level as "b.customerLevel",
        b.user_money as "b.userMoney",
        b.modified_time as "b.modifiedTime"
  from customer_login a
  left join customer_inf b on a.customer_id = b.customer_id
        where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToOne testOneToOne2(Integer customerId);
}

方法3 resultMap继承

<resultMap id="testOneToOne2Map3_1" type="com.sss.pojo.CustomerLoginOneToOne">
    <id property="customerId" column="a.customerId"></id>
    <result property="loginName" column="a.loginName"></result>
    <result property="password" column="a.password"></result>
    <result property="userStats" column="a.userStats"></result>
    <result property="modifiedTime" column="a.modifiedTime"></result>
</resultMap>

<resultMap id="testOneToOne2Map3" type="com.sss.pojo.CustomerLoginOneToOne" extends="testOneToOne2Map3_1">
    <result property="customerInf.customerId" column="b.customerId"></result>
    <result property="customerInf.customerInfId" column="b.customerInfId"></result>
    <result property="customerInf.customerName" column="b.customerName"></result>
    <result property="customerInf.identityCardType" column="b.identityCardType"></result>
    <result property="customerInf.identityCardNo" column="b.identityCardNo"></result>
    <result property="customerInf.mobilePhone" column="b.mobilePhone"></result>
    <result property="customerInf.customerEmail" column="b.customerEmail"></result>
    <result property="customerInf.gender" column="b.gender"></result>
    <result property="customerInf.userPoint" column="b.userPoint"></result>
    <result property="customerInf.registerTime" column="b.registerTime"></result>
    <result property="customerInf.birthday" column="b.birthday"></result>
    <result property="customerInf.customerLevel" column="b.customerLevel"></result>
    <result property="customerInf.userMoney" column="b.userMoney"></result>
    <result property="customerInf.modifiedTime" column="b.modifiedTime"></result>
</resultMap>

<select id="testOneToOne3" parameterType="java.lang.Integer" resultMap="testOneToOne2Map3">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime",
        b.customer_id as "b.customerId",
        b.customer_inf_id as "b.customerInfId",
        b.customer_name as "b.customerName",
        b.identity_card_type as "b.identityCardType",
        b.identity_card_no as "b.identityCardNo",
        b.mobile_phone as "b..mobilePhone",
        b.customer_email as "b.customerEmail",
        b.gender as "b.gender",
        b.user_point as "b.userPoint",
        b.register_time as "b.registerTime",
        b.birthday as "b.birthday",
        b.customer_level as "b.customerLevel",
        b.user_money as "b.userMoney",
        b.modified_time as "b.modifiedTime"
  from customer_login a
  left join customer_inf b on a.customer_id = b.customer_id
        where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToOne testOneToOne3(Integer customerId);
}

方法4：association嵌套结果

<resultMap id="testOneToOne2Map4" type="com.sss.pojo.CustomerLoginOneToOne" extends="testOneToOne2Map3_1">
    <association property="customerInf" columnPrefix="b." javaType="com.sss.pojo.CustomerInf">
        <id property="customerId" column="customerId"></id>
        <result property="customerInfId" column="customerInfId"></result>
        <result property="customerName" column="customerName"></result>
        <result property="identityCardType" column="identityCardType"></result>
        <result property="identityCardNo" column="identityCardNo"></result>
        <result property="mobilePhone" column="mobilePhone"></result>
        <result property="customerEmail" column="customerEmail"></result>
        <result property="gender" column="gender"></result>
        <result property="userPoint" column="userPoint"></result>
        <result property="registerTime" column="registerTime"></result>
        <result property="birthday" column="birthday"></result>
        <result property="customerLevel" column="customerLevel"></result>
        <result property="userMoney" column="userMoney"></result>
        <result property="modifiedTime" column="modifiedTime"></result>
    </association>
</resultMap>

<select id="testOneToOne4" parameterType="java.lang.Integer" resultMap="testOneToOne2Map4">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime",
        b.customer_id as "b.customerId",
        b.customer_inf_id as "b.customerInfId",
        b.customer_name as "b.customerName",
        b.identity_card_type as "b.identityCardType",
        b.identity_card_no as "b.identityCardNo",
        b.mobile_phone as "b.mobilePhone",
        b.customer_email as "b.customerEmail",
        b.gender as "b.gender",
        b.user_point as "b.userPoint",
        b.register_time as "b.registerTime",
        b.birthday as "b.birthday",
        b.customer_level as "b.customerLevel",
        b.user_money as "b.userMoney",
        b.modified_time as "b.modifiedTime"
  from customer_login a
  left join customer_inf b on a.customer_id = b.customer_id
        where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToOne testOneToOne4(Integer customerId);
}

方法5：association嵌套查询

<resultMap id="testOneToOne2Map5" type="com.sss.pojo.CustomerLoginOneToOne" extends="testOneToOne2Map3_1">
    <association property="customerInf" column="a.customerId" select="selectFromCustomerInf">
    </association>
</resultMap>

<select id="selectFromCustomerInf" parameterType="java.lang.Integer" resultType="com.sss.pojo.CustomerInf">
    select
        b.customer_id as "customerId",
        b.customer_inf_id as "customerInfId",
        b.customer_name as "customerName",
        b.identity_card_type as "identityCardType",
        b.identity_card_no as "identityCardNo",
        b.mobile_phone as "mobilePhone",
        b.customer_email as "customerEmail",
        b.gender as "gender",
        b.user_point as "userPoint",
        b.register_time as "registerTime",
        b.birthday as "birthday",
        b.customer_level as "customerLevel",
        b.user_money as "userMoney",
        b.modified_time as "modifiedTime"
  from  customer_inf b where b.customer_id = #{customerId}
</select>

<select id="testOneToOne5" parameterType="java.lang.Integer" resultMap="testOneToOne2Map5">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime"
  from customer_login a where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToOne testOneToOne5(Integer customerId);
}

查看控制台sql日志，参数传递正确：

15:57:16.930 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
15:57:19.233 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@ec2bf82]
15:57:19.242 [main] DEBUG c.s.dao.CustomerMapper.testOneToOne5 - ==>  Preparing: select a.customer_id as "a.customerId", a.login_name as "a.loginName", a.password as "a.password", a.user_stats as "a.userStats", a.modified_time as "a.modifiedTime" from customer_login a where a.customer_id = ? 
15:57:19.325 [main] DEBUG c.s.dao.CustomerMapper.testOneToOne5 - ==> Parameters: 1(Integer)
15:57:19.361 [main] DEBUG c.s.d.C.selectFromCustomerInf - ====>  Preparing: select b.customer_id as "customerId", b.customer_inf_id as "customerInfId", b.customer_name as "customerName", b.identity_card_type as "identityCardType", b.identity_card_no as "identityCardNo", b.mobile_phone as "mobilePhone", b.customer_email as "customerEmail", b.gender as "gender", b.user_point as "userPoint", b.register_time as "registerTime", b.birthday as "birthday", b.customer_level as "customerLevel", b.user_money as "userMoney", b.modified_time as "modifiedTime" from customer_inf b where b.customer_id = ? 
15:57:19.362 [main] DEBUG c.s.d.C.selectFromCustomerInf - ====> Parameters: 1(Integer)
15:57:19.484 [main] DEBUG c.s.d.C.selectFromCustomerInf - <====      Total: 1
15:57:19.485 [main] DEBUG c.s.dao.CustomerMapper.testOneToOne5 - <==      Total: 1

上例延迟加载测试

对于上例中控制台输出的2个sql，MySQL默认是没有开启延迟加载的，所以2个sql都执行了。
修改MyBatis的配置文件：

<settings>
    <!-- 打开延迟加载的开关 -->
    <setting name="lazyLoadingEnabled" value="true"/>
    <!-- 将积极加载改为消极加载，即延迟加载 -->
    <setting name="aggressiveLazyLoading" value="false"/>
</settings>

修改测试代码：

@Test
public void testOneToOne(){
	SqlSession sqlSession = sqlSessionFactory.openSession();
	System.out.println(sqlSession.getClass());
	try {
		CustomerMapper customerMapper = sqlSession.getMapper(CustomerMapper.class);
		//CustomerLoginOneToOne result = customerMapper.testOneToOne1(1);
		//CustomerLoginOneToOne result = customerMapper.testOneToOne2(1);
		//CustomerLoginOneToOne result = customerMapper.testOneToOne3(1);
		//CustomerLoginOneToOne result = customerMapper.testOneToOne4(1);
		CustomerLoginOneToOne result = customerMapper.testOneToOne5(1);
		//log.info("{}",result.getCustomerInf());
		sqlSession.commit();
	} finally {
		sqlSession.close();
	}
}

如果不放开最后一行注释，控制台指挥打印1个sql。反之放开注释，因为用到了CustomerInf对象，所以会即时去查库。

one to many

查询结果映射到：

public class CustomerLoginOneToMany implements Serializable {
    private Integer customerId;

    private String loginName;

    private String password;

    private Byte userStats;

    private Date modifiedTime;

    private static final long serialVersionUID = 1L;

    private List<CustomerLoginLog> customerLoginLogList;

    getter & setter
}

方法1：collection嵌套结果

<select id="testOneToMany1" parameterType="java.lang.Integer" resultMap="testOneToMany1Map">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime",
        b.login_id as "b.loginId",
        b.customer_id as "b.customerId",
        b.login_time as "b.loginTime",
        b.login_ip as "b.loginIp",
        b.login_type as "b.loginType"
  from customer_login a
  left join customer_login_log b on a.customer_id = b.customer_id
        where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

<resultMap id="testOneToOne2Map3_1" type="com.sss.pojo.CustomerLoginOneToOne">
    <id property="customerId" column="a.customerId"></id>
    <result property="loginName" column="a.loginName"></result>
    <result property="password" column="a.password"></result>
    <result property="userStats" column="a.userStats"></result>
    <result property="modifiedTime" column="a.modifiedTime"></result>
</resultMap>

<resultMap id="customerLoginLogMap" type="com.sss.pojo.CustomerLoginLog">
    <id property="loginId" column="loginId"></id>
    <result property="customerId" column="customerId"></result>
    <result property="loginTime" column="loginTime"></result>
    <result property="loginIp" column="loginIp"></result>
    <result property="loginType" column="loginType"></result>
</resultMap>


<resultMap id="testOneToMany1Map" type="com.sss.pojo.CustomerLoginOneToMany" extends="testOneToOne2Map3_1">
    <collection property="customerLoginLogList" columnPrefix="b." resultMap="customerLoginLogMap">
    </collection>
</resultMap>

public interface CustomerMapper {
    CustomerLoginOneToMany testOneToMany1(Integer customerId);
}

方法2：collection嵌套查询

<select id="testOneToMany2" parameterType="java.lang.Integer" resultMap="testOneToMany2Map">
    select
        a.customer_id as "a.customerId",
        a.login_name as "a.loginName",
        a.password as "a.password",
        a.user_stats as "a.userStats",
        a.modified_time as "a.modifiedTime"
  from customer_login a where a.customer_id = #{customerId,jdbcType=INTEGER}
</select>

<resultMap id="testOneToOne2Map3_1" type="com.sss.pojo.CustomerLoginOneToOne">
    <id property="customerId" column="a.customerId"></id>
    <result property="loginName" column="a.loginName"></result>
    <result property="password" column="a.password"></result>
    <result property="userStats" column="a.userStats"></result>
    <result property="modifiedTime" column="a.modifiedTime"></result>
</resultMap>

<resultMap id="testOneToMany2Map" type="com.sss.pojo.CustomerLoginOneToMany" extends="testOneToOne2Map3_1">
    <collection property="customerLoginLogList" column="a.customerId" ofType="com.sss.pojo.CustomerLoginLog" select="selectFromCustomerLoginLog">
    </collection>
</resultMap>

<select id="selectFromCustomerLoginLog" parameterType="java.lang.Integer" resultType="com.sss.pojo.CustomerLoginLog">
    select b.login_id as "loginId",
        b.customer_id as "customerId",
        b.login_time as "loginTime",
        b.login_ip as "loginIp",
        b.login_type as "loginType"
        from customer_login_log b where customer_id = #{customerId,jdbcType=INTEGER}
</select>

public interface CustomerMapper {
    CustomerLoginOneToMany testOneToMany2(Integer customerId);
}


20:39:46.546 [main] DEBUG c.s.d.CustomerMapper.testOneToMany2 - ==>  Preparing: select a.customer_id as "a.customerId", a.login_name as "a.loginName", a.password as "a.password", a.user_stats as "a.userStats", a.modified_time as "a.modifiedTime" from customer_login a where a.customer_id = ? 
20:39:46.601 [main] DEBUG c.s.d.CustomerMapper.testOneToMany2 - ==> Parameters: 1(Integer)
20:39:46.623 [main] DEBUG c.s.d.C.selectFromCustomerLoginLog - ====>  Preparing: select b.login_id as "loginId", b.customer_id as "customerId", b.login_time as "loginTime", b.login_ip as "loginIp", b.login_type as "loginType" from customer_login_log b where customer_id = ? 
20:39:46.623 [main] DEBUG c.s.d.C.selectFromCustomerLoginLog - ====> Parameters: 1(Integer)
20:39:46.709 [main] DEBUG c.s.d.C.selectFromCustomerLoginLog - <====      Total: 2
20:39:46.709 [main] DEBUG c.s.d.CustomerMapper.testOneToMany2 - <==      Total: 1

N+1问题

无论是association还是collection都支持嵌套结果和嵌套查询：
1、嵌套结果:使用嵌套结果映射来处理重复的联合结果的子集
2、嵌套查询:通过执行另外一个 SQL 映射语句来返回预期的复杂类型
但是MyBatis官方文档不建议嵌套查询，因为会产生N+1问题。假设A表和B表关联，A表查了１次有N条记录，B表会查N次，总共N＋１次。
可以用延迟加载解决。

<settings>
    <!-- 打开延迟加载的开关 -->
    <setting name="lazyLoadingEnabled" value="true"/>
    <!-- 将积极加载改为消极加载，即延迟加载 -->
    <setting name="aggressiveLazyLoading" value="false"/>
</settings>


fetchType=lazy

阿里java开发手册中关于ORM部分

  1. 【强制】 在表查询中，一律不要使用 * 作为查询的字段列表，需要哪些字段必须明确写明。说明： 1）增加查询分析器解析成本。 2）增减字段容易与 resultMap 配置不一致。 3）无用字段增加网络消耗，尤其是 text 类型的字段。

  2. 【强制】 POJO 类的布尔属性不能加 is，而数据库字段必须加 is_，要求在 resultMap 中进行字段与属性之间的映射。说明： 参见定义 POJO 类以及数据库字段定义规定，在中增加映射，是必须的。 在MyBatis Generator 生成的代码中，需要进行对应的修改。

  3. 【强制】 不要用 resultClass 当返回参数，即使所有类属性名与数据库字段一一对应，也需要定义；反过来，每一个表也必然有一个 POJO 类与之对应。说明： 配置映射关系，使字段与 DO 类解耦，方便维护。

  4. 【强制】 sql.xml 配置参数使用： #{}， #param# 不要使用${} 此种方式容易出现 SQL 注入。

  5. 【强制】 iBATIS 自带的 queryForList(String statementName,int start,int size)不推荐使用。说明： 其实现方式是在数据库取到 statementName 对应的 SQL 语句的所有记录，再通过 subList 取start,size 的子集合。
    正例： Map<String, Object> map = new HashMap<>();
    map.put(“start”, start);
    map.put(“size”, size);

  6. 【强制】 不允许直接拿 HashMap 与 Hashtable 作为查询结果集的输出。说明： resultClass=”Hashtable” ， 会置入字段名和属性值，但是值的类型不可控。

  7. 【强制】 更新数据表记录时，必须同时更新记录对应的 gmt_modified 字段值为当前时间。

  8. 【推荐】 不要写一个大而全的数据更新接口。 传入为 POJO 类，不管是不是自己的目标更新字段，都进行 update table set c1=value1,c2=value2,c3=value3; 这是不对的。执行 SQL时， 不要更新无改动的字段，一是易出错；二是效率低；三是增加 binlog 存储。Java 开发手册

  9. 【参考】 @Transactional 事务不要滥用。事务会影响数据库的 QPS，另外使用事务的地方需要考虑各方面的回滚方案，包括缓存回滚、搜索引擎回滚、消息补偿、统计修正等。

10.【参考】 中的 compareValue 是与属性值对比的常量，一般是数字，表示相等时带上此条件； 表示不为空且不为 null 时执行； 表示不为 null 值时执行

其他良好设计规范

1、查询传参：
MyBatis查询不允许直接传递Map，可读性差，扩展性差。传递参数少于5个时，可以使用@Param注解传递参数。多于5个时，用JavaBean传参。和上述阿里规范第6条类似，不允许直接拿HashMap和HashTable输出查询结果。

smith789
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MyBatis基础篇八：自定义映射resultMap
czj66666666666的博客
04-01 754
八、自定义映射resultMap
mybatis类型映射
sunny_json的博客
01-17 1167
Mybatis 和 Java 的类型映射 ​ 包路径: org.apache.ibatis.type.TypeAliasRegistry this.registerAlias("string", String.class); this.registerAlias("byte", Byte.class); this.registerAlias("long", Long.class); this.registerAlias("short", Short.cla
Mybatis、Mybatis plus 自动把布尔值true、false转换为1,0
最新发布
2201_75600005的博客
06-14 398
1.设置数据库字段类型为tinyint 长度为1 2，对应的实体类字段设为布尔类型 3.存储和获取，存储true的时候数据库会填入1，存储false的时候数据库会存储0，获取的时候，会自动将1和0转换成true和false。
MyBatis高级结果映射
BLAZAR'
03-08 400
官网的示例 <resultMap id="detailedBlogResultMap" type="Blog"> <constructor> <idArg column="blog_id" javaType="int"/> </constructor> <result property="title" column="blog_title"/> <association property="author" javaTy
mybatis对布尔类型的处理
FAIRYTAIL的博客
10-26 6718
写在前面：各位看到此博客的小伙伴，如有不对的地方请及时通过私信我或者评论此博客的方式指出，以免误人子弟。多谢！ 前几篇记录完了对枚举类的处理，顺便简单记录一下对布尔值的处理，因为遇到了一个小坑。 新增属性： 先看下保存相关代码： // 实体属性 private Boolean localFlag; // xml中 <insert id="savePerson" parameterType="com.example.springbootmy..
Mybatis结果集自动映射的实例代码
08-31
当执行`selectUser`方法时，Mybatis会自动将查询结果的每一行映射为一个`User`对象。 需要注意的是，自动映射功能并不总是万能的。例如，当数据库列名与Java属性名不完全匹配时，或者需要处理复杂的一对多、多对一...
Mybatis高级结果映射
08-10
MyBatis 高级结果映射是其强大功能的核心之一，它允许开发人员灵活地将数据库查询结果映射到复杂的对象结构。在处理多表关联查询时，这种映射尤为重要，因为它可以有效地解决数据模型与数据库关系之间的差异。 在...
mybatis中注解映射SQL示例代码
08-29
MyBatis内建了缓存支持，默认情况下，一级缓存是打开的，即如果你使用相同的sqlSession接口调用相同的select查询，查询结果从缓存中取得而不是去查询数据库。也可以通过 `<cache>` 标签配置二级缓存。当配置了二级...
MyBatis结果映射.docx
06-19
在MyBatis中，结果映射（Result Mapping）是核心功能之一，用于将数据库查询结果自动映射到Java对象上，极大地简化了数据访问层的开发工作。在本例中，我们有两个表：`customer_tbl`（客户表）和`order_tbl`（订单表...
MyBatis结果映射Collection.docx
06-19
在MyBatis中，结果映射（Result Mapping）是将数据库查询结果与Java对象属性进行匹配和转换的关键机制。在给定的文件中，我们看到了一个关于MyBatis结果映射涉及多对一关系的实例，主要展示了如何处理一个客户...
MyBatis-Plus 字段类型为 bit、tinyint(1) 时映射为 boolean 类型
奇妙的Bug之旅
01-03 1821
在数据库中，有些字段使用 bit 或 tinyint(1) 类型来表示布尔值。不过在 Java 中，我们通常使用 boolean 类型来表示布尔值。因此，在使用 MyBatis-Plus 框架时，我们需要将 bit 或 tinyint(1) 类型的字段映射为 boolean 类型。本文将详细介绍如何使用 MyBatis-Plus 实现这种映射，并提供相关的代码示例。
Mybatis与Mysql常用数据类型映射表
qq_22049773的博客
12-24 883
MySQL JDBCType JavaType 备注 char CHAR String 定长字符 varchar VARCHAR String 变长字符串 tinyint TINYINT byte 1字节 smallint SMALLINT short 2字节 in...
mybatis从0到1
韩利鹏
01-03 346
mybatis从零到一学习实战依赖的引入配置数据库连接功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 依赖的引入 主要...
MyBatis3 映射boolean 类型注意事项
drnrrwfs的博客
04-06 2493
1、MySQL8 数据库关于boolean 存储结构定义:使用tinyint(1) 代表Boolean 类型 2、实体定义关于属性字段为boolean 类型定义: 3、 实体属性与数据库字段映射文件配置*Mapper.xml 文件 4、控制层，如何传递请求参数及其后台查询接口*Mapper定义: *.Controller: Mapper.xml ...
oracle字段mybatis怎么映射为boolean
谭十二的博客
11-27 6549
oracle中使用 char(1) 类型 1:true 0:false 实体类使用 Boolean 类型 mapper.xml s 返回到VO的是为true select id, name, as s from user;
mybatis查重时将mysql中属性是tinyint(1)的0和1转换为Boolean类型
qq_47802184的博客
03-30 3653
mybatis查重时将数据库的0和1转换为Boolean类型 当mysql中属性是tinyint(1) mybatis查询时将mysql的数值0和1转换成Boolean类型 解决方案 在数据库中将属性是tinyint(1)改成tinyint(2) 当mysql中属性是bit bit类型在mysql中代表Boolean，0代表true 1代表false ...
MySQL查询结果映射到map,如何将数据库查询映射到[Java]中的对象？
weixin_35067558的博客
02-19 576
I have a query that joins 5 tables.Then I fill my hand-made object with the column values that I need.What are solutions here that are wide-common to solve that problem using specific tools ? are ther...
mybatis结果集映射
08-11
在简单的场景下，MyBatis可以自动映射查询结果，但在复杂的场景下，你需要构建一个结果映射。 在使用结果映射时，可以使用鉴别器（discriminator）来根据不同的条件选择不同的结果映射。鉴别器会从结果集中获取每条...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值