1、ssm系统架构
整合步骤
第一步:
MyBatis和Spring整合,通过Spring管理mapper接口。
使用mapper的扫描器自动扫描mapper接口在Spring中进行注册。
第二步:
通过Spring管理Service接口。
使用配置方式将Service接口配置在Spring配置文件中。
实现事务控制。
第三步:
由于SpringMVC是Spring的模块,无需整合这两个。
项目架构:
下面讲解部分包/文件作用
mapper:存放mybatis的mapper文件夹
log4j.properties:log4j日志属性文件
mybatis-conf.xml:mybatis全局配置文件
spring-bean.xml:spring与mybatis整合配置文件
spring-mvc.xml:spring mvc配置文件
2、项目整合
2.1、新建maven项目 添加依赖
maven是一个优秀的项目对象管理器工具 我可以通过在pom.xml中添加需要的jar包的依赖就可以导入对应的jar包了,非常的方便。
下面就列出整合ssm所对应的依赖
<!-- 添加sevlet支持 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
<!-- 添加jsp支持 -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>javax.servlet.jsp-api</artifactId>
<version>2.3.1</version>
</dependency>
<!-- 添加jstl支持 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- 添加spring支持 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!--spring test支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!--spring mvc支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!--spring 事务管理支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!--spring jdbc操作支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!--spring aop编程支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.0.RELEASE</version>
</dependency>
<!-- 添加mybatis支持 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!-- jdbc驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!-- 添加阿里巴巴连接池Druid支持 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.16</version>
</dependency>
<!-- 添加log4j日志 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.21</version>
</dependency>
<!-- apache共公包 -->
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>
<!-- 添加junit支持 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
2.2spring与mybatis整合
2.2.1 新建mybatis-conf.xml文件
这个文件主要配置mybatis全局配置文件
例如 别名 驼峰命名自动转换等 在这里我暂时只配置别名
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 别名 -->
<typeAliases>
<package name="ssm.blog.entity"/>
</typeAliases>
</configuration>
2.2.2新建spring-beans.xml文件
整合主要步骤
- 开启包扫描
- 配置druid数据源
- 列表内容
- 配置sqlSessionFactory
-
开启mybatis dao接口扫描
具体配置注解讲的很清楚
-
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 开启包扫描--> <context:component-scan base-package="ssm.blog"/> <!-- 配置druid数据源 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"> <property name="username" value="root"/> <property name="password" value="root"/> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/db_blog"/> </bean> <!-- 配置mybatis的sqlSessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <!-- 自动扫描mapper.xml文件--> <property name="mapperLocations" value="classpath:mapper/*.xml"/> <!-- 载入mybatis全局配置文件--> <property name="configLocation" value="classpath:mybatis-conf.xml"/> </bean> <!-- 配置mybatis dao接口扫描--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="ssm.blog.dao"/> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> </bean> <!-- 配置spring的声明式事务,名字为默认值 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 开启事务控制的注解支持 --> <tx:annotation-driven transaction-manager="transactionManager"/> </beans>现在mybatis与spring整合已经算完成了 接下来我们测试一下
-
2.2.3测试spring与mybatis整合
1、表格结构 (实体类) ActivityRecord

2、dao接口以及mapper文件 -
public interface ActivityRecordMapper { Map<String,Object> isCanJoinActivity(Map<String, Integer> map); List<ActivityRecord> selectActivityRecordInfo(ActivityRecord record); }mapper
-
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.magiclear.activity.dao.ActivityRecordMapper" > <!-- 返回结果映射 如果开启驼峰命名转换且命名规范该段代码可以不写 因为配置别名 所以type属性使用的是mybatis-conf中的别名 --> <resultMap id="BaseResultMap" type="com.magiclear.activity.bean.ActivityRecord" > <id column="ARD_ATE_ID" property="ardAteId" jdbcType="INTEGER" /> <result column="ARD_MIN_ID" property="ardMinId" jdbcType="VARCHAR" /> <result column="ARD_MAD_ID" property="ardMadId" jdbcType="VARCHAR" /> <result column="ARD_PIT_ID" property="ardPitId" jdbcType="VARCHAR" /> <result column="ARD_PRODUCT_NAME" property="ardProductName" jdbcType="VARCHAR"/> <result column="ARD_STATUS" property="ardStatus" jdbcType="VARCHAR"/> <result column="ARD_CREATE_DATE" property="ardCreateDate" jdbcType="TIMESTAMP" /> <result column="ARD_UPDATE_DATE" property="ardUpdateDate" jdbcType="TIMESTAMP" /> <result column="ARD_ATE_NAME" property="ardAteName" jdbcType="VARCHAR"/> <result column="ARD_ADDRESS" property="ardAddress" jdbcType="VARCHAR"/> </resultMap> <!-- 定义字段集合 --> <sql id="Base_Column_List" > ARD_ID,ARD_ATE_NAME, ARD_MIN_ID,ARD_ATE_ID,ARD_MAD_ID, ARD_PIT_ID,ARD_PRODUCT_NAME,ARD_STATUS,ARD_CREATE_DATE,ARD_UPDATE_DATE </sql <!-- 接口中getBloggerData 具体实现--> <select id="selectActivityRecordInfo" parameterType="com.magiclear.activity.bean.ActivityRecord" resultMap="BaseResultMap"> SELECT <include refid="Base_Column_List" />FROM ACTIVITY_RECORD WHERE 1=1 <if test="ardId!=null and ardId!=0"> AND ARD_ID = #{ardId,jdbcType=INTEGER} </if> <if test="ardMinId!=null and ardMinId!=0"> AND ARD_MIN_ID = #{ardMinId,jdbcType=INTEGER} </if> </select> //存储过程调用 <select id="isCanJoinActivity" parameterMap="queryActivvityParam" statementType="CALLABLE" resultType="java.util.Map"> {CALL PRO_ACTIVITY(?,?)} </select> <parameterMap id="queryActivvityParam" type="java.util.Map" > <parameter property="minId" mode="IN" jdbcType="INTEGER"></parameter> <parameter property="activityType" mode="IN" jdbcType="INTEGER"></parameter> </parameterMap> //插入 <insert id="insert" parameterType="com.magiclear.activity.bean.ActivityRecord" > INSERT INTO [dbo].[ACTIVITY_RECORD] ([ARD_ATE_ID] ,[ARD_MIN_ID] ,[ARD_MAD_ID] ,[ARD_PIT_ID] ,[ARD_PRODUCT_NAME] ,[ARD_STATUS] ,[ARD_CREATE_DATE] ,[ARD_UPDATE_DATE]) VALUES (#{ardAteId,jdbcType=INTEGER} ,#{ardMinId,jdbcType=INTEGER} ,#{ardMadId,jdbcType=INTEGER} ,#{ardPitId,jdbcType=INTEGER} ,#{ardProductName,jdbcType=VARCHAR} ,#{ardStatus,jdbcType=INTEGER} ,getdate() ,getdate()) </insert> </mapper>3、log4j.properties 文件
创建log4j.properties 打印日志 查看执行sql语句 -
log4j.rootLogger=DEBUG, Console #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 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=DEBUG4、创建测试类并测试
BloggerDaoTestimport org.junit.Test; import org.junit.runner.RunWith; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import ssm.blog.entity.Blogger; import javax.annotation.Resource; import static org.junit.Assert.*; @RunWith(SpringJUnit4ClassRunner.class) //使用spring测试 @ContextConfiguration(locations = "classpath:spring-beans.xml") //设置spring配置文件路径 public class BloggerDaoTest { @Resource //注入BloggerDao对象 private ActivityRecordDao dao; @Test public void getBloggerData() throws Exception { ActivityRecord activityRecord= dao.getActivityRecordData(); System.out.println(activityRecord); } }若成功打印结果,说明spring与mybatis整合成功
-
2.3spring与springmvc整合
2.3.1创建spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"> <!-- 扫描所有controller包下面的所有controller --> <context:component-scan base-package="ssm.controller"/> <!-- 开启注解配置--> <mvc:annotation-driven/> <!-- 静态资源解析,包括js,css,img... --> <mvc:resources location="/static/" mapping="/static/**"/> <!-- 配置视图解析器--> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!--视图前缀--> <property name="prefix" value="/"/> <!--视图后缀--> <property name="suffix" value=".jsp"/> </bean> </beans>2.3.2 配置web.xml文件
-
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> <!--spring配置文件路径--> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring-beans.xml</param-value> </context-param> <!-- 配置spring监听器--> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!--spring mvc核心servlet--> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 初始化参数配置 springnvc配置文件路径--> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring-mvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> <async-supported>true</async-supported> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>*.html</url-pattern> </servlet-mapping> <!-- 编码过滤器 --> <filter> <filter-name>encodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <async-supported>true</async-supported> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> </web-app>
本文介绍了SSM系统架构的整合步骤,包括MyBatis和Spring整合、Spring管理Service接口及实现事务控制等。还详细说明了项目整合过程,如新建Maven项目添加依赖,Spring与MyBatis、SpringMVC的整合步骤,最后通过测试验证Spring与MyBatis整合是否成功。
1152

被折叠的 条评论
为什么被折叠?



