• 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 坐标

      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.0modelVersion>
      6.  
      7.     <groupId>com.ruochengroupId>
      8.     <artifactId>ssmartifactId>
      9.     <version>1.0-SNAPSHOTversion>
      10.     <packaging>warpackaging>
      11.  
      12.     <properties>
      13.         <maven.compiler.source>8maven.compiler.source>
      14.         <maven.compiler.target>8maven.compiler.target>
      15.     properties>
      16.  
      17.     <dependencies>
      18.         
      19.         <dependency>
      20.             <groupId>org.springframeworkgroupId>
      21.             <artifactId>spring-contextartifactId>
      22.             <version>5.0.5.RELEASEversion>
      23.         dependency>
      24.         
      25.         <dependency>
      26.             <groupId>org.aspectjgroupId>
      27.             <artifactId>aspectjweaverartifactId>
      28.             <version>1.8.8version>
      29.         dependency>
      30.         <dependency>
      31.             <groupId>org.springframeworkgroupId>
      32.             <artifactId>spring-jdbcartifactId>
      33.             <version>5.0.5.RELEASEversion>
      34.         dependency>
      35.         
      36.         <dependency>
      37.             <groupId>org.springframeworkgroupId>
      38.             <artifactId>spring-txartifactId>
      39.             <version>5.0.5.RELEASEversion>
      40.         dependency>
      41.         
      42.         <dependency>
      43.             <groupId>org.springframeworkgroupId>
      44.             <artifactId>spring-testartifactId>
      45.             <version>5.0.5.RELEASEversion>
      46.         dependency>
      47.         
      48.         <dependency>
      49.             <groupId>org.springframeworkgroupId>
      50.             <artifactId>spring-webmvcartifactId>
      51.             <version>5.0.5.RELEASEversion>
      52.         dependency>
      53.  
      54.         
      55.         <dependency>
      56.             <groupId>javax.servletgroupId>
      57.             <artifactId>servlet-apiartifactId>
      58.             <version>2.5version>
      59.         dependency>
      60.         <dependency>
      61.             <groupId>javax.servlet.jspgroupId>
      62.             <artifactId>jsp-apiartifactId>
      63.             <version>2.0version>
      64.         dependency>
      65.  
      66.         
      67.         <dependency>
      68.             <groupId>org.mybatisgroupId>
      69.             <artifactId>mybatisartifactId>
      70.             <version>3.5.5version>
      71.         dependency>
      72.         
      73.         <dependency>
      74.             <groupId>org.mybatisgroupId>
      75.             <artifactId>mybatis-springartifactId>
      76.             <version>1.3.1version>
      77.         dependency>
      78.         <dependency>
      79.             <groupId>mysqlgroupId>
      80.             <artifactId>mysql-connector-javaartifactId>
      81.             <version>5.1.46version>
      82.         dependency>
      83.         
      84.         <dependency>
      85.             <groupId>c3p0groupId>
      86.             <artifactId>c3p0artifactId>
      87.             <version>0.9.1.2version>
      88.         dependency>
      89.         <dependency>
      90.             <groupId>junitgroupId>
      91.             <artifactId>junitartifactId>
      92.             <version>4.13version>
      93.             <scope>testscope>
      94.         dependency>
      95.         <dependency>
      96.             <groupId>jstlgroupId>
      97.             <artifactId>jstlartifactId>
      98.             <version>1.2version>
      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>Titletitle>
      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>Titletitle>
      13.     head>
      14.     <body>
      15.         <h1>展示账户数据列表h1>
      16.         <table border="1">
      17.             <tr>
      18.                 <th>账户IDth>
      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
      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
      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
      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
      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
      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.     
      8.     <context-param>
      9.         <param-name>contextConfigLocationparam-name>
      10.         <param-value>classpath:applicationContext.xmlparam-value>
      11.     context-param>
      12.     <listener>
      13.         <listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
      14.     listener>
      15.  
      16.     
      17.     <servlet>
      18.         <servlet-name>DispatcherServletservlet-name>
      19.         <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
      20.         <init-param>
      21.             <param-name>contextConfigLocationparam-name>
      22.             <param-value>classpath:spring-mvc.xmlparam-value>
      23.         init-param>
      24.         <load-on-startup>1load-on-startup>
      25.     servlet>
      26.     <servlet-mapping>
      27.         <servlet-name>DispatcherServletservlet-name>
      28.         <url-pattern>/url-pattern>
      29.     servlet-mapping>
      30.  
      31.     
      32.     <filter>
      33.         <filter-name>CharacterEncodingFilterfilter-name>
      34.         <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
      35.         <init-param>
      36.             <param-name>encodingparam-name>
      37.             <param-value>UTF-8param-value>
      38.         init-param>
      39.     filter>
      40.     <filter-mapping>
      41.         <filter-name>CharacterEncodingFilterfilter-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 修改如下

      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 修改如下

      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.     
      15.     <context:component-scan base-package="com.ruochen">
      16.         
      17.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
      18.     context:component-scan>
      19.  
      20.     
      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.     
      32.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      33.         <property name="dataSource" ref="dataSource"/>
      34.         
      35.         <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
      36.     bean>
      37.  
      38.     
      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.     
      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.mchangegroupId>
    3.    <artifactId>c3p0artifactId>
    4.    <version>0.9.5.2version>
    5. dependency>
  • 相关阅读:
    深入理解多线程（第三篇）
    win10蓝屏0xc000021a怎么修复？
    05【Redis的发布订阅】
    _jb_pytest_runner.py: error: unrecognized arguments: --cov报错
    Python面试题：在 Python 中，如何实现一个 LRU（最近最少使用）缓存？
    【计算机毕业设计】java开源项目——在线考试系统
    [ARM入门]ARM模式及其切换、异常
    cesium画的矩形不是方的？
    【opencv图像处理】--3.图像运算、基本变换、仿射变换
    docsify多页文档找不到文档404
  • 原文地址：https://blog.csdn.net/LBWNB_Java/article/details/126297433