Spring + SpringMVC + Mybatis 简单应
2018-08-24 本文已影响0人
shpunishment
web.xml 配置 SpringMVC
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 配置Spring IoC 配置文件路径 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/applicationContext.xml</param-value>
</context-param>
<!-- 配置ContextLoaderListener用以初始化Spring IoC 容器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置DispatchServlet -->
<!-- servlet-name : dispatcher 即找到/WEB-INF/dispatcher-servlet.xml载入Web工程 -->
<servlet>
<servlet-name>dispatcher</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 使DispatchServlet在服务器启动的时候就初始化 -->
<load-on-startup>2</load-on-startup>
</servlet>
<!-- Servlet 拦截配置 -->
<servlet-mapping>
<servlet-name>dispatcher</servlet-name>
<url-pattern>*.shpun</url-pattern>
</servlet-mapping>
</web-app>
dispatcher-servlet.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 使用注解驱动 -->
<mvc:annotation-driven/>
<!-- 扫描包下注解 -->
<context:component-scan base-package="com.*"/>
<!-- 定义视图解析器 -->
<!-- 找到/WEB-INF/jsp文件夹下，且文件后缀为.jsp的文件座位映射 -->
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"
p:prefix="/WEB-INF/jsp/" p:suffix=".jsp"
/>
<!-- 开启注解事务 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
applicationContext.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:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 启用扫描 -->
<context:annotation-config/>
<context:component-scan base-package="com.shpun.*"/>
<!-- 引入外部properties文件 -->
<context:property-placeholder location="WEB-INF/mysql.properties"/>
<!-- 设置数据库信息等 -->
<bean id="dateSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
</bean>
<!-- 集成Mybatis SqlSessionFactoryBean 去支持 SqlSessionFactory 配置 -->
<bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dateSource"/>
<property name="configLocation" value="WEB-INF/mybatis-config.xml"/>
</bean>
<!-- 事务管理器配置数据源事务 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dateSource"/>
</bean>
<!-- 使用注解定义事务 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
<!-- 自动扫描配置Mapper的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 指定Spring扫描的包 -->
<property name="basePackage" value="com.shpun.mapper"/>
<!-- 指定Spring中SqlSessionFactory的Bean的名称 -->
<property name="SqlSessionFactoryBeanName" value="SqlSessionFactory"/>
<!-- 指定类被注解标识才扫描 @Repository -->
<property name="annotationClass" value="org.springframework.stereotype.Repository"/>
</bean>
</beans>
mybatis-config.xml
<?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>
<settings>
<!-- 全局映射器启用缓存 -->
<setting name="cacheEnabled" value="true"/>
<!-- 允许JDBC支持生成的键 -->
<setting name="useGeneratedKeys" value="true"/>
<!-- 配置默认执行器 Reuse 重用预处理语句 -->
<setting name="defaultExecutorType" value="REUSE"/>
<!-- 全局启用延迟加载 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!-- 设置超时时间，决定驱动等待一个数据库相应的时间 -->
<setting name="defaultStatementTimeout" value="2500"/>
</settings>
<!-- 别名 -->
<typeAliases>
<typeAlias alias="customer" type="com.shpun.entity.Customer"/>
</typeAliases>
<!-- 映射器路径 -->
<mappers>
<mapper resource="com/shpun/mapper/CustomerMapper.xml"/>
</mappers>
</configuration>
Controller
package com.shpun.controller;
@Controller
@RequestMapping("/customer")
public class CustomerController {
@Autowired
private CustomerService customerService = null;
@RequestMapping(value = "/select",method = RequestMethod.GET)
public ModelAndView getCustomer(@RequestParam("id")String id){
Customer customer = customerService.selectCustomer(id);
ModelAndView mv = new ModelAndView();
mv.setViewName("customer");
mv.addObject("customer",customer);
// 需要Jackson2的jar包，设置后，返回的是json文件
//mv.setView(new MappingJackson2JsonView());
return mv;
}
}
table
json
ps:
Spring + SpringMVC + Mybatis 配置文件较多，一定一定一定不能配错了，不然各种错误，很难受的！相应的jsp文件需要使用jstl库，记得添加到lib中。然后再jsp的开头
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
IDEA中还要设置
IDEAuseJSTL.PNG
同时配置好，就可以使用JSTL库了，这里返回的jsp只简单使用的c:out
总结
虽然Spring + SpringMVC + Mybatis 一起使用时，配置的文件较多，但却为我们后面编写控制层真的省了很多麻烦。就是一开始配置这么多xml，会头疼！
