mybatis使用注解实现单表的CRUD

一、实体类

public class User {
		private Integer id;
		private String name;
		private String address;
		private Date birthday;
}

二、接口方法UserMapper.java

public interface UserMapper {
	@Insert("insert into user(name,address,birthday) values(#{name},#{address},#{birthday})")
	public void add(User user);
	@Update("update user set name=#{name},address=#{address},birthday=#{birthday} where id=#{id}")
	public void update(User user);
	@Delete("delete from user where id=#{value}")
	public void delete(Integer id);
	@Select("select * from user where id=#{value}")
	public User selectById(Integer id);
	@Select("select * from user")
	public List<User> selectAll();
}

三、mybatis配置文件注册mapper

  		<mappers>
  				<!-- 注解的时候使用class -->
  				<mapper class="com.gx.mapper.UserMapper" />
  		</mappers>

四、测试

public class UserTest {

	SqlSession session = MyBatisUtils.openSession();
	UserMapper userMapper = session.getMapper(UserMapper.class);
	
	@Test
	public void add() {
		userMapper.add(new User("aaa","武汉",new Date()));
		MyBatisUtils.closeSession(session);
	}
	
	@Test
	public void update() {
		userMapper.update(new User(102,"bbb","武汉",new Date()));
		MyBatisUtils.closeSession(session);
	}
	
	@Test
	public void delete() {
		userMapper.delete(102);
		MyBatisUtils.closeSession(session);
	}
	
	@Test
	public void selectById() {
		User user = userMapper.selectById(1);
		System.out.println(user);
		MyBatisUtils.closeSession(session);
	}
	
	@Test
	public void selectAll() {
		List<User> list = userMapper.selectAll();
		for (User u : list) {
			System.out.println(u);
		}
		MyBatisUtils.closeSession(session);
	}
}