介绍
通过 @Insert 注解执行 insert语句
修改IUserMapper
增加下面代码:
@Insert("insert into user (id,username,password,age,sex,status,create_time) values (#{id},#{username},#{password},#{age},#{sex},#{status},#{createTime})")
public int save(User user);
注解中的sql语句,与 mapper.xml 中的写法是一样的
#{id} 表示从 public int save(User user) 形参 user 中取出属性
测试
@org.junit.Test
public void test4() throws IOException {
User user=new User();
user.setId(UUID.randomUUID().toString().replace("-",""));
user.setUsername("lilei");
user.setPassword("12345678");
user.setAge(20);
user.setSex("1");
user.setStatus("1");
user.setCreateTime(new Date());
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
IUserMapper mapper = sqlSession.getMapper(IUserMapper.class);
int i=mapper.save(user);
sqlSession.commit();
System.out.println("插入"+i+"条记录!");
sqlSession.close();
inputStream.close();
}