RBAC项目：集成SSM框架

港控/mmm° 2023-06-22 05:27 42阅读 0赞

# 添加依赖 #

在atcrowdfunding-parent的pom.xml中添加如下依赖

<dependencies>                                                              
        <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.1.3-b06</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-core</artifactId>                          
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-context</artifactId>                       
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-jdbc</artifactId>                          
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-orm</artifactId>                           
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-web</artifactId>                           
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-webmvc</artifactId>                        
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>com.mchange</groupId>                                
            <artifactId>c3p0</artifactId>                                 
            <version>0.9.2</version>                                      
        </dependency>                                                           
        <dependency>                                                            
            <groupId>cglib</groupId>                                      
            <artifactId>cglib</artifactId>                                
            <version>2.2</version>                                        
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.aspectj</groupId>                                
            <artifactId>aspectjweaver</artifactId>                        
            <version>1.6.8</version>                                      
        </dependency>                                                           
                                                                                      
                                                      
                                         
                 
        <dependency>                                                            
            <groupId>org.mybatis</groupId>                                
            <artifactId>mybatis</artifactId>                              
            <version>3.2.8</version>                                      
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.mybatis</groupId>                                
            <artifactId>mybatis-spring</artifactId>                       
            <version>1.2.2</version>                                      
        </dependency>                                                           
                                                                                      
                                                
        <dependency>                                                            
            <groupId>log4j</groupId>                                      
            <artifactId>log4j</artifactId>                                
            <version>1.2.17</version>                                     
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.slf4j</groupId>                                  
            <artifactId>slf4j-api</artifactId>                            
            <version>1.7.7</version>                                      
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.slf4j</groupId>                                  
            <artifactId>slf4j-log4j12</artifactId>                        
            <version>1.7.7</version>                                      
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>mysql</groupId>                                      
            <artifactId>mysql-connector-java</artifactId>                 
            <version>5.1.37</version>                                     
        </dependency>                                                           
        <dependency>                                                            
            <groupId>jstl</groupId>                                       
            <artifactId>jstl</artifactId>                                 
            <version>1.2</version>                                        
        </dependency>                                                           
                                                                                      
                             
                                                                                      
                                                        
        <dependency>                                                            
            <groupId>net.sf.ehcache</groupId>                             
            <artifactId>ehcache</artifactId>                              
            <version>1.6.2</version>                                      
        </dependency>                                                           
                                                                                      
                                                                                      
                                                        
        <dependency>                                                            
            <groupId>org.quartz-scheduler</groupId>                       
            <artifactId>quartz</artifactId>                               
            <version>1.8.5</version>                                      
        </dependency>                                                           
        <dependency>                                                            
            <groupId>org.springframework</groupId>                        
            <artifactId>spring-context-support</artifactId>               
            <version>4.0.0.RELEASE</version>                              
        </dependency>                                                           
        <dependency>                                                            
            <groupId>commons-collections</groupId>                        
            <artifactId>commons-collections</artifactId>                  
            <version>3.1</version>                                        
        </dependency>                                                           
                                                        
                                                                                      
        <dependency>                                                            
            <groupId>org.codehaus.jackson</groupId>                       
            <artifactId>jackson-mapper-asl</artifactId>                   
            <version>1.9.2</version>                                      
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.apache.poi</groupId>                             
            <artifactId>poi</artifactId>                                  
            <version>3.9</version>                                        
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.jfree</groupId>                                  
            <artifactId>jfreechart</artifactId>                           
            <version>1.0.19</version>                                     
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>commons-fileupload</groupId>                         
            <artifactId>commons-fileupload</artifactId>                   
            <version>1.3.1</version>                                      
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.freemarker</groupId>                             
            <artifactId>freemarker</artifactId>                           
            <version>2.3.19</version>                                     
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.activiti</groupId>                               
            <artifactId>activiti-engine</artifactId>                      
            <version>5.15.1</version>                                     
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.activiti</groupId>                               
            <artifactId>activiti-spring</artifactId>                      
            <version>5.15.1</version>                                     
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.apache.commons</groupId>                         
            <artifactId>commons-email</artifactId>                        
            <version>1.3.1</version>                                      
        </dependency>                                                           
                                                                                      
        <dependency>                                                            
            <groupId>org.activiti</groupId>                               
            <artifactId>activiti-explorer</artifactId>                    
            <version>5.15.1</version>                                     
            <exclusions>                                                        
                <exclusion>                                                     
                    <artifactId>groovy-all</artifactId>                   
                    <groupId>org.codehaus.groovy</groupId>                
                </exclusion>                                                    
            </exclusions>                                                       
        </dependency>                                                           
    </dependencies>

因为依赖传递，所以就可以在其他项目（比如atcrowdfunding-web）就看到这些依赖

# 集成spring框架 #

spring是整个系统框架的核心，将前端请求数据的处理和数据库的数据操作整合在一起。

*  1、打开atcrowdfunding-web\\src\\main\\webapp\\WEB-INF中的web.xml，在标签中增加如下配置信息

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath*:spring/spring-*.xml</param-value>
        </context-param>
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    </web-app>

*  2、打开atcrowdfunding-web\\src\\main\\resources, 创建文件夹spring，并在sping文件夹下创建  
    spring-context.xml， 其内容为：

# 集成springMVC框架 #

SpringMVC框架用于处理系统中数据的流转和控制

*  1、打开atcrowdfunding-web\\src\\main\\webapp\\WEB-INF中的web.xml，在标签中增加如下配置信息

<servlet>
            <servlet-name>springmvc</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring/springmvc-context.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>

*  2、打开atcrowdfunding-web\\src\\main\\resources\\spring，在spring文件夹下创建  
    springmvc-context.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:p="http://www.springframework.org/schema/p"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
    		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-4.0.xsd">
    	
    	
        <context:component-scan base-package="com.atguigu.*" use-default-filters="false" >
            <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
        
        
        <mvc:default-servlet-handler/>
        <mvc:annotation-driven />
        
        
        
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" >
            <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
            <property name="prefix" value="/WEB-INF/jsp/"/>
            <property name="suffix" value=".jsp"/>
        </bean>
        
        
            <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" >
            <property name="messageConverters" >
                <list>
                    <bean class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter" >
                        <property name="supportedMediaTypes" >
                            <list>
                                <value>application/json;charset=UTF-8</value>
                            </list>
                        </property>
                    </bean>
                </list>
            </property>
        </bean>
        
        
        
        <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="UTF-8" >
            <property name="maxUploadSize" value="2097152"/>
            <property name="resolveLazily" value="true"/>
        </bean>
    </beans>

# 集成mybatis #

MyBatis作用是：处理业务也数据库之间的数据交互，因此创建对象和管理对象生命周期的职责可以委托spring框架完成

*  1、打开atcrowdfunding-web\\src\\main\\resources\\spring\\spring-context.xml， 增加配置项：

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
            <property name="configLocation" value="classpath:mybatis/config.xml" />
            <property name="dataSource" ref="dataSource" />
            <property name="mapperLocations" >
                <list>
                    <value>classpath*:mybatis/mapper-*.xml</value>
                </list>
            </property>
        </bean>
        
         
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" >
            <property name="driverClass" value="com.mysql.jdbc.Driver"/>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/atcrowdfunding?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf8"/>
            <property name="user" value="root"/>
            <property name="password" value="123456"/>
        </bean>
        
        
        
         <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer" >
            <property name="basePackage" value="com.atguigu.atcrowdfunding.**.dao" />
        </bean>
        
        
           
         <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" >
            <property name="dataSource" ref="dataSource"/>
        </bean>
        <tx:advice id="transactionAdvice" transaction-manager="transactionManager" >
            <tx:attributes>
                <tx:method name="*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="java.lang.Exception" />
                <tx:method name="query*" read-only="true" />
            </tx:attributes>
        </tx:advice>    
        <aop:config>
            <aop:advisor advice-ref="transactionAdvice" pointcut="execution(* com.atguigu..*Service.*(..))"/>
        </aop:config>

*  2、增加mybatis的核心配置文件：打开atcrowdfunding-web\\src\\main\\resources, 创建mybatis文件夹，  
    然后在mybatis文件夹中创建文件config.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>
            
        </typeAliases>
    </configuration>

# 测试框架是否成功集成 #

## 测试springMVC框架 ##

### 测试能否解析视图： ###

*  在 atcrowdfunding-web/src/main/java/com/atguigu/atcrowdfunding/controller目录中增加UserController

package com.atguigu.atcrowdfunding.controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    @RequestMapping("/user")
    public class UserController {
        
    	
    	@RequestMapping("/index")
    	public String index() {
        
    		return "index";
    	}
    }

*  添加视图  
    在 atcrowdfunding-web/…/WEB-INF/jsp/下面写一个jsp页面。

![在这里插入图片描述][20191214154459137.png]

### 测试能否解析json ###

package com.atguigu.atcrowdfunding.controller;
    
    import java.util.HashMap;
    import java.util.Map;
    
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    @Controller
    @RequestMapping("/user")
    public class UserController {
    	
    	@RequestMapping("/index")
    	public String index() {
    		return "index";
    	}
    	
    	@ResponseBody
    	@RequestMapping("/json")
    	public Object json() {
    		Map<String, String> map = new HashMap<String, String>();
    		map.put("username", "张珊");
    		
    		return map;
    	}
    }

*  将web项目发布到服务器中，启动服务器，浏览器中分别输入路径http://127.0.0.1:8080/应用路径名称/user/index，http://127.0.0.1:8080/应用路径名称/user/json进行测试。

**如果访问成功，说明项目中SpringMVC框架集成成功。**

## 测试spring框架 ##

*  1、测试前，在mysql数据库中增加atcrowdfunding库及t\_user表。

CREATE DATABASE `atcrowdfunding`;
    
    CREATE TABLE t_user (
       id int(11) NOT NULL auto_increment  ,
       PRIMARY KEY (id)
    ) ENGINE=InnoDB auto_increment =5 DEFAULT CHARSET=utf8;

[20191214154459137.png]: https://img-blog.csdnimg.cn/20191214154459137.png