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);
}