1. 基本执行流程图
2. 代码演示
public class MyBatisTest {
public static void main(String[] args) {
try {
InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
SqlSession sqlSession = sqlSessionFactory.openSession();
MyUser mu = sqlSession.selectOne("mybatis.mapper.UserMapper.selectUserById", 1);
System.out.println(mu);
MyUser addmu = new MyUser();
addmu.setUname("程恒");
addmu.setUsex("男");
sqlSession.insert("mybatis.mapper.UserMapper.addUser", addmu);
MyUser updatemu = new MyUser();
updatemu.setUid(1);
updatemu.setUname("张三");
updatemu.setUsex("女");
sqlSession.update("mybatis.mapper.UserMapper.updateUser", updatemu);
sqlSession.delete("mybatis.mapper.UserMapper.deleteUser", 3);
List<MyUser> listMu = sqlSession.selectList("mybatis.mapper.UserMapper.selectAllUser");
for (MyUser myUser : listMu) {
System.out.println(myUser);
}
sqlSession.commit();
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}