SpringBoot测试系列 - 处理数据库自增主键

CREATE TABLE /*prefix*/keywords (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyword` varchar(100) NOT NULL default '',
  `testproject_id` int(10) unsigned NOT NULL default '0',
  `notes` text,
  PRIMARY KEY  (`id`),
  KEY /*prefix*/testproject_id (`testproject_id`),
  KEY /*prefix*/keyword (`keyword`),
  UNIQUE KEY /*prefix*/keyword_testproject_id (`keyword`,`testproject_id`)
) DEFAULT CHARSET=utf8;

@Service
public class KeywordsServiceImpl implements KeywordsService {

    @Autowired
    private KeywordsMapper keywordsMapper;
    @Override
    public Integer createKeywords(Keywords keywords) {
        return keywordsMapper.insert(keywords);
    }

}

 Keywords keywords=Keywords.builder().id(666).keyword("tester").testproject_id(333).notes("tester").build();

 <!-- 先查询自增主键值 -->
  <insert id="insert" parameterType="com.testlink4j.domain.Keywords">
    <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer">
      SELECT LAST_INSERT_ID()
    </selectKey>
    insert into keywords (id, keyword, testproject_id,
      notes)
    values (#{id,jdbcType=INTEGER}, #{keyword,jdbcType=VARCHAR}, #{testproject_id,jdbcType=INTEGER},
      #{notes,jdbcType=LONGVARCHAR})
  </insert>