mybatis学习

1. 原生mybatis使用；
   一 ：简易mybatis核心配置文件
   ① 配置数据源
   ② 配置mapper
   文件：Configuration.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="com.ibm.db2.jcc.DB2Driver"/>
            <property name="url" value="jdbc:db2://10.27.24.242:60004/FCSPDEV" />
            <property name="username" value="fcspusr"/>
            <property name="password" value="$fdfg4Tg"/>
        </dataSource>
    </environment>
</environments>

<mappers>
    <mapper class="com.suning.demo.mapper.OperateRecordMapper"/>
</mappers>
</configuration>

二：model

package com.suning.demo.model;
public class OperateRecord {
    private String id;
    private String messageId;
    private String operateType;
    private String operateDesc;
    private String operateUser;
    private String operateTime;
    // 省略getset ，tostring
}

三:mapper
接口

package com.suning.demo.mapper;
import com.suning.demo.model.OperateRecord;
public interface OperateRecordMapper {
    OperateRecord getById();
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace 接口路径 -->
<mapper namespace="com.suning.demo.mapper.OperateRecordMapper">
<!-- id 和接口方法名一直 -->
    <select id="getById" parameterType="string" resultType="com.suning.demo.model.OperateRecord">
            SELECT * FROM OPERATE_RECORD WHERE ID = #{id}
    </select>
</mapper>

四：测试类

package com.suning.demo;

import com.suning.demo.mapper.OperateRecordMapper;
import com.suning.demo.model.OperateRecord;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;

import java.io.IOException;
import java.io.Reader;

public class Test {
    private static SqlSessionFactory sqlSessionFactory;
    private static Reader reader;
    static{
        try{
            reader  = Resources.getResourceAsReader("com/suning/demo/config/Configuration.xml"); // 注意路径
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        }catch(Exception e){
            e.printStackTrace();
        }
    }
    public static void main(String[] args) throws IOException {
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OperateRecordMapper operateRecordMapper = sqlSession.getMapper(OperateRecordMapper.class);
        OperateRecord operateRecord = operateRecordMapper.getById();
        System.out.println(operateRecord);
    }
}

五：依赖jar

org.mybatis
mybatis
3.2.1


com.ibm
db2jcc
9.5.3

1. mybatis + spring整合；
   配置sqlSessionFactory bean 和 MapperScannerConfigurer

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="plugins">
            <list>
            </list>
        </property>
        <property name="configurationProperties">
            <props>
                <prop key="dialect">db2</prop>
                <prop key="cacheEnabled">false</prop>
            </props>
        </property>
    </bean>

   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.suning.fly.business.dao.*"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

</beans>