mybatis注解开发-@Insert注解

介绍

通过 @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();
}

原文出处:/show_1IXl5q27l2.html