insert和insertSelective的差別:
後者有if标簽 前者沒有
DEBUG - ::, ==> Preparing: insert into teachers (id, name, gender, school_id) values (?, ?, ?, ?) (BaseJdbcLogger.java:)
DEBUG - ::, ==> Parameters: null, (String), (String), (Integer) (BaseJdbcLogger.java:)
DEBUG - ::, <== Updates: (BaseJdbcLogger.java:)
DEBUG - ::, ==> Preparing: insert into teachers ( name, gender, school_id ) values ( ?, ?, ? ) (BaseJdbcLogger.java:)
DEBUG - ::, ==> Parameters: (String), (String), (Integer) (BaseJdbcLogger.java:)
DEBUG - ::, <== Updates: (BaseJdbcLogger.java:)
總結:
insert和insertSelective:
如果是用前者 那麼就會插入id值 這樣以後插入的主鍵值自動增長就從那個最新插入的id開始
如果是後者就自動增長