Java_基础框架_SSM

亦凉 2021-10-06 03:42 256阅读 0赞

### Java\_基础框架\_SSM ###

*  源码
 *   *  CallbackMappingJackson2HttpMessageConverter
     *  UserExcelView
     *  MyIntercpetor
 *  jdbc.properties
 *  applicationContext-service.xml
 *  applicationContext-dao.xml
 *  mybatis-config.xml
 *  springmvc-servlet.xml
 *  web.xml
 *  依赖pom.xml

*SSM：Springmvc+Spring+Mybatis*

**（1）Spring**  
　　Spring就像是整个项目中装配bean的大工厂，在配置文件中可以指定使用特定的参数去调用实体类的构造方法来实例化对象。也可以称之为项目中的粘合剂。  
　　Spring的核心思想是`IoC`（控制反转），`Aop`（面向切面编程）即不再需要程序员去显式地new一个对象，而是让Spring框架帮你来完成这一切。  
　　官方文档：Spring Framework Reference Documentation  
　　https://docs.spring.io/spring/docs/4.3.22.RELEASE/spring-framework-reference/pdf/spring-framework-reference.pdf  
**（2）SpringMVC**  
　　SpringMVC在项目中拦截用户请求，它的`核心Servlet`即DispatcherServlet承担中介或是前台这样的职责，将用户请求通过HandlerMapping去匹配Controller，Controller就是具体对应请求所执行的操作。SpringMVC相当于SSH框架中struts。  
　　SpringMVC执行流程：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE1NzY0OTQz_size_16_color_FFFFFF_t_70]  
SpringMVC执行流程:  
1.用户发送请求至`前端控制器`DispatcherServlet  
2.DispatcherServlet收到请求调用`处理器映射器`HandlerMapping。  
3.处理器映射器根据请求url找到具体的处理器，生成处理器执行链HandlerExecutionChain(包括处理器对象和处理器拦截器)一并返回给DispatcherServlet。  
4.DispatcherServlet根据处理器Handler获取`处理器适配器`HandlerAdapter执行HandlerAdapter处理一系列的操作，如：*参数封装，数据格式转换，数据验证等操作*  
5.执行处理器Handler(Controller，也叫页面控制器)。  
6.Handler执行完成返回ModelAndView  
7.HandlerAdapter将Handler执行结果ModelAndView返回到DispatcherServlet  
8.DispatcherServlet将ModelAndView传给ViewReslover`视图解析器`  
9.ViewReslover解析后返回具体View  
10.DispatcherServlet对View进行渲染视图（即将模型数据model填充至视图中）。  
11.DispatcherServlet响应用户。

**（3）Mybatis**  
　　Mybatis是对jdbc的封装，它让数据库底层操作变的透明，`sql可自定义并可优化`。Mybatis的操作都是围绕一个sqlSessionFactory实例展开的。Mybatis通过配置文件关联到各实体类的Mapper文件，Mapper文件中配置了每个类对数据库所需进行的sql语句映射。在每次与数据库交互时，通过sqlSessionFactory拿到一个sqlSession，再执行sql命令。

# 源码 #

## CallbackMappingJackson2HttpMessageConverter ##

import java.io.IOException;
    import javax.servlet.http.HttpServletRequest;
    import org.apache.commons.io.IOUtils;
    import org.apache.commons.lang3.StringUtils;
    import org.springframework.http.HttpOutputMessage;
    import org.springframework.http.converter.HttpMessageNotWritableException;
    import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter;
    import org.springframework.web.context.request.RequestContextHolder;
    import org.springframework.web.context.request.ServletRequestAttributes;
    
    import com.fasterxml.jackson.core.JsonEncoding;
    import com.fasterxml.jackson.core.JsonProcessingException;
    /**
     * 响应跨域页面ajax数据的实体类
     * 
     * @author lsp
     */
    public class CallbackMappingJackson2HttpMessageConverter extends MappingJackson2HttpMessageConverter {
    	// 做jsonp的支持的标识，在请求参数中加该参数
    	private String callbackName;
    
    	@Override
    	protected void writeInternal(Object object, HttpOutputMessage outputMessage) throws IOException, HttpMessageNotWritableException {
    		// 从threadLocal中获取当前的Request对象
    		HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.currentRequestAttributes()).getRequest();
    		String callbackParam = request.getParameter(callbackName);
    		if(StringUtils.isEmpty(callbackParam)){
    			// 没有找到callback参数，直接返回json数据
    			super.writeInternal(object, outputMessage);
    		}else{
    			JsonEncoding encoding = getJsonEncoding(outputMessage.getHeaders().getContentType());
    			try {
    				String result =callbackParam+"("+super.getObjectMapper().writeValueAsString(object)+");";
    				IOUtils.write(result, outputMessage.getBody(),encoding.getJavaName());
    			}
    			catch (JsonProcessingException ex) {
    				throw new HttpMessageNotWritableException("Could not write JSON: " + ex.getMessage(), ex);
    			}
    		}
    		
    	}
    
    	public String getCallbackName() {
    		return callbackName;
    	}
    
    	public void setCallbackName(String callbackName) {
    		this.callbackName = callbackName;
    	}
    
    }

## UserExcelView ##

public class UserExcelView extends AbstractExcelView {
     
        /**
         * 以下完成视图的渲染
         */
        @Override
        protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook,
                HttpServletRequest request, HttpServletResponse response) throws Exception {
            
            // 从model对象中获取userList
            @SuppressWarnings("unchecked")
            List<User> userList = (List<User>) model.get("userList");
            // 创建Excel的sheet
            HSSFSheet sheet = workbook.createSheet("会员列表");
     
            // 创建标题行
            HSSFRow header = sheet.createRow(0);
            header.createCell(0).setCellValue("ID");
            header.createCell(1).setCellValue("用户名");
            header.createCell(2).setCellValue("姓名");
            header.createCell(3).setCellValue("年龄");
            header.createCell(4).setCellValue("性别");
            header.createCell(5).setCellValue("出生日期");
            header.createCell(6).setCellValue("创建时间");
            header.createCell(7).setCellValue("更新时间");
     
            // 填充数据
            int rowNum = 1;
            for (User user : userList) {
                HSSFRow row = sheet.createRow(rowNum);
                row.createCell(0).setCellValue(user.getId());
                row.createCell(1).setCellValue(user.getUserName());
                row.createCell(2).setCellValue(user.getName());
                row.createCell(3).setCellValue(user.getAge());
                String sexStr;
                if (user.getSex() == 1) {
                    sexStr = "男";
                } else if (user.getSex() == 2) {
                    sexStr = "女";
                } else {
                    sexStr = "未知";
                }
                row.createCell(4).setCellValue(sexStr);
                row.createCell(5).setCellValue(new DateTime(user.getBirthday()).toString(Constants.DATE));
                row.createCell(6).setCellValue(new DateTime(user.getCreated()).toString(Constants.DATE_TIME));
                row.createCell(7).setCellValue(new DateTime(user.getUpdated()).toString(Constants.DATE_TIME));
     
                rowNum++;
            }
            
            // 设置相应头信息，以附件形式下载并且指定文件名
            response.setHeader("Content-Disposition", "attachment;filename="
                    + new String("会员列表.xls".getBytes(), "ISO-8859-1"));
        }
     
    }

## MyIntercpetor ##

import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import org.springframework.web.servlet.HandlerInterceptor;
    import org.springframework.web.servlet.ModelAndView;
    
    public class MyIntercpetor implements HandlerInterceptor {
    //请求执行方法之前执行
        @Override
        public boolean preHandle(HttpServletRequest request,
                HttpServletResponse response, Object handler) throws Exception {
            System.out.println("MyIntercpetor.preHandle()");
            return true;
        }
    //执行方法之后执行
        @Override
        public void postHandle(HttpServletRequest request,
                HttpServletResponse response, Object handler,
                ModelAndView modelAndView) throws Exception {
            System.out.println("MyIntercpetor.postHandle()");
            
        }
        //最终执行的方法
        @Override
        public void afterCompletion(HttpServletRequest request,
                HttpServletResponse response, Object handler, Exception ex)
                throws Exception {
            System.out.println("MyIntercpetor.afterCompletion()");
            
        }
    
    }

# jdbc.properties #

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8
    jdbc.username=root
    jdbc.password=123456

# applicationContext-service.xml #

# applicationContext-dao.xml #

<?xml version="1.0" encoding="UTF-8"?>
        <beans xmlns="http://www.springframework.org/schema/beans"
        	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
        	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
        	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
        	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
         
        	
        	
        	<context:property-placeholder location="classpath:*.properties" />
        	
        	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
        		destroy-method="close">
        		<property name="url" value="${jdbc.url}" />
        		<property name="username" value="${jdbc.username}" />
        		<property name="password" value="${jdbc.password}" />
        		<property name="driverClassName" value="${jdbc.driver}" />
        		<property name="maxActive" value="10" />
        		<property name="minIdle" value="5" />
        	</bean>
        	
        	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        		
        		<property name="dataSource" ref="dataSource" />
        		
        		<property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
        	</bean>
        	
        	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        		<property name="basePackage" value="cn.lsp.ssm.mapper" />
        	</bean>
        	
        	<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="save*" propagation="REQUIRED" />
        			<tx:method name="insert*" propagation="REQUIRED" />
        			<tx:method name="add*" propagation="REQUIRED" />
        			<tx:method name="create*" propagation="REQUIRED" />
        			<tx:method name="delete*" propagation="REQUIRED" />
        			<tx:method name="update*" propagation="REQUIRED" />
        			<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
        			<tx:method name="select*" propagation="SUPPORTS" read-only="true" />
        			<tx:method name="get*" propagation="SUPPORTS" read-only="true" />
        		</tx:attributes>
        	</tx:advice>
        	
        	<aop:config>
        		<aop:advisor advice-ref="txAdvice"
        			pointcut="execution(* cn.lsp.ssm.service.*.*(..))" />
        	</aop:config>
    </beans>

# 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>
    
    	
    	<settings>
    		
    		<setting name="mapUnderscoreToCamelCase" value="true" />
    		
    		<setting name="cacheEnabled" value="false"/>
      		
    		<setting name="lazyLoadingEnabled" value="true"/>
    		<setting name="aggressiveLazyLoading" value="false"/>
    	</settings>
    
    	
    	<plugins> 
    	    
    	    <plugin interceptor="com.github.pagehelper.PageHelper">4
    	    		
    	        	<property name="dialect" value="mysql"/>
    	        	
    	        	<property name="rowBoundsWithCount" value="true"/>
    	    </plugin>
    		
    		<plugin interceptor="com.github.abel533.mapperhelper.MapperInterceptor">
           		 
            		<property name="IDENTITY" value="MYSQL"/>
           		 
             	 <property name="mappers" value="com.github.abel533.mapper.Mapper"/>
            </plugin>
    	</plugins>
    
    </configuration>

# springmvc-servlet.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:p="http://www.springframework.org/schema/p"
    	xmlns:context="http://www.springframework.org/schema/context"
    	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/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
    
    
    	
    	
    	<mvc:annotation-driven>
    		
    		<mvc:message-converters>
    			
    			<bean class="org.springframework.http.converter.StringHttpMessageConverter">
    				<constructor-arg index="0" value="UTF-8"/>
    			</bean>
    			
    			<bean class="org.pingruan.common.jsonp.converter.json.CallbackMappingJackson2HttpMessageConverter">
    				
    				<property name="callbackName" value="callback"></property>
    			</bean>
    		</mvc:message-converters>
    	</mvc:annotation-driven>
    	
    	
    	
    	
    	
    	
    	
    	<context:component-scan base-package="cn.lsp.ssm.controller"/>
    	
    	
    		
    	
    	
    	<bean
    		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		
    		<property name="prefix" value="/WEB-INF/views/"></property>
    		
    		<property name="suffix" value=".jsp"></property>
    	</bean>
    
    	
    	
    
    	
    	<bean class="org.springframework.web.servlet.view.BeanNameViewResolver">
    		<property name="order" value="1"></property>
    	</bean>
    
    	
    	<mvc:interceptors>
    		<mvc:interceptor>
    			<mvc:mapping path="/**"/>
    			<bean class="cn.lsp.springmvc.interceptor.MyInterceptor"/>
    		</mvc:interceptor>
    	</mvc:interceptors>
    
    	
    	<bean id="multipartResolver"
    		class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    		
    		<property name="defaultEncoding" value="UTF-8"></property>
    		
    		<property name="maxUploadSize" value="5242880"></property>
    	</bean>
    	
    	
    	<mvc:default-servlet-handler/>
    
     
     <mvc:resources location="/WEB-INF/css/" mapping="/css/**"/>
     <mvc:resources location="/WEB-INF/js/" mapping="/js/**"/>
    
    </beans>

# web.xml #

<?xml version="1.0" encoding="UTF-8"?>
    <web-app version="2.5" 
        xmlns="http://java.sun.com/xml/ns/javaee" 
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
        xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
        http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
    
        <display-name>ssm-demo</display-name>
    
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring/applicationContext*.xml</param-value>
        </context-param>
    
    
        
        <filter>
            
            <filter-name>shiroSecurityFilter</filter-name>
                
            <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
            <init-param>
                <param-name>targetFilterLifecycle</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>shiroSecurityFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
         
       <servlet>
            <servlet-name>cxf</servlet-name>
            <servlet-class>org.apache.cxf.transport.servlet.CXFServlet</servlet-class>
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>cxf</servlet-name>
            <url-pattern>/ws/*</url-pattern>
        </servlet-mapping>
        
        
        <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-config.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>
    
        
        <filter>
            <filter-name>encodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF8</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
        
        <filter>
            <filter-name>HiddenHttpMethodFilter</filter-name>
            <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
        </filter>
        <filter-mapping>
            <filter-name>HiddenHttpMethodFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
    
        
        <filter>
            <filter-name>HttpMethodFilter</filter-name>
            <filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>
        </filter>
        <filter-mapping>
            <filter-name>HttpMethodFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
      
      <error-page>
          
          <exception-type>org.apache.shiro.authz.UnauthorizedException</exception-type>
          
          <location>/500.jsp</location>
      </error-page>
    
        
        <welcome-file-list>
            <welcome-file>index.jsp</welcome-file>
        </welcome-file-list>
    
    </web-app>

# 依赖pom.xml #

<modelVersion>4.0.0</modelVersion>
    <groupId>com.vander.campus</groupId>
    <artifactId>campus-test</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>
    
    <properties>
    	<junit.version>4.12</junit.version>
    	<spring.version>4.2.5.RELEASE</spring.version>
    	<mybatis.version>3.2.8</mybatis.version>
    	<mybatis.spring.version>1.2.2</mybatis.spring.version>
    	<mybatis.paginator.version>1.2.15</mybatis.paginator.version>
    	<postgresql.version>9.3-1102-jdbc4</postgresql.version>
    	<slf4j.version>1.6.4</slf4j.version>
    	<jackson.version>2.4.2</jackson.version>
    	<druid.version>1.0.9</druid.version>
    	<servlet-api.version>2.5</servlet-api.version>
    	<joda-time.version>2.5</joda-time.version>
    	<cglib.version>3.1</cglib.version>
    	<c3p0.version>0.9.1.2</c3p0.version>
    	<oracle.version>10.2.0.4.0</oracle.version>
    	<commons-lang3.version>3.3.2</commons-lang3.version>
    	<commons-io.version>1.3.2</commons-io.version>
    	<commons-net.version>3.3</commons-net.version>
    	<commons-codec.version>1.9</commons-codec.version>
    	<hibernate-validator.version>5.1.3.Final</hibernate-validator.version>
    	<pagehelper.version>3.4.2-fix</pagehelper.version>
    	<jsqlparser.version>0.9.1</jsqlparser.version>
    	<mapper.version>2.3.4</mapper.version>
    	<commons-fileupload.version>1.3.1</commons-fileupload.version>
    	<jedis.version>2.7.2</jedis.version>
    	<mail.version>1.4.7</mail.version>
    	<poi.version>3.9</poi.version>
    </properties>
    <dependencies>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-context</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-beans</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-webmvc</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-jdbc</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-aspects</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-test</artifactId>
    		<version>${spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>joda-time</groupId>
    		<artifactId>joda-time</artifactId>
    		<version>${joda-time.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.apache.commons</groupId>
    		<artifactId>commons-lang3</artifactId>
    		<version>${commons-lang3.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>cglib</groupId>
    		<artifactId>cglib</artifactId>
    		<version>${cglib.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.apache.commons</groupId>
    		<artifactId>commons-io</artifactId>
    		<version>${commons-io.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>commons-net</groupId>
    		<artifactId>commons-net</artifactId>
    		<version>${commons-net.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>commons-codec</groupId>
    		<artifactId>commons-codec</artifactId>
    		<version>${commons-codec.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.hibernate</groupId>
    		<artifactId>hibernate-validator</artifactId>
    		<version>${hibernate-validator.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>com.fasterxml.jackson.core</groupId>
    		<artifactId>jackson-databind</artifactId>
    		<version>${jackson.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>junit</groupId>
    		<artifactId>junit</artifactId>
    		<version>${junit.version}</version>
    		<scope>test</scope>
    	</dependency>
    	<dependency>
    		<groupId>org.slf4j</groupId>
    		<artifactId>slf4j-log4j12</artifactId>
    		<version>${slf4j.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.mybatis</groupId>
    		<artifactId>mybatis</artifactId>
    		<version>${mybatis.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.mybatis</groupId>
    		<artifactId>mybatis-spring</artifactId>
    		<version>${mybatis.spring.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>com.github.miemiedev</groupId>
    		<artifactId>mybatis-paginator</artifactId>
    		<version>${mybatis.paginator.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>com.github.pagehelper</groupId>
    		<artifactId>pagehelper</artifactId>
    		<version>${pagehelper.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>com.github.jsqlparser</groupId>
    		<artifactId>jsqlparser</artifactId>
    		<version>${jsqlparser.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>com.github.abel533</groupId>
    		<artifactId>mapper</artifactId>
    		<version>${mapper.version}</version>
    	</dependency>
    	
    	<dependency>
    		<groupId>c3p0</groupId>
    		<artifactId>c3p0</artifactId>
    		<version>${c3p0.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.postgresql</groupId>
    		<artifactId>postgresql</artifactId>
    		<version>${postgresql.version}</version>
    		<scope>runtime</scope>
    	</dependency>
    	<dependency>
    		<groupId>com.alibaba</groupId>
    		<artifactId>druid</artifactId>
    		<version>${druid.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>javax.servlet</groupId>
    		<artifactId>servlet-api</artifactId>
    		<version>${servlet-api.version}</version>
    		<scope>provided</scope>
    	</dependency>
    	
    		<dependency>
    		<groupId>com.oracle</groupId>
    		<artifactId>ojdbc14</artifactId>
    		<version>${oracle.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>commons-fileupload</groupId>
    		<artifactId>commons-fileupload</artifactId>
    		<version>${commons-fileupload.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>redis.clients</groupId>
    		<artifactId>jedis</artifactId>
    		<version>${jedis.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>javax.mail</groupId>
    		<artifactId>mail</artifactId>
    		<version>${mail.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.apache.poi</groupId>
    		<artifactId>poi</artifactId>
    		<version>${poi.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.apache.poi</groupId>
    		<artifactId>poi-ooxml</artifactId>
    		<version>${poi.version}</version>
    	</dependency>
    	<dependency>
    		<groupId>org.apache.httpcomponents</groupId>
    		<artifactId>httpclient</artifactId>
    		<version>4.3.5</version>
    	</dependency>
    	<dependency>
    		<groupId>net.sf.json-lib</groupId>
    		<artifactId>json-lib</artifactId>
    		<version>2.4</version>
    		<classifier>jdk15</classifier>
    	</dependency>
    	<dependency>
    		<groupId>commons-beanutils</groupId>
    		<artifactId>commons-beanutils</artifactId>
    		<version>1.9.3</version>
    	</dependency>
    	<dependency>
    		<groupId>com.google.code.gson</groupId>
    		<artifactId>gson</artifactId>
    		<version>2.6.2</version>
    	</dependency>
    </dependencies>
    <build>
    	<finalName>${project.artifactId}</finalName>
    	<plugins>
    		
    		<plugin>
    			<groupId>org.apache.maven.plugins</groupId>
    			<artifactId>maven-resources-plugin</artifactId>
    			<version>2.7</version>
    			<configuration>
    				<encoding>UTF-8</encoding>
    			</configuration>
    		</plugin>
    		
    		<plugin>
    			<groupId>org.apache.tomcat.maven</groupId>
    			<artifactId>tomcat7-maven-plugin</artifactId>
    			<version>2.2</version>
    		</plugin>
    		
    		<plugin>
    			<groupId>org.apache.maven.plugins</groupId>
    			<artifactId>maven-compiler-plugin</artifactId>
    			<version>3.2</version>
    			<configuration>
    				<source>1.7</source>
    				<target>1.7</target>
    				<encoding>UTF-8</encoding>
    			</configuration>
    		</plugin>
    		<plugin>
    			<artifactId>maven-war-plugin</artifactId>
    			<configuration>
    				<version>3.1</version>
    			</configuration>
    		</plugin>
    	</plugins>
    </build>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE1NzY0OTQz_size_16_color_FFFFFF_t_70]: /images/20211006/4014f2047adf47d8966e1739c4f61c8c.png