Spring整合mybatis

Spring整合mybatis

 

mybatis jar包:

 

其它jar包

 

mybatis主配置文件

 

<?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>
   <!-- 读取配置文件中的数据库信息 -->
   <properties  resource="JDBC.properties"/>
   <typeAliases>
 	<!-- <typeAlias type="Entity.Cgoods" alias="Cgoods"/> --><!-- 指定类名作为全限定名 -->
	<package name="com.woniu.entity"/> <!-- 指定包中所有类都使用类名代替全限定名 -->   
    </typeAliases>
   <!-- JDBC4大参数,数据源,连接池 全部交给Sping来做 -->
   
   <mappers>
   <!-- 管理com.woniu.Dao 下的所有映射文件 -->
   <package name="com.woniu.Dao"/>
   </mappers>
   </configuration>

Spring主配置文件

 

<?xml version="1.0" encoding="UTF-8"?>
<!-- 这些所有可以在帮助文档中通过搜索  beans.xsd 复制而得 
使用注解 需要导入
xmlns:context="http://www.springframework.org/schema/context
http://www.springframework.org/schema/context 
http://www.springframework.org/schema/context/spring-context.xsd
-->
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    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/context 
        http://www.springframework.org/schema/context/spring-context.xsd">
        
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
   <!-- mybatis主配置文件位置 -->
    <property name="configLocation" value="classpath:mybatisConfig.xml"></property>
    <!-- 数据源连接池 使用c3p0 -->
    <property name="dataSource" ref="dataSource"></property>
    </bean>    
    <!-- 配置JDBC -->
     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> 
     <property name="driverClass" value="${jdbc.driver}" />
     <property name="jdbcUrl" value="${jdbc.url}" />
     <property name="user" value="${jdbc.userName}" />
     <property name="password" value="${jdbc.password}" />
     </bean>  
     <!-- 读取配置文件 --> 
     <context:property-placeholder location="JDBC.properties"/>
   <!-- 扫描指定包下的所有Dao接口,自动生成该接口的实现类 -->
     <bean id="mapperScannerConfigurer" 
     class="org.mybatis.spring.mapper.MapperScannerConfigurer">
     <property name="basePackage" value="com.woniu.Dao"/>
     <property name="sqlSessionFactoryBeanName"  value="sqlSessionFactory"/>
     </bean>
</beans>

 

测试代码:

package com.woniu.test;
import java.util.List;
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.woniu.Dao.UserDao;
import com.woniu.entity.UserInfo;

public class Test01 {
	UserDao userdao;

	@Before
	public void start() {
		String path="applicationContext.xml";
	ApplicationContext ac	=new ClassPathXmlApplicationContext(path);
	 userdao = (UserDao) ac.getBean("userDao");
	}

	@Test
	public void test01() {
		UserInfo user=new UserInfo(6,"qweqeqwasdasd4as545","lslisa","123456","15121345678",1,1);
		userdao.insertUser(user);
	}