ssm框架excel mysql_SSM框架搭建总结（重点）

1、添加jar包

junit

junit

4.11

test

javax.servlet

javax.servlet-api

3.1.0

provided

mysql

mysql-connector-java

5.1.38

org.mybatis

mybatis

3.2.8

org.springframework

spring-core

5.0.8.RELEASE

org.springframework

spring-web

5.0.8.RELEASE

org.springframework

spring-oxm

5.0.8.RELEASE

org.springframework

spring-tx

5.0.8.RELEASE

org.springframework

spring-jdbc

5.0.8.RELEASE

org.springframework

spring-webmvc

5.0.8.RELEASE

org.springframework

spring-aop

5.0.8.RELEASE

org.springframework

spring-context-support

5.0.8.RELEASE

org.springframework

spring-test

5.0.8.RELEASE

org.mybatis

mybatis-spring

1.2.2

jstl

jstl

1.2

com.alibaba

druid

1.0.9

com.github.pagehelper

pagehelper

4.1.6

com.fasterxml.jackson.core

jackson-databind

2.9.5

org.apache.poi

poi

3.6

javax

javaee-api

7.0

provided

commons-fileupload

commons-fileupload

1.3.1

commons-io

commons-io

2.4

org.activiti

activiti-spring

5.18.0

org.activiti

activiti-engine

5.18.0

slf4j-api

org.slf4j

spring-beans

org.springframework

jackson-core-asl

org.codehaus.jackson

commons-lang3

org.apache.commons

2、配置web.xml文件

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" version="2.5">

Archetype Created Web Application

springMvc

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

classpath:applicationContext.xml

springMvc

/

aa

org.springframework.web.filter.CharacterEncodingFilter

encoding

utf-8

aa

/*

3、配置mybatis-config文件

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

4、配置applicationContext.xml文件(Spring 配置文件)

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"

xmlns:tx="http://www.springframework.org/schema/tx"

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

http://www.springframework.org/schema/mvc/spring-mvc.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd">

5、系统的整体架构图：

整体架构