MyBatis简单使用

qwe3223678qwe

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");
}
}