spring整合mybatis
在mybaits的基础上进行整合,之前的代码在mybatis的find那篇。
1.导入spring-mybatis的jar包。
org.mybatis
mybatis-spring
2.0.6
2.创建spring-dao.xml配置文件,这个是用来整合mybatis的数据库,创建
sqlSessionFactory创建
sqlSession。创建
SqlSessionTemplate
<?xml version="1.0" encoding="UTF-8"?>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 https://www.springframework.org/schema/context/spring-context.xsd">
3.创建接口的实现类,通过实现类来访问数据。
public class MyBookMapperimpl implements MyBookMapper{
//在开始我们所有操作,都使用sqlSession来执行,spring介入后使用SqlSessionTemplate;
private SqlSessionTemplate sqlSessionTemplate;
public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate){
this.sqlSessionTemplate = sqlSessionTemplate;
}
@Override
public ListselectBooks() {
MyBookMapper myBookMapper = sqlSessionTemplate.getMapper(MyBookMapper.class);
return myBookMapper.selectBooks();
}
}
4.测试
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring-dao.xml");
MyBookMapper myBookMapper = applicationContext.getBean("mybookMapper",MyBookMapper.class);
for (Books books : myBookMapper.selectBooks()) {
System.out.println(books);