SSM11.4【Mybatis：Mybatis相关API】

 

 

 

 

 

userMapper.xml

+

<!--根据id进行查询-->
    <select id="findById" resultType="user" parameterType="int">
        select * from user where id=#{id}
    </select>
 1 MybatisTest
 2 
 3 +
 4 
 5     @Test
 6     public void test5() throws IOException {
 7         //模拟User对象
 8         User user = new User();
 9         user.setUsername("tom");
10         user.setPassword("abc");
11 
12         //加载Mybatis核心配置文件
13         InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
14         //获取session工厂对象
15         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
16         //获取session会话对象
17         SqlSession sqlSession = sqlSessionFactory.openSession(true); //设置为true，那么不需要手动提交事务
18         //执行操作
19         sqlSession.insert("userMapper.save", user);
20         //提交事务
21 //        sqlSession.commit();
22         //释放资源
23         sqlSession.close();
24     }
25 
26     /**
27      * 查询一条数据
28      * @throws IOException
29      */
30     @Test
31     public void test6() throws IOException {
32         //加载Mybatis核心配置文件
33         InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
34         //获取session工厂对象
35         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
36         //获取session会话对象
37         SqlSession sqlSession = sqlSessionFactory.openSession();
38         //执行操作
39         User user = sqlSession.selectOne("userMapper.findById", 2);
40         //打印结果
41         System.out.println(user); //User{id=2, username='lisi', password='345'}
42         //释放资源
43         sqlSession.close();
44     }

 

posted @ 2021-07-22 23:35  yub4by  阅读(46)  评论(0)    收藏  举报