Mybatis注解增删改查的实例代码

public interface PeopleMapper {
 @Select("select * from people")
 List getPeopleList();
}

public static SqlSession getSqlSession(){
  return sqlSessionFactory.openSession(true);
 }
}

public interface PeopleMapper {
 @Select("select * from people")
 List getPeopleList();
 @Insert("insert into people(id, name, age, address) VALUES (#{id},#{name},#{age},#{address})")
 int addPeople(People people);
}

public class PeopleDAOtest {
 @Test
 public void print() {
  SqlSession sqlSession = MybatisUtils.getSqlSession();
  PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
  List people = peopleMapper.getPeopleList();
  for (People p :people){
   System.out.println(p);
  }
  sqlSession.close();
 }
 @Test
 public void add(){
  SqlSession sqlSession = MybatisUtils.getSqlSession();
  PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
  peopleMapper.addPeople(new People(6,"圣迭戈",456,"啥地方"));
  print();
 }
}

public interface PeopleMapper {
 @Delete("delete people from people where id=#{uid}")
 int delPeople(@Param("uid") int i);
}

public class PeopleDAOtest {
 @Test
 public void del(){
  SqlSession sqlSession = MybatisUtils.getSqlSession();
  PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
  peopleMapper.delPeople(6);
  print();
 }
}

public interface PeopleMapper {
 @Update("update mybatis.people set name=#{name} ,age=#{age} ,address=#{address} where id=#{id}")
 int updateP(People people);
}

public class PeopleDAOtest {
 @Test
 public void update(){
  SqlSession sqlSession = MybatisUtils.getSqlSession();
  PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
  peopleMapper.updateP(new People(5,"圣迭戈",456,"啥地方"));
  print();
 }
}