mybatis-spring整合笔记

来源：互联网发布：游族网络天使纪元编辑：程序博客网时间：2024/06/10 14:44

1.1原始Dao开发的整合

开发步骤：

1、mybatis的配置文件sqlmapConfig.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>  <!-- Mappers的位置 -->  <mappers>  <mapper resource="com/zhfy/project/dao/UserMapper.xml"/>  </mappers>  </configuration>

2、编写spring的配置文件

（1）数据库连接及连接池

（2）事务管理（暂时可以不配置）

（3）sqlsessionFactory对象，配置到spring容器中

（4）mapper代理对象或者是dao实现类配置到spring容器中。

<?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:aop="http://www.springframework.org/schema/aop"         xmlns:tx="http://www.springframework.org/schema/tx"         xmlns:context="http://www.springframework.org/schema/context"         xsi:schemaLocation="http://www.springframework.org/schema/beans                              http://www.springframework.org/schema/beans/spring-beans.xsd                             http://www.springframework.org/schema/tx                              http://www.springframework.org/schema/tx/spring-tx.xsd                             http://www.springframework.org/schema/aop                              http://www.springframework.org/schema/aop/spring-aop.xsd                             http://www.springframework.org/schema/context                              http://www.springframework.org/schema/context/spring-context.xsd">                                                                      <!-- 加载配置文件 -->               <context:property-placeholder location="db.properties"/>                <!--1、 数据库连接池 -->               <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">                    <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>                 <!-- 3、 -->               <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">                 <property name="dataSource" ref="dataSource" />                 <!-- 加载mybatis的全局配置文件 -->                 <property name="configLocation" value="classpath:SqlMapConfig.xml" />               </bean>                <!-- 4、 -->                <bean id="userDao" class="com.zhfy.project.dao.impl.UserDaoImpl">                  <property name="sqlSessionFactory" ref="sqlSessionFactory" ></property>                </bean>                           </beans>

3、编写dao

public class UserDaoImpl extends SqlSessionDaoSupport implements IUserDao{public User findUserById(Integer id) {// TODO Auto-generated method stubreturn this.getSqlSession().selectOne("test.findUserById",id);} }

dao需要继承spring的提供的SqlSessionDaoSupport
4、测试

@Test    public void test1(){    ApplicationContext ac  = new ClassPathXmlApplicationContext("applicationContext.xml");    IUserDao userDao = ac.getBean(IUserDao.class);    User user = userDao.findUserById(1);    System.out.println(user);    }

1.2 Mapper的动态代理开发

开发步骤：

1、mybatis的配置文件sqlmapConfig.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>  <!-- Mappers的位置 -->  <mappers>  <mapper resource="com/zhfy/project/dao/UserMapper.xml"/>  </mappers>  </configuration>

2、编写spring的配置文件

（1）数据库连接及连接池

（2）事务管理（暂时可以不配置）

（3）sqlsessionFactory对象，配置到spring容器中

（4）mapper代理对象或者是dao实现类配置到spring容器中。

<?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:aop="http://www.springframework.org/schema/aop"         xmlns:tx="http://www.springframework.org/schema/tx"         xmlns:context="http://www.springframework.org/schema/context"         xsi:schemaLocation="http://www.springframework.org/schema/beans                              http://www.springframework.org/schema/beans/spring-beans.xsd                             http://www.springframework.org/schema/tx                              http://www.springframework.org/schema/tx/spring-tx.xsd                             http://www.springframework.org/schema/aop                              http://www.springframework.org/schema/aop/spring-aop.xsd                             http://www.springframework.org/schema/context                              http://www.springframework.org/schema/context/spring-context.xsd">                                                                      <!-- 加载配置文件 -->               <context:property-placeholder location="db.properties"/>                <!--1、 数据库连接池 -->               <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">                    <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>                 <!-- 3、 -->               <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">                 <property name="dataSource" ref="dataSource" />                 <!-- 加载mybatis的全局配置文件 -->                 <property name="configLocation" value="classpath:SqlMapConfig.xml" />               </bean>                              <bean class="org.mybatis.spring.mapper.MapperFactoryBean"><!--Mapper接口--><property name="mapperInterface" value="com.zhfy.project.dao.IUserDao"/><!--工厂--><property name="sqlSessionFactory" ref="sqlSessionFactory"/>  </bean>                            </beans>

3、编写mapper文件

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.zhfy.project.dao.IUserDao">  <select id="findUserById" parameterType="Integer" resultType="com.zhfy.project.pojo.User">    SELECT * FROM t_user WHERE ID= #{id}  </select></mapper>

mapper中的namespace要为对应接口

4、测试

@Test    public void test1(){    ApplicationContext ac  = new ClassPathXmlApplicationContext("applicationContext.xml");    IUserDao userDao = ac.getBean(IUserDao.class);    User user = userDao.findUserById(1);    System.out.println(user);    }

1.3扫描mapper动态代理开发

开发步骤：

1、mybatis的配置文件sqlmapConfig.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>  <!-- Mappers的位置 -->  <mappers>  <mapper resource="com/zhfy/project/pojo/UserMapper.xml"/>  </mappers>  </configuration>

2、编写spring的配置文件

（1）数据库连接及连接池

（2）事务管理（暂时可以不配置）

（3）sqlsessionFactory对象，配置到spring容器中

（4）mapper代理对象或者是dao实现类配置到spring容器中。

<?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:aop="http://www.springframework.org/schema/aop"         xmlns:tx="http://www.springframework.org/schema/tx"         xmlns:context="http://www.springframework.org/schema/context"         xsi:schemaLocation="http://www.springframework.org/schema/beans                              http://www.springframework.org/schema/beans/spring-beans.xsd                             http://www.springframework.org/schema/tx                              http://www.springframework.org/schema/tx/spring-tx.xsd                             http://www.springframework.org/schema/aop                              http://www.springframework.org/schema/aop/spring-aop.xsd                             http://www.springframework.org/schema/context                              http://www.springframework.org/schema/context/spring-context.xsd">                                                                      <!-- 加载配置文件 -->               <context:property-placeholder location="db.properties"/>                <!--1、 数据库连接池 -->               <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">                    <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>                 <!-- 3、 -->               <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">                 <property name="dataSource" ref="dataSource" />                 <!-- 加载mybatis的全局配置文件 -->                 <property name="configLocation" value="classpath:SqlMapConfig.xml" />               </bean>                             <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 指定扫描的基本包 --><property name="basePackage" value="com.zhfy.project.dao"/></bean>                           </beans>

3、编写mapper文件

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.zhfy.project.dao.IUserDao">  <select id="findUserById" parameterType="Integer" resultType="com.zhfy.project.pojo.User">    SELECT * FROM t_user WHERE ID= #{id}  </select></mapper>

mapper中的namespace要为对应接口

4、测试

@Test    public void test1(){    ApplicationContext ac  = new ClassPathXmlApplicationContext("applicationContext.xml");    IUserDao userDao = ac.getBean(IUserDao.class);    User user = userDao.findUserById(1);    System.out.println(user);    }

阅读全文

0 0