SSH增删查改功能（人力资源管理系统）

一、准备工作
开发环境：MyEclipse6.0 +JDK6.0+Tomcat5.0+SQLServer
struts2+Spring2.0.6+Hibernate3.1。本示例通过对一个人力资源的系统，提供基本的增加、删除、修改、查询等功能。更详细请看附件：SSH增删查改详解。
二、建立数据库

三、建立数据化持久层
建立Hibernate逆向工程
1、建立实体类Employee及Employee.hbm.xml映射文件。
Employee.java

package com.fejd.companyrm.model;

/**
 * Employee entity.
 * 
 * @author MyEclipse Persistence Tools
 */

public class Employee implements java.io.Serializable {

	private Long id;
	private String name;
	private String address;
	private String phone;

	// Constructors

	/** default constructor */
	public Employee() {
	}

	/** full constructor */
	public Employee(String name, String address, String phone) {
		this.name = name;
		this.address = address;
		this.phone = phone;
	}

	// Property accessors

	public Long getId() {
		return this.id;
	}

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

	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getAddress() {
		return this.address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getPhone() {
		return this.phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

}

2、把实体类Employee的属性映射到Employee表，生成下面的Employee.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.fejd.companyrm.model.Employee" table="Employee" schema="dbo" catalog="CompanyRM">
        <id name="id" type="java.lang.Long">
            <column name="ID" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="Name" length="50" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="Address" length="50" />
        </property>
        <property name="phone" type="java.lang.String">
            <column name="Phone" length="50" />
        </property>
    </class>
</hibernate-mapping>


四、建立DAO层 

1、建立DAO的接口类：EmployeeDao

package com.fejd.companyrm.dao;

import java.util.List;

import com.fejd.companyrm.model.Employee;

public interface EmployeeDao {

	public void add(Employee e);//添加新雇员
	public Employee getEmployee(Long id);//根据雇员的ID显示雇员的所有信息
	public List getEmployees();//显示所有雇员信息
	public void delete(Long id);//根据雇员ID删除雇员
	public void saveOrUpdate(Employee e);//根据雇员ID，修改或更新某个雇员信息
	public List getEmployee(String name,String phone);//判断是否为合法雇员
}


2、实现此接口的类文件，EmployeeDaoImpl

package com.fejd.companyrm.dao.impl;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.fejd.companyrm.dao.EmployeeDao;
import com.fejd.companyrm.model.Employee;

public class EmployeeDaoImpl extends HibernateDaoSupport implements EmployeeDao {

	private SessionFactory sessionFactory;
	public SessionFactory getFactory() {

		return sessionFactory;//hibernate　SessionFactory对象，由spring注入．
	}

	public void setFactory(SessionFactory sessionFactory) {

		this.sessionFactory = sessionFactory;//get/set方法在spring注入时使用
	}
	public void add(Employee e) {
/**
      * 函数说明：添加雇员
      * 参数说明：对象 
      * 返回值：
      */

		this.getHibernateTemplate().save(e);
	}

	public void delete(Long id) {
/**
      * 函数说明：删除雇员
      * 参数说明： 对象
      * 返回值：
      */

	this.getHibernateTemplate().delete(this.getEmployee(id));
	}
	public Employee getEmployee(Long id) {
		 /**
      * 函数说明：获得一个雇员的所有信息
      * 参数说明： ID
      * 返回值：对象
      */

		return (Employee)this.getHibernateTemplate().get(Employee.class, id);
	}
	public List getEmployees() {
		/**
      * 函数说明：获得所有雇员的信息
      * 参数说明： 
      * 返回值：信息的集合
      */

		return this.getHibernateTemplate().find("from Employee");
	}
	public List getEmployee(String name,String phone){
		Object o[]={name,phone};
		System.out.println("查询的结果是："+name+phone);
		return this.getHibernateTemplate().find("select employee from Employee as employee where employee.name=? and employee.phone=?",o);
		
	}
	public void saveOrUpdate(Employee e) {
/**
      * 函数说明：修改雇员信息
      * 参数说明： 对象
      * 返回值：
      */

		this.getHibernateTemplate().saveOrUpdate(e);
	}
}


五、建立业务逻辑层

注明：在业务逻辑层需要认真思考每个业务逻辑所能用到的持久层对象和DAO。DAO层之上是业务逻辑层，DAO类可以有很多个，但业务逻辑类应该只有一个，可以在业务逻辑类中调用各个DAO类进行操作。

1、创建服务接口类EmployeeManager

package com.fejd.companyrm.service;

import java.util.List;

import com.fejd.companyrm.model.Employee;

public interface EmployeeManager {
	public void addEmployee(Employee e);//增加雇员
	public List listEmployee();//获得雇员的集合
	public void deletEmployee(Long id);//删除雇员
	public void savaOrUpdate(Employee e);//修改雇员
	public Employee getEmployee(String name,String phone);//根据雇员的某个记录查询雇员信息
	public Employee ggetEmployee(Long id);//根据ID查询雇员，实现修改操作
}


2、实现此接口类：EmployeeManagerImpl

package com.fejd.companyrm.service.impl;

import java.util.List;

import com.fejd.companyrm.dao.EmployeeDao;
import com.fejd.companyrm.model.Employee;
import com.fejd.companyrm.service.EmployeeManager;

public class EmployeeManagerImpl implements EmployeeManager {

	private EmployeeDao employeeDao;
	public void setEmployeeDao(EmployeeDao employeeDao) {
		this.employeeDao = employeeDao;
	}
	public void addEmployee(Employee e) {
 /**
      * 函数说明：添加雇员
      * 参数说明：对象 
      * 返回值：
      */

		this.employeeDao.add(e);
	}
	public void deletEmployee(Long id) {
/**
      * 函数说明：删除雇员
      * 参数说明： 对象
      * 返回值：
      */

		this.employeeDao.delete(id);
	}
	public List listEmployee() {
		 /**
      * 函数说明：获得所有雇员的信息
      * 参数说明： 
      * 返回值：信息的集合
      */

		return this.employeeDao.getEmployees();
	}
	public Employee getEmployee(String name,String phone) {
		List list=employeeDao.getEmployee(name,phone);
		if(list!=null&&list.size()==1){
			System.out.println("查询的结果是："+name+phone);
			return (Employee)list.get(0);
		}
		else
		return null;
	}
	public void savaOrUpdate(Employee e) {
/**
      * 函数说明：修改雇员信息
      * 参数说明： 对象
      * 返回值：
      */

	employeeDao.saveOrUpdate(e);
	}
	public Employee ggetEmployee(Long id) {
 /**
      * 函数说明：获得一个雇员的信息
      * 参数说明： ID
      * 返回值：对象
      */

		return employeeDao.getEmployee(id);
	}

}


六、创建Action类：EmployeeAction.java：

package com.fejd.companyrm.action;

import java.util.List;

import com.fejd.companyrm.model.Employee;
import com.fejd.companyrm.service.EmployeeManager;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public class Employee Action extends ActionSupport implements ModelDriven{

	private EmployeeManager employeeManager;
	private List employees;
	private Employee employee;
	private Long id;
	public void setEmployeeManager(EmployeeManager employeeManager) {
		this.employeeManager = employeeManager;
	}
	public String add(){
		employeeManager.addEmployee(employee);
		return SUCCESS;
	}
	public String list(){
		this.employees=employeeManager.listEmployee();
		return SUCCESS;
	}
	public String delete(){
		employeeManager.deletEmployee(id);
		return SUCCESS;
	}
	public String saveOrUpdate(){
		employeeManager.savaOrUpdate(employee);
		return SUCCESS;
	}
	public String edit(){
		employee=employeeManager.ggetEmployee(id);
		return SUCCESS;
		
	}
	public String save(){
		Long id=this.getEmployee().getId();
		employee=employeeManager.ggetEmployee(id);
		return SUCCESS;
	}
	public String update(){
		Long id=this.getEmployee().getId();
		employeeManager.savaOrUpdate(this.getEmployee());
		return SUCCESS;
	}
	public Employee getEmployee() {
		return employee;
	}

	public void setEmployee(Employee employee) {
		this.employee = employee;
	}
	public List getEmployees() {
		return employees;
	}
	public void setEmployees(List employees) {
		this.employees = employees;
	}
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public Employee getModel() {
		
		return employee;
	}
}




七、Web页面

1、主页面：index.jsp，其代码如下

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<html>
  <head>
  </head>
  <body>
  <center><h1>人力资源管理系统</h1></center>
  <hr color="red">
  <center>
  <a href="add.jsp">雇员登记</a>
    <a href="list.action">显示用户列表</a>
  </center>
  </body>
</html>


2、增加页面add.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<html>
  <head>
  <title>add.jsp</title>
  <!-- 增加雇员信息页面 -->
  </head>
  
  <body>
  请输入雇员信息：
  <s:form action="add">
  <s:textfield name="employee.name" label="姓名"></s:textfield>
  <s:textfield name="employee.address" label="地址"></s:textfield>
  <s:textfield name="employee.phone" label="电话"></s:textfield>
  <s:submit></s:submit>
  </s:form>
  </body>
</html>


3、列表页面：list.jsp

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib uri="/struts-tags" prefix="s"%>
<html>
  <head>
    <title>list.jsp</title>
    <!-- 显示用户列表页面 -->
  </head>
  
  <body>
  输出雇员的信息：<br />
  <s:iterator value="employees">
    <table>
    <tr><td>编号：</td><td><s:property value="id"/></td></tr>
    <tr><td>姓名：</td><td><s:property value="name" /></td></tr>
    <tr><td>地址：</td><td><s:property value="address"/></td></tr>
    <tr><td>电话：</td><td><s:property value="phone"/></td></tr>
    <tr><td align="center">
    <a href="edit.action?id=<s:property value='id' /> ">更新</a></td>
    
    <td align="center">
   
     <a href='<s:url action="delete"><s:param name="id" value="id"></s:param></s:url>'>删除</a>
    
    </td>
   </tr>
    </table>
    </s:iterator>
  </body>
</html>


注明：

(1)、<s:property> :得到'value'的属性,如果value没提供,默认为堆栈顶端的元素。其相关的参数及使用如下表所示：

名称	必需	默认	类型	描述

default	否		String	如果属性是null则显示的default值

escape	否	true	Booelean	是否escape HTML

value	否	栈顶	Object	要显示的值

id	否		Object/String	用来标识元素的id。在UI和表单中为HTML的id属性

(2)、<s:Iterator>：用于遍历集合（java.util.Collection）或枚举值（java.util.Iterator）。其相关的参数及使用如下表所示：  

名称	必需	默认	类型	描述

status	否		String	如果设置此参数，一个IteratorStatus的实例将会压入每个遍历的堆栈

value	否		Object/String	要遍历的可枚举的（iteratable）数据源，或者将放入新列表（List）的对象

id	否		Object/String	用来标识元素的id。在UI和表单中为HTML的id属性

(3)、<s:param>:为其他标签提供参数,比如include标签和bean标签. 参数的name属性是可选的,如果提供，会调用Component的方法addParameter(String, Object), 如果不提供，则外层嵌套标签必须实现UnnamedParametric接口(如TextTag)。 value的提供有两种方式,通过value属性或者标签中间的text,不同之处我们看一下例子:

<param name="color">blue</param><!-- (A) -->

<param name="color" value="blue"/><!-- (B) -->

(A)参数值会以String的格式放入statck. 

(B)该值会以java.lang.Object的格式放入statck.

4、修改页面：update.jsp

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib uri="/struts-tags" prefix="s"%>
<html>
  <head>
   
  </head>
  
  <body>
  
   <s:form action="update.action" method="post">
   <s:hidden name="employee.id"></s:hidden>
   <s:textfield name="employee.name" label="用户名"></s:textfield>
   <s:textfield name="employee.address" label="地址"></s:textfield>
   <s:textfield name="employee.phone" label="电话"></s:textfield>
   <s:submit></s:submit>
   </s:form>
  </body>
</html>




八、配置信息：

1、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>
    <constant name="struts.objectFactory" value="spring" />
   
    <package name="struts2" extends="struts-default">
    <action name="add" class="addBean" method="add">
    <result type="redirect">list.action</result>
    </action>
    <action name="list" class="listBean" method="list">
    <result>/list.jsp</result>
    </action>
    <action name="delete" class="deleteBean" method="delete">
    <result type="redirect">list.action</result>
    </action>
    <action name="update" class="updateBean" method="saveOrUpdate">
    <result type="redirect">list.action</result>
    <result name="input">/update.jsp</result>
    <result name="error">/error.jsp</result>
    </action>
    
    <action name="edit" class="editBean" method="edit">
    <result>/update.jsp</result>
    </action>
    
    <action name="login" class="loginBean" method="login">
    <result>/add.jsp</result>
    <result name="error">/login.jsp</result>
    </action>
    </package>
</struts>


2、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"

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

		<property name="driverClassName"

			value="com.microsoft.jdbc.sqlserver.SQLServerDriver">

		</property>

		<property name="url"

			value="jdbc:microsoft:sqlserver://localhost:1433">

		</property>

		<property name="username" value="sa"></property>

		<property name="password" value="sa"></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.SQLServerDialect

				</prop>

			</props>

		</property>

		<property name="mappingResources">

			<list>

				<value>com/fejd/companyrm/model/Employee.hbm.xml</value></list>

		</property></bean>

	<bean id="employeeDao"

		class="com.fejd.companyrm.dao.impl.EmployeeDaoImpl" abstract="false"

		lazy-init="default" autowire="default" dependency-check="default">

		<property name="sessionFactory">

			<ref bean="sessionFactory" />

		</property>

	</bean>

	<bean id="employeeManager"

		class="com.fejd.companyrm.service.impl.EmployeeManagerImpl"

		abstract="false" lazy-init="default" autowire="default"

		dependency-check="default">

		<property name="employeeDao">

			<ref bean="employeeDao" />

		</property>

	</bean>

	<bean id="addBean" class="com.fejd.companyrm.action.EmployeeAction"  scope="prototype">

		<property name="employeeManager">

			<ref bean="employeeManager" />

		</property>

	</bean>

	<bean id="deleteBean" class="com.fejd.companyrm.action.EmployeeAction"  scope="prototype">

		<property name="employeeManager">

			<ref bean="employeeManager" />

		</property>

	</bean>

	<bean id="listBean" class="com.fejd.companyrm.action.EmployeeAction"  scope="prototype">

		<property name="employeeManager">

			<ref bean="employeeManager" />

		</property>

	</bean>

	<bean id="updateBean" class="com.fejd.companyrm.action.EmployeeAction"  scope="prototype">

		<property name="employeeManager">

			<ref bean="employeeManager" />

		</property>

	</bean>

	

	<bean id="editBean" class="com.fejd.companyrm.action.EmployeeAction" scope="prototype">

	<property name="employeeManager">

	<ref bean="employeeManager"/>

	</property>

	</bean>

	

	<bean id="loginBean" class="com.fejd.companyrm.action.EmployeeAction"  scope="prototype">

		<property name="employeeManager">

			<ref bean="employeeManager" />

		</property>

	</bean>

</beans>

3、web.xml
<?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">
 
  <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>
  <listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

引用

含附件，导入项目即可