application.xml
<?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">
<!--mybatis和spring整各整体思路
1、加载数据源文件和实例化dbcp连接池
2、创建工厂,实例化工厂的同时就会创建出一个SqlSeesion
3、实例化代理类,
-->
<!--加载db.properties文件,注意这里是java项目可以直接写,如果是web项目就要写成classpath:db.properties -->
<context:property-placeholder location="db.properties" />
<!-- 数据源 -->
<bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${db.driver}"></property>
<property name="url" value="${db.url}"></property>
<property name="username" value="${db.username}"></property>
<property name="password" value="${db.password}"></property>
</bean>
<!--实例化工厂 -->
<bean id="sqlSessionfactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--这里我们把别名的配置也加到spring里面,这样之前配置的SqlMapperConfig.xml的配置就都在spring了 -->
<!-- <property name="configLocation" value="mybatis/SqlMapConfig.xml"></property> -->
<property name="typeAliasesPackage" value="zym.com.po"></property>
<property name="dataSource" ref="datasource"></property>
</bean>
<!--配置代理类,这里不用写id,默认id就是接口类名,并且首字母必须是小写 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="mapper"></property>
<!--如果只有一个数据源,默认是不需要指定工厂的,如果存在多个数据源,可以通过设置不同的工厂和basePackage的value值,这样不同路径下的代理接口就指向不同的工厂了。 -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionfactory"></property>
</bean>
</beans>
测试代码:
public class sqlTest extends SqlSessionDaoSupport {
private ApplicationContext applicationContext;
@Before
public void setup(){
applicationContext = new ClassPathXmlApplicationContext("mybatis/applicationContext.xml");
}
/*传入参数是基本类型的*/
@Test
public void findUserByName() {
UserMapper mapper = (UserMapper) applicationContext.getBean("userMapper");
List<User> findUserByName = mapper.findUserByName("zym");
System.out.println("结果:" +findUserByName);
}
}