SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

1.开发环境搭建以及创建Maven Web项目

参看之前的博文：http://www.cnblogs.com/cainiaomahua/p/6306476.html

2.SSM整合

这次整合有2个配置文件，分别是spring-mybatis.xml，包含spring和mybatis的配置文件，还有个是spring-mvc的配置文件，此外有2个资源文件：jdbc.propertis和log4j.properties。

完整目录结构如下:

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

使用框架的版本：

Spring 4.0.2 RELEASE

Spring MVC 4.0.2 RELEASE

MyBatis 3.2.6

2.1 Maven引入需要的JAR包

在pom.xml中引入jar包(此处引入jar包,可以复制代码,也可以使用视图的方式,参考此链接:http://www.360doc.com/content/14/0517/18/9560593_378558295.shtml)

  1 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  3     <modelVersion>4.0.0</modelVersion>
  4     <groupId>org.storm</groupId>
  5     <artifactId>storm</artifactId>
  6     <version>0.0.1-SNAPSHOT</version>
  7     <name>storm</name>
  8     <url>http://maven.apache.org</url>
  9 
 10     <properties>
 11         <!-- Spring版本号 -->
 12         <spring.version>4.0.2.RELEASE</spring.version>
 13         <!-- mybatis版本号 -->
 14         <mybatis.version>3.2.6</mybatis.version>
 15         <!-- log4j日志文件管理包版本 -->
 16         <slf4j.version>1.7.7</slf4j.version>
 17         <log4j.version>1.2.17</log4j.version>
 18     </properties>
 19 
 20     <dependencies>
 21         <dependency>
 22             <groupId>junit</groupId>
 23             <artifactId>junit</artifactId>
 24             <version>4.11</version>
 25             <!-- 表示开发的时候引入，发布的时候不会加载此包 -->
 26             <scope>test</scope>
 27         </dependency>
 28 
 29         <!-- Spring核心包 -->
 30         <dependency>
 31             <groupId>org.springframework</groupId>
 32             <artifactId>spring-core</artifactId>
 33             <version>4.0.2.RELEASE</version>
 34         </dependency>
 35         <dependency>
 36             <groupId>org.springframework</groupId>
 37             <artifactId>spring-web</artifactId>
 38             <version>4.0.2.RELEASE</version>
 39         </dependency>
 40         <dependency>
 41             <groupId>org.springframework</groupId>
 42             <artifactId>spring-oxm</artifactId>
 43             <version>4.0.2.RELEASE</version>
 44         </dependency>
 45         <dependency>
 46             <groupId>org.springframework</groupId>
 47             <artifactId>spring-tx</artifactId>
 48             <version>4.0.2.RELEASE</version>
 49         </dependency>
 50         <dependency>
 51             <groupId>org.springframework</groupId>
 52             <artifactId>spring-jdbc</artifactId>
 53             <version>4.0.2.RELEASE</version>
 54         </dependency>
 55         <dependency>
 56             <groupId>org.springframework</groupId>
 57             <artifactId>spring-webmvc</artifactId>
 58             <version>4.0.2.RELEASE</version>
 59         </dependency>
 60         <dependency>
 61             <groupId>org.springframework</groupId>
 62             <artifactId>spring-aop</artifactId>
 63             <version>4.0.2.RELEASE</version>
 64         </dependency>
 65         <dependency>
 66             <groupId>org.springframework</groupId>
 67             <artifactId>spring-context-support</artifactId>
 68             <version>4.0.2.RELEASE</version>
 69         </dependency>
 70         <dependency>
 71             <groupId>org.springframework</groupId>
 72             <artifactId>spring-test</artifactId>
 73             <version>4.0.2.RELEASE</version>
 74         </dependency>
 75 
 76         <!-- mybatis核心包 -->
 77         <dependency>
 78             <groupId>org.mybatis</groupId>
 79             <artifactId>mybatis</artifactId>
 80             <version>3.2.6</version>
 81         </dependency>
 82 
 83         <!-- mybatis/spring包 -->
 84         <dependency>
 85             <groupId>org.mybatis</groupId>
 86             <artifactId>mybatis-spring</artifactId>
 87             <version>1.2.2</version>
 88         </dependency>
 89 
 90         <!-- 引入java ee jar 包 -->
 91         <dependency>
 92             <groupId>javax</groupId>
 93             <artifactId>javaee-api</artifactId>
 94             <version>7.0</version>
 95         </dependency>
 96 
 97         <!-- 导入oracle包 -->
 98         <dependency>
 99             <groupId>com.oracle</groupId>
100             <artifactId>ojdbc</artifactId>
101             <version>6</version>
102         </dependency>
103 
104         <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
105         <dependency>
106             <groupId>commons-dbcp</groupId>
107             <artifactId>commons-dbcp</artifactId>
108             <version>1.2.2</version>
109         </dependency>
110 
111         <!-- JSTL标签类 -->
112         <dependency>
113             <groupId>jstl</groupId>
114             <artifactId>jstl</artifactId>
115             <version>1.2</version>
116         </dependency>
117 
118         <!-- 日志文件管理包 -->
119         <!-- log start -->
120         <dependency>
121             <groupId>log4j</groupId>
122             <artifactId>log4j</artifactId>
123             <version>1.2.17</version>
124         </dependency>
125 
126         <!-- 格式化对象，方便输出日志 -->
127         <dependency>
128             <groupId>com.alibaba</groupId>
129             <artifactId>fastjson</artifactId>
130             <version>1.1.41</version>
131         </dependency>
132         <dependency>
133             <groupId>org.slf4j</groupId>
134             <artifactId>slf4j-api</artifactId>
135             <version>1.7.7</version>
136         </dependency>
137         <dependency>
138             <groupId>org.slf4j</groupId>
139             <artifactId>slf4j-log4j12</artifactId>
140             <version>1.7.7</version>
141         </dependency>
142         <!-- log end -->
143         <!-- 映入JSON -->
144         <dependency>
145             <groupId>org.codehaus.jackson</groupId>
146             <artifactId>jackson-mapper-asl</artifactId>
147             <version>1.9.13</version>
148         </dependency>
149 
150         <!-- 上传组件包 -->
151         <dependency>
152             <groupId>commons-fileupload</groupId>
153             <artifactId>commons-fileupload</artifactId>
154             <version>1.3.1</version>
155         </dependency>
156         <dependency>
157             <groupId>commons-io</groupId>
158             <artifactId>commons-io</artifactId>
159             <version>2.4</version>
160         </dependency>
161         <dependency>
162             <groupId>commons-codec</groupId>
163             <artifactId>commons-codec</artifactId>
164             <version>1.9</version>
165         </dependency>
166     </dependencies>
167     <build>
168         <finalName>storm</finalName>
169         <plugins>
170             <plugin>
171                 <groupId>org.eclipse.jetty</groupId>
172                 <artifactId>jetty-maven-plugin</artifactId>
173                 <version>9.2.8.v20150217</version>
174                 <configuration>
175                     <httpConnector>
176                         <port>8090</port>
177                     </httpConnector>
178                     <stopKey>shutdown</stopKey>
179                     <stopPort>9966</stopPort>
180                 </configuration>
181             </plugin>
182         </plugins>
183     </build>
184     <packaging>war</packaging>
185 </project>

2.2 整合SpringMVC

2.2.1 配置spring-mvc.xml

配置里面的注释也很详细，主要是自动扫描控制器，视图模式，注解的启动这三个。

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
 4     xmlns:context="http://www.springframework.org/schema/context"
 5     xmlns:mvc="http://www.springframework.org/schema/mvc"
 6     xsi:schemaLocation="
 7         http://www.springframework.org/schema/beans 
 8         http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
 9         http://www.springframework.org/schema/context 
10         http://www.springframework.org/schema/context/spring-context-3.1.xsd
11         http://www.springframework.org/schema/mvc
12         http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
13     <!-- 自动扫描,使SpringMVC认为包下用了@Controller注解的类是控制器 -->
14     <context:component-scan base-package="com.cn.hnust.controller" />
15     <!-- 扩充了注解驱动,可以将请求参数绑定到控制器参数 -->
16     <mvc:annotation-driven />
17     <!-- 静态资源处理 css js imgs -->
18     <mvc:resources location="/resources/**" mapping="/resources" />
19     <!-- 避免IE执行AJAX时,返回JSON出现下载文件 -->
20     <bean id="mappingJacksonHttpMessageConverter"
21         class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
22         <property name="supportedMediaTypes">
23             <list>
24                 <value>text/html;charset=UTF-8</value>
25             </list>
26         </property>
27     </bean>
28 
29     <!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->
30     <bean
31         class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
32         <property name="messageConverters">
33             <list>
34                 <!-- JSON转换器 -->
35                 <ref bean="mappingJacksonHttpMessageConverter" />
36             </list>
37         </property>
38     </bean>
39 
40     <!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 -->
41     <bean id="multipartResolver"
42         class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
43         <!-- 默认编码 -->
44         <property name="defaultEncoding" value="utf-8"></property>
45         <!-- 文件大小最大值 -->
46         <property name="maxUploadSize" value="10485760000"></property>
47         <!-- 内存中的最大值 -->
48         <property name="maxInMemorySize" value="40960"></property>
49         <!-- 启用是为了推迟文件解析,以便捕获文件大小异常 -->
50         <property name="resolveLazily" value="true"></property>
51     </bean>
52 
53     <!-- 配置ViewResolver。可用多个ViewResolver。使用order属性排序。 InternalResourceViewResolver 
54         放在最后 -->
55     <bean
56         class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">
57         <property name="order" value="1"></property>
58         <property name="mediaTypes">
59             <map>
60                 <!-- 告诉视图解析器,返回的类型是json格式 -->
61                 <entry key="json" value="application/json"></entry>
62                 <entry key="xml" value="application/xml"></entry>
63                 <entry key="htm" value="text/htm"></entry>
64             </map>
65         </property>
66         <property name="defaultViews">
67             <list>
68                 <!-- ModelAndView里的数据变成JSON -->
69                 <bean
70                     class="org.springframework.web.servlet.view.json.MappingJacksonJsonView"></bean>
71             </list>
72         </property>
73         <property name="ignoreAcceptHeader" value="true"></property>
74     </bean>
75     <!-- 定义跳转的文件的前后缀,视图模式配置 -->
76     <bean
77         class="org.springframework.web.servlet.view.InternalResourceViewResolver">
78         <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
79         <property name="prefix" value="/WEB-INF/jsp/"></property>
80         <property name="suffix" value=".jsp"></property>
81     </bean>
82 </beans>

2.2.2 配置web.xml文件

配置的spring-mvc的Servlet就是为了完成SpringMVC+MAVEN的整合。

web.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 3     xmlns="http://java.sun.com/xml/ns/javaee"
 4     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
 5     version="3.0">
 6     <display-name>Archetype Created Web Application</display-name>
 7     <!-- Spring和MyBatis的配置文件 -->
 8     <!-- <context-param>
 9         <param-name>contextConfigLocation</param-name>
10         <param-value>classpath:spring-mybatis.xml</param-value>
11     </context-param> -->
12     <!-- 编码过滤器 -->
13     <filter>
14         <filter-name>encodingFilter</filter-name>
15         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
16         <async-supported>true</async-supported>
17         <init-param>
18             <param-name>encoding</param-name>
19             <param-value>UTF-8</param-value>
20         </init-param>
21     </filter>
22     <filter-mapping>
23         <filter-name>encodingFilter</filter-name>
24         <url-pattern>/*</url-pattern>
25     </filter-mapping>
26     <!-- Spring监听器 -->
27     <!-- <listener>
28         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
29     </listener> -->
30     <!-- 防止Spring内存溢出监听器 -->
31     <!-- <listener>
32         <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
33     </listener> -->
34 
35     <!-- Spring MVC servlet -->
36     <servlet>
37         <servlet-name>SpringMVC</servlet-name>
38         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
39         <!-- 下面init-param是自定义servlet.xml配置文件的位置和名称，默认为WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，如spring-servlet.xml -->
40         <init-param>
41             <param-name>contextConfigLocation</param-name>
42             <param-value>classpath:spring-mvc.xml</param-value>
43         </init-param>
44         <load-on-startup>1</load-on-startup>
45         <async-supported>true</async-supported>
46     </servlet>
47     <servlet-mapping>
48         <servlet-name>SpringMVC</servlet-name>
49         <!-- 此处可以配置成*.do,对应struts的后缀习惯 -->
50         <url-pattern>/</url-pattern>
51     </servlet-mapping>
52     <welcome-file-list>
53         <welcome-file>/index.jsp</welcome-file>
54     </welcome-file-list>
55 </web-app>

2.2.3 Log4j的配置

为了方便调试，一般都会使用日志来输出信息，Log4j是Apache的一个开放源代码项目，通过使用Log4j，我们可以控制日志信息输送的目的地是控制台、文件、GUI组件，甚至是套接口服务器、NT的事件记录器、UNIX Syslog守护进程等；我们也可以控制每一条日志的输出格式；通过定义每一条日志信息的级别，我们能够更加细致地控制日志的生成过程。

Log4j的配置很简单，而且也是通用的，下面给出一个基本的配置，换到其他项目中也无需做多大的调整。

log4j.properties

 1 #定义LOG输出级别
 2 log4j.rootLogger=INFO,Console,File
 3 #定义日志输出目的地为控制台
 4 log4j.appender.Console=org.apache.log4j.ConsoleAppender
 5 log4j.appender.Console.Target=System.out
 6 #可以灵活地指定日志输出格式,下面一行是指定具体的格式
 7 log4j.appender.Console.layout=org.apache.log4j.PatternLayout
 8 log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n
 9 
10 #文件大小达到指定尺寸的时候产生一个新的文件
11 log4j.appender.File=org.apache.log4j.RollingFileAppender
12 #指定输出目录
13 log4j.appender.File.File=logs/ssm.log
14 #定义文件最大大小
15 log4j.appender.File.MaxFileSize=10MB
16 #输出所有日志,如果换成DEBUG表示输出DEBUG以上级别日志
17 log4j.appender.File.Threshold=ALL
18 log4j.appender.File.layout=org.apache.log4j.PatternLayout  
19 log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

2.2.4 使用Jetty测试

Student类对应于数据库中表的属性

 1 package com.cn.hnust.pojo;
 2 
 3 public class Student {
 4     private Integer id;
 5 
 6     private String stu_name;
 7 
 8     private Integer gender;
 9 
10     private Integer age;
11 
12     private String address;
13 
14     public Integer getId() {
15         return id;
16     }
17 
18     public void setId(Integer id) {
19         this.id = id;
20     }
21 
22     public String getStu_name() {
23         return stu_name;
24     }
25 
26     public void setStu_name(String stu_name) {
27         this.stu_name = stu_name;
28     }
29 
30     public Integer getGender() {
31         return gender;
32     }
33 
34     public void setGender(Integer gender) {
35         this.gender = gender;
36     }
37 
38     public Integer getAge() {
39         return age;
40     }
41 
42     public void setAge(Integer age) {
43         this.age = age;
44     }
45 
46     public String getAddress() {
47         return address;
48     }
49 
50     public void setAddress(String address) {
51         this.address = address;
52     }
53 
54     @Override
55     public String toString() {
56         return "Student [id=" + id + ", stu_name=" + stu_name + ", gender="
57                 + gender + ", age=" + age + ", address=" + address + "]";
58     }
59 }

控制器类

 1 package com.cn.hnust.controller;
 2 
 3 import java.io.File;
 4 import java.io.IOException;
 5 import java.util.Map;
 6 
 7 import javax.annotation.Resource;
 8 import javax.servlet.http.HttpServletRequest;
 9 
10 import org.apache.commons.io.FileUtils;
11 import org.slf4j.Logger;
12 import org.slf4j.LoggerFactory;
13 import org.springframework.http.HttpStatus;
14 import org.springframework.http.ResponseEntity;
15 import org.springframework.stereotype.Controller;
16 import org.springframework.ui.Model;
17 import org.springframework.web.bind.annotation.PathVariable;
18 import org.springframework.web.bind.annotation.RequestMapping;
19 import org.springframework.web.bind.annotation.RequestMethod;
20 import org.springframework.web.bind.annotation.RequestParam;
21 import org.springframework.web.bind.annotation.ResponseBody;
22 import org.springframework.web.multipart.MultipartFile;
23 
24 import com.cn.hnust.pojo.Student;
25 import com.cn.hnust.service.IStudentService;
26 
27 @Controller
28 @RequestMapping("/student")
29 public class StudentController {
30     private static Logger log = LoggerFactory
31             .getLogger(StudentController.class);
32 
33     @Resource
34     private IStudentService studentService;
35 
36     // /student/test?id=1
37     @RequestMapping(value = "/test", method = RequestMethod.GET)
38     public String test(HttpServletRequest request, Model model) {
39         int studentId = Integer.parseInt(request.getParameter("id"));
40         System.out.println("test studentId:" + studentId);
41         Student student = null;
42         if (studentId == 1) {
43             student = new Student();
44             student.setAge(19);
45             student.setId(1);
46             student.setGender(1);
47             student.setAddress("北京七里省际大厦3栋4402");
48             student.setStu_name("江泽");
49         }
50 
51         log.debug(student.toString());
52         model.addAttribute("student", student);
53         return "index";
54     }
55 }

运行测试

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

控制台没有报错

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

在浏览器中输入：http://localhost:8090/student/test?id=1 (端口号根据你的设置有关,自己调查)

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

到此 SpringMVC+Maven 整合完毕

2.3 Spring与MyBatis的整合

取消2.2.2 web.xml中注释的代码,下面是去除后的代码

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 3     xmlns="http://java.sun.com/xml/ns/javaee"
 4     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
 5     version="3.0">
 6     <display-name>Archetype Created Web Application</display-name>
 7     <!-- Spring和MyBatis的配置文件 -->
 8     <context-param>
 9         <param-name>contextConfigLocation</param-name>
10         <param-value>classpath:spring-mybatis.xml</param-value>
11     </context-param>
12     <!-- 编码过滤器 -->
13     <filter>
14         <filter-name>encodingFilter</filter-name>
15         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
16         <async-supported>true</async-supported>
17         <init-param>
18             <param-name>encoding</param-name>
19             <param-value>UTF-8</param-value>
20         </init-param>
21     </filter>
22     <filter-mapping>
23         <filter-name>encodingFilter</filter-name>
24         <url-pattern>/*</url-pattern>
25     </filter-mapping>
26     <!-- Spring监听器 -->
27     <listener>
28         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
29     </listener>
30     <!-- 防止Spring内存溢出监听器 -->
31     <listener>
32         <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
33     </listener>
34 
35     <!-- Spring MVC servlet -->
36     <servlet>
37         <servlet-name>SpringMVC</servlet-name>
38         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
39         <!-- 下面init-param是自定义servlet.xml配置文件的位置和名称，默认为WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，如spring-servlet.xml -->
40         <init-param>
41             <param-name>contextConfigLocation</param-name>
42             <param-value>classpath:spring-mvc.xml</param-value>
43         </init-param>
44         <load-on-startup>1</load-on-startup>
45         <async-supported>true</async-supported>
46     </servlet>
47     <servlet-mapping>
48         <servlet-name>SpringMVC</servlet-name>
49         <!-- 此处可以配置成*.do,对应struts的后缀习惯 -->
50         <url-pattern>/</url-pattern>
51     </servlet-mapping>
52     <welcome-file-list>
53         <welcome-file>/index.jsp</welcome-file>
54     </welcome-file-list>
55 </web-app>

2.3.1、建立JDBC属性文件

jdbc.properties（文件编码修改为utf-8）根据自己数据库配置url username password

 1 #连接数据库
 2 #jdbc.driver=net.sf.log4jdbc.DriverSpy
 3 #jdbc.url=jdbc:log4jdbc:oracle:thin:@192.168.0.125:1521:xe
 4 jdbc.driver=oracle.jdbc.OracleDriver
 5 jdbc.url=jdbc:oracle:thin:@192.168.0.125:1521:xe
 6 jdbc.username=orcl
 7 jdbc.password=orcl
 8 
 9 #dbcp settings
10 dbcp.maxIdle=5
11 dbcp.maxActive=50

2.3.2、建立spring-mybatis.xml配置文件

这个文件就是用来完成spring和mybatis的整合的。主要的就是自动扫描，自动注入，配置数据库。注释也很详细，大家看看就明白了。

spring-mybatis.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
 4     xmlns:context="http://www.springframework.org/schema/context"
 5     xmlns:mvc="http://www.springframework.org/schema/mvc"
 6     xsi:schemaLocation="
 7         http://www.springframework.org/schema/beans 
 8         http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
 9         http://www.springframework.org/schema/context 
10         http://www.springframework.org/schema/context/spring-context-3.1.xsd
11         http://www.springframework.org/schema/mvc
12         http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd">
13     <!-- 自动扫描 -->
14     <context:component-scan base-package="com.cn.hnust" />
15     
16     <!-- 使用annotation 自动注册bean, 并保证@Required、@Autowired的属性被注入 -->
17     <!--<context:component-scan base-package="com.cn.hnust">
18         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
19     </context:component-scan>-->
20     
21     <!-- 引入配置文件 -->
22     <bean id="propertyConfigurer"
23         class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
24         <property name="location" value="classpath:jdbc.properties" />
25     </bean>
26 
27     <!-- 数据源配置, 使用应用中的DBCP数据库连接池 -->
28     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
29         destroy-method="close">
30         <!-- Connection Info -->
31         <property name="driverClassName" value="${jdbc.driver}" />
32         <property name="url" value="${jdbc.url}" />
33         <property name="username" value="${jdbc.username}" />
34         <property name="password" value="${jdbc.password}" />
35 
36         <!-- Connection Pooling Info -->
37         <property name="maxActive" value="${dbcp.maxActive}" />
38         <property name="maxIdle" value="${dbcp.maxIdle}" />
39         <property name="defaultAutoCommit" value="false" />
40         <!-- 连接Idle一个小时后超时 -->
41         <property name="timeBetweenEvictionRunsMillis" value="3600000" />
42         <property name="minEvictableIdleTimeMillis" value="3600000" />
43     </bean>
44 
45     <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
46     <bean id="sqlSessionFactory"
47         class="org.mybatis.spring.SqlSessionFactoryBean">
48         <property name="dataSource" ref="dataSource"/>
49         <!-- 自动扫描mapping.xml文件 -->
50         <property name="mapperLocations" value="classpath:com/cn/hnust/mapping/*.xml"></property>
51     </bean>
52     <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
53     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
54         <property name="basePackage" value="com.cn.hnust.dao"></property>
55         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
56     </bean>
57     
58     <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->  
59     <bean id="transactionManager"  
60         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
61         <property name="dataSource" ref="dataSource" />  
62     </bean> 
63 </beans>

2.4 JUnit测试

创建实体类、MyBatis映射文件以及DAO接口

DAO接口类

 1 package com.cn.hnust.dao;
 2 
 3 import com.cn.hnust.pojo.Student;
 4 
 5 public interface IStudentDao {
 6     int deleteByPrimaryKey(Integer id);
 7     
 8     int insert(Student record);
 9     
10     int insertSelective(Student record);
11     
12     Student selectByPrimaryKey(Integer id);
13     
14     int updateByPrimaryKeySelective(Student record);
15     
16     int updateByPrimaryKey(Student record);
17 }

实现增删改查的xml配置文件

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper
 3   PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 4   "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 5 <mapper namespace="com.cn.hnust.dao.IStudentDao">
 6     <resultMap type="com.cn.hnust.pojo.Student" id="BaseResultMap">
 7         <id column="id" property="id" jdbcType="INTEGER" />
 8         <result column="stu_name" property="stu_name" jdbcType="VARCHAR" />
 9         <result column="age" property="age" jdbcType="INTEGER" />
10         <result column="gender" property="gender" jdbcType="INTEGER" />
11         <result column="address" property="address" jdbcType="VARCHAR" />
12     </resultMap>
13     <sql id="Base_Column_List">
14         id,stu_name,age,gender,address
15     </sql>
16     <select id="selectByPrimaryKey" resultMap="BaseResultMap"
17         parameterType="java.lang.Integer">
18         select
19         <include refid="Base_Column_List"></include>
20         from student
21         where id = #{id,jdbcType=INTEGER}
22     </select>
23     <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
24         delete from
25         student
26         where id = #{id,jdbcType=INTEGER}
27     </delete>
28     <insert id="insert" parameterType="com.cn.hnust.pojo.Student">
29         insert into
30         student(id,stu_name,age,gender,address)
31         values
32         (#{id,jdbcType=INTEGER},#{stu_name,jdbcType=VARCHAR},#{age,jdbcType=INTEGER},#{gender,jdbcType=INTEGER},#{address,jdbcType=VARCHAR})
33     </insert>
34     <insert id="insertSelective" parameterType="com.cn.hnust.pojo.Student">
35         insert into student
36         <trim prefix="(" suffix=")" suffixOverrides=",">
37             <if test="id != null">
38                 id,
39             </if>
40             <if test="stu_name != null">
41                 stu_name,
42             </if>
43             <if test="age != null">
44                 age,
45             </if>
46             <if test="gender != null">
47                 gender,
48             </if>
49             <if test="address != null">
50                 address,
51             </if>
52         </trim>
53         <trim prefix="values (" suffix=")" suffixOverrides=",">
54             <if test="id != null">
55                 #{id,jdbcType=INTEGER},
56             </if>
57             <if test="stu_name != null">
58                 #{stu_name,jdbcType=VARCHAR},
59             </if>
60             <if test="age != null">
61                 #{age,jdbcType=INTEGER},
62             </if>
63             <if test="gender != null">
64                 #{gender,jdbcType=INTEGER},
65             </if>
66             <if test="address != null">
67                 #{address,jdbcType=VARCHAR},
68             </if>
69         </trim>
70     </insert>
71     <update id="updateByPrimaryKeySelective" parameterType="com.cn.hnust.pojo.Student">
72         update student
73         <set >
74             <if test="stu_name != null">
75                 stu_name = #{stu_name,jdbcType=VARCHAR},
76             </if>
77             <if test="age != null">
78                 age = #{age,jdbcType=INTEGER},
79             </if>
80             <if test="gender != null">
81                 gender = #{gender,jdbcType=INTEGER},
82             </if>
83             <if test="address != null">
84                 address = #{address,jdbcType=VARCHAR},
85             </if>
86         </set>
87         where id = #{id,jdbcType=INTEGER}
88     </update>
89     <update id="updateByPrimaryKey" parameterType="com.cn.hnust.pojo.Student">
90         update student
91         set stu_name = #{stu_name,jdbcType=VARCHAR},
92             age = #{age,jdbcType=INTEGER},
93             gender = #{gender,jdbcType=INTEGER},
94             address = #{address,jdbcType=VARCHAR}
95         where id = #{id,jdbcType=INTEGER}
96     </update>
97 </mapper>

建立Service接口和实现类

1 package com.cn.hnust.service;
2 
3 import com.cn.hnust.pojo.Student;
4 
5 public interface IStudentService {
6     public Student getStudentById(int studentId);
7 }

 1 package com.cn.hnust.service.impl;
 2 
 3 import javax.annotation.Resource;
 4 
 5 import org.springframework.stereotype.Service;
 6 
 7 import com.cn.hnust.dao.IStudentDao;
 8 import com.cn.hnust.pojo.Student;
 9 import com.cn.hnust.service.IStudentService;
10 
11 @Service("studentService")
12 public class StudentServiceImpl implements IStudentService {
13 
14     @Resource
15     private IStudentDao studentDao;
16 
17     @Override
18     public Student getStudentById(int studentId) {
19         return this.studentDao.selectByPrimaryKey(studentId);
20     }
21 
22 }

建立UserController类

  1 package com.cn.hnust.controller;
  2 
  3 import java.io.File;
  4 import java.io.IOException;
  5 import java.util.Map;
  6 
  7 import javax.annotation.Resource;
  8 import javax.servlet.http.HttpServletRequest;
  9 
 10 import org.apache.commons.io.FileUtils;
 11 import org.slf4j.Logger;
 12 import org.slf4j.LoggerFactory;
 13 import org.springframework.http.HttpStatus;
 14 import org.springframework.http.ResponseEntity;
 15 import org.springframework.stereotype.Controller;
 16 import org.springframework.ui.Model;
 17 import org.springframework.web.bind.annotation.PathVariable;
 18 import org.springframework.web.bind.annotation.RequestMapping;
 19 import org.springframework.web.bind.annotation.RequestMethod;
 20 import org.springframework.web.bind.annotation.RequestParam;
 21 import org.springframework.web.bind.annotation.ResponseBody;
 22 import org.springframework.web.multipart.MultipartFile;
 23 
 24 import com.cn.hnust.pojo.Student;
 25 import com.cn.hnust.service.IStudentService;
 26 
 27 @Controller
 28 @RequestMapping("/student")
 29 public class StudentController {
 30     private static Logger log = LoggerFactory
 31             .getLogger(StudentController.class);
 32 
 33     @Resource
 34     private IStudentService studentService;
 35 
 36     // /student/test?id=1
 37     @RequestMapping(value = "/test", method = RequestMethod.GET)
 38     public String test(HttpServletRequest request, Model model) {
 39         int studentId = Integer.parseInt(request.getParameter("id"));
 40         System.out.println("test studentId:" + studentId);
 41         Student student = null;
 42         if (studentId == 1) {
 43             student = new Student();
 44             student.setAge(19);
 45             student.setId(1);
 46             student.setGender(1);
 47             student.setAddress("北京七里省际大厦3栋4402");
 48             student.setStu_name("江泽");
 49         }
 50 
 51         log.debug(student.toString());
 52         model.addAttribute("student", student);
 53         return "index";
 54     }
 55 
 56     // /student/showStudent?id=1
 57     @RequestMapping(value = "/showStudent", method = RequestMethod.GET)
 58     public String toIndex(HttpServletRequest request, Model model) {
 59         int studentId = Integer.parseInt(request.getParameter("id"));
 60         System.out.println("toIndex studentId:" + studentId);
 61         Student student = this.studentService.getStudentById(studentId);
 62         log.debug(student.toString());
 63         model.addAttribute("student", student);
 64         return "showStudent";
 65     }
 66 
 67     // /student/showStudent2?id=1
 68     @RequestMapping(value = "/showStudent2", method = RequestMethod.GET)
 69     public String toIndex2(@RequestParam("id") String id, Model model) {
 70         int studentId = Integer.parseInt(id);
 71         System.out.println("toIndex2 studentId:" + studentId);
 72         Student student = this.studentService.getStudentById(studentId);
 73         log.debug(student.toString());
 74         model.addAttribute("student", student);
 75         return "showStudent";
 76     }
 77 
 78     // /student/showStudent3/{id}
 79     @RequestMapping(value = "/showStudent3/{id}", method = RequestMethod.GET)
 80     public String toIndex3(@RequestParam("id") String id,
 81             Map<String, Object> model) {
 82         int studentId = Integer.parseInt(id);
 83         System.out.println("toIndex3 studentId:" + studentId);
 84         Student student = this.studentService.getStudentById(studentId);
 85         log.debug(student.toString());
 86         model.put("student", student);
 87         return "showStudent";
 88     }
 89 
 90     // /student{id}
 91     @RequestMapping(value = "/{id}", method = RequestMethod.GET)
 92     public @ResponseBody
 93     Student getStudentInJson(@PathVariable String id, Map<String, Object> model) {
 94         int studentId = Integer.parseInt(id);
 95         System.out.println("getStudentInJson studentId:" + studentId);
 96         Student student = this.studentService.getStudentById(studentId);
 97         log.info(student.toString());
 98         return student;
 99     }
100 
101     // /student/{id}
102     @RequestMapping(value = "/jsontype/{id}", method = RequestMethod.GET)
103     public ResponseEntity<Student> getStudentInJson2(@PathVariable String id,
104             Map<String, Object> model) {
105         int studentId = Integer.parseInt(id);
106         System.out.println("getStudentInJson2 studentId:" + studentId);
107         Student student = this.studentService.getStudentById(studentId);
108         log.info(student.toString());
109         return new ResponseEntity<Student>(student, HttpStatus.OK);
110     }
111 
112     // 文件上传
113     @RequestMapping(value = "/upload")
114     public String showUploadPage() {
115         return "student_admin/file";
116     }
117 
118     @RequestMapping(value = "/doUpload", method = RequestMethod.GET)
119     public String doUploadFile(@RequestParam("file") MultipartFile file)
120             throws IOException {
121         if (!file.isEmpty()) {
122             log.info("Process file:{}", file.getOriginalFilename());
123         }
124         FileUtils.copyInputStreamToFile(file.getInputStream(), new File("F:\\",
125                 System.currentTimeMillis() + file.getOriginalFilename()));
126         return "sucess";
127     }
128 }

新建jsp页面

file.jsp

 1 <%@ page language="java" contentType="text/html;charset=utf-8"
 2     pageEncoding="utf-8" %>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org//TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
 7     <title>Insert title here</title>
 8 </head>
 9 <body>
10     <h1>上传文件</h1>
11     <form action="/student/doUpload" method="post" enctype="multipart/form-data">
12         <input type="file" name="file"/>
13         <input type="submit" value="上传文件"/>
14     </form>
15 </body>
16 </html>

index.jsp

 1 <%@ page language="java" import="java.util.*"
 2     pageEncoding="utf-8" %>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 4 <html>
 5 <body>
 6 <h2>Hello zou</h2>
 7 <br>
 8 <a href="jsp/showStudent.jsp">跳转</a>
 9 </body>
10 </html>

showUser.jsp

 1 <%@ page language="java" import="java.util.*"
 2     pageEncoding="utf-8" %>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 4 <html>
 5 <head>
 6     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
 7     <title>Testing</title>
 8 </head>
 9 <body>
10     ${student.stu_name}
11 </body>
12 </html>

success.jsp

 1 <%@ page language="java" contentType="text/html;charset=utf-8"
 2     pageEncoding="utf-8" %>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org//TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
 7     <title>success</title>
 8 </head>
 9 <body>
10     <h1>success</h1>
11 </body>
12 </html>

部署项目

输入地址：http://localhost:8090/student/jsontype/2

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

秒客网

SSM框架整合（Spring+SpringMVC+MyBatis+Oracle）

2.2.1 配置spring-mvc.xml

2.2.2 配置web.xml文件

2.2.3 Log4j的配置

2.3 Spring与MyBatis的整合

2.3.2、建立spring-mybatis.xml配置文件

相关文章