• SSM 框架整合

    原始整合方式

    • 数据表

      1. create database ssm character set utf8;
      2. use ssm;
      3. create table account(
      4.     id int primary key auto_increment,
      5.     name varchar(100),
      6.     money double(7,2)
      7. );
      8.

    • 创建 Maven 工程

    • 导入 Maven 坐标

      1. <?xml version="1.0" encoding="UTF-8"?>
      2. <project xmlns="http://maven.apache.org/POM/4.0.0"
      3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      5.     <modelVersion>4.0.0</modelVersion>
      6.  
      7.     <groupId>com.ruochen</groupId>
      8.     <artifactId>ssm</artifactId>
      9.     <version>1.0-SNAPSHOT</version>
      10.     <packaging>war</packaging>
      11.  
      12.     <properties>
      13.         <maven.compiler.source>8</maven.compiler.source>
      14.         <maven.compiler.target>8</maven.compiler.target>
      15.     </properties>
      16.  
      17.     <dependencies>
      18.         <!--spring相关-->
      19.         <dependency>
      20.             <groupId>org.springframework</groupId>
      21.             <artifactId>spring-context</artifactId>
      22.             <version>5.0.5.RELEASE</version>
      23.         </dependency>
      24.         <!--aop织入-->
      25.         <dependency>
      26.             <groupId>org.aspectj</groupId>
      27.             <artifactId>aspectjweaver</artifactId>
      28.             <version>1.8.8</version>
      29.         </dependency>
      30.         <dependency>
      31.             <groupId>org.springframework</groupId>
      32.             <artifactId>spring-jdbc</artifactId>
      33.             <version>5.0.5.RELEASE</version>
      34.         </dependency>
      35.         <!--事务相关-->
      36.         <dependency>
      37.             <groupId>org.springframework</groupId>
      38.             <artifactId>spring-tx</artifactId>
      39.             <version>5.0.5.RELEASE</version>
      40.         </dependency>
      41.         <!--测试相关-->
      42.         <dependency>
      43.             <groupId>org.springframework</groupId>
      44.             <artifactId>spring-test</artifactId>
      45.             <version>5.0.5.RELEASE</version>
      46.         </dependency>
      47.         <!--springmvc相关-->
      48.         <dependency>
      49.             <groupId>org.springframework</groupId>
      50.             <artifactId>spring-webmvc</artifactId>
      51.             <version>5.0.5.RELEASE</version>
      52.         </dependency>
      53.  
      54.         <!--servlet 和 jsp-->
      55.         <dependency>
      56.             <groupId>javax.servlet</groupId>
      57.             <artifactId>servlet-api</artifactId>
      58.             <version>2.5</version>
      59.         </dependency>
      60.         <dependency>
      61.             <groupId>javax.servlet.jsp</groupId>
      62.             <artifactId>jsp-api</artifactId>
      63.             <version>2.0</version>
      64.         </dependency>
      65.  
      66.         <!--mybatis 相关-->
      67.         <dependency>
      68.             <groupId>org.mybatis</groupId>
      69.             <artifactId>mybatis</artifactId>
      70.             <version>3.5.5</version>
      71.         </dependency>
      72.         <!--spring 整合 mybatis -->
      73.         <dependency>
      74.             <groupId>org.mybatis</groupId>
      75.             <artifactId>mybatis-spring</artifactId>
      76.             <version>1.3.1</version>
      77.         </dependency>
      78.         <dependency>
      79.             <groupId>mysql</groupId>
      80.             <artifactId>mysql-connector-java</artifactId>
      81.             <version>5.1.46</version>
      82.         </dependency>
      83.         <!--数据源-->
      84.         <dependency>
      85.             <groupId>c3p0</groupId>
      86.             <artifactId>c3p0</artifactId>
      87.             <version>0.9.1.2</version>
      88.         </dependency>
      89.         <dependency>
      90.             <groupId>junit</groupId>
      91.             <artifactId>junit</artifactId>
      92.             <version>4.13</version>
      93.             <scope>test</scope>
      94.         </dependency>
      95.         <dependency>
      96.             <groupId>jstl</groupId>
      97.             <artifactId>jstl</artifactId>
      98.             <version>1.2</version>
      99.         </dependency>
      100.     </dependencies>
      101.  
      102. </project>
      103.

    • 编写实体类 Account.java

      1. package com.ruochen.domain;
      2.  
      3. public class Account {
      4.  
      5.     private Integer id;
      6.     private String name;
      7.     private Double money;
      8.  
      9.     public Integer getId() {
      10.         return id;
      11.     }
      12.  
      13.     public void setId(Integer id) {
      14.         this.id = id;
      15.     }
      16.  
      17.     public String getName() {
      18.         return name;
      19.     }
      20.  
      21.     public void setName(String name) {
      22.         this.name = name;
      23.     }
      24.  
      25.     public Double getMoney() {
      26.         return money;
      27.     }
      28.  
      29.     public void setMoney(Double money) {
      30.         this.money = money;
      31.     }
      32.  
      33.     @Override
      34.     public String toString() {
      35.         return "Account{" +
      36.                 "id=" + id +
      37.                 ", name='" + name + '\'' +
      38.                 ", money=" + money +
      39.                 '}';
      40.     }
      41. }
      42.

    • 编写 Mapper 接口

      1. package com.ruochen.mapper;
      2.  
      3. import com.ruochen.domain.Account;
      4.  
      5. import java.util.List;
      6.  
      7. public interface AccountMapper {
      8.  
      9.     void save(Account account);
      10.  
      11.     List findAll();
      12. }
      13.

    • 编写 Service 接口

      1. package com.ruochen.service;
      2.  
      3. import com.ruochen.domain.Account;
      4.  
      5. import java.util.List;
      6.  
      7. public interface AccountService {
      8.     void save(Account account);
      9.  
      10.     List findAll();
      11.  
      12. }
      13.

    • 编写 Service 接口实现

      1. package com.ruochen.service.impl;
      2.  
      3. import com.ruochen.domain.Account;
      4. import com.ruochen.mapper.AccountMapper;
      5. import com.ruochen.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;
      11.  
      12. import java.io.IOException;
      13. import java.io.InputStream;
      14. import java.util.List;
      15.  
      16. @Service("accountService")
      17. public class AccountServiceImpl implements AccountService {
      18.     @Override
      19.     public void save(Account account) {
      20.         try {
      21.             InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
      22.             SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
      23.             SqlSession sqlSession = sqlSessionFactory.openSession();
      24.             AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
      25.             mapper.save(account);
      26.             sqlSession.commit();
      27.             sqlSession.close();
      28.         } catch (IOException e) {
      29.             e.printStackTrace();
      30.         }
      31.     }
      32.  
      33.     @Override
      34.     public List findAll() {
      35.         try {
      36.             InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
      37.             SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
      38.             SqlSession sqlSession = sqlSessionFactory.openSession();
      39.             AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
      40.             List accountList = mapper.findAll();
      41.             sqlSession.close();
      42.             return accountList;
      43.         } catch (IOException e) {
      44.             e.printStackTrace();
      45.         }
      46.         return null;
      47.     }
      48. }
      49.

    • 编写 Controller

      1. package com.ruochen.controller;
      2.  
      3. import com.ruochen.domain.Account;
      4. import com.ruochen.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;
      10.  
      11. import java.util.List;
      12.  
      13. @Controller
      14. @RequestMapping("/account")
      15. public class AccountController {
      16.  
      17.     @Autowired
      18.     private AccountService accountService;
      19.  
      20.     // 保存
      21.     @RequestMapping(value = "/save", produces = "text/html;charset=UTF-8")
      22.     @ResponseBody
      23.     public String save(Account account) {
      24.         accountService.save(account);
      25.         return "保存成功";
      26.     }
      27.  
      28.     // 查询
      29.     @RequestMapping("/findAll")
      30.     public ModelAndView findAll() {
      31.         List accountList = accountService.findAll();
      32.         ModelAndView modelAndView = new ModelAndView();
      33.         modelAndView.addObject("accountList", accountList);
      34.         modelAndView.setViewName("accountList");
      35.         return modelAndView;
      36.     }
      37. }
      38.

    • 编写添加页面

      1. <%--
      2.   Created by IntelliJ IDEA.
      3.   User: ruochen
      4.   Date: 2022/3/12
      5.   Time: 21:31
      6.   To change this template use File | Settings | File Templates.
      7. --%>
      8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
      9. <html>
      10.     <head>
      11.         <title>Title</title>
      12.     </head>
      13.     <body>
      14.         <h1>添加账户信息表单</h1>
      15.         <form name="accountForm" action="${pageContext.request.contextPath}/account/save" method="post">
      16.             账户名称：<input type="text" name="name"><br/>
      17.             账户金额：<input type="text" name="money"><br/>
      18.             <input type="submit" value="保存"><br/>
      19.         </form>
      20.     </body>
      21. </html>
      22.  
      23.

    • 编写列表页面

      1. <%--
      2.   Created by IntelliJ IDEA.
      3.   User: ruochen
      4.   Date: 2022/3/12
      5.   Time: 21:34
      6.   To change this template use File | Settings | File Templates.
      7. --%>
      8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
      9. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
      10. <html>
      11.     <head>
      12.         <title>Title</title>
      13.     </head>
      14.     <body>
      15.         <h1>展示账户数据列表</h1>
      16.         <table border="1">
      17.             <tr>
      18.                 <th>账户ID</th>
      19.                 <th>账户名称</th>
      20.                 <th>账户金额</th>
      21.             </tr>
      22.             <c:forEach items="${accountList}" var="account">
      23.                 <tr>
      24.                     <td>${account.id}</td>
      25.                     <td>${account.name}</td>
      26.                     <td>${account.money}</td>
      27.                 </tr>
      28.             </c:forEach>
      29.         </table>
      30.     </body>
      31. </html>

    • 编写相应配置文件

      • Spring 配置文件：applicationContext.xml
      1. "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.        xsi:schemaLocation="
      6.        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
      7.        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
      8. ">
      9.  
      10.     
      11.     <context:component-scan base-package="com.ruochen">
      12.         
      13.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
      14.     context:component-scan>
      15. beans>
      16.
      • SpringMVC 配置文件：spring-mvc.xml
      1. "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:mvc="http://www.springframework.org/schema/mvc"
      5.        xmlns:context="http://www.springframework.org/schema/context"
      6.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
      7.                            http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
      8.                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
      9.  
      10.     
      11.     <context:component-scan base-package="com.ruochen.controller"/>
      12.  
      13.     
      14.     <mvc:annotation-driven/>
      15.  
      16.     
      17.     <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
      18.         <property name="prefix" value="/WEB-INF/pages/"/>
      19.         <property name="suffix" value=".jsp"/>
      20.     bean>
      21.  
      22.     
      23.     <mvc:default-servlet-handler/>
      24. beans>
      25.
      • MyBatis 映射文件：AccountMapper.xml
      1. "1.0" encoding="UTF-8" ?>
      2. mapper
      3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
      4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
      5. <mapper namespace="com.ruochen.mapper.AccountMapper">
      6.     <insert id="save" parameterType="account">
      7.         insert into account
      8.         values (#{id}, #{name}, #{money})
      9.     insert>
      10.  
      11.     <select id="findAll" resultType="account">
      12.         select *
      13.         from account
      14.     select>
      15. mapper>
      16.
      • MyBatis 核心文件：sqlMapConfig.xml
      1. "1.0" encoding="UTF-8" ?>
      2. configuration
      3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
      5. <configuration>
      6.  
      7.     
      8.     <properties resource="jdbc.properties"/>
      9.  
      10.     
      11.     <typeAliases>
      12.         
      13.         
      14.         <package name="com.ruochen.domain"/>
      15.     typeAliases>
      16.  
      17.     
      18.     <environments default="development">
      19.         <environment id="development">
      20.             <transactionManager type="JDBC"/>
      21.             <dataSource type="POOLED">
      22.                 <property name="driver" value="${jdbc.driver}"/>
      23.                 <property name="url" value="${jdbc.url}"/>
      24.                 <property name="username" value="${jdbc.username}"/>
      25.                 <property name="password" value="${jdbc.password}"/>
      26.             dataSource>
      27.         environment>
      28.     environments>
      29.  
      30.     
      31.     <mappers>
      32.         
      33.         <package name="com.ruochen.mapper"/>
      34.     mappers>
      35. configuration>
      36.
      • 数据库连接信息文件：jdbc.properties
      1. jdbc.driver=com.mysql.jdbc.Driver
      2. jdbc.url=jdbc:mysql://localhost:3306/ssm?useSSL=false&useServerPrepStmts=true&useUnicode=true&characterEncoding=UTF-8
      3. jdbc.username=root
      4. jdbc.password=ruochen666
      5.
      • Web.xml 文件：web.xml
      1. <?xml version="1.0" encoding="UTF-8"?>
      2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
      3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
      5.          version="4.0">
      6.  
      7.     <!--spring 监听器-->
      8.     <context-param>
      9.         <param-name>contextConfigLocation</param-name>
      10.         <param-value>classpath:applicationContext.xml</param-value>
      11.     </context-param>
      12.     <listener>
      13.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      14.     </listener>
      15.  
      16.     <!--springmvc 的前端控制器-->
      17.     <servlet>
      18.         <servlet-name>DispatcherServlet</servlet-name>
      19.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      20.         <init-param>
      21.             <param-name>contextConfigLocation</param-name>
      22.             <param-value>classpath:spring-mvc.xml</param-value>
      23.         </init-param>
      24.         <load-on-startup>1</load-on-startup>
      25.     </servlet>
      26.     <servlet-mapping>
      27.         <servlet-name>DispatcherServlet</servlet-name>
      28.         <url-pattern>/</url-pattern>
      29.     </servlet-mapping>
      30.  
      31.     <!--乱码过滤器-->
      32.     <filter>
      33.         <filter-name>CharacterEncodingFilter</filter-name>
      34.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
      35.         <init-param>
      36.             <param-name>encoding</param-name>
      37.             <param-value>UTF-8</param-value>
      38.         </init-param>
      39.     </filter>
      40.     <filter-mapping>
      41.         <filter-name>CharacterEncodingFilter</filter-name>
      42.         <url-pattern>/*</url-pattern>
      43.     </filter-mapping>
      44.
      • 日志文件：log4j.xml
      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
      6.  
      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
      12.  
      13. ### set log levels - for more verbose logging change 'info' to 'debug' ###
      14.  
      15. log4j.rootLogger=debug, stdout
      16.  
      17.

    MyBatis 整合 Spring 实现

    • sqlMapConfig.xml 修改如下

      1. "1.0" encoding="UTF-8" ?>
      2. configuration
      3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
      5. <configuration>
      6.  
      7.     
      8.     <typeAliases>
      9.         <package name="com.ruochen.domain"/>
      10.     typeAliases>
      11.  
      12. configuration>
      13.

    • applicationContext.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"
      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"
      7.        xsi:schemaLocation="
      8.        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
      9.        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
      10.        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
      11.        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
      12. ">
      13.  
      14.     <!--组件扫描 扫描 service 和 mapper-->
      15.     <context:component-scan base-package="com.ruochen">
      16.         <!--排除controller的扫描-->
      17.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
      18.     </context:component-scan>
      19.  
      20.     <!--加载 properties 文件-->
      21.     <context:property-placeholder location="classpath:jdbc.properties"/>
      22.  
      23.     <!--配置数据源-->
      24.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
      25.         <property name="driverClass" value="${jdbc.driver}"/>
      26.         <property name="jdbcUrl" value="${jdbc.url}"/>
      27.         <property name="user" value="${jdbc.username}"/>
      28.         <property name="password" value="${jdbc.password}"/>
      29.     </bean>
      30.  
      31.     <!--配置 sessionFactory-->
      32.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      33.         <property name="dataSource" ref="dataSource"/>
      34.         <!--加载 mybatis 核心文件-->
      35.         <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
      36.     </bean>
      37.  
      38.     <!--扫描 mapper 所在的包，为 mapper 创建实现类-->
      39.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
      40.         <property name="basePackage" value="com.ruochen.mapper"/>
      41.     </bean>
      42.  
      43.     <!--声明式事务控制-->
      44.     <!--平台事务管理器-->
      45.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      46.         <property name="dataSource" ref="dataSource"/>
      47.     </bean>
      48.  
      49.     <!--配置事务增强-->
      50.     <tx:advice id="txAdvice">
      51.         <tx:attributes>
      52.             <tx:method name="*"/>
      53.         </tx:attributes>
      54.     </tx:advice>
      55.  
      56.     <!--事务的aop织入-->
      57.     <aop:config>
      58.         <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.ruochen.service.impl.*.*(..))"/>
      59.     </aop:config>
      60. </beans>
      61.

    • AccountServiceImpl.java 修改如下

      1. package com.ruochen.service.impl;
      2.  
      3. import com.ruochen.domain.Account;
      4. import com.ruochen.mapper.AccountMapper;
      5. import com.ruochen.service.AccountService;
      6. import org.springframework.beans.factory.annotation.Autowired;
      7. import org.springframework.stereotype.Service;
      8.  
      9. import java.util.List;
      10.  
      11. @Service("accountService")
      12. public class AccountServiceImpl implements AccountService {
      13.  
      14.     @Autowired
      15.     private AccountMapper accountMapper;
      16.  
      17.     @Override
      18.     public void save(Account account) {
      19.         accountMapper.save(account);
      20.     }
      21.  
      22.     @Override
      23.     public List findAll() {
      24.         return accountMapper.findAll();
      25.     }
      26. }
      27.

    报错：Method com/mchange/v2/c3p0/impl/NewProxyResultSet.isClosed()Z is abstract 解决方法 在 pom.xml 文件中修改C3P0的依赖包

    1. <dependency>
    2.    <groupId>com.mchange</groupId>
    3.    <artifactId>c3p0</artifactId>
    4.    <version>0.9.5.2</version>
    5. </dependency>
  • 相关阅读:
    C++静态代码检查工具 - cppcheck
    Node.js--》简易资金管理系统后台项目实战（后端）
    Docker常用基础指令
    智慧供应链解决方案-最新全套文件
    Centos - DNS - 域名解析 服务搭建
    【动态规划】leetcode 1137. 第 N 个泰波那契数
    壳聚糖修饰人血清白蛋白 Chitosan-HSA，根皮苷修饰人血清白蛋白(Phlorizin-HSA)
    【MYSQL安装】Liunx内核为CentOS7
    竖式计算（c++基础）
    数据结构-单链表（增删查改）
  • 原文地址：https://blog.csdn.net/jcc4261/article/details/127682186