myeclipse6.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文件

<?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

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)

<?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

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

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

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

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

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

<?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文件

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

ibatis的配置文件config.xml

<?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

<?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

<%@ 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

<%@ 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

<%@ 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"> <s:property value="userName" /></td>
<td align="center"> <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

<%@ 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

<%@ 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

<%@ 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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值