SSM 框架整合

	```sql
	create database ssm character set utf8;
	use ssm;
	create table account(
		id int primary key auto_increment,
		name varchar(100),
		money double(7,2)
	);
	```

	```xml
	<?xml version="1.0" encoding="UTF-8"?>
	<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">
	    <modelVersion>4.0.0</modelVersion>

    <groupId>com.ruochen</groupId>

    <artifactId>ssm</artifactId>

    <version>1.0-SNAPSHOT</version>

    <packaging>war</packaging>

    <properties>

        <maven.compiler.source>8</maven.compiler.source>

        <maven.compiler.target>8</maven.compiler.target>

    </properties>

    <dependencies>

        <!--spring相关-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context</artifactId>

            <version>5.0.5.RELEASE</version>

        </dependency>

        <!--aop织入-->

        <dependency>

            <groupId>org.aspectj</groupId>

            <artifactId>aspectjweaver</artifactId>

            <version>1.8.8</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jdbc</artifactId>

            <version>5.0.5.RELEASE</version>

        </dependency>

        <!--事务相关-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-tx</artifactId>

            <version>5.0.5.RELEASE</version>

        </dependency>

        <!--测试相关-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-test</artifactId>

            <version>5.0.5.RELEASE</version>

        </dependency>

        <!--springmvc相关-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-webmvc</artifactId>

            <version>5.0.5.RELEASE</version>

        </dependency>

        <!--servlet 和 jsp-->

        <dependency>

            <groupId>javax.servlet</groupId>

            <artifactId>servlet-api</artifactId>

            <version>2.5</version>

        </dependency>

        <dependency>

            <groupId>javax.servlet.jsp</groupId>

            <artifactId>jsp-api</artifactId>

            <version>2.0</version>

        </dependency>

        <!--mybatis 相关-->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>3.5.5</version>

        </dependency>

        <!--spring 整合 mybatis -->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId>

            <version>1.3.1</version>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.46</version>

        </dependency>

        <!--数据源-->

        <dependency>

            <groupId>c3p0</groupId>

            <artifactId>c3p0</artifactId>

            <version>0.9.1.2</version>

        </dependency>

        <dependency>

            <groupId>junit</groupId>

            <artifactId>junit</artifactId>

            <version>4.13</version>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>jstl</groupId>

            <artifactId>jstl</artifactId>

            <version>1.2</version>

        </dependency>

    </dependencies>

</project>

```

	```java
	package com.ruochen.domain;

public class Account {

    private Integer id;

    private String name;

    private Double money;

    public Integer getId() {

        return id;

    }

    public void setId(Integer id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public Double getMoney() {

        return money;

    }

    public void setMoney(Double money) {

        this.money = money;

    }

    @Override

    public String toString() {

        return "Account{" +

                "id=" + id +

                ", name='" + name + '\'' +

                ", money=" + money +

                '}';

    }

}

```

	```java
	package com.ruochen.mapper;

import com.ruochen.domain.Account;

import java.util.List;

public interface AccountMapper {

    void save(Account account);

    List<Account> findAll();

}

```

	```java
	package com.ruochen.service;

import com.ruochen.domain.Account;

import java.util.List;

public interface AccountService {

    void save(Account account);

    List<Account> findAll();

}

```

	```java
	package com.ruochen.service.impl;

import com.ruochen.domain.Account;

import com.ruochen.mapper.AccountMapper;

import com.ruochen.service.AccountService;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.springframework.stereotype.Service;

import java.io.IOException;

import java.io.InputStream;

import java.util.List;

@Service("accountService")

public class AccountServiceImpl implements AccountService {

    @Override

    public void save(Account account) {

        try {

            InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");

            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);

            SqlSession sqlSession = sqlSessionFactory.openSession();

            AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);

            mapper.save(account);

            sqlSession.commit();

            sqlSession.close();

        } catch (IOException e) {

            e.printStackTrace();

        }

    }

    @Override

    public List<Account> findAll() {

        try {

            InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");

            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);

            SqlSession sqlSession = sqlSessionFactory.openSession();

            AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);

            List<Account> accountList = mapper.findAll();

            sqlSession.close();

            return accountList;

        } catch (IOException e) {

            e.printStackTrace();

        }

        return null;

    }

}

```

	```java
	package com.ruochen.controller;

import com.ruochen.domain.Account;

import com.ruochen.service.AccountService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.servlet.ModelAndView;

import java.util.List;

@Controller

@RequestMapping("/account")

public class AccountController {

    @Autowired

    private AccountService accountService;

    // 保存

    @RequestMapping(value = "/save", produces = "text/html;charset=UTF-8")

    @ResponseBody

    public String save(Account account) {

        accountService.save(account);

        return "保存成功";

    }

    // 查询

    @RequestMapping("/findAll")

    public ModelAndView findAll() {

        List<Account> accountList = accountService.findAll();

        ModelAndView modelAndView = new ModelAndView();

        modelAndView.addObject("accountList", accountList);

        modelAndView.setViewName("accountList");

        return modelAndView;

    }

}

```

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

```

	```java
	<%--
	  Created by IntelliJ IDEA.
	  User: ruochen
	  Date: 2022/3/12
	  Time: 21:34
	  To change this template use File | Settings | File Templates.
	--%>
	<%@ page contentType="text/html;charset=UTF-8" language="java" %>
	<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
	<html>
	    <head>
	        <title>Title</title>
	    </head>
	    <body>
	        <h1>展示账户数据列表</h1>
	        <table border="1">
	            <tr>
	                <th>账户ID</th>
	                <th>账户名称</th>
	                <th>账户金额</th>
	            </tr>
	            <c:forEach items="${accountList}" var="account">
	                <tr>
	                    <td>${account.id}</td>
	                    <td>${account.name}</td>
	                    <td>${account.money}</td>
	                </tr>
	            </c:forEach>
	        </table>
	    </body>
	</html>
	```

		- Spring 配置文件：applicationContext.xml	```xml
	<?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"
	       xsi:schemaLocation="
	       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
	       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
	">

    <!--组件扫描 扫描 service 和 mapper-->

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

        <!--排除controller的扫描-->

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

    </context:component-scan>

</beans>

```

- SpringMVC 配置文件：`spring-mvc.xml`
```xml
<?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:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
                           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!--组件扫描 主要扫描 controller-->

    <context:component-scan base-package="com.ruochen.controller"/>

    <!--配置 mvc 注解驱动-->

    <mvc:annotation-driven/>

    <!--配置内部资源视图解析器-->

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

        <property name="prefix" value="/WEB-INF/pages/"/>

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

    </bean>

    <!--开放静态资源访问权限-->

    <mvc:default-servlet-handler/>

</beans>

```

- MyBatis 映射文件：`AccountMapper.xml`
```xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruochen.mapper.AccountMapper">
    <insert id="save" parameterType="account">
        insert into account
        values (#{id}, #{name}, #{money})
    </insert>

    <select id="findAll" resultType="account">

        select *

        from account

    </select>

</mapper>

```

- MyBatis 核心文件：`sqlMapConfig.xml`
```xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!--加载 properties文件-->

    <properties resource="jdbc.properties"/>

    <!--定义别名-->

    <typeAliases>

        <!--<typeAlias type="com.ruochen.domain.Account" alias="account"/>-->

        <!--扫包-->

        <package name="com.ruochen.domain"/>

    </typeAliases>

    <!--环境-->

    <environments default="development">

        <environment id="development">

            <transactionManager type="JDBC"/>

            <dataSource type="POOLED">

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

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

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

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

            </dataSource>

        </environment>

    </environments>

    <!--加载映射-->

    <mappers>

        <!--<mapper resource="com.ruochen.mapper.AccountMapper"/>-->

        <package name="com.ruochen.mapper"/>

    </mappers>

</configuration>

```

- 数据库连接信息文件：`jdbc.properties`
```xml
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?useSSL=false&useServerPrepStmts=true&useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=ruochen666
```
- Web.xml 文件：`web.xml`
```xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">

    <!--spring 监听器-->

    <context-param>

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

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

    </context-param>

    <listener>

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

    </listener>

    <!--springmvc 的前端控制器-->

    <servlet>

        <servlet-name>DispatcherServlet</servlet-name>

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

        <init-param>

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

            <param-value>classpath:spring-mvc.xml</param-value>

        </init-param>

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

    </servlet>

    <servlet-mapping>

        <servlet-name>DispatcherServlet</servlet-name>

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

    </servlet-mapping>

    <!--乱码过滤器-->

    <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>

    </filter>

    <filter-mapping>

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

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

    </filter-mapping>

</web-app>

```

- 日志文件：`log4j.xml`
```xml
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###

log4j.appender.file=org.apache.log4j.FileAppender

log4j.appender.file.File=c:/mylog.log

log4j.appender.file.layout=org.apache.log4j.PatternLayout

log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=debug, stdout

```

	```xml
	<?xml version="1.0" encoding="UTF-8" ?>
	<!DOCTYPE configuration
	        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
	        "http://mybatis.org/dtd/mybatis-3-config.dtd">
	<configuration>

    <!--定义别名-->

    <typeAliases>

        <package name="com.ruochen.domain"/>

    </typeAliases>

</configuration>

```

	```xml
	<?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:tx="http://www.springframework.org/schema/tx"
	       xmlns:aop="http://www.springframework.org/schema/aop"
	       xsi:schemaLocation="
	       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
	       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
	       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
	       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
	">

    <!--组件扫描 扫描 service 和 mapper-->

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

        <!--排除controller的扫描-->

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

    </context:component-scan>

    <!--加载 properties 文件-->

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

    <!--配置数据源-->

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

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

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

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

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

    </bean>

    <!--配置 sessionFactory-->

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

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

        <!--加载 mybatis 核心文件-->

        <property name="configLocation" value="classpath:sqlMapConfig.xml"/>

    </bean>

    <!--扫描 mapper 所在的包，为 mapper 创建实现类-->

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

        <property name="basePackage" value="com.ruochen.mapper"/>

    </bean>

    <!--声明式事务控制-->

    <!--平台事务管理器-->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

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

    </bean>

    <!--配置事务增强-->

    <tx:advice id="txAdvice">

        <tx:attributes>

            <tx:method name="*"/>

        </tx:attributes>

    </tx:advice>

    <!--事务的aop织入-->

    <aop:config>

        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.ruochen.service.impl.*.*(..))"/>

    </aop:config>

</beans>

```

	```java
	package com.ruochen.service.impl;

import com.ruochen.domain.Account;

import com.ruochen.mapper.AccountMapper;

import com.ruochen.service.AccountService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import java.util.List;

@Service("accountService")

public class AccountServiceImpl implements AccountService {

    @Autowired

    private AccountMapper accountMapper;

    @Override

    public void save(Account account) {

        accountMapper.save(account);

    }

    @Override

    public List<Account> findAll() {

        return accountMapper.findAll();

    }

}

```

<dependency>
   <groupId>com.mchange</groupId>
   <artifactId>c3p0</artifactId>
   <version>0.9.5.2</version>
</dependency>