天天看點

Mybatis逆向工程中insert和insertSelective的差別

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開始

如果是後者就自動增長

繼續閱讀