乙巳🐍年

<script>INSERT INTO ar_bank_info
  <trim prefix="(" suffix=")" suffixOverrides="," >
    <if test = 'policyNo != null'>policy_no, </if>
    <if test = 'orderNo != null'>order_no, </if>
    <if test = 'bankCode != null'>bank_code, </if>
    <if test = 'bankName != null'>bank_name, </if>
    <if test = 'bankIdNo != null'>bank_id_no, </if>
    <if test = 'bankAccountName != null'>bank_account_name, </if>
    <if test = 'bankProvince != null'>bank_province, </if>
    <if test = 'bankCity != null'>bank_city, </if>
    <if test = 'paymentForm != null'>payment_form, </if>
    <if test = 'createTime != null'>create_time, </if>
    <if test = 'backAmount != null'>back_amount, </if>
    <if test = 'soStatus != null'>so_status, </if>
  </trim>
  <trim prefix="values (" suffix=")" suffixOverrides="," >
    <if test = 'policyNo != null'>#{policyNo}, </if>
    <if test = 'orderNo != null'>#{orderNo}, </if>
    <if test = 'bankCode != null'>#{bankCode}, </if>
    <if test = 'bankName != null'>#{bankName}, </if>
    <if test = 'bankIdNo != null'>#{bankIdNo}, </if>
    <if test = 'bankAccountName != null'>#{bankAccountName}, </if>
    <if test = 'bankProvince != null'>#{bankProvince}, </if>
    <if test = 'bankCity != null'>#{bankCity}, </if>
    <if test = 'paymentForm != null'>#{paymentForm}, </if>
    <if test = 'createTime != null'>#{createTime}, </if>
    <if test = 'backAmount != null'>#{backAmount}, </if>
    <if test = 'soStatus != null'>#{soStatus}, </if>
  </trim>
  ON DUPLICATE KEY UPDATE
  policy_no = VALUES(policy_no),
  bank_name = VALUES(bank_name),
  bank_id_no = VALUES(bank_id_no),
  bank_code = VALUES(bank_code),
  bank_account_name = VALUES(bank_account_name),
  payment_form = VALUES(payment_form),
  modify_time = VALUES(modify_time),
  back_amount = VALUES(back_amount),
  so_status = VALUES(so_status)
</script>

阅读全文 »

04. MyBatis 注解

发表于 2022-10-01 分类于语言-Java ，框架-MyBatis

注解提供了一种简单的方式来实现简单映射语句，省略了对应的 mapper.xml，而不会引入大量的开销。但是比较复杂的 SQL 和动态 SQL 还是建议采用映射文件。

MyBatis 框架的注解

MyBatis 的常用的注解包括

注解	描述
@Insert、@Update、@Delete、@Select	映射增改删查 SQL 语句
@InsertProvider、@UpdateProvider、@DeleteProvider、@SelectProvider	映射增改删查动态 SQL 语句
@Result	在列和属性或字段之间的单独结果映射
@Results	结果映射的列表，包含了一个特别结果列如何被映射到属性或字段的详情
@One	复杂类型的单独属性值映射，相当于 `<association>`
@Many	映射到复杂类型的集合属性，相当于 `<collection>`
@Options	提供配置选项的附加值
@Param	当映射方法需要多个参数，这个注解可以被应用于映射器的方法参数来给每个参数一个名字。否则，多（不包括任何 RowBounds 参数），如 #{param1} , #{param2} 等。使用 @Param(“id”), 参数应该被命名为 #{id}
@ResultMap	给@Select 或者@SelectProvider 提供在 XML 映射中的的 id
@ResultType	当使用结果处理器时启用此注解

阅读全文 »