- 原生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
- 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>