spring.springMVC.mybatis框架整和

1. pom.xml
2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
3.   <modelVersion>4.0.0</modelVersion>
4.   <groupId>com.my</groupId>
5.   <artifactId>ssm</artifactId>
6.   <version>0.0.1-SNAPSHOT</version>
7.   <packaging>war</packaging>
8.   <dependencies>
9.     <!-- Servlet API -->
10.     <dependency>
11.        <groupId>javax.servlet</groupId>
12.        <artifactId>servlet-api</artifactId>
13.        <version>3.0-alpha-1</version>
14.        <scope>provided</scope>
15.     </dependency>
17.     <!--  Spring Web -->
18.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
19.     <dependency>
20.        <groupId>org.springframework</groupId>
21.        <artifactId>spring-web</artifactId>
22.        <version>5.0.3.RELEASE</version>
23.     </dependency>
25.     <!-- Spring SpringMVC -->
26.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
27.     <dependency>
28.        <groupId>org.springframework</groupId>
29.        <artifactId>spring-webmvc</artifactId>
30.        <version>5.0.3.RELEASE</version>
31.     </dependency>
33.     <!-- Spring JDBC -->
34.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
35.     <dependency>
36.        <groupId>org.springframework</groupId>
37.        <artifactId>spring-jdbc</artifactId>
38.        <version>5.0.3.RELEASE</version>
39.     </dependency>
41.     <!-- Spring Aspects -->
42.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
43.     <dependency>
44.        <groupId>org.springframework</groupId>
45.        <artifactId>spring-aspects</artifactId>
46.        <version>5.0.3.RELEASE</version>
47.     </dependency>
49.     <!-- MyBatis -->
50.     <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
51.     <dependency>
52.        <groupId>org.mybatis</groupId>
53.        <artifactId>mybatis</artifactId>
54.        <version>3.4.5</version>
55.     </dependency>
57.     <!-- MyBatis Spring -->
58.     <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
59.     <dependency>
60.        <groupId>org.mybatis</groupId>
61.        <artifactId>mybatis-spring</artifactId>
62.        <version>1.3.1</version>
63.     </dependency>
65.     <!-- C3P0 -->
66.     <!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
67.     <dependency>
68.        <groupId>c3p0</groupId>
69.        <artifactId>c3p0</artifactId>
70.        <version>0.9.1.2</version>
71.     </dependency>
73.     <!-- MySQL驱动包 -->
74.     <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
75.     <dependency>
76.        <groupId>mysql</groupId>
77.        <artifactId>mysql-connector-java</artifactId>
78.        <version>5.1.45</version>
79.     </dependency>
81.     <!-- JSTL -->
82.     <!-- https://mvnrepository.com/artifact/jstl/jstl -->
83.     <dependency>
84.        <groupId>jstl</groupId>
85.        <artifactId>jstl</artifactId>
86.        <version>1.2</version>
87.     </dependency>
89.     <!-- https://mvnrepository.com/artifact/com.googlecode.json-simple/json-simple -->
90.     <dependency>
91.        <groupId>com.googlecode.json-simple</groupId>
92.        <artifactId>json-simple</artifactId>
93.        <version>1.1</version>
94.     </dependency>
96.     <!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
97.     <dependency>
98.        <groupId>commons-fileupload</groupId>
99.        <artifactId>commons-fileupload</artifactId>
100.        <version>1.3.3</version>
101.     </dependency>
103.     <!-- https://mvnrepository.com/artifact/com.google.code.gson/gson -->
104.     <dependency>
105.        <groupId>com.google.code.gson</groupId>
106.        <artifactId>gson</artifactId>
107.        <version>2.8.2</version>
108.     </dependency>
110.     <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-lang3 -->
111.     <dependency>
112.        <groupId>org.apache.commons</groupId>
113.        <artifactId>commons-lang3</artifactId>
114.        <version>3.7</version>
115.     </dependency>
116. </dependencies>
117.   
118.   
119. </project>

2.web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

<display-name>ssm</display-name>

   <welcome-file-list>

      <welcome-file>index.html</welcome-file>

      <welcome-file>index.htm</welcome-file>

      <welcome-file>index.jsp</welcome-file>

      <welcome-file>default.html</welcome-file>

      <welcome-file>default.htm</welcome-file>

      <welcome-file>default.jsp</welcome-file>

   </welcome-file-list>

   <!--1、启动Spring的容器 -->

   <!-- needed for ContextLoaderListener -->

   <context-param>

      <param-name>contextConfigLocation</param-name>

      <param-value>classpath:applicationContext.xml</param-value>

   </context-param>

   <!-- Bootstraps the root web application context before servlet initialization -->

   <listener>

      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

   </listener>

   <!--2、springmvc的前端控制器，拦截所有请求 -->

   <!-- The front controller of this Spring Web application, responsible for

      handling all application requests -->

   <servlet>

      <servlet-name>dispatcherServlet</servlet-name>

      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

      <load-on-startup>1</load-on-startup>

   </servlet>

   <!-- Map all requests to the DispatcherServlet for handling -->

   <servlet-mapping>

      <servlet-name>dispatcherServlet</servlet-name>

      <url-pattern>/</url-pattern>

   </servlet-mapping>

   <!-- 3、字符编码过滤器，一定要放在所有过滤器之前 -->

   <filter>

      <filter-name>CharacterEncodingFilter</filter-name>

      <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

      <init-param>

         <param-name>encoding</param-name>

         <param-value>utf-8</param-value>

      </init-param>

      <init-param>

         <param-name>forceRequestEncoding</param-name>

         <param-value>true</param-value>

      </init-param>

      <init-param>

         <param-name>forceResponseEncoding</param-name>

         <param-value>true</param-value>

      </init-param>

   </filter>

   <filter-mapping>

      <filter-name>CharacterEncodingFilter</filter-name>

      <url-pattern>/*</url-pattern>

   </filter-mapping>

   <!-- 4、使用Rest风格的URI，将页面普通的post请求转为指定的delete或者put请求 -->

   <filter>

      <filter-name>HiddenHttpMethodFilter</filter-name>

      <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>

   </filter>

   <filter-mapping>

      <filter-name>HiddenHttpMethodFilter</filter-name>

      <url-pattern>/*</url-pattern>

   </filter-mapping>

   <filter>

      <filter-name>HttpPutFormContentFilter</filter-name>

      <filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>

   </filter>

   <filter-mapping>

      <filter-name>HttpPutFormContentFilter</filter-name>

      <url-pattern>/*</url-pattern>

   </filter-mapping>

</web-app>

3.springMVC的配置文件

<?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:mvc="http://www.springframework.org/schema/mvc"

   xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd

      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd

      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">

   <!-- 启动注解扫描功能  -->

   <context:component-scan base-package="com.my" use-default-filters="false">

      <!--只扫描控制器  -->

      <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

   </context:component-scan>

  

   <!--配置视图解析器，方便页面返回  -->

   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="prefix" value="/"/>

        <property name="suffix" value=".jsp"/>

   </bean>

  

   <!--两个标准配置  -->

   <!-- 将springmvc不能处理的请求交给tomcat -->

   <mvc:default-servlet-handler/>

   <!-- 能支持springmvc更高级的一些功能，JSR303校验，快捷的ajax...映射动态请求 -->

   <mvc:annotation-driven/>

</beans>

4.数据库连接的配置

jdbc.jdbcUrl=jdbc:mysql://localhost:3306/eshop

jdbc.driverClass=com.mysql.jdbc.Driver

jdbc.user=root

jdbc.password=123456

5.spring和mybatis的配置

<?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:aop="http://www.springframework.org/schema/aop"

   xmlns:tx="http://www.springframework.org/schema/tx"

   xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd

      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd

      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd

      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">

   <context:component-scan base-package="com.my">

      <context:exclude-filter type="annotation"

         expression="org.springframework.stereotype.Controller" />

   </context:component-scan>

   <!-- Spring的配置文件，这里主要配置和业务逻辑有关的 -->

   <!--=================== 数据源，事务控制，xxx ================-->

   <context:property-placeholder location="classpath:dbconfig.properties" />

   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

      <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>

      <property name="driverClass" value="${jdbc.driverClass}"></property>

      <property name="user" value="${jdbc.user}"></property>

      <property name="password" value="${jdbc.password}"></property>

   </bean>

   <!-- 配置SqlSessionFactoryBean -->

   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

      <property name="dataSource" ref="dataSource" />

   </bean>

   <!-- 配置MapperScannerConfigurer,Dao接口所在包名，Spring会自动查找其下的类 -->

   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

      <property name="basePackage" value="com.my.dao" />

      <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>

   </bean>

   <!-- 配置DataSourceTransactionManager(事务管理) -->

   <bean id="transactionManager"

      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

      <property name="dataSource" ref="dataSource" />

   </bean>

   <!-- 启用基于注解的声明式事务管理配置 -->

   <tx:annotation-driven transaction-manager="transactionManager" />

  

</beans>