mybatis简单使用

1. 引入jar包

如果是非maven项目只需引入 mybatis-x.x.x.jar包到classpath目录下

如果是maven项目则需引入maven依赖

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>x.x.x</version>
</dependency>

注：不要忘记引入对应数据库的驱动

2. 添加mybatis全局配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@XXXX:1521:XXX"/>
                <property name="username" value="XXX"/>
                <property name="password" value="XXXXX"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper/nameMapper.xml"/>
    </mappers>
</configuration>

3.写Mapper.xml文件对应的sql语句

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.XXXX">
    <select id="queryXXX" resultType="com.entity.XXXX">
               select *  from dual
    </select>
</mapper>

4. 获取sqlSessionFactory并连接数据库

   @Test
    public void test1() throws IOException {
        String path="mybatis-config.xml";
        InputStream is= Resources.getResourceAsStream(path);
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);
        try{
            SqlSession sqlSession = sqlSessionFactory.openSession();
            List<X> objects =sqlSession.selectList("com.XX.queryXX");
            System.out.println(objects);
        }catch (Exception ex){
            ex.printStackTrace();
        }
    }

接口方式调用

   1.添加调用接口和xml

配置XML

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.contentMapper">
    <select id="queryBannder" resultType="com.entity.XXVo">
        select * from dual
    </select>
</mapper>



与XML对应接口
package mapper;
public interface contentMapper {
    List<XXVo> queryBannder();
}

   2.配置接口信息在mybatis配置文件中

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@10.16.3.236:1521:webdb"/>
                <property name="username" value="zcms"/>
                <property name="password" value="zving10301"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="mapper.contentMapper"/>
    </mappers>
</configuration>

3. 获取sqlSessionFactory

@Test
    public void test2() throws IOException {
        String path="mybatis-config.xml";
        InputStream is= Resources.getResourceAsStream(path);
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        XXMapper mapper = sqlSession.getMapper(XXMapper.class);
        List<XX> XXVos = mapper.queryXX();
        System.out.println(XXVos );
    }