Spring+Mybatis+SpringMVC框架集成

最新推荐文章于 2024-07-06 20:30:42 发布
最新推荐文章于 2024-07-06 20:30:42 发布
阅读量132 收藏
点赞数 2
文章标签： 导依赖

SSM框架集成

本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合本章目标
搭建Spring + SpringMVC + MyBatis集成环境。
搭建步骤
手动导入jar包

spring+springmvc的jar包
mybatisjar包
mybatis-spring-1.3.1.jar
c3p0的jar包
log4j的jar包
jstl的jar包
jacksonjar包
数据库的jar的包
Common-fileupload
Maven依赖


4.0.0
com.znsd.ssm
ssm-web
war
0.0.1-SNAPSHOT
ssm-web Maven Webapp
http://maven.apache.org

<distributionManagement>
    <snapshotRepository>
        <id>nexus-snapshots</id>
        <name>Snapshots</name>
        <url>http://nexus.znsd.com/content/repositories/snapshots/</url>
    </snapshotRepository>
    <repository>
        <id>nexus-releases</id>
        <name>Releases</name>
        <url>http://nexus.znsd.com/content/repositories/releases/</url>
    </repository>
</distributionManagement>

<!-- 依赖属性定义 -->
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <spring.version>4.2.3.RELEASE</spring.version>
    <javassist.version>3.11.0.GA</javassist.version>
    <aspectj.version>1.5.3</aspectj.version>
    <asm.version>3.2</asm.version>
    <cglib.version>2.2.2</cglib.version>
    <jackson.version>1.9.13</jackson.version>
    <mybatis.version>3.2.8</mybatis.version>
    <mybatis-spring.version>1.2.2</mybatis-spring.version>
    <mysql-jdbc.version>5.0.8</mysql-jdbc.version>
    <hessian.version>4.0.38</hessian.version>
    <druid.version>1.1.10</druid.version>
    <slf4j.version>1.6.1</slf4j.version>
    <logback.version>1.1.2</logback.version>
    <commons-codec.version>1.3</commons-codec.version>
</properties>

<dependencies>
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>${commons-codec.version}</version>
    </dependency>

    <!-- spring begin -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</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-aspects</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</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-jms</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- javassist -->
    <dependency>
        <groupId>javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>${javassist.version}</version>
    </dependency>

    <!-- aspectj -->
    <dependency>
        <groupId>aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>${aspectj.version}</version>
    </dependency>

    <!-- asm -->
    <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>${asm.version}</version>
    </dependency>
    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>${cglib.version}</version>
    </dependency>

    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-core</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-annotations</artifactId>
        <version>2.9.0</version>
    </dependency>
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.9.0</version>
    </dependency>

    <!-- mybatis -->
    <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>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-jdbc.version}</version>
    </dependency>

    <!-- spring mvc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <!-- jsp servlet -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>jsp-api</artifactId>
        <version>2.1</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>jsptags</groupId>
        <artifactId>pager-taglib</artifactId>
        <version>2.0</version>
    </dependency>
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>

    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>

    <!-- alibaba 数据源 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>${druid.version}</version>
    </dependency>

    <!-- log -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>${logback.version}</version>
    </dependency>
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.3</version>
    </dependency>
</dependencies>

<build>
    <finalName>ssm-web</finalName>

    <plugins>
        <!-- 编译插件，默认使用jdk1.8 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>2.3.2</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
        <!-- 使用utf-8编码处理资源文件 -->
        <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-resources-plugin</artifactId>
            <version>2.4.3</version>
            <configuration>
                <encoding>UTF-8</encoding>
            </configuration>
        </plugin>
    </plugins>
</build>
添加log4j配置文件 由于MyBatis依赖与log4j输出sql语句信息，所以需要配置log4j配置文件。

#设置输出级别和输出位置
log4j.rootLogger=debug,Console
#设置控制台相关的参数
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置MyBatis的输出内容
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
配置web.xml
添加SpringMVC核心控制器DispatcheerServlet配置信息

dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / 添加编码过滤器 添加乱码过滤器，避免提交时出现乱码。 字符集过滤器 encodingFilter org.springframework.web.filter.CharacterEncodingFilter 字符集编码 encoding UTF-8 encodingFilter /* 添加druid监控数据源的监控 DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/* 添加put和delete请求 支持put和delete请求 HiddenHttpMethodFilter org.springframework.web.filter.HiddenHttpMethodFilter HiddenHttpMethodFilter /* 配置springmvc.xml 添加springmvc的配置文件，设置自动扫描包路径，静态资源处理，视图解析器等。 <?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package=“com.znsd.ssm” />

<mvc:default-servlet-handler />

<mvc:annotation-driven />
配置文件上传
配置文件上传组件。

配置druid连接池信息 配置c3p0连接池信息

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




























jdbc.properties文件

##jdbc\u914D\u7F6E##
jdbc.driver=com.mysql.jdbc.Driver
jdbc.dbname=test
jdbc.port=3306
jdbc.host=192.168.41.10
jdbc.user=znsd_test
jdbc.password=123456
jdbc.pool.minPoolSize=5
jdbc.pool.maxPoolSize=30
jdbc.pool.initialPoolSize=5
jdbc.pool.maxIdleTime=60
jdbc.pool.timeBetweenEvictionRunsMillis=60000
jdbc.pool.minEvictableIdleTimeMillis=300000
配置sqlSessionFactory
MyBatis中使用sqlSessionFactory来生产session对象，和Hibernate中相似，也可以交由spring来管理。

设置扫描的映射文件和dao包

classpath*:/mybatis-mapping/*.xml Mybatis映射文件 在SSM中，可以省略mybatis配置文件，也可以添加，只不过需要在sqlSessionFactory中配置configLocation属性即可。 <?xml version="1.0" encoding="UTF-8" ?> 配置事务 在Spring里面，可以通过AOP来管理事务，非常强大。

<tx:advice id=“txAdvice” transaction-manager=“txManager”>
tx:attributes
<tx:method name=“find*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“search*” propagation=“REQUIRED” read-only=“true” />
<tx:method name=“query*” propagation=“REQUIRED” read-only=“true” />

    <tx:method name="add*" propagation="REQUIRED" />
    <tx:method name="submit*" propagation="REQUIRED" />
    <tx:method name="save*" propagation="REQUIRED" />
    <tx:method name="insert*" propagation="REQUIRED" />

    <tx:method name="del*" propagation="REQUIRED" />
    <tx:method name="remove*" propagation="REQUIRED" />

    <tx:method name="update*" propagation="REQUIRED" />
    <tx:method name="modify*" propagation="REQUIRED" />

    <tx:method name="*" propagation="REQUIRED" read-only="true" />
</tx:attributes>

</tx:advice>
实现查询学生列表信息
使用SSM来查询学生列表信息
获取学生列表的json格式数据
image

添加实体类
学生实体类

public class Student implements Serializable {

private Integer id;
private String name;
private String password;
private String gender;
private String address;
private Clazz clazz;

// 省略getter和setter方法

}
映射文件
StudentDao接口

@Repository
public interface StudentDao {
public List selectList();
}
映射文件StudentMapper.xml

<?xml version="1.0" encoding="UTF-8"?> 
<resultMap id="BaseResultMap" type="com.znsd.ssm.bean.Student">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="c_id" property="clazz.classId" jdbcType="INTEGER" />
</resultMap>

<select id="selectList" resultMap="BaseResultMap">
    select * from t_student
</select>
Service层 StudentService代码

public interface StudentService {
public List selectList();
}
StudentService实现类

@Service
public class StudentServiceImpl implements StudentService {

@Resource
private StudentDao studentDao;

@Override
public List<Student> selectList() {
    return this.studentDao.selectList();
}

}
Controller层
由控制器层将数据返回对应的视图，输出json格式的数据。

@Controller
@RequestMapping(“student”)
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping("/list")
public String getStudentList(Map<String, Object> map) {
    List<Student> studentList = service.selectList();
    map.put("studentList", studentList);
    return "studentList";
}

@ResponseBody
@RequestMapping("/json")
public List<Student> getlistJson() {
    List<Student> list = service.selectList();
    return list;
}

}
View视图层
显示学生列表

idnamepasssex
${stu.id}${stu.name}${stu.password}${stu.gender}
练习：实现学生信息列表 实现学生信息查询，并返回json格式

imageimage

总结
SSM整合

AE-86 G7
关注
WPF入门教程系列四——Dispatcher介绍
weixin_34019929的博客
05-06 2043
一、Dispatcher介绍      微软在WPF引入了Dispatcher，那么这个Dispatcher的主要作用是什么呢？      不管是WinForm应用程序还是WPF应用程序，实际上都是一个进程，一个进程可以包含多个线程，其中有一个是主线程，其余的是子线程。在WPF或WinForm应用程序中，主线程负责接收输入、处理事件、绘制屏幕等工作，为了使主线程及时响应，防止假死，在开发过程中...
SSM框架——详细整合教程（Spring+SpringMVC+MyBatis）
热门推荐
在路上
07-19 63万+
使用SSM（Spring、SpringMVC和Mybatis）已经有三个多月了，项目在技术上已经没有什么难点了，基于现有的技术就可以实现想要的功能，当然肯定有很多可以改进的地方。之前没有记录SSM整合的过程，这次刚刚好基于自己的一个小项目重新搭建了一次，而且比项目搭建的要更好一些。以前解决问题的过程和方法并没有及时记录，以后在自己的小项目中遇到我再整理分享一下。这次，先说说三大框架整合过程。个人认
Spring3.2.6
weixin_34162629的博客
06-10 123
2019独角兽企业重金招聘Python工程师标准>>> ...
尚硅谷maven2022----③生产实践
weixin_44235759的博客
05-01 1305
文章目录一、搭建 Maven 私服：Nexus1、Nexus 安装2、初始设置3、对接 Nexus`①通过 Nexus 下载 jar 包``②将 jar 包部署到 Nexus``③引用别人部署的 jar 包`4、修改仓库配置 一、搭建 Maven 私服：Nexus 1、Nexus 安装 ①下载地址 小诀窍：使用迅雷下载比直接用浏览器下载快很多 https://download.sonatype.com/nexus/3/latest-unix.tar.gz ②上传、解压 上传到 Linux 系统，解压后即可使
spring-boot整合mybatis(1)
weixin_33943347的博客
07-20 67
sprig-boot是一个微服务架构，加快了spring工程快速开发，以及简便了配置。接下来开始spring-boot与mybatis的整合。 1、创建一个maven工程命名为spring-boot-entity，pom.xml文件配置如下： <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www....
手把手教你整合最优雅SSM框架：SpringMVC + Spring + MyBatis
小疯的代码健身房
05-08 61万+
小疯手把手带你整合SpringMVC+Spring+MyBatis三大框架，俗称SSM，用它完全代替传统的SSH框架，把它们最优雅的一面发挥出来。整合配置结束后，会有一个应用实例“图书管理系统”带给大家，希望能快速上手这个框架！
Spring+SpringMVC+MyBatis框架整合的配置
fzt12138的博客
07-06 991
不扯那些有的没的，夸赞的话我们上官网去看，这里只总结一些关于Spring框架的东西。通俗点来说，所谓的轻量级，就是没有那么繁琐了，至于JavaEE，它只是j2EE的另一个名称，指代的是企业版。剩下的还有j2SE和J2ME，分别是标准版和用于移动设备、嵌入式设备上的Java应用程序。以上是Spring框架的一些特性，重在理解。控制反转，就是把创建对象的过程交给Spring进行管理，在应用开发场景中，我们会使用到Spring的注解，类似与@Bean、@controller、@Service、@Component
【SSM进阶学习系列丨整合篇】Spring+SpringMVC+MyBatis 框架配置详解
陈橘又青的博客
04-26 1万+
MyBatis框架和Spring框架整合需要一个mybatis-spring的jar包，该jar包的作用是两个框架的转换包。
Spring+SpringMVC+MyBatis集成一文完成
gjb760662328的博客
03-06 427
SSM完整搭建流程
SpringMVC+Spring+Mybatis集成开发环境
04-28
在IT行业中，SpringMVC、Spring和Mybatis是三大核心框架，它们的集成使用是Java Web开发中的常见实践。这个集成开发环境旨在提供一个高效、灵活的开发平台，以实现业务逻辑与数据访问的分离，提高代码的可维护性和可...
spring+spring mvc+mybatis框架整合实现超市货物管理系统
01-08
在本文中，我们将深入探讨如何使用JavaEE技术栈，特别是Spring、Spring MVC和MyBatis框架，来构建一个超市货物管理系统的实现。这个系统涵盖了基本的登录功能以及与MySQL数据库的交互，包括增删改查操作和分页显示。...
Spring+SpringMVC+MyBatis整合工程实例 完整版源码（带注释）
07-19
SSM框架整合是指Spring、SpringMVC和MyBatis三个开源框架的集成，常用于构建企业级的Java Web应用程序。这三个框架各有其优势，Spring负责控制层，SpringMVC处理视图和业务逻辑，而MyBatis则专注于数据库操作。 **1...
spring+mybatis+springmvc 全注解框架
04-29
【标题】"spring+mybatis+springmvc 全注解框架"揭示了这是一个基于Java的Web开发框架，其中集成了Spring、MyBatis和SpringMVC这三个关键组件。Spring是全面的企业级应用框架，提供了依赖注入（DI）和面向切面编程...
Spring+SpringMVC+Mybatis框架整合例子——亲测可用.zip
02-17
SSM框架整合是Java开发中常见的技术栈，包括Spring、SpringMVC和Mybatis三个核心组件。这个压缩包提供了一个已经验证过的整合示例，帮助开发者理解和实践这三大框架的协同工作。 首先，Spring框架是Java企业级应用...
java WEB 框架开发之SSM（springmvc、spring、mybatis）
weixin_30555125的博客
09-22 231
　　在使用SSM开发项目之前，需要单独学习springmvc、spring、mybatis。 　　　　springmvc:当一个请求到来，springmvc执行流程： 　　　　　　　　1.前端控制器DispatcherServlet：拦截请求 　　　　　　　　2.处理器映射器（HandlerMapping）：找到对应的Handler 　　　　　　　　3.处理器适配器（HandlerAdap...
【气动学】基于matlab三种导引律下的弹道仿真【含Matlab源码 8026期】.mp4
最新发布
09-26
Matlab领域上传的视频均有对应的完整代码，皆可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描视频QQ名片； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作
性能测试面试题宝典-覆盖大部分性能专项面试题
09-26
性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性能专项面试题性能测试面试题宝典--覆盖大部分性
整合SpringMVC+Spring+Mybatis框架技术详解
"SpringMVC+Spring+Mybatis框架技术分享" 在现代Java Web开发中，SpringMVC、Spring和Mybatis是三个非常重要的组件，它们共同构建了一个强大的应用程序框架。这个框架技术分享主要关注这三个技术的集成和使用。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值