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>