SSM三大框架整合

男娘i 2022-05-17 03:51 256阅读 0赞

# Spring 整合SpringMVC + MyBatis #

## 第一部分： 基本工程结构搭建（eclipse 创建一个 Dynamic Web project） ##

1.  ** 导入jar包**

![70][]

**2、添加source folder ，命名为 resources**

最后工程结构如下：

![70 1][]

## 第二部分：整合步骤 ##

**Dao层：**

1.  SqlMapConfig.xml（这个是Mybatis的配置文件），空文件即可。需要文件头。
2.  applicationContext-dao.xml。
    
    1.  数据库连接池
    2.  SqlSessionFactory对象，需要spring和mybatis整合包下的。
    3.  配置mapper文件扫描器。

**SqlMapConfig.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
    </configuration>

**applicationContext-dao.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
    	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
    	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    
       
       <context:property-placeholder location="classpath:jdbc.properties" />
    
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		
    		<property name="maxActive" value="10" />
    		
    		<property name="maxIdle" value="5" />
    	</bean>
    	
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="configLocation" value="classpath:SqlMapConfig.xml" />
    		
    		<property name="typeAliasesPackage" value="com.jk.pojo" />
    	</bean>
    	
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        	
        	<property name="basePackage" value="com.jk.mapper" />
        </bean>
    </beans>

**jdbc.propeties**

# 数据库连接驱动
    jdbc.driver=com.mysql.jdbc.Driver
    # 数据库的url 
    jdbc.url=jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8
    # 数据库安装时 用户名
    jdbc.username=root
    # 数据库安装时 密码(若没有密码 就不写)
    #jdbc.password=
    jdbc.password=root

**Service层：**

1.  applicationContext-service.xml包扫描器，扫描@service注解的类。
2.  applicationContext-transaction.xml配置事务。

**applicationContext-service.xml**

**applicationContext-transaction.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
    	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
    	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    
    	
    	<bean id="transactionManager"
    		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    
    	
    	<tx:advice id="txAdvice" transaction-manager="transactionManager">
    		<tx:attributes>
    			
    			<tx:method name="save*" propagation="REQUIRED" />
    			<tx:method name="insert*" propagation="REQUIRED" />
    			<tx:method name="delete*" propagation="REQUIRED" />
    			<tx:method name="update*" propagation="REQUIRED" />
    			<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
    			<tx:method name="get*" propagation="SUPPORTS" read-only="true" />
    			<tx:method name="query*" propagation="SUPPORTS" read-only="true" />
    		</tx:attributes>
    	</tx:advice>
    
    	
    	<aop:config>
    		<aop:advisor advice-ref="txAdvice"
    			pointcut="execution(* com.jk.service.*.*(..))" />
    	</aop:config>
    
    </beans>

**Controller层：**

**spring-mvc.xml**

1.  包扫描器，扫描@Controller注解的类。
2.  配置注解驱动。
3.  视图解析器

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
            http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
    
    	
    	<context:component-scan base-package="com.jk.controller" />
    	
    	
    	
    	<mvc:annotation-driven />
    	
    	
    	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
    		<property name="prefix" value="/WEB-INF/jsp/"/>
    
            
    		<property name="suffix" value=".jsp"/>
    	</bean>
    </beans>

**Web.xml**

1.  配置spring容量监听器
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_2_5.xsd" id="WebApp_ID" version="2.5">
      <display-name>03-springmvc-mybatis</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
      
      
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:spring/applicationContext*.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<listener-class>
                org.springframework.web.context.ContextLoaderListener
            </listener-class>
    	</listener>
    	
    	
    	<filter>
    		<filter-name>encoding</filter-name>
    		<filter-class>
                org.springframework.web.filter.CharacterEncodingFilter
            </filter-class>
    		
    		<init-param>
    			<param-name>encoding</param-name>
    			<param-value>UTF-8</param-value>
    		</init-param>
    	</filter>
    	<filter-mapping>
    		<filter-name>encoding</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
    	
    	
    	
    	<servlet>
    		<servlet-name>springmvc-web</servlet-name>
    		<servlet-class>
                org.springframework.web.servlet.DispatcherServlet
            </servlet-class>
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring/spring-mvc.xml</param-value>
    		</init-param>
    	</servlet>
    
    	<servlet-mapping>
    		<servlet-name>springmvc-web</servlet-name>
    		<url-pattern>*.action</url-pattern>
    	</servlet-mapping>
      
    </web-app>

# #

## 第三部分：编码测试 ##

### 创建数据库（设置字符集为UTF-8,命名为ssm） ###

### 建表语句如下 ###

CREATE TABLE `emp` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) DEFAULT NULL,
      `password` varchar(255) DEFAULT NULL,
      `phone` varchar(255) DEFAULT NULL,
      `sex` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
    
    INSERT INTO `emp` VALUES ('1', '张三', '123456', '1008611', '男');

### 编写pojo ###

package com.jk.pojo;
    
    import java.io.Serializable;
    
    /**
     * 雇员信息
     * @author 风尘洛语
     *
     */
    public class Emp implements Serializable{
    	private static final long serialVersionUID = 1L;
    	
    	// 主键，自动递增
    	private Integer id;
    	
    	// 雇员名
    	private String name;
    	
    	// 雇员密码
    	private String password;
    	
    	// 雇员电话
    	private String phone;
    	
    	// 雇员性别
    	private String sex;
    	
    	// GET AND SET
    	public Integer getId() {
    		return id;
    	}
    	public void setId(Integer id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    	public String getSex() {
    		return sex;
    	}
    	public void setSex(String sex) {
    		this.sex = sex;
    	}
    	@Override
    	public String toString() {
    		return "User [id=" + id + ", name=" + name + ", password=" + password + ", phone=" + phone + ", sex=" + sex
    				+ "]";
    	}
    	
    	
    }

### 编写Mapper ###

package com.jk.mapper;
    
    import com.jk.pojo.Emp;
    
    /**
     * 用户持久化接口
     * @author 风尘洛语
     */
    public interface EmpMapper {
    	/**
    	 * 根据id 查询雇员信息
    	 * @param id 雇员ID
    	 * @return 
    	 */
    	Emp findEmpById (Integer id);
    }

### 编写xxxMapper.xml ###

<?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.jk.mapper.EmpMapper" >
    	<select id="findEmpById" parameterType="int" resultType="com.jk.pojo.Emp">
    		SELECT
    			e.`id`,
    			e.`name`,
    			e.`password`,
    			e.`sex`,
    			e.`phone`
    		FROM
    			emp e
    		WHERE
    			e.`id` = #{id}
    	</select>
    </mapper>

### 编写Service ###

package com.jk.service;
    
    import com.jk.pojo.Emp;
    
    public interface EmpService {
    	/**
    	 * 根据id 查询雇员信息
    	 * @param id 雇员ID
    	 * @return 
    	 */
    	Emp findEmpById (Integer id);
    }

package com.jk.service;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.jk.mapper.EmpMapper;
    import com.jk.pojo.Emp;
    
    /**
     * 服务层接口
     * @author 风尘洛语
     */
    @Service("empService")
    public class EmpServiceImpl {
    	@Autowired
    	EmpMapper empMapper;
    
    	/**
    	 * 根据id 查询雇员信息
    	 * @param id 雇员ID
    	 * @return 
    	 */
    	Emp findEmpById (Integer id) {
    		return empMapper.findEmpById(id);
    	}
    }

### 编写Controller ###

package com.jk.controller;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.jk.pojo.Emp;
    import com.jk.service.EmpService;
    
    /**
     * 表现层接口
     * @author 风尘洛语
     */
    @Controller
    public class EmpController {
    
    	@Autowired
    	EmpService empService;
    	
    	@RequestMapping("/emp/{id}")
    	@ResponseBody
    	public Emp queryEmpById (@PathVariable("id") Integer id) {
    		
    		return empService.findEmpById(id);
    	}
    }

### 更改web.xml 使其能支持RESTful 风格请求 ###

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns="http://java.sun.com/xml/ns/javaee"
    	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    	id="WebApp_ID" version="2.5">
    	<display-name>ssm-demo</display-name>
    	<welcome-file-list>
    		<welcome-file>index.html</welcome-file>
    		<welcome-file>index.htm</welcome-file>
    		<welcome-file>index.jsp</welcome-file>
    		<welcome-file>default.html</welcome-file>
    		<welcome-file>default.htm</welcome-file>
    		<welcome-file>default.jsp</welcome-file>
    	</welcome-file-list>
    
    
    	
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:spring/applicationContext*.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    
    	
    	<filter>
    		<filter-name>encoding</filter-name>
    		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    		
    		<init-param>
    			<param-name>encoding</param-name>
    			<param-value>UTF-8</param-value>
    		</init-param>
    	</filter>
    	<filter-mapping>
    		<filter-name>encoding</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
    
    
    	
    	<servlet>
    		<servlet-name>springmvc-web</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring/springmvc.xml</param-value>
    		</init-param>
    	</servlet>
    
    	<servlet-mapping>
    		<servlet-name>springmvc-web</servlet-name>
    		<url-pattern>/</url-pattern>
    	</servlet-mapping>
    </web-app>

## ##

### 测试 ###

### http://localhost:8080/ssm-demo/emp/1 ###

[70]: /images/20220517/1c341c4ef7a34a83b249709365bc22b0.png
[70 1]: /images/20220517/19f9eb3c2f6347f795ef1a56b6f732bd.png