Spring和SpringMVC的整合是无缝整合。而MyBatis是第三方。

原始方式整合

1、创建数据表

这里创建了一个account表，里面有id、name、money字段。

2、创建maven工程

3、导入坐标

spring-context、aspectj、spring-tx【事务相关】、spring-test【测试相关】、spring-webmvc、servlet-api、jsp-api；
mybatis、mybatis-spring【mybatis整合spring时使用】、mysql-connetcor-java、c3p0；
junit、jstl

  1.     <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework</groupId>
  4.             <artifactId>spring-context</artifactId>
  5.             <version>5.2.8.RELEASE</version>
  6.         </dependency>
  7.         <dependency>
  8.             <groupId>org.springframework</groupId>
  9.             <artifactId>spring-tx</artifactId>
  10.             <version>5.2.8.RELEASE</version>
  11.         </dependency>
  12.         <dependency>
  13.             <groupId>org.springframework</groupId>
  14.             <artifactId>spring-test</artifactId>
  15.             <version>5.2.8.RELEASE</version>
  16.         </dependency>
  18.         <dependency>
  19.             <groupId>org.springframework</groupId>
  20.             <artifactId>spring-webmvc</artifactId>
  21.             <version>5.2.8.RELEASE</version>
  22.         </dependency>
  23.         <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
  24.         <dependency>
  25.             <groupId>org.aspectj</groupId>
  26.             <artifactId>aspectjweaver</artifactId>
  27.             <version>1.9.6</version>
  28.             <scope>runtime</scope>
  29.         </dependency>
  30.         <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
  31.         <dependency>
  32.             <groupId>javax.servlet</groupId>
  33.             <artifactId>javax.servlet-api</artifactId>
  34.             <version>4.0.1</version>
  35.             <scope>provided</scope>
  36.         </dependency>
  37.         <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api -->
  38.         <dependency>
  39.             <groupId>javax.servlet.jsp</groupId>
  40.             <artifactId>javax.servlet.jsp-api</artifactId>
  41.             <version>2.3.3</version>
  42.             <scope>provided</scope>
  43.         </dependency>
  45.         <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  46.         <dependency>
  47.             <groupId>mysql</groupId>
  48.             <artifactId>mysql-connector-java</artifactId>
  49.             <version>5.1.49</version>
  50.         </dependency>
  51.         <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
  52.         <dependency>
  53.             <groupId>com.mchange</groupId>
  54.             <artifactId>c3p0</artifactId>
  55.             <version>0.9.5.5</version>
  56.         </dependency>
  57.         <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  58.         <dependency>
  59.             <groupId>org.mybatis</groupId>
  60.             <artifactId>mybatis</artifactId>
  61.             <version>3.5.5</version>
  62.         </dependency>
  63.         <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  64.         <dependency>
  65.             <groupId>org.mybatis</groupId>
  66.             <artifactId>mybatis-spring</artifactId>
  67.             <version>2.0.5</version>
  68.         </dependency>
  70.         <!-- https://mvnrepository.com/artifact/junit/junit -->
  71.         <dependency>
  72.             <groupId>junit</groupId>
  73.             <artifactId>junit</artifactId>
  74.             <version>4.13</version>
  75.             <scope>test</scope>
  76.         </dependency>
  78.         <!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
  79.         <dependency>
  80.             <groupId>javax.servlet</groupId>
  81.             <artifactId>jstl</artifactId>
  82.             <version>1.2</version>
  83.         </dependency>
  86.     </dependencies>

4、编写实体类

Account.java

  1. package com.learn.domain;
  3. public class Account {
  4.     private Integer id;
  5.     private String name;
  6.     private Double money;
  8.     public Integer getId() {
  9.         return id;
  10.     }
  12.     public void setId(Integer id) {
  13.         this.id = id;
  14.     }
  16.     public String getName() {
  17.         return name;
  18.     }
  20.     public void setName(String name) {
  21.         this.name = name;
  22.     }
  24.     public Double getMoney() {
  25.         return money;
  26.     }
  28.     public void setMoney(Double money) {
  29.         this.money = money;
  30.     }
  31. }

5、编写Mapper接口

AccountMapper.java

  1. package com.learn.mapper;
  3. import com.learn.domain.Account;
  5. import java.util.List;
  7. public interface AccountMapper {
  9.     public void save(Account account);
  11.     public List<Account> findAll();
  12. }

6、编写Service接口

AccountService.java

  1. package com.learn.service;
  3. import com.learn.domain.Account;
  5. import java.util.List;
  7. public interface AccountService {
  8.     public void save(Account account);
  10.     public List<Account> findAll();
  11. }

7、编写Service接口实现

AccountServiceImpl.java

  1. package com.learn.service.impl;
  3. import com.learn.domain.Account;
  4. import com.learn.mapper.AccountMapper;
  5. import com.learn.service.AccountService;
  6. import org.apache.ibatis.io.Resources;
  7. import org.apache.ibatis.session.SqlSession;
  8. import org.apache.ibatis.session.SqlSessionFactory;
  9. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  10. import org.springframework.stereotype.Service;
  12. import java.io.IOException;
  13. import java.io.InputStream;
  14. import java.util.List;
  15. @Service("accountService")
  16. public class AccountServiceImpl implements AccountService {
  17.     public void save(Account account) {
  18.         try {
  19.             InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapperConfig.xml");
  20.             SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
  21.             SqlSession sqlSession = sqlSessionFactory.openSession();
  22.             AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
  23.             mapper.save(account);
  24.             sqlSession.commit();
  25.             sqlSession.close();
  26.         }catch (IOException e){
  27.             e.printStackTrace();
  28.         }
  31.     }
  33.     public List<Account> findAll() {
  34.         //没问题返回List，有问题返回null
  35.         try {
  36.             InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapperConfig.xml");
  37.             SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
  38.             SqlSession sqlSession = sqlSessionFactory.openSession();
  39.             AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
  40.             List<Account> accountList = mapper.findAll();
  41.              sqlSession.close();
  42.              return accountList;
  43.         }catch (IOException e){
  44.             e.printStackTrace();
  45.         }
  46.         return null;
  47.     }
  48. }

8、编写Controller

AccountController.java

  1. package com.learn.controller;
  3. import com.learn.domain.Account;
  4. import com.learn.service.AccountService;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.stereotype.Controller;
  7. import org.springframework.web.bind.annotation.RequestMapping;
  8. import org.springframework.web.bind.annotation.ResponseBody;
  9. import org.springframework.web.servlet.ModelAndView;
  11. import java.util.List;
  13. @Controller
  14. @RequestMapping("/account")
  15. public class AccountController {
  17.     //注入service对象
  18.     @Autowired
  19.     private AccountService accountService;
  21.     //设置响应数据的编码格式.即保存成功可以正常显示，而不是？？？
  22.     @RequestMapping(value = "/save",produces = "text/html;charset=UTF-8")
  23.     @ResponseBody
  24.     //保存,这里实际上应该跳转到某个页面，这里先不那么设置
  25.     public String save(Account account){
  26.         accountService.save(account);
  27.         return "保存成功";
  28.     }
  30.     //查询
  31.     @RequestMapping("/findAll")
  32.     public ModelAndView findAll(){
  33.         List<Account> accountList = accountService.findAll();
  34.         ModelAndView modelAndView = new ModelAndView();
  35.         modelAndView.addObject("accountList",accountList);
  36.         modelAndView.setViewName("accountList");
  37.         return modelAndView;
  38.     }
  39. }

9、编写表单添加页面

save.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <html>
  3. <head>
  4.     <title>Title</title>
  5. </head>
  6. <body>
  7.     <h1>添加账户信息表单</h1>
  8.     <form name="accountForm" action="${pageContext.request.contextPath}/account/save" method="post">
  9.         账户名称:<input type="text" name="name"><br>
  10.         账户金额:<input type="text" name="money"><br>
  11.         <input type="submit" value="保存"><br>
  12.     </form>
  13. </body>
  14. </html>

10、编写列表展示页面

accountList.jsp,这里需要使用到el表达式

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  3. <html>
  4. <head>
  5.     <title>Title</title>
  6. </head>
  7. <body>
  8. <h1>展示账户数据列表</h1>
  10. <table>
  11.     <tr>
  12.         <th>账户id</th>
  13.         <th>账户名称</th>
  14.         <th>账户金额</th>
  15.     </tr>
  16.     <c:forEach items="${accountList}" var="account">
  17.         <tr>
  18.             <td>${account.id}</td>
  19.             <td>${account.name}</td>
  20.             <td>${account.money}</td>
  21.         </tr>
  23.     </c:forEach>
  25. </table>
  26. </body>
  27. </html>

11、配置文件

Spring配置文件

applicationContext.xml
这个配置文件只管理service和mapper，不管理controller，需要exclude一下

  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"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:tx="http://www.springframework.org/schema/tx"
  6.        xmlns:aop="http://www.springframework.org/schema/aop"
  8.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  9.                            http://www.springframework.org/schema/beans/spring-beans.xsd
  10.                            http://www.springframework.org/schema/context
  11.                            http://www.springframework.org/schema/context/spring-context.xsd
  12.                            http://www.springframework.org/schema/tx
  13.                                                      http://www.springframework.org/schema/tx/spring-tx.xsd
  14.                            http://www.springframework.org/schema/aop
  15. http://www.springframework.org/schema/aop/spring-aop.xsd">
  18.     <!--组件扫描 扫描service和mapper-->
  19.     <context:component-scan base-package="com.learn">
  20.         <!--需要排除controller扫描，这个需要交给springmvc-->
  21.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  22.     </context:component-scan>
  23. </beans>

SpringMVC配置文件

spring-mvc.xml
配置组件扫描【主要扫描controller】、配置mvc注解驱动、配置内部资源视图解析器、开放静态资源【因为如果pattern是*，但是有些静态资源无法解析,需要放行】

  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"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.                            http://www.springframework.org/schema/beans/spring-beans.xsd
  9.                            http://www.springframework.org/schema/context
  10.                            http://www.springframework.org/schema/context/spring-context.xsd
  11.                            http://www.springframework.org/schema/mvc
  12.                            http://www.springframework.org/schema/mvc/spring-mvc.xsd">
  13.     <!--组件扫描 主要扫描controller-->
  14.     <context:component-scan base-package="com.learn.controller">
  16.     </context:component-scan>
  19.     <!--配置mvc注解驱动-->
  20.     <mvc:annotation-driven></mvc:annotation-driven>
  22.     <!--配置内部资源视图解析器-->
  23.     <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  24.         <property name="prefix" value="/WEB-INF/pages"/>
  25.         <property name="suffix" value=".jsp"/>
  26.     </bean>
  28.     <!--开放静态资源访问权限-->
  29.     <mvc:default-servlet-handler/>
  32. </beans>

Mybatis映射文件

AccountMapper.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.learn.mapper.AccountMapper">
  4.     <insert id="save" parameterType="account">
  5.         insert into account values (#{name},#{money});
  6.     </insert>
  8.     <select id="findAll" resultType="account">
  9.         select  * from  account;
  10.     </select>
  11. </mapper>

MyBatis核心文件

SqlMapperConfig.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
  3. <configuration>
  4. <properties resource="jdbc.properties"></properties>
  6.     <!--定义别名-->
  7.     <typeAliases>
  8.         <!--<typeAlias type="com.learn.domain.Account" alias="account"></typeAlias>-->
  9.         <!--也可以使用扫包的方式，别名默认是实体名称或者实体名称的首字母小写-->
  10.         <package name="com.learn.domain"/>
  11.     </typeAliases>
  13.     <environments default="development">
  14.         <environment id="development">
  15.             <transactionManager type="JDBC"></transactionManager>
  16.             <dataSource type="POOLED">
  17.                 <property name="driver" value="${jdbc.driver}"/>
  18.                 <property name="url" value="${jdbc.url}"/>
  19.                 <property name="username" value="${jdbc.username"/>
  20.                 <property name="password" value="${jdbc.password}"/>
  21.             </dataSource>
  22.         </environment>
  23.     </environments>
  25.     <mappers>
  26.         <package name="com.learn.mapper"/>
  27.     </mappers>
  28. </configuration>

数据库连接信息文件

jdbc.properties

Web.xml文件

web.xml

idea默认是2.3的，可以升个级

  1. <?xml version="1.0" encoding="UTF-8"?>
  3. <web-app    version="3.0"
  4.         xmlns="http://java.sun.com/xml/ns/javaee"
  5.         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  6.         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
  8. </web-app>

在web.xml文件中，需要配置spring监听器、springmvc前端控制器和乱码过滤器。

  1. <?xml version="1.0" encoding="UTF-8"?>
  3. <web-app    version="3.0"
  4.         xmlns="http://java.sun.com/xml/ns/javaee"
  5.         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  6.         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
  8.         <!--配置spring监听器-->
  9.         <context-param>
  10.                 <param-name>contextConfigLocation</param-name>
  11.                 <param-value>classpath:applicationContext.xml</param-value>
  12.         </context-param>
  14.         <listener>
  15.                 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  16.         </listener>
  18.         <!--springmvc前端控制器-->
  19.         <servlet>
  20.                 <servlet-name>DispatcherServlet</servlet-name>
  21.                 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  22.                   <init-param>
  23.                         <param-name>contextConfigLocation</param-name>
  24.                         <param-value>classpath:spring-mvc.xml</param-value>
  25.                 </init-param>
  26.                 <load-on-startup>1</load-on-startup>
  27.         </servlet>
  29.         <servlet-mapping>
  30.                 <servlet-name>DispatcherServlet</servlet-name>
  31.                 <url-pattern>/</url-pattern>
  32.         </servlet-mapping>
  35.         <!--乱码过滤器-->
  36.         <filter>
  37.                 <filter-name>CharacterEncodingFilter</filter-name>
  38.                 <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  39.                 <init-param>
  40.                         <param-name>encoding</param-name>
  41.                         <param-value>UTF-8</param-value>
  42.                 </init-param>
  43.         </filter>
  45.         <filter-mapping>
  46.                 <filter-name>CharacterEncodingFilter</filter-name>
  47.                 <url-pattern>/*</url-pattern>
  48.         </filter-mapping>
  49. </web-app>

日志文件

log4j.xml或者log4j.properties

  1. ### direct log messages to stdout ###
  2. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  3. log4j.appender.stdout.Target=System.out
  4. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  5. log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
  7. ### direct messages to file mylog.log ###
  8. log4j.appender.file=org.apache.log4j.FileAppender
  9. log4j.appender.file.File=c:\mylog.log
  10. log4j.appender.file.layout=org.apache.log4j.PatternLayout
  11. log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
  13. ### set log levels - for more verbose logging change 'info' to 'debug' ###
  15. log4j.rootLogger=debug, stdout

12、测试

实际上这里有个问题，就是在保存中文的时候，显示的都是???，不知道是什么原因，是不是web.xml没有配置正确导致的。