關(guān)于在Mybatis和Mapper下的Postgresql自增主鍵Insert后取值的問題

iliyaku 發(fā)布于2019-07-25 12:35 / 3098人閱讀

摘要：傳統(tǒng)的形式如果用注解的話，特別是選擇的話，可能對的自增主鍵支持并不好。只需要稍一下即可支持對于袁貴對于，在生成動態(tài)時，忽略字段，然后就會自動取值數(shù)據(jù)庫里的類型的值以上代碼在下測試通過

傳統(tǒng)的xml形式

  
    
    insert into hxc.user_bank_account (bank_account, fund_id, validity_period, 
      deleted, bank_id, full_name, 
      is_default, deposit_bank, province, 
      city)
    values (#{bankAccount,jdbcType=VARCHAR}, #{fundId,jdbcType=BIGINT}, #{validityPeriod,jdbcType=DATE}, 
      #{deleted,jdbcType=INTEGER}, #{bankId,jdbcType=INTEGER}, #{fullName,jdbcType=VARCHAR}, 
      #{isDefault,jdbcType=INTEGER}, #{depositBank,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, 
      #{city,jdbcType=VARCHAR})

如果用注解的話，特別是選擇tk.mybatis.mapper的話，可能對POSTGRESQL的自增主鍵支持并不好。只需要稍buff一下即可支持
對于mapper

/**
 * DAO of `sms_send_result`
 * 
 * @author 袁貴
 * @version 1.0
 * @since 1.0
 */
public interface SmsSendResultMapper extends Mapper {
    
    @InsertProvider(type = BaseInsertProvider.class, method = "dynamicSQL")
    @Options(useGeneratedKeys = true, keyColumn = "id", keyProperty = "id")
    @Override
    int insertSelective(SmsSendResult record);
    
    @Options(useGeneratedKeys = true, keyColumn = "id", keyProperty = "id")
    @InsertProvider(type = BaseInsertProvider.class, method = "dynamicSQL")
    @Override
    int insert(SmsSendResult record);

}

對于entity，在生成insert動態(tài)SQL時，忽略ID字段，然后就會自動取值數(shù)據(jù)庫里的bigserial類型的ID值

@Table(name = "sms_send_result", schema = "sms")
public class SmsSendResult {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sms.sms_send_result.id
     *
     * @mbggenerated
     */
    @Id
    @Column(insertable = false)
    private Long id;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column sms.sms_send_result.telephone
     *
     * @mbggenerated
     */
    private String telephone;
.....
}

以上代碼在mybatis3.4.5+mapper3.4.5下測試通過