MyBatis简单使用

public interface UserMapper {
	@Insert(value = "insert into t_user (username,nickname,password,type) values (#{username},#{nickname},#{password},#{type})")
	public void add(User user);
	@Update(value = "update t_user set username=#{username},nickname=#{nickname},password=#{password},type=#{type} where id=#{id}")
	public void update(User user);
	@Delete(value = "delete from t_user where id=#{id}")
	public void delete(int id);
	@Select("select * from t_user where id=#{id}")
	public User load(int id);
}


public class test {
	@Test
	public void testLoad() {
		SqlSession sqlSession = null;
		InputStream is = null;

		try {
			is = Resources.getResourceAsStream("mybatis-config.xml");
			// 创建SqlSessionFactory
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()
					.build(is);
			// 创建SqlSession
			sqlSession = sqlSessionFactory.openSession();
			// 基于annotation的方式实现
			User u = sqlSession.getMapper(UserMapper.class).load(2);
			System.out.println(u.toString());

		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			if (sqlSession != null)
				sqlSession.close();
			if (is != null) {
				try {
					is.close();
				} catch (Exception e2) {
					// TODO: handle exception
				}
			}

		}
		// 读取配置文件

		// fail("Not yet implemented");
	}
}