第一步:整合dao层即持久层
mybatis和spring整合,通过spring管理mapper接口,使用mapper的扫描自动扫描mapper接口在spring中进行注册
第二步:整合service层
service主要是进行业务逻辑处理
通过spring来管理service接口,使用注解/配置形式将service中实例交给容器管理
事务管理
第三步:整合SpringMVC
由于SpringMVC是属于spring一部分,不需要进行整合
需求:获取user表中所有数据展示到页面
依赖jar包
spring依赖、SpringMVC依赖、mybatis依赖、mybatis-spring依赖、MySQL依赖
<!--SPring 核心依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<!--Spring MVC依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
<!--mybatis和spring整合-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.2.RELEASE</version>
</dependency>
<!--数据库连接池-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
</dependencies>
开发dao层
主要mybatis相关
mybatis全局配置、pojo类、mapper.java接口文件,mapper.xml配置文件
mybatis全局配置文件
spring-mybatis.xml即mybatis全局配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--spring和mybatis-->
<!--配置数据源,可以整合到spring配置中-->
<!--配置mapper映射,可以整合到spring中-->
</configuration>
mapper.java接口文件
public interface UserMapper {
public List<User> selectAllUsers();
}
mapper.java接口文件
public interface UserMapper {
public List<User> selectAllUsers();
}
Spring配置文件
spring-core.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:aop="http://www.springframework.org/schema/aop"
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/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!--开启注解扫描-->
<context:component-scan base-package="com.tulun"/>
<!--配置数据源-->
<bean id="dataSource" class="com.mchange.v2.c3p0.DriverManagerDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test"/>
<property name="user" value="root"/>
<property name="password" value="123456"/>
</bean>
<!--配置SQLSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--配置数据源-->
<property name="dataSource" ref="dataSource"/>
<!--配置mapper配置文件路径-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
<!--引入mybatis的全局配置文件-->
<property name="configLocation" value="spring-mybatis.xml"/>
</bean>
<!--配置动态打理对象-->
<bean class="org.mybatis.spring.mapper.MapperFactoryBean">
<!--指定接口-->
<property name="mapperInterface" value="com.tulun.dao.UserMapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
</beans>
service层
service层主要是调用dao层获取数据,需要将dao层对象注入到service
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
public List<User> getAllUsers(){
return userMapper.selectAllUsers();
}
}
开发web层
配置前端控制器
在web.xml中配置前端控制器
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<!-- springMvc前端控制器配置 -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<!--指定需要加载SPringMVC配置文件的位置-->
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<!--
第一种:*.action 或者 *.do,访问以.action或*.do结尾 由DispatcherServlet进行解析
第二种:/,所以访问的地址都由DispatcherServlet进行解析,对于静态文件的解析需要配置不让DispatcherServlet进行解析
使用此种方式可以实现 RESTful风格的url
-->
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
springmvc的全局配置文件
spring-mvc.xml,主要完成处理器适配器、映射器、解析器等配置`<?xml version="1.0" encoding="UTF-8"?>
<!--开启COntroller相关注解扫描-->
<context:component-scan base-package="com.tulun.controller"/>
<!-- 处理器映射器、处理器适配器等采用SpringMVC提供的默认的处理器处理,就不需要显性配置-->
<mvc:annotation-driven />
<!--配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"
id="internalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
`
开发controller层
调用service层获取业务数据,即在controller层注入service
@Controller
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/list")
public ModelAndView userList() {
ModelAndView modelAndView = new ModelAndView();
List <User> users = userService.getAllUsers();
//填充数据
modelAndView.addObject("users",users);
//指定逻辑视图名
modelAndView.setViewName("userList");
return modelAndView;
}
}
开发jsp页面
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用户列表</title>
</head>
<body>
<table width="80%" border="1" align="center">
<h1 align="center">用户列表</h1>
<tr>
<td>用户ID</td>
<td>用户名</td>
<td>金额</td>
</tr>
<c:forEach items="${users }" var="user">
<tr>
<td>${user.id }</td>
<td>${user.name }</td>
<td>${user.money}" </td>
</tr>
</c:forEach>
</table>
</body>
</html>
配置引入spring核心配置
在web.xml中通过监听器来完成对spring配置文件的监听和加载
<!-- 加载spring容器:Spring和mybatis的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-core.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>