mybatis利用注解的方式操作数据库

2019独角兽企业重金招聘Python工程师标准>>>

public interface UserMapperI {
    @Insert("inset into users(name,age) values(#{name},#{age})")
    public  int add(User user);
    @Delete("delete from users where id=#{id}")
    public int delete(int id);
    @Update("update users set name=#{name},age=#{age} where id=#{id}")
    public int update(User user);
    @Select("select * from users")
    public List<User> getAll();
    @Select("select * from users where id=#{id}")
    public User getById(int id);
}

其中

config.xml设置为

测试类中是这样写的

       String resource="cofig.xml";
        InputStream is=TestUsers.class.getClassLoader().getResourceAsStream(resource);
        SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(is);
        SqlSession session=sessionFactory.openSession();

//得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
      UserMapperI userMapperI=session.getMapper(UserMapperI.class);
     List<User> list=userMapperI.getAll();
     session.close();
     System.out.println(list.size());

转载于:https://my.oschina.net/liujiawan/blog/497802