通用Mapper中insert方法与insertSelective的区别

insert方法是使用所有的属性作为字段使用

[html]  view plain  copy

1. @Test  
2.     public void testInsert() {  
3.         User record=new User();  
4.         record.setName("sansan");  
5.      // 使用所有的属性作为字段使用  
6.         this.newUserMapper.insert(record);  
7.     }  

结果：

2017-08-03 15:06:03,946 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insert]-[DEBUG] ==>  Preparing: INSERT INTO tb_user (AGE,USER_NAME,ID,NAME,BIRTHDAY,SEX,PASSWORD,UPDATED,CREATED) VALUES ( ?,?,?,?,?,?,?,?,? ) 
2017-08-03 15:06:03,973 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insert]-[DEBUG] ==> Parameters: null, null, null, sansan(String), null, null, null, null, null
2017-08-03 15:06:04,010 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insert]-[DEBUG] <==    Updates: 1
2017-08-03 15:06:04,014 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insert!selectKey]-[DEBUG] ==>  Executing: SELECT LAST_INSERT_ID() 
2017-08-03 15:06:04,025 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insert!selectKey]-[DEBUG] <==      Total: 1

insertSelective插入数据，使用不为null的属性作为字段使用

[html]  view plain  copy

1. <span style="font-size:10px;"> @Test  
2.     public void testInsertSelective() {  
3.         User record=new User();  
4.         record.setName("test_insertSelective");  
5. //        插入数据，使用不为null的属性作为字段使用  
6.         this.newUserMapper.insertSelective(record);  
7.     }</span>  

结果：

2017-08-03 14:41:30,406 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insertSelective]-[DEBUG] ==>  Preparing: INSERT INTO tb_user ( ID,NAME ) VALUES ( ?,? ) 
2017-08-03 14:41:30,434 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insertSelective]-[DEBUG] ==> Parameters: null, test_insertSelective(String)
2017-08-03 14:41:30,477 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insertSelective]-[DEBUG] <==    Updates: 1
2017-08-03 14:41:30,481 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insertSelective!selectKey]-[DEBUG] ==>  Executing: SELECT LAST_INSERT_ID() 
2017-08-03 14:41:30,493 [main] [cn.itcast.mybatis.mapper.NewUserMapper.insertSelective!selectKey]-[DEBUG] <==      Total: 1