1.mavenjar包
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>3.3.9</version>
</dependency>
2.spring mybats配置
<!-- mybatis -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:/mybatis/mybatis-config.xml"></property>
<property name="dataSource" ref="dynamicDataSource" />
<property name="typeAliasesPackage" value="com.ovationtrip.erp.domain" />
<property name="mapperLocations" value="classpath:/mybatis/mapper/**/*Mapper.xml" />
</bean>
<bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<property name="basePackage" value="com.ovationtrip.erp.dao" />
<property name="annotationClass" value="org.springframework.stereotype.Repository"/>
<property name="properties">
<value>
mappers=tk.mybatis.mapper.common.Mapper,tk.mybatis.mapper.common.IdsMapper
</value>
</property>
</bean>
ps:原来我使用MapperScannerConfigurer的时候,没有配置properties,只会实例化tk.mybatis.mapper.common.Mapper的接口
所以我下面使用IdsMapper的时候就会报错,这里需要实例化配置一下
而且,selectByIds和deleteByIds,的参数ids ,它in的时候是不会再split的,所以字符串,你传入的ids要自己拼上'' 。
接口方法里的实现代码是in ( ${param} )
3.
dao
//公共service和公共dao使用
public interface MapperAdapter<T> extends IdsMapper<T> , Mapper<T> {}
//业务dao的父类接口
public interface BaseMapper<T> extends MapperAdapter<T>{}
譬如一个UserMapper
@Repository
public interface UserMapper extends BaseMapper<User>{}
公共service
public interface IBaseService<T> extends MapperAdapter<T>{}
@Transactional
public class BaseServiceImpl<T> implements IBaseService<T> {
@Autowired
private BaseMapper<T> mapper ;
//实现父类的各种方法就行了
@Override
public List<T> select(T record) {
return mapper.select(record) ;
}
//好多方法。。。。
}
@Service
public class UserService extends BaseServiceImpl implemetns IUserService{
}
OK