Mybatis学习——Mybatis操作sql


// 1. 获取配置流

  InputStream is = Resources.getResourceAsStream("sqlMapperConfig.xml")

// 2. 获取sql会话工厂

  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder.build(is);

// 3. 通过会话工厂获取会话对象

  SqlSession sqlSession = sqlSessionFactory.openSession();

// 4. 使用会话对象进行操作

  List userArray = sqlSession.selectList("userMapper.select");

// 加载流
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapperConfig.xml");
        // 获取会话工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        // 获取会话对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        List userArray = sqlSession.selectList("userMapper.select");
        System.out.println(userArray);
        sqlSession.close();