SSM项目整合

# SSM项目整合
## 先创建一个maven工程
按maven规范创建包
* src  
    * main
        * java
        * resources
        * webapp
    * test
1. 在pom.xml中导入相关的jar包  
```
 <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>
    <!-- 
    cglib,commons-logging,log4j,ognl,
    log4j-core,javassist,slf4j-api,slf4j-log4j12, -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.5</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/cglib/cglib -->
    <dependency>
      <groupId>cglib</groupId>
      <artifactId>cglib</artifactId>
      <version>3.2.5</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/commons-logging/commons
   -logging -->
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/log4j/log4j -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/ognl/ognl -->
    <dependency>
      <groupId>ognl</groupId>
      <artifactId>ognl</artifactId>
      <version>3.1.15</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.logging.log4
   j/log4j-core -->
    <dependency>
      <groupId>org.apache.logging.log4j</groupId>
      <artifactId>log4j-core</artifactId>
      <version>2.3</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.javassist/javassist
    -->
    <dependency>
      <groupId>org.javassist</groupId>
      <artifactId>javassist</artifactId>
      <version>3.22.0-CR2</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>1.7.25</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12
    -->
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>1.7.25</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-j
   ava -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.18</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spr
   ing-context -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring_data_version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.2.1</version>
    </dependency>
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>mchange-commons-java</artifactId>
      <version>0.2.3.4</version>
    </dependency>
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.1.1</version>
    </dependency>
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.5</version>
    </dependency>


    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
  </dependencies>
```
2. 如果想要在source目录中创建配置文件，则需要在pom.xml中添加如下代码  
```
<build>
    <finalName>Day57_SSM整合</finalName>


    <!--
                默认情况下，maven不会将source目录下的
                xml文件打包
                只会将resources目录下的xml文件打包


                如果想将source目录下的xml文件也打包
                则需要配置下面内容
            -->
    <resources>


      <!--添加也打包java下的-->
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <!--要加入的文件的后缀名-->
          <!--*.properties的*：任意文件-->
          <!--**/：任意目录下-->
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <!-- 是否替换资源中的属性-->
        <filtering>false</filtering>
      </resource>
      <!--默认只打包resources的-->
      <resource>
        <directory>src/main/resources</directory>
      
      </resource>
    </resources>
  </build>
```
3. 在resources目录下创建db.properties（c3p0配置文件）
```
# 配置四大参数
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/mybatis
db.username=root
db.password=123
# 池配置
db.initialPoolSize=20
db.maxIdleTime=60
db.maxPoolSize=200
db.minPoolSize=50
db.acquireIncrement=3
db.acquireRetryDelay=1000
db.acquireRetryAttempts=30
db.breakAfterAcquireFailure=false
```
4. 在resources目录下创建spring配置文件，spring-config.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" xmlns:mvc="http://www.springframework.org/schema/mvc"
       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 
       http://www.springframework.org/schema/mvc 
       http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--MVC的注解-->
    <mvc:annotation-driven/>
    <!--自动扫描-->
    <context:component-scan base-package="com.ssm"/>
    <!--
        将静态资源，交由web处理
        SpringMVC不管         2018-2-8 15:12:46
    -->
    <mvc:default-servlet-handler/>


    <!-- SpringMVC：处理请求转发 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--注解-->
    <context:annotation-config/>
    <!--导入db配置文件-->
    <context:property-placeholder location="classpath:db.properties"/>


    <!-- 配置c3p0数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">


        <property name="driverClass" value="${db.driver}"/>
        <property name="jdbcUrl" value="${db.url}"/>
        <property name="user" value="${db.username}"/>
        <property name="password" value="${db.password}"/>


        <property name="initialPoolSize" value="${db.initialPoolSize}"/>
        <!--最大空闲时间，池中连接对象，长时间不使用则被丢弃-->
        <!--默认：0，不丢弃-->
        <property name="maxIdleTime" value="${db.maxIdleTime}"/>
        <property name="maxPoolSize" value="${db.maxPoolSize}"/>
        <property name="minPoolSize" value="${db.minPoolSize}"/>


        <!--若池中无空闲连接，则一次性增加多少连接对象-->
        <!--默认：3-->
        <property name="acquireIncrement" value="${db.acquireIncrement}"/>


        <!--两次获取连接的间隔时间-->
        <!--默认：1000毫秒-->
        <property name="acquireRetryDelay" value="${db.acquireRetryDelay}"/>


        <!--若获取连接失败，尝试多少次-->
        <!--默认：30次-->
        <property name="acquireRetryAttempts" value="${db.acquireRetryAttempts}"/>




        <!--获取连接失败，则会引起所有正在等待连接池给予连接的线程，抛出异常-->
        <!--但是数据源扔有效保留，并在下次调用getConnection时，继续尝试获取连接-->
        <!--如果设置为true，那么在尝试获取连接失败后，会将数据源设置为已断开状态并永久关闭-->
        <!--默认：false-->
        <property name="breakAfterAcquireFailure" value="${db.breakAfterAcquireFailure}"/>
    </bean>


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


        <!--mybatis的配置文件路径-->
        <property name="configLocation" value="classpath:SqlMapConfig.xml"/>


        <!--在spring的配置文件中，为mybatis指定数据源-->
        <!--就是我们上面定义的c3p0的dataSource-->
        <property name="dataSource" ref="dataSource"/>
    </bean>


    <!--这里和ssh时一样，配置事务管理对象-->
    <!--切面-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>




    <!--配置事务属性-->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="add*"/>
            <tx:method name="delete*"/>
            <tx:method name="update*"/>
            <tx:method name="find*"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>


    <aop:config>
        <!--配置切入点-->
        <aop:pointcut id="pointCut" expression="execution(* com.ssm.*.dao.*.*(..))"/>


        <!--
            配置通知
            就是在切入点前后要做的事情（前置通知后置通知什么的
        -->
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut"/>
    </aop:config>


    <!--由spring管理原始dao-->
    <!--方式一-->
    <!--<bean id="userDao" class="com.lanou">-->
    <!--<property name="sqSessionFactory" ref="sqlSessionFactory"/>-->
    <!--</bean>-->


    <!--方式二-->
    <!--通过mapper代理开发模式，批量进行mapper配置-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--指定批量mapper配置的包名（就是dao层）-->
        <property name="basePackage" value="com.ssm.*.dao"/>
        <!--指定这些dao都使用哪个SqlSessionFactory-->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>


</beans>
```
5. 在resources目录下创建Mybatis配置文件SQLMapConfig.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>
    <!--
        将数据库的配置文件导入到MyBatis的配置文件中
        这样在后面的标签中，就可以找到db中的属性值了
    -->
    <properties resource="db.properties"/>
    <settings>
        <!-- lazyLoadingEnabled：延迟加载的开关，默认为false -->
        <setting name="lazyLoadingEnabled" value="true"/>


        <!-- aggressiveLazyLoading默认为true，一旦为true，则上面的懒加载开关将失效 -->
        <setting name="aggressiveLazyLoading" value="false"/>


        <!-- cacheEnabled：二级缓存的总开关 默认为false -->
        <setting name="cacheEnabled" value="true"/>
    </settings>
    <typeAliases>


    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${db.driver}"/>
                <property name="url" value="${db.url}"/>
                <property name="username" value="${db.username}"/>
                <property name="password" value="${db.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="com.ssm.*.dao"/>
    </mappers>
</configuration>
```
6. 配置web.xml
```
<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >


<web-app>
  <display-name>Archetype Created Web Application</display-name>
  <!--指定Spring配置文件-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-config.xml</param-value>
  </context-param>




  <context-param>
    <param-name>log4jRefreshInterval</param-name>
    <param-value>60000</param-value>
  </context-param>


  <!--字符编码配置-->
  <filter>
    <filter-name>characterEncoding</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>characterEncoding</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>


  <listener>
    <listener-class>
      org.springframework.web.context.ContextLoaderListener
    </listener-class>
  </listener>
  <servlet>
    <servlet-name>springmvc</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet
    </servlet-class>


    <!--指定SpringMVC配置文件-->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-config.xml</param-value>
    </init-param>
  </servlet>
  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>
```
**到这就配置完毕了，是不是很简单**  
***
**我们写个类来测试一下**  
1. 在java下创建包com.ssm.user
2. 在user包下创建四个包
    * controller
    * dao
    * domain
    * service


*你可以和我不一样，但一定要符合配置文件中的规范*
```
 <!--指定批量mapper配置的包名（就是dao层）-->
        <property name="basePackage" value="com.ssm.*.dao"/>
```
```
<aop:pointcut id="pointCut" expression="execution(* com.ssm.*.dao.*.*(..))"/>
```
```
 <mappers>
        <package name="com.ssm.*.dao"/>
    </mappers>
```
3. 在创建domain包下创建User类  
*请自行创建mybatis数据库和user表*
```
package com.ssm.user.domain;


public class User {
    private int id;
    private String username;


    public User() {
    }


    public int getId() {


        return id;
    }


    public void setId(int id) {
        this.id = id;
    }


    public String getUsername() {
        return username;
    }


    public void setUsername(String username) {
        this.username = username;
    }
}
```
4. 在dao包下创建UserMapper和UserMapper.xml
```
package com.ssm.user.dao;


import com.ssm.user.domain.User;
import org.springframework.stereotype.Repository;


@Repository
public interface UserMapper {
    User findUserById(int id);


    void insertUser(User user);
}


```
```
<?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.ssm.user.dao.UserMapper">
    <insert id="insertUser"
            parameterType="com.ssm.user.domain.User">
        INSERT INTO USER (id,username)
        VALUES (#{id},#{username})
    </insert>
    <select id="findUserById" parameterType="int" resultType="com.ssm.user.domain.User">
        SELECT * FROM user WHERE id = #{id}
    </select>
</mapper>
```
5. 在controller包下创建UserController类
```
<?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.ssm.user.dao.UserMapper">
    <insert id="insertUser"
            parameterType="com.ssm.user.domain.User">
        INSERT INTO USER (id,username)
        VALUES (#{id},#{username})
    </insert>
    <select id="findUserById" parameterType="int" resultType="com.ssm.user.domain.User">
        SELECT * FROM user WHERE id = #{id}
    </select>
</mapper>
```
6.在WEB_INF/pages下创建login.jsp和register.jsp
```
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>login.jsp</title>
</head>
<body>
<h1>SUCCESS</h1>
</body>
</html>
```
```
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page isELIgnored="false" %>
<html>
<head>
    <title>注册页面</title>
</head>
<body>
    <form action="${pageContext.request.contextPath}/user/register"
          method="post">
        <input type="text" name="username">
        <input type="submit">
    </form>
</body>
</html>


```
7. 启动tomcat
8. 更改程序中的错误
9. 更改程序中的错误
10. 更改程序中的错误
11. 更改程序中的错误
12. 更改程序中的错误
13. 更改程序中的错误
14. 更改程序中的错误