SpringMVC-eight(springMVC的跳转处理)-nine(SSM的整合)

谁践踏了优雅 2022-03-08 04:28 164阅读 0赞

# 08【掌握】springMVC的跳转处理 #

**视图解析器配置前后缀**

<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		
    		<property name="prefix" value="/WEB-INF/view/"></property>
    		
    		<property name="suffix" value=".jsp"></property>
    	</bean>

在返回页面跳转地址时就可以写成下如配置

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]  
说明视图解析器只能请求转发起做作

## 请求转发和请求重定向 ##

spring默认的方式是请求转发  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]  
说明视图解析器只能请求转发起做作

# 09【掌握】SSM的整合 #

spring+springmvc +mybatis的集合

## 1.创建项目 ##

![在这里插入图片描述][20190314112213458.png]

## 2.导包 ##

1，spring+springmvc  
2，mybatis+spring-mybaits  
3，pageHelper插件  
3，相关数据源  
5，mysql

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 2]

## 3.集成spring+mybaits\[无mybatis.cfg.xml\] ##

**1.创建log4j.properties**

# Global logging configuration
    log4j.rootLogger=DEBUG, stdout
    # MyBatis logging configuration...
    log4j.logger.org.mybatis.example.BlogMapper=TRACE
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

**2.创建application-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:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd
                http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/context
    	http://www.springframework.org/schema/context/spring-context.xsd
            ">
    	
    	<bean id="dataSource" 
    	class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    		
    		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    		<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property>
    		<property name="username" value="root"></property>
    		<property name="password" value="123456"></property>
    	</bean>
    	
    	
    	<bean id="configuration" class="org.apache.ibatis.session.Configuration">
    		
    		<property name="logImpl" value="org.apache.ibatis.logging.log4j.Log4jImpl" >
    		</property>
    	</bean>
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource"></property>
    		
    		<property name="configuration" ref="configuration"></property>
    		
    		<property name="plugins">
    			
    			<array>
    				<bean class="com.github.pagehelper.PageInterceptor"></bean>
    			</array>
    		</property>
    		
    		<property name="mapperLocations" >
    			<array>
    				<value>classpath:mapper/*Mapper.xml</value>
    			</array>
    		</property>
    	</bean>
    	 
    	 
    	 
    	 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    	 	
    	 	<property name="basePackage">
    	 		<value>com.sxt.mapper</value>
    	 	</property>
    	 	
    	 	<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    	 	
    	 </bean>
    	
    	
    	
    
    </beans>

**3.创建application-service.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:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd
                http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/context
    	http://www.springframework.org/schema/context/spring-context.xsd
    	http://www.springframework.org/schema/tx
         http://www.springframework.org/schema/tx/spring-tx.xsd
            ">
    	
    	<context:component-scan base-package="com.sxt.service.impl"
    	></context:component-scan>
    	
    	
    	<bean id="transactionManager" 
    	class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    	
    	
    	<tx:advice id="myAdvise" transaction-manager="transactionManager">	
    		
    		<tx:attributes>
    		
    			
    			<tx:method name="add*" propagation="REQUIRED"/>
    			<tx:method name="save*" propagation="REQUIRED"/>
    			<tx:method name="update*" propagation="REQUIRED"/>
    			<tx:method name="mod*" propagation="REQUIRED"/>
    			<tx:method name="delete*" propagation="REQUIRED"/>
    			<tx:method name="del*" propagation="REQUIRED"/>
    			<tx:method name="reset*" propagation="REQUIRED"/>
    			<tx:method name="*" read-only="true"/>
    		</tx:attributes>
    	</tx:advice>
    	
    	
    	<aop:config>
    		
    		<aop:pointcut expression="execution(* com.sxt.service.impl.*.*(..))" id="pc"/>
    		
    		<aop:advisor advice-ref="myAdvise" pointcut-ref="pc"/>
    	</aop:config>
    	
    </beans>

**4.创建applicationContext.xml**

**5.测试是否集成成功**

![在这里插入图片描述][20190314112432155.png]

## 4.集成springmvc ##

**1.创建springmvc.xml**

**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">
      <display-name>06_ssm</display-name>
      
       
      <filter>
      	<filter-name>encodingFilter</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>encodingFilter</filter-name>
      	
      	<servlet-name>springmvc</servlet-name>
      </filter-mapping>
      
      
      
      
      <listener>
      	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      <context-param>
      	
      	<param-name>contextConfigLocation</param-name>
      	<param-value>classpath*:applicationContext.xml</param-value>
      </context-param>
      
      
      
      <servlet>
      	<servlet-name>springmvc</servlet-name>
      	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      	
      	<init-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath*:springmvc.xml</param-value>  	
      	</init-param>
      	
      	<load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
      	<servlet-name>springmvc</servlet-name>
      	
    		<url-pattern>*.action</url-pattern>
      </servlet-mapping>
     
      
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
    </web-app>

**3.发布到tomcat启动测试**

## 5.完成sys\_user表的查询 ##

1.创建表  
![在这里插入图片描述][20190314112556918.png]  
2.创建User  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 3]  
3.创建UserMapper  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 4]  
**4.创建UserMapper.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.sxt.mapper.UserMapper" >
      <resultMap id="BaseResultMap" type="com.sxt.domain.User" >
        <id column="user_id" property="userId" jdbcType="INTEGER" />
        <result column="user_name" property="userName" jdbcType="VARCHAR" />
        <result column="user_address" property="userAddress" jdbcType="VARCHAR" />
        <result column="user_birthday" property="userBirthday" jdbcType="DATE" />
      </resultMap>
      <sql id="Base_Column_List" >
        user_id, user_name, user_address, user_birthday
      </sql>
      <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
        select 
        <include refid="Base_Column_List" />
        from sys_user
        where user_id = #{
        userId,jdbcType=INTEGER}
      </select>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
        delete from sys_user
        where user_id = #{
        userId,jdbcType=INTEGER}
      </delete>
      <insert id="insert" parameterType="com.sxt.domain.User" >
        insert into sys_user (user_id, user_name, user_address, 
          user_birthday)
        values (#{
        userId,jdbcType=INTEGER}, #{
        userName,jdbcType=VARCHAR}, #{
        userAddress,jdbcType=VARCHAR}, 
          #{
        userBirthday,jdbcType=DATE})
      </insert>
      <insert id="insertSelective" parameterType="com.sxt.domain.User" >
        insert into sys_user
        <trim prefix="(" suffix=")" suffixOverrides="," >
          <if test="userId != null" >
            user_id,
          </if>
          <if test="userName != null" >
            user_name,
          </if>
          <if test="userAddress != null" >
            user_address,
          </if>
          <if test="userBirthday != null" >
            user_birthday,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
          <if test="userId != null" >
            #{
        userId,jdbcType=INTEGER},
          </if>
          <if test="userName != null" >
            #{
        userName,jdbcType=VARCHAR},
          </if>
          <if test="userAddress != null" >
            #{
        userAddress,jdbcType=VARCHAR},
          </if>
          <if test="userBirthday != null" >
            #{
        userBirthday,jdbcType=DATE},
          </if>
        </trim>
      </insert>
      <update id="updateByPrimaryKeySelective" parameterType="com.sxt.domain.User" >
        update sys_user
        <set >
          <if test="userName != null" >
            user_name = #{
        userName,jdbcType=VARCHAR},
          </if>
          <if test="userAddress != null" >
            user_address = #{
        userAddress,jdbcType=VARCHAR},
          </if>
          <if test="userBirthday != null" >
            user_birthday = #{
        userBirthday,jdbcType=DATE},
          </if>
        </set>
        where user_id = #{
        userId,jdbcType=INTEGER}
      </update>
      <update id="updateByPrimaryKey" parameterType="com.sxt.domain.User" >
        update sys_user
        set user_name = #{
        userName,jdbcType=VARCHAR},
          user_address = #{
        userAddress,jdbcType=VARCHAR},
          user_birthday = #{
        userBirthday,jdbcType=DATE}
        where user_id = #{
        userId,jdbcType=INTEGER}
      </update>
      
      
      <select id="queryAllUser" resultMap="BaseResultMap" >
        select 
        <include refid="Base_Column_List" />
        from sys_user
      </select>
    </mapper>

**5.创建UserVo**  
和页面上的表单数据对应  
![在这里插入图片描述][20190314112639594.png]  
6.创建UserService  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 5]  
**7.创建UserServiceImpl**

@Service
    public class UserServiceImpl implements UserService {
        
    
    	@Autowired
    	private UserMapper userMapper;
    
    	@Override
    	public void addUser(UserVo userVo) {
        
    		userMapper.insertSelective(userVo);
    	}
    
    	@Override
    	public void updateUser(UserVo userVo) {
        
    		userMapper.updateByPrimaryKeySelective(userVo);
    	}
    	@Override
    	public void deleteUser(Integer userId) {
        
    		userMapper.deleteByPrimaryKey(userId);
    	}
    	@Override
    	public User queryUserById(Integer userId) {
        
    		return userMapper.selectByPrimaryKey(userId);
    	}
    	@Override
    	public List<User> queryAllUser() {
        
    		return userMapper.queryAllUser();
    	}
    
    }

**8.创建UserController**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 6]  
9.创建index.jsp

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 7]  
**10.创建list.jsp**

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
    <%
    	String path = request.getContextPath();
    	String basePath = request.getScheme() + "://"
    			+ request.getServerName() + ":" + request.getServerPort()
    			+ path + "/";
    %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <base href="<%=basePath%>">
    
    <title>用户列表</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    </head>
    
    <body>
    	<h1>
    		所有用户
    	</h1>
    	<hr>
    	<table border="1" width="100%" cellpadding="5" cellspacing="5">
    		<tr>
    			<th>编号</th>
    			<th>姓名</th>
    			<th>地址</th>
    			<th>生日</th>
    		</tr>
    		<c:forEach var="sn" items="${list }">
    			<tr>
    				<td align="center">${
        sn.userId }</td>
    				<td align="center">${
        sn.userName }</td>
    				<td align="center">${
        sn.userAddress }</td>
    				<td align="center">
    				<fmt:formatDate value="${sn.userBirthday }" pattern="yyyy-MM-dd HH:mm:ss"/>
    				</td>
    			</tr>
    		</c:forEach>
    	</table>
    </body>
    </html>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]: /images/20220308/d78ec29896174ddbb61ad3d3922148a0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]: /images/20220308/5c410d42da7d49b9ba0826762564bae9.png
[20190314112213458.png]: /images/20220308/4dc4128b03024e87a44a4afccdeb9e53.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 2]: /images/20220308/88881bddfd6b4cbcb8eb21417e30d9a6.png
[20190314112432155.png]: /images/20220308/d31a0ba32b17402ebe3f7b781dddea01.png
[20190314112556918.png]: /images/20220308/aa0cb31d7d744261a070879c54a6b6da.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 3]: /images/20220308/e7fd9bd6388e4b4b92fdd30a7d91ebce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 4]: /images/20220308/6d46a5495d46408aad3f5addfa2b5bbe.png
[20190314112639594.png]: /images/20220308/d69df22cea3b495aa86473b1f293c7c5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 5]: /images/20220308/cd9b9b1d860a4dd3a2d1632ee1f1ff05.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 6]: /images/20220308/b63691b01137445195efe5fbbfab7395.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 7]: /images/20220308/240a30d6c8504d5a927fb347f6f75cbe.png