insert和insertSelective的区别:
后者有if标签 前者没有
DEBUG 09-06 14:36:54,534 ==> Preparing: insert into teachers (id, name, gender, school_id) values (?, ?, ?, ?) (BaseJdbcLogger.java:159)
DEBUG 09-06 14:36:54,610 ==> Parameters: null, 8(String), 1(String), 2(Integer) (BaseJdbcLogger.java:159)
DEBUG 09-06 14:36:54,614 <== Updates: 1 (BaseJdbcLogger.java:159)
DEBUG 09-06 14:36:54,659 ==> Preparing: insert into teachers ( name, gender, school_id ) values ( ?, ?, ? ) (BaseJdbcLogger.java:159)
DEBUG 09-06 14:36:54,661 ==> Parameters: 9(String), 1(String), 2(Integer) (BaseJdbcLogger.java:159)
DEBUG 09-06 14:36:54,666 <== Updates: 1 (BaseJdbcLogger.java:159)
总结:
insert和insertSelective:
如果是用前者 那么就会插入id值 这样以后插入的主键值自动增长就从那个最新插入的id开始
如果是后者就自动增长