对于mybatis,就是sqlsessionfactory->sqlsession->方法->map语句
即与spring整合即可分为三部分:
1.整合sqlsessionfactory(通过单例方式管理)
2.整合sqlsession(使用sqlsessionfactory来管理。spring和mybatis整合自动完成)
3.整合mapper.(mapper.xml文件不需要spring来管理,但是mapper.java需要在spring中管理)
一、整合sqlsessionfactory
在applicationContext.xml配置sqlSessionFactory
和数据源
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置数据源 ,使用dacp -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="10" />
<property name="maxIdle" value="5" />
</bean>
<!-- sqlSessionFactory的配置 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 加载mybatis的配置文件 -->
<property name="configLocation" value="mybatis/sqlMapConfig.xml"></property>
<!-- 数据源 -->
<property name="dataSource" ref="dataSource"></property>
</bean>
二、举个原生dao的例子
1.创建User.xml
<?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">
<mapper namespace="test">
<select id="findUserById" parameterType="int" resultType="vo.User">
SELECT * FROM user WHERE id=#{value}
</select>
</mapper>
2.在SqlMapconfig.xml中加载User.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>
<mappers>
<mapper resource="yuandao/User.xml"/>
</mappers>
</configuration>
3.写一个接口
public interface UserDao { //根据id查询用户信息 public User findUserById(int id) throws Exception; }
4.写接口实现类dao(实现类要继承SqlSessionDaoSupport来自动生成sqlSession)
public class userDaoImp extends SqlSessionDaoSupport implements UserDao {
@Override
public User findUserById(int id) throws Exception {
SqlSession sqlSession=this.getSqlSession();
User user=sqlSession.selectOne("test.findUserById", id);
return user;
}
5.配置dao(在applicationcontxt.xmldao中管理dao,同时dao要注入sqlsessionfactory。)
<!-- 配置DAO -->
<bean id="userDao" class="yuandao.userDaoImp">
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
6.编写测试代码(测试代码通过spring容器来获得dao对象)
private ApplicationContext applicationContext;
//在setUp这个方法得到spring容器
@Before
public void setUp() throws Exception {
applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
}
@Test
public void testFindUserById() throws Exception {
UserDao userDao=(UserDao)applicationContext.getBean("userDao");
User user=userDao.findUserById(1);
System.out.println(user);
}