SSH增删改查

Package Explorer

Users

package com.test.bean;

public class Users {
	
	private int id;
	private String firstname;
	private String lastname;
	private int age;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getFirstname() {
		return firstname;
	}
	public void setFirstname(String firstname) {
		this.firstname = firstname;
	}
	public String getLastname() {
		return lastname;
	}
	public void setLastname(String lastname) {
		this.lastname = lastname;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}

	
}

Users.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.test.bean.Users" table="USERS" schema="SYSTEM">
        <id name="id" type="java.lang.Integer">
            <column name="ID" precision="9" scale="0" />
            <generator class="sequence">
            	<param name="sequence">SQ_USERS</param>
            </generator>
        </id>
        
        <property name="firstname" type="java.lang.String">
            <column name="firstname" length="20" />
        </property>
        
        <property name="lastname" type="java.lang.String">
            <column name="LASTNAME" length="20" />
        </property>
        
        <property name="age" type="java.lang.Integer">
            <column name="AGE" precision="9" scale="0" />
        </property>
    </class>
</hibernate-mapping>

UserDAO

package com.test.dao;

import java.util.List;

import com.test.bean.Users;

public interface UserDAO {
	
	public void saveUsers(Users users);
	
	public List<Users> findAllUsers();
	
	public void removeUser(Users users);
	
	public void updateUsers(Users usre);
	
	public Users findUsersById(int id);
	
}

UserDAOImpl

package com.test.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.test.bean.Users;
import com.test.dao.UserDAO;

public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {

	public void saveUsers(Users users) {
		this.getHibernateTemplate().save(users);
	}

	@SuppressWarnings("unchecked")
	public List<Users> findAllUsers() {
		String hql="from Users us order by us.id desc";
		return this.getHibernateTemplate().find(hql);
	}

	public void removeUser(Users users) {
		this.getHibernateTemplate().delete(users);
	}

	public void updateUsers(Users usre) {
		this.getHibernateTemplate().update(usre);
	}

	public Users findUsersById(int id) {
		Users users=(Users) this.getHibernateTemplate().get(Users.class, id);
		return users;
	}
}

UserService

package com.test.service;

import java.util.List;

import com.test.bean.Users;

public interface UserService {
	
	public void save(Users users);
	
	public List<Users> findAllUsers();
	
	public void delete(Users users);
	
	public void update(Users users);
	
	public Users findById(int id);

}

UserServiceImpl

package com.test.service.impl;

import java.util.List;

import com.test.bean.Users;
import com.test.dao.UserDAO;
import com.test.service.UserService;

public class UserServiceImpl implements UserService {

	private UserDAO userDao;

	public UserDAO getUserDao() {
		return userDao;
	}

	public void setUserDao(UserDAO userDao) {
		this.userDao = userDao;
	}

	
	
	
	public void save(Users users) {
		this.userDao.saveUsers(users); //finish the really business logic.
	}

	public List<Users> findAllUsers() {
		return this.userDao.findAllUsers();
	}

	public void delete(Users users) {
		this.userDao.removeUser(users);
	}

	public void update(Users users) {
		this.userDao.updateUsers(users);
	}

	public Users findById(int id) {
		return this.userDao.findUsersById(id);
	}

}

ListUserAction

package com.test.action.user;

import java.util.Map;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.test.service.UserService;

public class ListUserAction extends ActionSupport {
	
	private UserService service;

	public UserService getService() {
		return service;
	}

	public void setService(UserService service) {
		this.service = service;
	}
	
	
	@Override
	public String execute() throws Exception {
		Map request=(Map) ActionContext.getContext().get("request"); 
		request.put("list", this.service.findAllUsers());
		
		return SUCCESS;
	}
	

}

SaveUserAction

package com.test.action.user;

import com.opensymphony.xwork2.ActionSupport;
import com.test.bean.Users;
import com.test.service.UserService;

public class SaveUserAction extends ActionSupport {
	
	private Users users;
	private UserService service;

	public UserService getService() {
		return service;
	}

	public void setService(UserService service) {
		this.service = service;
	}

	public Users getUsers() {
		return users;
	}

	public void setUsers(Users users) {
		this.users = users;
	}
	
	

	@Override
	public String execute() throws Exception {
		this.service.save(users);
		return SUCCESS;
	}

}

DeleteUserAction

package com.test.action.user;

import com.opensymphony.xwork2.ActionSupport;
import com.sun.org.apache.regexp.internal.recompile;
import com.test.bean.Users;
import com.test.service.UserService;

public class DeleteUserAction extends ActionSupport {

	private Users users;
	private UserService service;

	public Users getUsers() {
		return users;
	}

	public void setUsers(Users users) {
		this.users = users;
	}

	public UserService getService() {
		return service;
	}

	public void setService(UserService service) {
		this.service = service;
	}

	@Override
	public String execute() throws Exception {
		this.service.delete(users);
		return SUCCESS;
	}

}

ShowBeforeUpdateAction

package com.test.action.user;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.test.bean.Users;
import com.test.service.UserService;

public class ShowBeforeUpdateAction extends ActionSupport {
	
	private Users users;
	private UserService service;
	
	public Users getUsers() {
		return users;
	}
	public void setUsers(Users users) {
		this.users = users;
	}
	public UserService getService() {
		return service;
	}
	public void setService(UserService service) {
		this.service = service;
	}
	
	@Override
	public String execute() throws Exception {
		this.users=this.service.findById(users.getId());
		
		return SUCCESS;
	}
}

UpdateUsersAction

package com.test.action.user;

import com.opensymphony.xwork2.ActionSupport;
import com.test.bean.Users;
import com.test.service.UserService;

public class UpdateUsersAction extends ActionSupport {
	private Users users;
	private UserService service;
	
	public Users getUsers() {
		return users;
	}
	public void setUsers(Users users) {
		this.users = users;
	}
	public UserService getService() {
		return service;
	}
	public void setService(UserService service) {
		this.service = service;
	}
 
	@Override
	public String execute() throws Exception {
		
		this.service.update(users);
		return SUCCESS;
	}

}

struts.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>
	<package name="ssh" extends="struts-default">
		<!-- 处理防止表单重复提交方式：1用重定向，2.令牌-->
		<action name="saveUsers" class="saveUserAction">
			<result name="success" type="redirect">listUser.action</result>
		</action>
		
		<action name="listUser" class="listUserAction">
			<result name="success">/list.jsp</result>
		</action>
		
		<action name="deleteUsers" class="removeUserAction">
			<result name="success" type="chain">listUser</result>
		</action>
		
		
		<!-- Show the information before update. -->
		<action name="showBeforeUpdate" class="showBeforeUpdateAction">
			<result name="success">/update.jsp</result>
		</action>
		
		<!-- Execute the really update -->
		<action name="updateUsers" class="updateUserAction">
			<result name="success" type="redirect">listUser</result>
		</action>
		
	</package>

</struts>    

applicationContext.xml

<?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"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">


	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
		<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
		<property name="username" value="system"></property>
		<property name="password" value="orcl"></property>
	</bean>

	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>

		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>

		<property name="mappingResources">
			<list>
				<value>com/test/bean/Users.hbm.xml</value>
			</list>
		</property>
	</bean>

	<!-- 配置dao -->
	<bean id="userDao" class="com.test.dao.impl.UserDAOImpl" scope="singleton">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>
	
	<!-- 配置service -->
	<bean id="userService" class="com.test.service.impl.UserServiceImpl">
		<property name="userDao" ref="userDao"></property>
	</bean>
	
	<!-- 配置action  若scope不是配置为prototype，错误！ -->
	<bean id="saveUserAction" class="com.test.action.user.SaveUserAction" scope="prototype">
		<property name="service" ref="userService"></property>
	</bean>
	
	<bean id="listUserAction" class="com.test.action.user.ListUserAction" scope="prototype">
		<property name="service" ref="userService"></property>
	</bean>

	<bean id="removeUserAction" class="com.test.action.user.DeleteUserAction" scope="prototype">
		<property name="service" ref="userService"></property>
	</bean>
	
	
	<!-- Show the information before update. -->
	<bean id="showBeforeUpdateAction" class="com.test.action.user.ShowBeforeUpdateAction">
		<property name="service" ref="userService"></property>
	</bean>
	
	<!-- Executed the update. -->
	<bean id="updateUserAction" class="com.test.action.user.UpdateUsersAction" scope="prototype">
		<property name="service" ref="userService"></property>
	</bean>

</beans>

Spring Explorer

index.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>index Page</title>
    <style type="text/css">
    	#main{border: 1px black solid; width: 300px; margin-left: 25%; padding-left: 60px; height: 200px;}
    </style>
  </head>
  
  <body>
	<div id="main">
		 <h1><font color="red">Operation List</font></h1>
		 <ul>
		 	<li><s:a href="save.jsp">Save Users</s:a></li><br>
		 	<li><s:a href="listUser.action">List Users</s:a></li>
		 </ul>
	</div>
  </body>
</html>

save.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>Save Page.</title>
    <style type="text/css">
    	#main{border: 1px black solid; width: 300px; margin-left: 25%; padding-left: 60px;}
    </style>
  </head>
  
  <body>
	<div id="main">
		<h1><font color="red">Save Users</font></h1>
		<s:form action="saveUsers">
			<s:textfield name="users.firstname" label="fist name"></s:textfield>
			<s:textfield name="users.lastname" label="last name"></s:textfield>
			<s:textfield name="users.age" label="age"></s:textfield>
			<s:submit value="submit"></s:submit>
		</s:form>
	</div>
  </body>
</html>

list.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>List information Page.</title>
    <style type="text/css">
    	table {border-collapse: collapse; width: 70%; text-align: center; font-size: 12px;}
    	.ti{color: red;}
    	.th{background: #CCCCCC; font-size: 14px;}
    	#mian{margin-left: 25%;}
    </style>
    
    <script type="text/javascript">
    	 function del(){
    		 if(confirm("Are you sure?")){
    			 return true;
    		 }
    		 return false;
    	 }
    </script>
  </head>
  
  <body>
	<div id="mian">
		<h1 class="ti">Users List</h1> 
		<table border="1">
			<font class="ta"><s:a href="index.jsp"> back</s:a></font>
			<tr class="th">
				<td>ID</td>
				<td>First Name</td>
				<td>Last Name</td>
				<td>Age</td>
				<td>Operation</td>
			</tr>
			
			<s:iterator value="#request.list" id="us">
				<tr>
					<td><s:property value="#us.id"/></td>
					<td><s:property value="#us.firstname"/></td>
					<td><s:property value="#us.lastname"/></td>
					<td><s:property value="#us.age"/></td>
					<td>
						<s:a href="showBeforeUpdate.action?users.id=%{#us.id}">Update</s:a>      
						<s:a href="deleteUsers.action?users.id=%{#us.id}" οnclick="return del()">Delete</s:a>
					</td> 
				</tr>
			</s:iterator>
		</table>
	</div>	
  </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>Update Page.</title>
    <style type="text/css">
    	table {border-collapse: collapse; text-align: center; font-size: 12px; }
    	.ti{color: red;}
    	#main{border: 1px black solid; width: 300px; margin-left: 25%; padding-left: 60px;}
    </style>
  </head>
  
  <body>
    <div id="main">
    	<h1 class="ti">Update users</h1>
	    <s:form action="updateUsers.action">
	    	 <table border="0">
	    	 	<tr>
	    	 		<%--<td><s:hidden name="users.id"  value="%{users.id}"></s:hidden></td>--%>
	    	 		<td><s:textfield label="ID" name="users.id" value="%{users.id}" readonly="true"></s:textfield></td>
	    	 	</tr>
	    	 	
	    	 	<tr>
	    	 		<td><s:textfield label="firstname" name="users.firstname" value="%{users.firstname}"></s:textfield></td>
	    	 	</tr>
	    	 	
	    	 	<tr>
	    	 		<td><s:textfield label="lastname" name="users.lastname" value="%{users.lastname}"></s:textfield></td>
	    	 	</tr>
	    	 	
	    	 	<tr>
	    	 		<td><s:textfield label="age" name="users.age" value="%{users.age}"></s:textfield></td>
	    	 	</tr>
	    	 	
	    	 	<s:submit value="Update Now"></s:submit>
	    	 </table>
	    </s:form>
    </div>
  </body>
</html>