struts2.0+spring2.0+ibatis

首页 新闻 论坛 博客 招聘 更多 ▼ 问答

知识库

myeclipse6.0下struts2.0+spring2.0+hibern ...
2008-04-18myeclipse6.0下struts2.0+spring2.0+ibatis整合示例
参考网上的例子，自己做了个简单的struts2.0+ibatis+spring2.0登陆的例子。
链接：http://blog.csdn.net/jinlong0/archive/2008/01/11/2034732.aspx
1. 新建web工程
[img] http://shiningwu.iteye.com/upload/picture/pic/12457/86475e67-51e5-3fba-998c-4e1178dfd578.bmp [/img]
点击“finish”。
2. 加入jar包
将下面的jar包加入WEB-INF/lib下
antlr-2.7.2.jar
aopalliance.jar
cglib-2.1.3.jar
commons-collections.jar
commons-dbcp.jar
commons-logging-1.0.4.jar
commons-pool.jar
freemarker-2.3.8.jar
ibatis-2.3.1.710.jar
mysql-connector-java-5.0.4-bin.jar
ognl-2.6.11.jar
oro-2.0.8.jar
spring.jar
struts2-core-2.0.11.1.jar
struts2-spring-plugin-2.0.11.1.jar
xwork-2.0.4.jar
3. 配置web.xml文件
Java代码
<?xml version="1.0" encoding="UTF-8"?>  
<web-app version="2.4"   
    xmlns="http://java.sun.com/xml/ns/j2ee"   
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">  
  <welcome-file-list>  
    <welcome-file>login.jsp</welcome-file>  
  </welcome-file-list>  
  <context-param>    
        <param-name>contextConfigLocation</param-name>  
        <param-value>/WEB-INF/classes/applicationContext.xml</param-value>   
    </context-param>   
  <listener>  
      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
  </listener>  
  <filter>  
      <filter-name>struts2</filter-name>  
      <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class>  
  </filter>  
  <filter-mapping>  
      <filter-name>struts2</filter-name>  
      <url-pattern>/*</url-pattern>  
  </filter-mapping>  
</web-app> 

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

4. 创建类与类包
结构如下图
[img]http://shiningwu.iteye.com/upload/picture/pic/12455/3668ca76-3bd8-3253-aec6-5d69df169dc8.bmp [/img]
5. 映射数据库表Users.java
Java代码
package org.login.vo;  
 
public class Users {  
    private Integer id;  
    private String userName;  
    private String password;  
          
    public Integer getId() {  
        return id;  
    }  
 
    public void setId(Integer id) {  
        this.id = id;  
    }  
 
    public String getUserName() {  
        return userName;  
    }  
 
    public void setUserName(String userName) {  
        this.userName = userName;  
    }  
 
    public String getPassword() {  
        return password;  
    }  
 
    public void setPassword(String password) {  
        this.password = password;  
    }  
 
    public Users() {  
          
    }  
 
    public Users(Integer id, String userName, String password) {  
        super();  
        this.id = id;  
        this.userName = userName;  
        this.password = password;  
    }  
 
} 

package org.login.vo;

public class Users {
private Integer id;
    private String userName;
    private String password;
       
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Users() {
       
    }

    public Users(Integer id, String userName, String password) {
        super();
        this.id = id;
        this.userName = userName;
        this.password = password;
    }

}

6. 映射xml（users.xml）
Java代码
<?xml version="1.0" encoding="UTF-8"?>  
 
<!DOCTYPE sqlMap        
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"        
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">  
<sqlMap namespace="User">  
    <typeAlias alias="user" type="org.login.vo.Users"/>  
      
    <select id="recordCount" resultClass="int">  
        select count(*) as count from users  
    </select>  
    <select id="firstPage" resultClass="user" parameterClass="user">  
        select top $pagesize$ * from users order by id desc  
    </select>  
 
    <!--分页排序-->  
    <sql id="paginationStart">  
        <![CDATA[  
           select * from (select row_.*, rownum rownum_ from (  
          ]]>  
    </sql>  
    <sql id="paginationEnd">  
        <![CDATA[  
           )row_ where rownum<=#end# ) where rownum_>=#start#  
          ]]>  
    </sql>  
 
    <select id="otherPage" resultClass="user" parameterClass="map">  
        <include refid="paginationStart"/>  
        <![CDATA[  
            SELECT   
             *   
            FROM   
             users  
        ]]>  
        <include refid="paginationEnd"/>   
    </select>  
      
    <select id="checkUser" parameterClass="user" resultClass="user">  
        <![CDATA[  
            SELECT id, username, password FROM users WHERE username = #userName# and password = #password#  
        ]]>  
    </select>  
      
    <select id="getUserById" parameterClass="java.lang.Integer" resultClass="user">  
        <![CDATA[  
            SELECT id, username, password FROM users WHERE id = #id#  
        ]]>  
    </select>  
      
    <select id="getAllUser" resultClass="user" parameterClass="map">  
        <![CDATA[  
            SELECT id, username, password FROM users limit #start# ,#end#  
        ]]>  
    </select>  
      
    <insert id="insertUser" parameterClass="user">  
        <![CDATA[  
            INSERT INTO users (username, password) VALUES (#userName#, #password#)  
        ]]>  
    </insert>  
      
    <update id="updateUser" parameterClass="user">  
        <![CDATA[  
            UPDATE users SET username=#userName#, password=#password# WHERE id=#id#  
        ]]>  
    </update>  
      
    <delete id="deleteUser" parameterClass="java.lang.Integer">  
        <![CDATA[  
            DELETE FROM users WHERE id = #id#  
        ]]>  
    </delete>  
</sqlMap> 

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
    <typeAlias alias="user" type="org.login.vo.Users"/>
   
    <select id="recordCount" resultClass="int">
select count(*) as count from users
</select>
<select id="firstPage" resultClass="user" parameterClass="user">
select top $pagesize$ * from users order by id desc
</select>

<!--分页排序-->
<sql id="paginationStart">
<![CDATA[
   select * from (select row_.*, rownum rownum_ from (
  ]]>
</sql>
<sql id="paginationEnd">
<![CDATA[
   )row_ where rownum<=#end# ) where rownum_>=#start#
  ]]>
</sql>

<select id="otherPage" resultClass="user" parameterClass="map">
        <include refid="paginationStart"/>
        <![CDATA[
            SELECT
             *
            FROM
             users
        ]]>
        <include refid="paginationEnd"/>
</select>

    <select id="checkUser" parameterClass="user" resultClass="user">
        <![CDATA[
            SELECT id, username, password FROM users WHERE username = #userName# and password = #password#
        ]]>
    </select>
   
    <select id="getUserById" parameterClass="java.lang.Integer" resultClass="user">
        <![CDATA[
            SELECT id, username, password FROM users WHERE id = #id#
        ]]>
    </select>
   
    <select id="getAllUser" resultClass="user" parameterClass="map">
        <![CDATA[
            SELECT id, username, password FROM users limit #start# ,#end#
        ]]>
    </select>
   
    <insert id="insertUser" parameterClass="user">
        <![CDATA[
            INSERT INTO users (username, password) VALUES (#userName#, #password#)
        ]]>
    </insert>
   
    <update id="updateUser" parameterClass="user">
        <![CDATA[
            UPDATE users SET username=#userName#, password=#password# WHERE id=#id#
        ]]>
    </update>
   
    <delete id="deleteUser" parameterClass="java.lang.Integer">
        <![CDATA[
            DELETE FROM users WHERE id = #id#
        ]]>
    </delete>
</sqlMap>
7. 接口及实现
接口IUserDAO.java
Java代码
package org.login.dao;  
 
import java.util.List;  
import org.login.vo.Users;  
 
public interface IUserDAO {  
    List<Users> getAllUser();     
    Users getUserById(Integer id);     
    boolean isLogin(Users user);  
    boolean insertUser(Users user);  
    boolean updateUser(Users user);    
    boolean deleteUser(Integer id);  
} 

package org.login.dao;

import java.util.List;
import org.login.vo.Users;

public interface IUserDAO {
    List<Users> getAllUser();  
    Users getUserById(Integer id);  
    boolean isLogin(Users user);
    boolean insertUser(Users user);
    boolean updateUser(Users user); 
    boolean deleteUser(Integer id);
}

实现UserDAO
Java代码
package org.login.dao.Impl;  
 
import java.sql.SQLException;  
import java.util.List;  
 
import org.login.dao.IUserDAO;  
import org.login.vo.Users;  
import com.ibatis.sqlmap.client.SqlMapClient;  
 
 
public class UserDAO implements IUserDAO {  
 
    private SqlMapClient client = null;  
 
    public SqlMapClient getClient() {  
        return client;  
    }  
 
    public void setClient(SqlMapClient client) {  
        this.client = client;  
    }  
 
      
    public boolean deleteUser(Integer id) {  
        try {  
            client.delete("deleteUser", id);  
            return true;  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return false;  
    }  
 
    
    public List<Users> getAllUser() {  
        List<Users> list = null;  
        try {  
            list =  client.queryForList("getAllUser");  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return list;  
    }  
 
     
    public boolean insertUser(Users user) {  
        try {  
            client.insert("insertUser", user);  
            return true;  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return false;  
    }  
 
    
    public boolean updateUser(Users user) {  
        try {  
            client.update("updateUser", user);  
            return true;  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return false;  
    }  
 
    
    public boolean isLogin(Users user) {  
        try {  
            Users u = (Users) client.queryForObject("checkUser", user);  
            if (u != null) {  
                return true;  
            }  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return false;  
    }  
 
    
    public Users getUserById(Integer id) {  
        Users u = null;  
        try {  
            u = (Users) client.queryForObject("getUserById", id);  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return u;  
    }  
 
} 

package org.login.dao.Impl;

import java.sql.SQLException;
import java.util.List;

import org.login.dao.IUserDAO;
import org.login.vo.Users;
import com.ibatis.sqlmap.client.SqlMapClient;


public class UserDAO implements IUserDAO {

    private SqlMapClient client = null;

    public SqlMapClient getClient() {
        return client;
    }

    public void setClient(SqlMapClient client) {
        this.client = client;
    }

   
    public boolean deleteUser(Integer id) {
        try {
            client.delete("deleteUser", id);
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

 
    public List<Users> getAllUser() {
        List<Users> list = null;
        try {
            list =  client.queryForList("getAllUser");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

  
    public boolean insertUser(Users user) {
        try {
            client.insert("insertUser", user);
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

 
    public boolean updateUser(Users user) {
        try {
            client.update("updateUser", user);
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

 
    public boolean isLogin(Users user) {
        try {
            Users u = (Users) client.queryForObject("checkUser", user);
            if (u != null) {
                return true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

 
    public Users getUserById(Integer id) {
        Users u = null;
        try {
            u = (Users) client.queryForObject("getUserById", id);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return u;
    }

}

服务层接口IUserService.java
Java代码
package org.login.service;  
 
import java.util.List;  
 
import org.login.vo.Users;  
 
public interface IUserService {  
      
    List<Users> getAllUser();  
      
    Users getUserById(Integer id);  
      
    boolean isLogin(Users user);  
      
    boolean insertUser(Users user);  
      
    boolean updateUser(Users user);  
      
    boolean deleteUser(Integer id);  
} 

package org.login.service;

import java.util.List;

import org.login.vo.Users;

public interface IUserService {
   
    List<Users> getAllUser();
   
    Users getUserById(Integer id);
   
    boolean isLogin(Users user);
   
    boolean insertUser(Users user);
   
    boolean updateUser(Users user);
   
    boolean deleteUser(Integer id);
}

服务层实现UserService.java
Java代码
package org.login.service.Impl;  
 
import java.util.List;  
 
import org.login.dao.IUserDAO;  
import org.login.service.IUserService;  
import org.login.vo.Users;  
 
 
 
public class UserService implements IUserService {  
 
    private IUserDAO userDAO = null;  
      
    public IUserDAO getUserDAO() {  
        return userDAO;  
    }  
 
    public void setUserDAO(IUserDAO userDAO) {  
        this.userDAO = userDAO;  
    }  
 
      
    public boolean deleteUser(Integer id) {  
          
        return userDAO.deleteUser(id);  
    }  
 
    
    public List<Users> getAllUser() {  
          
        return userDAO.getAllUser();  
    }  
 
    
    public boolean insertUser(Users user) {  
          
        return userDAO.insertUser(user);  
    }  
 
     
    public boolean isLogin(Users user) {  
          
        return userDAO.isLogin(user);  
    }  
 
    
    public boolean updateUser(Users user) {  
          
        return userDAO.updateUser(user);  
    }  
 
     
    public Users getUserById(Integer id) {  
          
        return userDAO.getUserById(id);  
    }  
 
} 

package org.login.service.Impl;

import java.util.List;

import org.login.dao.IUserDAO;
import org.login.service.IUserService;
import org.login.vo.Users;



public class UserService implements IUserService {

    private IUserDAO userDAO = null;
   
    public IUserDAO getUserDAO() {
        return userDAO;
    }

    public void setUserDAO(IUserDAO userDAO) {
        this.userDAO = userDAO;
    }

   
    public boolean deleteUser(Integer id) {
       
        return userDAO.deleteUser(id);
    }

 
    public List<Users> getAllUser() {
       
        return userDAO.getAllUser();
    }

 
    public boolean insertUser(Users user) {
       
        return userDAO.insertUser(user);
    }

  
    public boolean isLogin(Users user) {
       
        return userDAO.isLogin(user);
    }

 
    public boolean updateUser(Users user) {
       
        return userDAO.updateUser(user);
    }

  
    public Users getUserById(Integer id) {
       
        return userDAO.getUserById(id);
    }

}

Struts中Action实现Login.java
Java代码
package org.login.actions;  
 
import java.util.HashMap;  
import java.util.List;  
import java.util.Map;  
 
import javax.servlet.http.HttpServletRequest;  
import javax.xml.registry.infomodel.User;  
 
import org.login.page.PageUtil;  
import org.login.service.IUserService;  
import org.login.vo.Users;  
 
import com.opensymphony.xwork2.ActionSupport;  
import com.opensymphony.xwork2.ModelDriven;  
import com.opensymphony.xwork2.Preparable;  
 
public class Login extends ActionSupport implements ModelDriven<Users>, Preparable {  
    private IUserService userService ;   
    private String id ;  
    private int pageIndex=1 ;  
    private String pageBar ;  
    private List<Users> list;  
    private Users user;  
      
    public String getId() {  
        return id;  
    }  
 
    public void setId(String id) {  
        this.id = id;  
    }  
      
    public IUserService getUserService() {  
        return userService;  
    }  
 
    public void setUserService(IUserService userService) {  
        this.userService = userService;  
    }  
 
    public int getPageIndex() {  
        return pageIndex;  
    }  
 
    public void setPageIndex(int pageIndex) {  
        this.pageIndex = pageIndex;  
    }  
      
 
    public String getPageBar() {  
        return pageBar;  
    }  
 
    public void setPageBar(String pageBar) {  
        this.pageBar = pageBar;  
    }  
      
 
    public List<Users> getList() {  
        return list;  
    }  
 
    public void setList(List<Users> list) {  
        this.list = list;  
    }  
      
    public Users getUser() {  
        return user;  
    }  
 
    public void setUser(Users user) {  
        this.user = user;  
    }  
      
    public void prepare() throws Exception {  
        if (id == null || id.length() == 0)  
            user = new Users();  
        else 
            user = getUserService().getUserById(Integer.parseInt(id));  
    }  
      
    public String execute() throws Exception {  
        if (getUserService().isLogin(user)) {  
            return SUCCESS;  
        }  
        return INPUT;  
    }  
      
    public String save() throws Exception {  
        if (getUserService().insertUser(user)) {  
            return SUCCESS;  
        }  
        return ERROR;  
    }  
 
    public String edit() {  
        return SUCCESS;  
    }  
      
    public String update() throws Exception {      
        if (getUserService().updateUser(user)) {  
                return SUCCESS;  
        }      
        return ERROR;  
    }  
      
    public String delete() throws Exception {  
        if (getUserService().deleteUser(Integer.valueOf(id))) {  
            return SUCCESS;  
        }  
        return ERROR;  
    }  
      
      
    public String findAllUsers() throws Exception {  
        PageUtil page = new PageUtil();   
        int count = getUserService().getCount();  
        page.setCurPage(pageIndex);  
        page.setTotalRow(count);  
        pageBar = page.getToolsMenu();  
        Map<String,Integer> pageMap = new HashMap<String,Integer>();  
        pageMap.put("start", page.getStart());  
        pageMap.put("end", page.getPageSize());  
        list = getUserService().getAllUser(pageMap);   
        return SUCCESS;  
    }  
      
    public Users getModel() {  
        return user;  
    }  
 
 
 
} 

package org.login.actions;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.xml.registry.infomodel.User;

import org.login.page.PageUtil;
import org.login.service.IUserService;
import org.login.vo.Users;

import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.opensymphony.xwork2.Preparable;

public class Login extends ActionSupport implements ModelDriven<Users>, Preparable {
    private IUserService userService ;
    private String id ;
    private int pageIndex=1 ;
private String pageBar ;
private List<Users> list;
private Users user;
   
    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }
   
    public IUserService getUserService() {
        return userService;
    }

    public void setUserService(IUserService userService) {
        this.userService = userService;
    }

public int getPageIndex() {
return pageIndex;
}

public void setPageIndex(int pageIndex) {
this.pageIndex = pageIndex;
}


public String getPageBar() {
return pageBar;
}

public void setPageBar(String pageBar) {
this.pageBar = pageBar;
}


public List<Users> getList() {
return list;
}

public void setList(List<Users> list) {
this.list = list;
}

public Users getUser() {
return user;
}

public void setUser(Users user) {
this.user = user;
}
   
public void prepare() throws Exception {
if (id == null || id.length() == 0)
user = new Users();
else
user = getUserService().getUserById(Integer.parseInt(id));
}

    public String execute() throws Exception {
        if (getUserService().isLogin(user)) {
            return SUCCESS;
        }
        return INPUT;
    }
   
    public String save() throws Exception {
        if (getUserService().insertUser(user)) {
            return SUCCESS;
        }
        return ERROR;
    }

    public String edit() {
return SUCCESS;
}
   
    public String update() throws Exception {   
        if (getUserService().updateUser(user)) {
                return SUCCESS;
        }   
        return ERROR;
    }
   
    public String delete() throws Exception {
        if (getUserService().deleteUser(Integer.valueOf(id))) {
            return SUCCESS;
        }
        return ERROR;
    }
   
   
    public String findAllUsers() throws Exception {
    PageUtil page = new PageUtil();
int count = getUserService().getCount();
page.setCurPage(pageIndex);
page.setTotalRow(count);
pageBar = page.getToolsMenu();
Map<String,Integer> pageMap = new HashMap<String,Integer>();
pageMap.put("start", page.getStart());
pageMap.put("end", page.getPageSize());
        list = getUserService().getAllUser(pageMap);
        return SUCCESS;
    }
   
    public Users getModel() {
return user;
}



}
8. 配置文件
struts.xml
Java代码
<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE struts PUBLIC  
        "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" 
        "http://struts.apache.org/dtds/struts-2.0.dtd">  
<struts>  
    <constant name="struts.objectFactory.spring.autoWire" value="type" />  
    <constant name="struts.objectFactory" value="spring" />  
    <include file="struts-default.xml"/>  
    <package name="struts2" extends="struts-default">  
    <default-interceptor-ref name="paramsPrepareParamsStack" />  
        <!-- aciton的class为applicationContext.xml中的注册名 -->  
        <action name="login" class="LoginAction">  
            <result name="success">/success.jsp</result>  
            <result name="input">/login.jsp</result>  
        </action>  
        <action name="save" class="LoginAction" method="save">  
            <result name="success" type="redirect-action">show.action</result>  
            <result name="error">/error.jsp</result>  
        </action>  
        <action name="edit" class="LoginAction" method="edit">  
            <result name="success">update.jsp</result>  
        </action>  
        <action name="update" class="LoginAction" method="update">  
            <result name="success" type="redirect-action">show.action</result>  
            <result name="error">/error.jsp</result>  
        </action>  
        <action name="delete" class="LoginAction" method="delete">  
            <result name="success" type="redirect-action">show.action</result>  
            <result name="error">/error.jsp</result>  
        </action>  
        <action name="show" class="LoginAction" method="findAllUsers">  
            <result name="success">/list.jsp</result>  
            <result name="error">/error.jsp</result>  
        </action>  
    </package>  
</struts> 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
        "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
        "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
    <constant name="struts.objectFactory.spring.autoWire" value="type" />
<constant name="struts.objectFactory" value="spring" />
    <include file="struts-default.xml"/>
    <package name="struts2" extends="struts-default">
    <default-interceptor-ref name="paramsPrepareParamsStack" />
        <!-- aciton的class为applicationContext.xml中的注册名 -->
        <action name="login" class="LoginAction">
            <result name="success">/success.jsp</result>
            <result name="input">/login.jsp</result>
        </action>
        <action name="save" class="LoginAction" method="save">
            <result name="success" type="redirect-action">show.action</result>
            <result name="error">/error.jsp</result>
        </action>
        <action name="edit" class="LoginAction" method="edit">
<result name="success">update.jsp</result>
</action>
        <action name="update" class="LoginAction" method="update">
            <result name="success" type="redirect-action">show.action</result>
            <result name="error">/error.jsp</result>
        </action>
        <action name="delete" class="LoginAction" method="delete">
            <result name="success" type="redirect-action">show.action</result>
            <result name="error">/error.jsp</result>
        </action>
        <action name="show" class="LoginAction" method="findAllUsers">
            <result name="success">/list.jsp</result>
            <result name="error">/error.jsp</result>
        </action>
    </package>
</struts>
struts.properties文件
Java代码
struts.locale=zh_CN  
struts.i18n.encoding=UTF-8    
struts.objectFactory=spring   

struts.locale=zh_CN
struts.i18n.encoding=UTF-8 
struts.objectFactory=spring 

ibatis的配置文件config.xml
Java代码
<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE sqlMapConfig        
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"        
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">  
      
<sqlMapConfig>  
    <sqlMap resource="org/login/vo/users.xml"/>  
</sqlMapConfig> 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
   
<sqlMapConfig>
    <sqlMap resource="org/login/vo/users.xml"/>
</sqlMapConfig>

Spring配置文件applicationContext.xml
Java代码
<?xml version="1.0" encoding="UTF-8"?>  
<beans default-autowire="byType" 
    xmlns="http://www.springframework.org/schema/beans" 
    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-2.0.xsd">  
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />  
        <property name="url" value="jdbc:mysql://192.168.151.238:3306/chgl" />  
        <property name="username" value="vcom" />  
        <property name="password" value="vcom_8968888" />  
    </bean>  
      
    <bean id="client" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">  
        <property name="dataSource">  
            <ref local="dataSource"/>  
        </property>  
        <property name="configLocation">  
            <value>classpath:config.xml</value>  
        </property>  
    </bean>  
      
    <!-- bean中的class为实现接口的类；property的name为类中引用的属性名称；ref为spring注册的名称，如上面的client-->  
    <bean id="userDao" 
        class="org.login.dao.Impl.UserDAO">  
        <property name="client" ref="client" />  
    </bean>  
 
    <bean id="userService" 
        class="org.login.service.Impl.UserService">  
        <property name="userDAO" ref="userDao"></property>  
    </bean>  
 
    <bean id="LoginAction" class="org.login.actions.Login">  
        <property name="userService" ref="userService"></property>  
    </bean>  
</beans> 

<?xml version="1.0" encoding="UTF-8"?>
<beans default-autowire="byType"
xmlns="http://www.springframework.org/schema/beans"
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-2.0.xsd">
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://192.168.151.238:3306/chgl" />
        <property name="username" value="vcom" />
        <property name="password" value="vcom_8968888" />
    </bean>
   
    <bean id="client" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="dataSource">
            <ref local="dataSource"/>
        </property>
        <property name="configLocation">
            <value>classpath:config.xml</value>
        </property>
    </bean>
   
    <!-- bean中的class为实现接口的类；property的name为类中引用的属性名称；ref为spring注册的名称，如上面的client-->
    <bean id="userDao"
class="org.login.dao.Impl.UserDAO">
<property name="client" ref="client" />
</bean>

<bean id="userService"
class="org.login.service.Impl.UserService">
<property name="userDAO" ref="userDao"></property>
</bean>

<bean id="LoginAction" class="org.login.actions.Login">
<property name="userService" ref="userService"></property>
</bean>
</beans>

9. UI层
登陆页面login.jsp
Java代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
<%@ taglib uri="/struts-tags" prefix="s" %>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
  <head>  
    <title>login.jsp</title>  
  </head>  
    
  <body>  
    <s:form action="login" method="post">  
    <s:textfield name="userName" label="User Name" />  
    <s:password name="password" label="Password" />  
    <s:submit value="Submit" />  
    </s:form>  
  </body>  
</html> 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>login.jsp</title>
  </head>
 
  <body>
    <s:form action="login" method="post">
    <s:textfield name="userName" label="User Name" />
    <s:password name="password" label="Password" />
    <s:submit value="Submit" />
    </s:form>
  </body>
</html>
添加用户页面adduser.jsp
Java代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
<%@ taglib uri="/struts-tags" prefix="s" %>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
  <head>  
    <title>addUser.jsp</title>  
  </head>  
    
  <body>  
    <s:form action="save">  
    <s:textfield name="userName" label="User Name" />  
    <s:password name="password" label="Password" />  
    <s:submit value="Save" />  
    </s:form>  
  </body>  
</html> 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>addUser.jsp</title>
  </head>
 
  <body>
    <s:form action="save">
    <s:textfield name="userName" label="User Name" />
    <s:password name="password" label="Password" />
    <s:submit value="Save" />
    </s:form>
  </body>
</html>
用户列表页面list.jsp
Java代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
<%@ taglib uri="/struts-tags" prefix="s" %>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
  <head>  
    <title>Users list</title>  
    <style type="text/css">  
        table {  
            border-collapse: collapse;  
        }  
    </style>  
  </head>  
    
  <body>  
      <br /><br /><br /><br />  
    <s:form action="show">  
    <table border="1" width="50%" align="center">  
        <tr bgcolor="#cccc00">  
            <td align="center">UserID</td>  
            <td align="center">UserName</td>  
            <td align="center">Password</td>  
            <td colspan="2" align="center">Options</td>  
        </tr>  
        <s:iterator value="list" id="user" status="st">  
        <tr <s:if test="#st.odd">style="background-color:#dddddd"</s:if>  
            <s:else>style="background-color:#eeeeee"</s:else>>  
            <td align="center"><s:property value="id" /></td>  
            <td align="center">&nbsp;<s:property value="userName" /></td>  
            <td align="center">&nbsp;<s:property value="password" /></td>  
            <td align="center">  
            <s:url id="update" action="edit">  
               <s:param name="id">  
               <s:property value="id" />   
               </s:param>  
            </s:url>   
            <s:a href="%{update}">update</s:a>  
            </td>  
              
            <td align="center">  
            <s:url id="delete" action="delete">  
               <s:param name="id">  
               <s:property value="id" />  
               </s:param>  
            </s:url>   
            <s:a href="%{delete}">delete</s:a>  
            </td>  
        </tr>  
        </s:iterator>  
        <tr>  
                <td colspan="4">   
                    <s:property value="#request.pageBar" escape="false"/>  
                </td>  
        </tr>  
    </table>  
    </s:form>  
  </body>  
</html> 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>Users list</title>
    <style type="text/css">
        table {
            border-collapse: collapse;
        }
    </style>
  </head>
 
  <body>
      <br /><br /><br /><br />
    <s:form action="show">
    <table border="1" width="50%" align="center">
        <tr bgcolor="#cccc00">
            <td align="center">UserID</td>
            <td align="center">UserName</td>
            <td align="center">Password</td>
            <td colspan="2" align="center">Options</td>
        </tr>
        <s:iterator value="list" id="user" status="st">
        <tr <s:if test="#st.odd">style="background-color:#dddddd"</s:if>
<s:else>style="background-color:#eeeeee"</s:else>>
            <td align="center"><s:property value="id" /></td>
            <td align="center">&nbsp;<s:property value="userName" /></td>
            <td align="center">&nbsp;<s:property value="password" /></td>
            <td align="center">
            <s:url id="update" action="edit">
   <s:param name="id">
   <s:property value="id" />
   </s:param>
</s:url>
<s:a href="%{update}">update</s:a>
</td>

            <td align="center">
            <s:url id="delete" action="delete">
   <s:param name="id">
   <s:property value="id" />
   </s:param>
</s:url>
<s:a href="%{delete}">delete</s:a>
</td>
        </tr>
        </s:iterator>
        <tr>
<td colspan="4">
<s:property value="#request.pageBar" escape="false"/>
</td>
</tr>
    </table>
    </s:form>
  </body>
</html>
用户更新页面update.jsp
Java代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
<%@ taglib uri="/struts-tags" prefix="s" %>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
  <head>  
    <title>update.jsp</title>  
  </head>  
    
  <body>  
    <s:form action="update" method="post">  
        <s:textfield name="id" label="ID" value="%{id}"  readonly="true"/>  
        <s:textfield name="userName" label="User Name" value="%{userName}"  required="true"/>  
        <s:textfield name="password" label="Password" value="%{password}"  required="true"/>  
        <s:submit value="Update" />  
    </s:form>  
  </body>  
</html> 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>update.jsp</title>
  </head>
 
  <body>
    <s:form action="update" method="post">
        <s:textfield name="id" label="ID" value="%{id}"  readonly="true"/>
        <s:textfield name="userName" label="User Name" value="%{userName}"  required="true"/>
        <s:textfield name="password" label="Password" value="%{password}"  required="true"/>
        <s:submit value="Update" />
    </s:form>
  </body>
</html>
成功页面success.jsp
Java代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
<%@ taglib uri="/struts-tags" prefix="s" %>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
  <head>  
    <title>success</title>  
  </head>  
    
  <body>  
    This is Success page. <br>  
    <br /><br />  
    <a href="show.action">显示用户列表</a>  <a href="adduser.jsp">添加用户</a>  
  </body>  
</html> 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>success</title>
  </head>
 
  <body>
    This is Success page. <br>
    <br /><br />
    <a href="show.action">显示用户列表</a>  <a href="adduser.jsp">添加用户</a>
  </body>
</html>

失败页面error.jsp
Java代码
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>  
<%  
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>My JSP 'error.jsp' starting page</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">  
    <!--  
    <link rel="stylesheet" type="text/css" href="styles.css">  
    -->  
 
  </head>  
    
  <body>  
    This is my JSP page. <br>  
  </body>  
</html> 

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%
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>My JSP 'error.jsp' starting page</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->

  </head>
 
  <body>
    This is my JSP page. <br>
  </body>
</html>