Struts2+MyBatis3.1.0+Spring3.1.0 整合之道一：数据映射器整合

我不是女神ヾ 2023-10-16 20:18 12阅读 0赞

第一步：导入相应的jar包

![Center][]

**第二步：Web.xml文件中整合Struts2和Spring3.1.0**

<?xml version="1.0" encoding="UTF-8"?>
    <web-app version="2.5" 
    	xmlns="http://java.sun.com/xml/ns/javaee" 
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
    	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
      <display-name></display-name>	
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
        
      <listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
      </listener>
      
      <context-param>
     		<param-name>contextConfigLocation</param-name>
     		 <param-value>WEB-INF/applicationContext.xml</param-value>
      </context-param>
      
      <filter>
      	<filter-name>struts2</filter-name>
      	<filter-class>
      		org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
      	</filter-class>
      </filter>
      <filter-mapping>
      	<filter-name>struts2</filter-name>
      	<url-pattern>/*</url-pattern>
      </filter-mapping>
     
    </web-app>

**第三步：Spring的配置文件配置：数据源、MyBatis和事务管理**

<?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: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-2.5.xsd
    	 http://www.springframework.org/schema/context
    	 http://www.springframework.org/schema/context/spring-context-2.5.xsd
    	 http://www.springframework.org/schema/tx 
    	 http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
    	 http://www.springframework.org/schema/aop 
    	 http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
    	 "	
    	>	
    
       <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
     		<property name="driverClassName">
    			<value>com.mysql.jdbc.Driver</value> 		
     		</property>  
     		<property name="url">
     			<value>jdbc:mysql://127.0.0.1:3306/skydrive</value>		
     		</property>
     		<property name="username">
     				<value>root</value>
     		</property>
     		<property name="password">
     				<value>123456</value>
     		</property>
     		<property name="maxIdle">
    			<value>40</value> 		
     		</property>
     		<property name="maxWait">
     			<value>40</value>
     		</property> 		
       </bean>
       
       <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       			<property name="configLocation">
       				<value>classpath:mybatis.xml</value>
       			</property>
       			<property name="dataSource">
       				<ref local="dataSource"></ref>
       			</property>
       </bean>
    <span style="color:#ff0000;">  </span>

**第四步：Mybatis配置文件**

注意：采用数据映射器（MapperFactoryBean）的方式，不用写mybatis映射文件，采用注解方式提供相应的sql语句和输入参数。

<?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> 
        <mappers>  
            <mapper resource="com/schoolmanager/dao/UserMapper.xml" />  
        </mappers>
    </configuration>

第五步：编写实体类------User

package com.schoolmanager.model;
    
    import java.io.Serializable;
    
    public class User implements Serializable {
    
    	/**
    	 * 
    	 */
    	private static final long serialVersionUID = 1L;
    	private String user;
    	private String pass;
    	private String xm;
    	private String email;
    	private String phone;
    	private String qq;
    	//默认构造函数
    	public User(){
    		
    	}
    	//set和get
    	public String getUser() {
    		return user;
    	}
    	public void setUser(String user) {
    		this.user = user;
    	}
    	public String getPass() {
    		return pass;
    	}
    	public void setPass(String pass) {
    		this.pass = pass;
    	}
    	public String getXm() {
    		return xm;
    	}
    	public void setXm(String xm) {
    		this.xm = xm;
    	}
    	public String getEmail() {
    		return email;
    	}
    	public void setEmail(String email) {
    		this.email = email;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    	public String getQq() {
    		return qq;
    	}
    	public void setQq(String qq) {
    		this.qq = qq;
    	}
    	
    
    }

第六步：编写User实体类---数据映射接口（UserMapper）

package com.schoolmanager.dao;
    
    import com.schoolmanager.model.User;
    
    public interface UserMapper {
    	public User selectUser(User user);   
    	public void insertUser(User user);   
    	public void updateUser(User user);   
    	public void deleteUser(String username); 
    }

第七步：配置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.schoolmanager.dao.UserMapper">
    <select id="selectUser" parameterType="com.schoolmanager.model.User" resultType="com.schoolmanager.model.User">
    	SELECT * FROM t_user WHERE user=#{user} AND pass=#{pass}
    </select>
    <insert id="insertUser" parameterType="com.schoolmanager.model.User" flushCache="true">
       INSERT INTO t_user (user,pass,xm,email,phone,qq) VALUES (#{user},#{pass},#{xm},#{email},#{phone},#{qq})
    </insert>
    <update id="updateUser" parameterType="com.schoolmanager.model.User">
    	UPDATE t_user SET pass=#{pass} WHERE user=#{user}
    </update>
    <delete id="deleteUser" parameterType="String">
    	DELETE FROM t_user WHERE user=#{user}
    </delete>
    </mapper>

第八步：编写UserServer接口和UserServer接口实现（UserServerImpl）

package com.schoolmanager.service;
    
    import com.schoolmanager.model.User;
    
    public interface UserServer {
    	public User selectUser(User user);   
    	public void insertUser(User user);   
    	public void updateUser(User user);   
    	public void deleteUser(String username); 
    
    }

package com.schoolmanager.serverimpl;
    
    import com.schoolmanager.dao.UserMapper;
    import com.schoolmanager.model.User;
    import com.schoolmanager.service.UserServer;
    
    public class UserServerImpl implements UserServer {
    	private UserMapper userMapper; 
    	
    
    	public UserMapper getUserMapper() {
    		return userMapper;
    	}
    
    	public void setUserMapper(UserMapper userMapper) {
    		this.userMapper = userMapper;
    	}
    
    	public User selectUser(User user) {
    		// TODO Auto-generated method stub
    		return userMapper.selectUser(user);
    	}
    
    	public void insertUser(User user) {
    		// TODO Auto-generated method stub
    		userMapper.insertUser(user);
    	}
    
    	public void updateUser(User user) {
    		// TODO Auto-generated method stub
    		userMapper.updateUser(user);
    	}
    
    	public void deleteUser(String username) {
    		// TODO Auto-generated method stub
    		userMapper.deleteUser(username);
    	}
    
    }

第九步：编写相关页面（add.jsp、update.jsp和delete.jsp)

add.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>  
    <%@ taglib prefix="s"  uri="/struts-tags"%>  
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
    <html>  
      <head>  
          
        <title>添加新用户</title>  
          
        <meta http-equiv="pragma" content="no-cache">  
        <meta http-equiv="cache-control" content="no-cache">  
        <meta http-equiv="expires" content="0">     
      
      </head>  
        
      <body>  
        <center>  
            <h1>添加新用户</h1>  
            <s:form action="user_add" namespace="/user" method="post">  
                <s:textfield label="用户名" name="user.user"></s:textfield>  
                <s:password label="密码" name="user.pass"></s:password>  
                <s:textfield label="姓名" name="user.xm"></s:textfield>
                <s:textfield label="邮箱" name="user.email"></s:textfield>
                <s:textfield label="电话" name="user.phone"></s:textfield>
                <s:textfield label="qq" name="user.qq"></s:textfield>
                <s:submit value="提交"></s:submit>  
            </s:form>  
        </center>  
      </body>  
    </html>

update.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>  
    <%@ taglib prefix="s"  uri="/struts-tags"%>  
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
    <html>  
      <head>  
          
        <title>修改用户</title>  
          
        <meta http-equiv="pragma" content="no-cache">  
        <meta http-equiv="cache-control" content="no-cache">  
        <meta http-equiv="expires" content="0">     
      
      </head>  
        
      <body>  
        <center>  
            <h1>修改用户</h1>  
            <s:form action="user_update" namespace="/user" method="post">  
                <s:hidden name="user.xm"></s:hidden>  
                <s:textfield label="用户名" name="user.user"></s:textfield>  
                <s:password label="密码" name="user.pass"></s:password>  
                <s:submit value="提交"></s:submit>  
            </s:form>  
        </center>  
      </body>  
    </html>

delete.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>  
    <%@ taglib prefix="s"  uri="/struts-tags"%>  
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
    <html>  
      <head>  
          
        <title>添加新用户</title>  
          
        <meta http-equiv="pragma" content="no-cache">  
        <meta http-equiv="cache-control" content="no-cache">  
        <meta http-equiv="expires" content="0">     
      
      </head>  
        
      <body>  
        <center>  
            <h1>添加新用户</h1>  
            <s:form action="user_delete" namespace="/user" method="post">   
             <s:textfield label="用户名" name="user.user"></s:textfield>             
                <s:submit value="提交"></s:submit>  
            </s:form>  
        </center>  
      </body>  
    </html>

第十步：编写相关Action和配置Action（UserAction）

package com.schoolmanager.action;
    
    import com.opensymphony.xwork2.ActionSupport;
    import com.schoolmanager.model.User;
    import com.schoolmanager.serverimpl.UserServerImpl;
    
    
    
    public class UserAction extends ActionSupport{
    
    	/**
    	 * 
    	 */
    	private static final long serialVersionUID = 1L;
    	private User user;
    	private UserServerImpl userServerImpl; 
    	
    
    	public User getUser() {
    		return user;
    	}
    
    	public void setUser(User user) {
    		this.user = user;
    	}
    
    	
    
    	public UserServerImpl getUserServerImpl() {
    		return userServerImpl;
    	}
    
    	public void setUserServerImpl(UserServerImpl userServerImpl) {
    		this.userServerImpl = userServerImpl;
    	}
    
    	@Override
    	public String execute() throws Exception {
    		// TODO Auto-generated method stub
    		return null;
    	}
    	
    	public String add() { 		    
    		userServerImpl.insertUser(user);
    	        return SUCCESS;  
    	    }  
    	  
    	    public String delete() {  
    	    	userServerImpl.deleteUser(user.getUser());
    	        return SUCCESS;  
    	    }  
    	  
    	    public String update() {  
    	    	userServerImpl.updateUser(user);
    	        return SUCCESS;  
    	    }
    
    	
    	
    	
    	
    
    }

Struts2.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
    <struts>       
    	<constant name="struts.i18n.encoding" value="UTF-8"/>  
                  
        <constant name="struts.configuration.xmlreload" value="true"/>  
                  
        <constant name="struts.devMode" value="false"/>  
                  
        <constant name="struts.ui.theme" value="xhtml"/>  
        
         <package name="users" namespace="/user" extends="struts-default">  
            <action name="user_*" class="com.schoolmanager.action.UserAction" method="{1}">  
                <result name="success">/index.jsp</result>             
            </action>  
        </package>  
        
        
          
      
        
    
    
    </struts>

该项目结构图：

![Center 1][]

[Center]: https://img-blog.csdn.net/20140722005905315?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: https://img-blog.csdn.net/20140722011802734?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center