前言
本章讲解使用目前掌握的Spring的相关知识简化MyBatis
方法
1.概念
之前有说过,我们使用bean标签实例化一个类,我们感觉还不如"new"起来方便,那么我们将通过它简化MyBatis的步骤一步一步的探寻Spring的IOC/DI的妙用!
2.准备工作
在进行简化的时候,需要引入spring-jdbc、spring-web和mybatis-spring的jar
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.1.6.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
一、配置Spring配置文件
1.使用Spring配置文件加载JDBC配置文件
在MyBatis配置文件中,使用如下标签加载配置文件:
<properties resource="db.properties"/>
在Spring配置文件中,我们这样配置:
<!-- 引入jdbc配置文件 -->
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath*:db.properties</value>
</list>
</property>
</bean>
2.使用Spring配置文件配置JDBC配置数据源
在MyBatis配置文件中,使用如下标签:
<environments default="development">
<!-- 数据库连接环境配置标签,id唯一标识每个环境 -->
<environment id="development">
<!-- 声明使用的事务管理方式,这里采用原生的JDBC事务管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- 配置数据源,采用数据库连接池技术 -->
<dataSource type="POOLED">
<!-- 定义数据库连接必备的属性 -->
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
在Spring配置文件中,我们这样配置(事务管理暂时忽略):
<!-- 配置数据源 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
<property name="driverClassName" value="${driverClass}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</bean>
3.使用Spring配置文件配置SqlSessionFactory
<!-- 配置sqlSessionFactory -->
<bean id="sqlSessionFactory" name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
</bean>
4.配置mapper扫描
在MyBatis配置文件中,使用如下标签:
<!-- 配置mapper文件关联 -->
<mappers>
<!--<mapper resource="cn/edu/ccut/mapper/StudentMapper.xml"/>-->
<package name="cn.edu.ccut.mapper"/>
</mappers>
在Spring配置文件中,我们这样配置:
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.edu.ccut.mapper"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
5.配置service
<!-- 配置Service -->
<bean id="studentService" class="cn.edu.ccut.service.impl.StudentServiceImpl">
<property name="studentMapper" ref="studentMapper"></property>
</bean>
由于servlet目前无法实例化,因为实例化的结果不正确,暂时采用其他方式实例化,该部分将稍后介绍!
6.配置web.xml
配置其加载spring配置文件:
<!-- 加载Spring配置文件 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 配置欢迎页 -->
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
到此,我们基本的配置流程就算结束了,我们进行代码部分的修改,将减少很大部分的代码量!
二、精简代码
1.删除原来的DatabaseConnection,相关的Factory类,删除myBatis的配置文件
2.修改service文件:
修改StudentServiceImpl如下:
package cn.edu.ccut.service.impl;
import cn.edu.ccut.bo.Student;
import cn.edu.ccut.bo.User;
import cn.edu.ccut.mapper.StudentMapper;
import cn.edu.ccut.service.IStudentService;
import java.util.List;
import java.util.Set;
public class StudentServiceImpl implements IStudentService {
private StudentMapper studentMapper;
@Override
public boolean insert(Student student) {
if (studentMapper.findById(student.getId()) == null) {
studentMapper.doCreate(student);
}
return true;
}
@Override
public List<Student> listAll(){
return studentMapper.doListAll();
}
@Override
public User login(String username, String password){
return studentMapper.doLogin(username,password);
}
@Override
public List<Student> listAll(int currentPage, int lineSize){
return studentMapper.doListAllForPage(currentPage,lineSize);
}
@Override
public boolean delete(String id){
studentMapper.doRemove(id);
return true;
}
@Override
public boolean update(Student student){
studentMapper.doUpdate(student);
return true;
}
@Override
public boolean bantchDelete(Set<String> all){
studentMapper.doBantchRemove(all);
return true;
}
@Override
public Student getStudentInfo(String id){
return studentMapper.findById(id);
}
public StudentMapper getStudentMapper() {
return studentMapper;
}
public void setStudentMapper(StudentMapper studentMapper) {
this.studentMapper = studentMapper;
}
}
这里我们会发现,我们直接使用了mapper,比原来简化了很多!!
3.修改servlet文件:
实例:修改LoginServlet文件如下:
package cn.edu.ccut.servlet;
import cn.edu.ccut.service.IStudentService;
import cn.edu.ccut.service.impl.StudentServiceImpl;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/login.do")
@SuppressWarnings("all")
public class LoginServlet extends HttpServlet {
private IStudentService studentService;
@Override
public void init() throws ServletException {
ApplicationContext ac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
studentService = ac.getBean("studentService", StudentServiceImpl.class);
}
@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
String password = request.getParameter("password");
try {
if (studentService.login(username, password) != null) {
request.getSession().setAttribute("username", username);
request.getRequestDispatcher("/admin/list/welcome.jsp").forward(request, response);
} else {
request.setAttribute("errorMsg", "用户名或密码错误,请重新输入!");
request.getRequestDispatcher("/admin/login/login.jsp").forward(request, response);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
这里有人疑问了,为什么不能用之前的方法在配置文件里面加载service这个bean呢?我们光靠spring是不能够管理servlet的,将产生问题,需要我们之后学到的SpringMVC进行专门的管理才行,我们这里暂时采用初始化加载service进行操作!