关于MyBatis在插入时获取自增id

1.1 注释方法

@Insert("insert into book(bid, bname, price, number, cratedate) values(null,#{bname},#{price},#{number},#{cratedate}) ")int add(Book book);
//注意：在mapper中是不能重载的这里我特意写为add01@Insert("insert into book set  bname = #{name}, price =#{price}")@Options(useGeneratedKeys = true,keyColumn = "bid",keyProperty = "id")int add01(Map<String,Object> map);

主程序也就是测试程序可以查看结果

@Test
void add(){Map<String,Object> map = new HashMap<>();map.put("name","《钢铁是怎样连城的》");map.put("price",60.6);map.put("cratedate",LocalDateTime.now());System.out.println(map);bm.add01(map);System.out.println(map);}

结果

1.2 xml配置文件中书写

mapper

int add02(Map<String,Object> map);

对应的xml

   <insert id="add02" useGeneratedKeys="true" keyColumn="bid" keyProperty="id">insert into book set  bname = #{name}, price =#{price};</insert>

   @Testvoid add2xml(){Map<String,Object> map = new HashMap<>();map.put("name","《活着》");map.put("price",60.6);map.put("cratedate",LocalDateTime.now());System.out.println(map);bm.add02(map);System.out.println(map);}

结果