新建一个BaseDao.java
注:
public abstract class BaseDao extends SqlSessionDaoSupport {
@Resource
public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
super.setSqlSessionTemplate(sqlSessionTemplate);
}
@Resource
public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
super.setSqlSessionFactory(sqlSessionFactory);
}
protected <T> T getMapper(Class<T> clazz) {
return getSqlSession().getMapper(clazz);
}
}
然后将原本继承SqlSessionDaoSupport的方法改为继承BaseDao
注:
如果你在Application.xml中用了SqlSessionTemplate或者SqlSessionFactory就把另外一个注释掉,如果2个都用了就都保留。
另外附上我的配置代码:
<?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-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<context:component-scan base-package="com.xzc.xuexi" />
<context:property-placeholder location="classpath:jdbc.properties" />
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url"
value="jdbc:mysql://${jdbc.host}/${jdbc.dbname}?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<!-- 自动扫描和注册Mapper接口 -->
<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property
name="basePackage" value="com.xzc.xuexi.mybatis.mapper" /> </bean> -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- spring中数据源引用 -->
<property name="dataSource" ref="dataSource" />
<!-- Mybatis自身的配置文件,一般用来声明别名 -->
<property name="configLocation" value="classpath:MybatisConifg.xml"></property>
<!-- mybatis的映射文件 -->
<property name="mapperLocations"
value="classpath*:com/xzc/xuexi/mybatis/sqlmap/*Mapper.xml" />
<!-- 要映射类的包路径,如果使用了这种方式,则configLocation中不必再进行声明 它一般对应我们的实体类所在的包,这个时候会自动取对应包中不包括包名的简单类名作为包括包名的别名。多个package之间可以用逗号或者分号等来进行分隔 -->
<property name="typeAliasesPackage" value="com.xzc.xuexi.entity" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
<!-- 如果想要进行批量操作可加入这个属性 -->
<constructor-arg index="1" value="BATCH" />
</bean>
</beans>