基于ssh框架的员工管理系统

10 篇文章 0 订阅
5 篇文章 0 订阅

 

前台页面及功能:

1.注册员工,管理员(默认为未审核状态,由后台管理员审核后则成为真正的员工和管理员)

2.员工登录(登录后进入员工页面,员工又可查询或更改自己可更改的信息,此页面只有员工登录后可以进入)

3.管理员登录(登录后进入后台)

后台页面及功能:

 

项目结构:

导包:

 

主要代码:

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:web="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" id="WebApp_9" version="2.4">
  <display-name>Struts Blank</display-name>
  <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>
  
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:bean.xml</param-value>
  </context-param>
  <!-- 自己定义的filter -->
	<filter>
		<filter-name>LoginFilter</filter-name>
		<filter-class>cn.xxs.filter.LoginFilter</filter-class>
	</filter>
	
	<filter-mapping>
		<filter-name>LoginFilter</filter-name>
		<url-pattern>*.jsp</url-pattern>
	</filter-mapping>

  <!-- <filter>
    <filter-name>CharacterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>  -->
</web-app>

bean.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:aop="http://www.springframework.org/schema/aop" 
    xmlns:context="http://www.springframework.org/schema/context"  
    xmlns:tx="http://www.springframework.org/schema/tx"       
    xsi:schemaLocation="
    http://www.springframework.org/schema/beans  
        http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-4.3.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
        ">    
     
     <!-- 开启注解驱动 -->
     <context:annotation-config />
     <!-- 开启组件扫描 -->
     <context:component-scan base-package="cn.xxs"/>
         
     <!-- 加载jdbc配置文件 -->
     <bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations" value="classpath:jdbc.properties" />	
	</bean>
     
     <!-- 配置数据源
     		destroy-method:关闭数据库连接时,它自动销毁连接
      -->
     <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    
	<!-- 配置sessionFactory,把myDataSource注入给下面这个类 -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <!-- 把myDataSource注入到LocalSessionFactoryBean中 -->
        <property name="dataSource" ref="myDataSource"/>
        
        <!-- 注解方法 -->
        <property name="packagesToScan" value="cn.xxs"></property>
        
        <!-- hibernate其他配置 -->
        <property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
			</props>
		</property>

    </bean>
    
    <!-- 配置事务 -->
    <bean id="txManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
    	<property name="sessionFactory" ref="sessionFactory"/>
	</bean>
	<!-- 声明事务 -->
	<tx:advice id="txAdvice" transaction-manager="txManager">        
        <tx:attributes>          
            <tx:method name="get*" read-only="true"/>
            <tx:method name="delete*" read-only="false"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>
     <aop:config>
        <aop:pointcut id="fooServiceOperation" expression="execution(* cn.xxs.service.impl.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="fooServiceOperation"/>
    </aop:config>
    
    <!-- 配置hibernateTemplate -->
     <bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
     
     <aop:aspectj-autoproxy/>
</beans>  

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssh?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root

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>
   <package name="default"  namespace="/"  extends="struts-default,json-default">
     <!-- 配置验证用户名方法 -->
      <action name="checkUser" class="cn.xxs.action.UserAction" method="checkUser">
            <result name="success" type="json">
            	<param name="root">result</param>           	
            </result>           
      </action>
      <!-- 配置验证登录方法 -->
      <action name="checkUserLogin" class="cn.xxs.action.UserAction" method="login">
            <result name="success">/list.jsp</result>   
            <result name="error">/index.jsp</result>   
      </action>
      <action name="delete" class="cn.xxs.action.UserAction" method="delete">
            <result name="success">/back/uList.jsp</result>                 
      </action>
       
      <action name="selectAll" class="cn.xxs.action.UserAction" method="selectAll">
            <result name="success">/back/uList.jsp</result>                 
      </action>
      <action name="selectuDuty" class="cn.xxs.action.UserAction" method="selectuDuty">
            <result name="success">/back/sList.jsp </result>                 
      </action>
      <action name="select" class="cn.xxs.action.UserAction" method="select">
            <result name="success">/back/uUpdate.jsp</result>                 
      </action>
       <action name="update" class="cn.xxs.action.UserAction" method="update">
            <result name="success">/back/uList.jsp</result>
            <result name="error">/back/uUpdate.jsp</result>            
      </action>
      <action name="updateUser" class="cn.xxs.action.UserAction" method="updateUser">
            <result name="success">/list.jsp</result>
            <result name="error">/list.jsp</result>            
      </action>
      <action name="add" class="cn.xxs.action.UserAction" method="add">
            <result name="success">/back/uList.jsp</result>
            <result name="error">/back/uAdd.jsp</result>            
      </action>
      <action name="register" class="cn.xxs.action.UserAction" method="register">
            <result name="success">/index.jsp</result>
            <result name="error">/index.jsp</result>            
      </action>
      <!-- 部门 -->
      <action name="dselectAll" class="cn.xxs.action.DepartmentAction" method="selectAll">
            <result name="success">/back/dList.jsp</result>                 
      </action>
      <action name="ddelete" class="cn.xxs.action.DepartmentAction" method="delete">
            <result name="success">/back/dList.jsp</result>                 
      </action>
      <action name="dselect" class="cn.xxs.action.DepartmentAction" method="select">
            <result name="success">/back/dUpdate.jsp</result>                 
      </action>
      <action name="dupdate" class="cn.xxs.action.DepartmentAction" method="update">
            <result name="success">/back/dList.jsp</result>
            <result name="error">/back/dUpdate.jsp</result>                 
      </action>
      <action name="dadd" class="cn.xxs.action.DepartmentAction" method="add">
            <result name="success">/back/dList.jsp</result>
            <result name="error">/back/dAdd.jsp</result>                 
      </action>     
      <action name="selectDname" class="cn.xxs.action.DepartmentAction" method="selectDname">
            <result name="success">/back/dSelect.jsp</result>                            
      </action>
      <!-- 部门end -->
      
      <!-- 最高管理员 -->
      <!-- 配置验证用户名方法 -->
      <action name="checkName" class="cn.xxs.action.SystemUserAction" method="checkUser">
            <result name="success" type="json">
            	<param name="root">result</param>           	
            </result>           
      </action>
      <!-- 配置验证登录方法 -->
      <action name="checkLogin" class="cn.xxs.action.SystemUserAction" method="login">
            <result name="success">/back/backIndex.jsp</result>   
            <result name="error">/index.jsp</result>   
      </action>
      <action name="mselect" class="cn.xxs.action.SystemUserAction" method="mselect">            
            <result name="success">/back/updatePwd.jsp</result>   
      </action>
      <action name="index">            
            <result>/NewFile.jsp</result>   
      </action>
      <action name="updatePwd" class="cn.xxs.action.SystemUserAction" method="updatePwd">
            <result name="success" type="redirectAction">index</result>         
            <result name="error">/back/updatePwd.jsp</result>   
      </action>
      <!-- 最高管理员end -->
   </package>
</struts>

package cn.xxs.entity;

import java.io.Serializable;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="t_department")
public class Department implements Serializable{
	
	private static final long serialVersionUID = -2683408342420521063L;
	private Integer dId;
	private String dName;
	private String dMoney;
	private String dBonus;	
	private String dStatus;
	public Department() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Department(Integer dId, String dName, String dMoney, String dBonus, String dStatus) {
		super();
		this.dId = dId;
		this.dName = dName;
		this.dMoney = dMoney;
		this.dBonus = dBonus;
		this.dStatus = dStatus;
	}
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	public Integer getdId() {
		return dId;
	}
	public void setdId(Integer dId) {
		this.dId = dId;
	}
	public String getdName() {
		return dName;
	}
	public void setdName(String dName) {
		this.dName = dName;
	}
	public String getdMoney() {
		return dMoney;
	}
	public void setdMoney(String dMoney) {
		this.dMoney = dMoney;
	}
	public String getdBonus() {
		return dBonus;
	}
	public void setdBonus(String dBonus) {
		this.dBonus = dBonus;
	}
	public String getdStatus() {
		return dStatus;
	}
	public void setdStatus(String dStatus) {
		this.dStatus = dStatus;
	}
	@Override
	public String toString() {
		return "Department [dId=" + dId + ", dName=" + dName + ", dMoney=" + dMoney + ", dBonus=" + dBonus
				+ ", dStatus=" + dStatus + "]";
	}
	
}
package cn.xxs.entity;

import java.io.Serializable;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="t_system")
public class SystemUser implements Serializable{
	
	private static final long serialVersionUID = -1963156657701811037L;
	
	private Integer id;
	private String name;
	private String pwd;
	public SystemUser() {
		super();
		// TODO Auto-generated constructor stub
	}
	public SystemUser(Integer id, String name, String pwd) {
		super();
		this.id = id;
		this.name = name;
		this.pwd = pwd;
	}
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	@Override
	public String toString() {
		return "System [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
	}
	
}
package cn.xxs.entity;

import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="t_user")
public class User implements Serializable{
	
	private static final long serialVersionUID = -4310399242696962019L;
	
	private Integer uId;
	private String uName;
	private String uIdcard;
	private String uSex;	
	private String uAddress;
	private String uPhone;
	private String uCreatetime;
	private String uPicture;
	private String uDuty;
	private String uState;
	private String uDname;
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}
	public User(Integer uId, String uName, String uIdcard, String uSex, String uAddress, String uPhone,
			String uCreatetime, String uPicture, String uDuty, String uState, String uDname) {
		super();
		this.uId = uId;
		this.uName = uName;
		this.uIdcard = uIdcard;
		this.uSex = uSex;
		this.uAddress = uAddress;
		this.uPhone = uPhone;
		this.uCreatetime = uCreatetime;
		this.uPicture = uPicture;
		this.uDuty = uDuty;
		this.uState = uState;
		this.uDname = uDname;
	}
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	public Integer getuId() {
		return uId;
	}
	public void setuId(Integer uId) {
		this.uId = uId;
	}
	public String getuName() {
		return uName;
	}
	public void setuName(String uName) {
		this.uName = uName;
	}
	public String getuIdcard() {
		return uIdcard;
	}
	public void setuIdcard(String uIdcard) {
		this.uIdcard = uIdcard;
	}
	public String getuSex() {
		return uSex;
	}
	public void setuSex(String uSex) {
		this.uSex = uSex;
	}
	public String getuAddress() {
		return uAddress;
	}
	public void setuAddress(String uAddress) {
		this.uAddress = uAddress;
	}
	public String getuPhone() {
		return uPhone;
	}
	public void setuPhone(String uPhone) {
		this.uPhone = uPhone;
	}
	public String getuCreatetime() {
		return uCreatetime;
	}
	public void setuCreatetime(String uCreatetime) {
		this.uCreatetime = uCreatetime;
	}
	public String getuPicture() {
		return uPicture;
	}
	public void setuPicture(String uPicture) {
		this.uPicture = uPicture;
	}
	public String getuDuty() {
		return uDuty;
	}
	public void setuDuty(String uDuty) {
		this.uDuty = uDuty;
	}
	public String getuState() {
		return uState;
	}
	public void setuState(String uState) {
		this.uState = uState;
	}
	public String getuDname() {
		return uDname;
	}
	public void setuDname(String uDname) {
		this.uDname = uDname;
	}
	@Override
	public String toString() {
		return "User [uId=" + uId + ", uName=" + uName + ", uIdcard=" + uIdcard + ", uSex=" + uSex + ", uAddress="
				+ uAddress + ", uPhone=" + uPhone + ", uCreatetime=" + uCreatetime + ", uPicture=" + uPicture
				+ ", uDuty=" + uDuty + ", uState=" + uState + ", uDname=" + uDname + "]";
	}
	

}

dao层:

package cn.xxs.dao;

import java.util.List;

import cn.xxs.entity.Department;
import cn.xxs.entity.User;


public interface DepartmentDao {
	
	/**
	 * 查询所有
	 * @return
	 */
	public List<Department> selectAll();
	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public Department select(Integer dId);
	/**
	 * 查询
	 * @param dName
	 * @return
	 */
	public Department select(String dName);
	
	/**
	 * 删除Department
	 * @param Department
	 */
	public void delete(Department de);
	
	/**
	 * 更新Department
	 * @param Department
	 * @return
	 */	
	public boolean update(Department de);
	
	/**
	 * 添加
	 * @param Department
	 * @return
	 */
	public void add(Department de);
}
package cn.xxs.dao;

import java.util.List;

import cn.xxs.entity.SystemUser;


public interface SystemUserDao {	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public SystemUser select(Integer id);
	/**
	 * 根据用户名查询
	 * @param name
	 * @return
	 */
	public SystemUser select(String name);
	/**
	 * 
	 * 根据用戶名,密码查询	
	 * @param name
	 * @param pwd
	 * @return
	 */
	public SystemUser select(String name,String pwd);			
	
	/**
	 * 更新SystemUser
	 * @param SystemUser
	 * @return
	 */	
	public boolean update(SystemUser sys);
	
}
package cn.xxs.dao;

import java.util.List;

import cn.xxs.entity.User;

public interface UserDao {
	
	/**
	 * 查询所有
	 * @return
	 */
	public List<User> selectAll();
	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public User select(Integer uId);
	/**
	 * 根据手机号查询
	 * @param uPhone
	 * @return
	 */
	public User select(String uPhone);
	public User selectName(String uName);
	public User selectIdCard(String uIdcard);
	public List<User> selectuDuty(String uDuty);
	public List<User> selectuDname(String uDname);
	/**
	 * 
	 * 根据手机号,身份证号查询	
	 * @param uPhone
	 * @param uIdcard
	 * @return
	 */
	public User select(String uPhone,String uIdcard);		
	
	/**
	 * 删除user
	 * @param user
	 */
	public void delete(User user);
	
	/**
	 * 更新user
	 * @param user
	 * @return
	 */	
	public boolean update(User user);
	
	/**
	 * 添加user
	 * @param user
	 * @return
	 */
	public void add(User user);
}
package cn.xxs.dao.impl;

import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;

import cn.xxs.dao.DepartmentDao;
import cn.xxs.entity.Department;

/**
 * 
 * @author xxs
 *
 */
@Repository
public class DepartmentDaoImpl implements DepartmentDao{
	@Resource
	private SessionFactory sessionFactory;
	
	@Resource
	private HibernateTemplate hibernateTemplate;
	
	/**
	 * 查询	所有
	 */
	@Override
	public List<Department> selectAll() {
		List<Department> list = (List<Department>) hibernateTemplate.find("from Department");
		return list;
	}
	
	/**
	 * 查询	
	 */	
	@Override
	public Department select(Integer dId) {		
		Department d = hibernateTemplate.get(Department.class, dId);
		return d;
	}		

	@Override
	public void delete(Department de) {
		hibernateTemplate.delete(de);
		
	}

	@Override
	public boolean update(Department de) {
		Department d=(Department)hibernateTemplate.find("from Department d where d.dId =?",de.getdId()).get(0);		
		//更改数据
		 d.setdName(de.getdName());
		 d.setdMoney(de.getdMoney());
		 d.setdBonus(de.getdBonus());
		 d.setdStatus(de.getdStatus());
		 hibernateTemplate.update(d);		
		return  true;
	}

	@Override
	public void add(Department de) {						
			 hibernateTemplate.save(de);			
	}

	@Override
	public Department select(String dName) {		
		List<Department> list = (List<Department>) hibernateTemplate.find("from Department where dName=?",dName);
		return list.size()==0? null:list.get(0);	
	}		
}
package cn.xxs.dao.impl;

import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;

import cn.xxs.dao.SystemUserDao;
import cn.xxs.entity.SystemUser;

/**
 * 
 * @author xxs
 *
 */
@Repository
public class SystemUserDaoImpl implements SystemUserDao{
	@Resource
	private SessionFactory sessionFactory;
	
	@Resource
	private HibernateTemplate hibernateTemplate;
	
	/**
	 * 查询	
	 */	
	@Override
	public SystemUser select(Integer id) {		
		SystemUser u = hibernateTemplate.get(SystemUser.class, id);
		return u;
	}
	
	/**
	 * 根据用户名查询
	 */
	@Override
	public SystemUser select(String name) {
		List<SystemUser> list = (List<SystemUser>) hibernateTemplate.find("from SystemUser where name=?",name);
		return list.size()==0? null:list.get(0);				
	}
	
	/**
	 * 根据用户名密码查询
	 */
	@Override
	public SystemUser select(String name,String pwd) {
		List<SystemUser> list = (List<SystemUser>) hibernateTemplate.find("from SystemUser where name=? and pwd=?",name,pwd);
		return list.size()==0? null:list.get(0);				
	}
	



	@Override
	public boolean update(SystemUser sys) {
		SystemUser u=(SystemUser)hibernateTemplate.find("from SystemUser u where u.id =?",sys.getId()).get(0);		
		//更改
		u.setName(sys.getName());
		u.setPwd(sys.getPwd());
		hibernateTemplate.update(u);		
		return  true;
	}	
}
package cn.xxs.dao.impl;

import java.util.ArrayList;
import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;

import cn.xxs.dao.UserDao;
import cn.xxs.entity.User;
/**
 * 
 * @author xxs
 *
 */
@Repository
public class UserDaoImpl implements UserDao{
	@Resource
	private SessionFactory sessionFactory;
	
	@Resource
	private HibernateTemplate hibernateTemplate;
	
	/**
	 * 查询	所有
	 */
	@Override
	public List<User> selectAll() {
		List<User> list = (List<User>) hibernateTemplate.find("from User");
		return list;
	}
	
	/**
	 * 查询	
	 */	
	@Override
	public User select(Integer uId) {		
		User u = hibernateTemplate.get(User.class, uId);
		return u;
	}
	
	/**
	 * 根据手机号查询
	 */
	@Override
	public User select(String uPhone) {
		List<User> list = (List<User>) hibernateTemplate.find("from User where uPhone=?",uPhone);
		return list.size()==0? null:list.get(0);				
	}
	
	/**
	 * 根据手机号,身份证号查询
	 */
	@Override
	public User select(String uPhone, String uIdcard) {
		List<User> list = (List<User>) hibernateTemplate.find("from User where uPhone=? and uIdcard=?",uPhone,uIdcard);
		return list.size()==0? null:list.get(0);
	}

	@Override
	public void delete(User user) {
		hibernateTemplate.delete(user);
		
	}	

	@Override
	public boolean update(User user) {
		User u=(User)hibernateTemplate.find("from User u where u.uId =?",user.getuId()).get(0);		

		//更改数据
		u.setuName(user.getuName());
		u.setuIdcard(user.getuIdcard());
		u.setuSex(user.getuSex());
		u.setuAddress(user.getuAddress());
		u.setuPhone(user.getuPhone());
		u.setuCreatetime(user.getuCreatetime());
		u.setuPicture(user.getuPicture());
		u.setuDuty(user.getuDuty());
		u.setuState(user.getuState());
		u.setuDname(user.getuDname());			 
		 hibernateTemplate.update(u);		
		return  true;
	}	
	
	@Override
	public void add(User user) {		
		 hibernateTemplate.save(user);
	}

	@Override
	public User selectName(String uName) {
		List<User> list = (List<User>) hibernateTemplate.find("from User where uName=?",uName);
		return list.size()==0? null:list.get(0);			
	}

	@Override
	public User selectIdCard(String uIdcard) {
		List<User> list = (List<User>) hibernateTemplate.find("from User where uIdcard=?",uIdcard);
		return list.size()==0? null:list.get(0);		
	}

	@Override
	public List<User> selectuDuty(String uDuty) {		
		List<User> list = (List<User>) hibernateTemplate.find("from User where uDuty=?",uDuty);
		return list.size()==0? new ArrayList<>():list;	
	}

	@Override
	public List<User> selectuDname(String uDname) {
		List<User> list = (List<User>) hibernateTemplate.find("from User where uDname=?",uDname);
		return list.size()==0? new ArrayList<>():list;	
	}
}

service层:

package cn.xxs.service;

import java.util.List;

import cn.xxs.entity.Department;


public interface DepartmentService {
	
	/**
	 * 查询所有
	 * @return
	 */
	public List<Department> selectAll();
	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public Department select(Integer dId);
	/**
	 * 查询
	 * @param dName
	 * @return
	 */
	public Department select(String dName);
	/**
	 * 删除Department
	 * @param Department
	 */
	public void delete(Department de);
	
	/**
	 * 更新Department
	 * @param Department
	 * @return
	 */	
	public boolean update(Department de);
	
	/**
	 * 添加
	 * @param Department
	 * @return
	 */
	public void add(Department de);
}
package cn.xxs.service;

import java.util.List;

import cn.xxs.entity.SystemUser;


public interface SystemUserService {	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public SystemUser select(Integer id);
	/**
	 * 根据用户名查询
	 * @param name
	 * @return
	 */
	public SystemUser select(String name);
	/**
	 * 
	 * 根据用戶名,密码查询	
	 * @param name
	 * @param pwd
	 * @return
	 */
	public SystemUser select(String name,String pwd);			
	
	/**
	 * 更新SystemUser
	 * @param SystemUser
	 * @return
	 */	
	public boolean update(SystemUser sys);
	
}
package cn.xxs.service;

import java.util.List;

import cn.xxs.entity.User;

public interface UserService {
	
	/**
	 * 查询所有
	 * @return
	 */
	public List<User> selectAll();
	
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	public User select(Integer uId);
	public User selectName(String uName);
	public User selectIdCard(String uIdcard);
	public List<User> selectuDuty(String uDuty);
	public List<User> selectuDname(String uDname);
	/**
	 * 根据手机号查询
	 * @param uPhone
	 * @return
	 */
	public User select(String uPhone);
	/**
	 * 
	 * 根据手机号,身份证号查询	
	 * @param uPhone
	 * @param uIdcard
	 * @return
	 */
	public User select(String uPhone,String uIdcard);
	
	
	/**
	 * 删除user
	 * @param user
	 */
	public void delete(User user);
	
	/**
	 * 更新user
	 * @param user
	 * @return
	 */
	public boolean update(User user);
	
	/**
	 * 添加
	 * @param user
	 * @return
	 */
	public void add(User user);
}
package cn.xxs.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

import cn.xxs.dao.DepartmentDao;
import cn.xxs.entity.Department;
import cn.xxs.service.DepartmentService;


/**
 * 
 * @author xxs
 *
 */
@Service("departmentService")
public class DepartmentServiceImpl implements DepartmentService{
	@Resource
	private DepartmentDao departmentDao;
	
	/**
	 * 查询	所有
	 */
	@Override
	public List<Department> selectAll() {		
		return departmentDao.selectAll();
	}

	/**
	 * 查询	
	 */
	@Override
	public Department select(Integer dId) {		
		return departmentDao.select(dId);
	}
	
	/**
	 * 删除Department	 
	 */
	@Override
	public void delete(Department de) {
		
		departmentDao.delete(de);
	}

	
	@Override
	public boolean update(Department de) {
		
		return departmentDao.update(de);
	}

	@Override
	public void add(Department de) {
		departmentDao.add(de);
	}

	@Override
	public Department select(String dName) {
		
		return departmentDao.select(dName);
	}	
}
package cn.xxs.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import cn.xxs.dao.SystemUserDao;
import cn.xxs.entity.SystemUser;
import cn.xxs.service.SystemUserService;

@Service("systemUserService")
public class SystemUserServiceImpl implements SystemUserService{
	@Resource
	private SystemUserDao systemUserDao;
	/**
	 * 查询
	 * @param id
	 * @return
	 */
	@Override
	public SystemUser select(Integer id) {		
		return systemUserDao.select(id);
	}
	/**
	 * 根据用户名查询
	 * @param name
	 * @return
	 */
	@Override
	public SystemUser select(String name) {		
		return systemUserDao.select(name);
	}
	/**
	 * 
	 * 根据用戶名,密码查询	
	 * @param name
	 * @param pwd
	 * @return
	 */
	@Override
	public SystemUser select(String name, String pwd) {		
		return systemUserDao.select(name, pwd);
	}
	
	/**
	 * 更新SystemUser
	 * @param SystemUser
	 * @return
	 */	
	@Override
	public boolean update(SystemUser sys) {
		
		return systemUserDao.update(sys);
	}

}
package cn.xxs.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

import cn.xxs.dao.UserDao;
import cn.xxs.entity.User;
import cn.xxs.service.UserService;

/**
 * 
 * @author xxs
 *
 */
@Service("userService")
public class UserServiceImpl implements UserService{
	@Resource
	private UserDao userDao;
	
	/**
	 * 查询	所有
	 */
	@Override
	public List<User> selectAll() {		
		return userDao.selectAll();
	}

	/**
	 * 查询	
	 */
	@Override
	public User select(Integer uId) {		
		return userDao.select(uId);
	}
	
	/**
	 * 根据手机号查询
	 */
	@Override
	public User select(String uPhone) {		
		return userDao.select(uPhone);
	}
	
	/**
	 * 根据手机号,身份证号查询
	 */
	@Override
	public User select(String uPhone, String uIdcard) {		
		return userDao.select(uPhone, uIdcard);
	}
		
	/**
	 * 删除user	 
	 */
	@Override
	public void delete(User user) {
		
		userDao.delete(user);
	}

	
	@Override
	public boolean update(User user) {
		
		return userDao.update(user);
	}
	
	/**
	 * 添加user	 
	 */
	@Override
	public void add(User user) {
		
		 userDao.add(user);
	}

	@Override
	public User selectName(String uName) {
		
		return userDao.selectName(uName);
	}

	@Override
	public User selectIdCard(String uIdcard) {
		
		return userDao.selectIdCard(uIdcard);
	}

	@Override
	public List<User> selectuDuty(String uDuty) {
		
		return userDao.selectuDuty(uDuty);
	}

	@Override
	public List<User> selectuDname(String uDname) {		
		return userDao.selectuDname(uDname);
	}	
}

过滤器,拦截器:

package cn.xxs.filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class EncodingFilter implements Filter {

	private String encode;

	@Override
	public void destroy() {
		// TODO Auto-generated method stub

	}

	@Override
	public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain arg2)
			throws IOException, ServletException {
		// 1.
		HttpServletRequest request = (HttpServletRequest) arg0;
		HttpServletResponse response = (HttpServletResponse) arg1;

		// 2.
//		request.setCharacterEncoding(encode);
//		response.setContentType("text/html;charset=utf-8");
//		// 3.
//
		arg2.doFilter(request, response);

	}

	@Override
	public void init(FilterConfig arg0) throws ServletException {
		// TODO Auto-generated method stub
		this.encode = arg0.getInitParameter("encode");

	}
}
package cn.xxs.filter;
import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginFilter extends HttpServlet implements Filter {

	/**
	 * 反序列化
	 */
	private static final long serialVersionUID = 1L;

	public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain)
			throws IOException, ServletException {

		HttpServletRequest request = (HttpServletRequest) req;
		HttpServletResponse response = (HttpServletResponse) resp;
		HttpSession session = request.getSession(true);

		String url = request.getRequestURI();
		String name = (String) session.getAttribute("name");
		if (name == null && url.indexOf("index.jsp") == -1) {
			String location = "/index.jsp";
			request.getRequestDispatcher(location).forward(request, response);
			System.out.println("成功拦截到外星人企图入侵网站后台   :  " + url);
			response.setHeader("Cache-Control", "no-store");
			response.setDateHeader("Expires", 0);
			response.setHeader("Pragma", "no-cache");
		} else {
			chain.doFilter(request, response);
		}
	}

	public void init(FilterConfig arg0) throws ServletException {

	}
}

控制层:

package cn.xxs.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;

public class BaseAction extends ActionSupport{

	/**
	 * 获取HTTPServletRequest
	 */
	
	public HttpServletRequest getRequest() {
		return ServletActionContext.getRequest();
	}
	/**
	 * 获取HTTPServletResponse
	 */
	public HttpServletResponse getResponse() {
		return ServletActionContext.getResponse();
	}
	
	/**
	 * 获取HTTPSession
	 */
	public HttpSession getSession() {
		return getRequest().getSession();
	}
}
package cn.xxs.action;

import java.util.List;
import javax.annotation.Resource;
import cn.xxs.entity.Department;
import cn.xxs.entity.User;
import cn.xxs.service.DepartmentService;
import cn.xxs.service.UserService;

public class DepartmentAction extends BaseAction{
	@Resource
	private DepartmentService departmentService;
	@Resource
	private UserService userService;
	
	private Department department;
	
	private Integer dId;
	private String dName;
	private String dMoney;
	private String dBonus;	
	private String dStatus;
	
	public Department getDepartment() {
		return department;
	}

	public void setDepartment(Department department) {
		this.department = department;
	}

	public DepartmentService getDepartmentService() {
		return departmentService;
	}

	public void setDepartmentService(DepartmentService departmentService) {
		this.departmentService = departmentService;
	}

	public Integer getdId() {
		return dId;
	}

	public void setdId(Integer dId) {
		this.dId = dId;
	}

	public String getdName() {
		return dName;
	}

	public void setdName(String dName) {
		this.dName = dName;
	}

	public String getdMoney() {
		return dMoney;
	}

	public void setdMoney(String dMoney) {
		this.dMoney = dMoney;
	}

	public String getdBonus() {
		return dBonus;
	}

	public void setdBonus(String dBonus) {
		this.dBonus = dBonus;
	}

	public String getdStatus() {
		return dStatus;
	}

	public void setdStatus(String dStatus) {
		this.dStatus = dStatus;
	}

	
	public String selectAll(){
		List<Department> list = departmentService.selectAll();		
		getRequest().setAttribute("dList", list);
		return SUCCESS;		
	}
	
	public String delete(){
		String id = getRequest().getParameter("dId");
		Department d = departmentService.select(Integer.parseInt(id));
		departmentService.delete(d);
		selectAll();
		return SUCCESS;		
	}
	
	public String select() {
		String id1 = getRequest().getParameter("dId");
		Department d = departmentService.select(Integer.parseInt(id1));
		getRequest().setAttribute("u", d);
		return SUCCESS;	
	}
	public String selectDname(){
		String dName = department.getdName();		
		List<User> u = (List<User>) userService.selectuDname(dName);
		getRequest().setAttribute("user", u);
		return SUCCESS;					
	}
	
	public String update(){
		Integer id1 = department.getdId();
		String dName1 = department.getdName();
		String dMoney1 = department.getdMoney();
		String dBonus1 = department.getdBonus();
		String dStatus1 = department.getdStatus();
		if(!dName1.equals("") && !dName1.isEmpty() && !dMoney1.equals("") && !dMoney1.isEmpty()
				 && !dBonus1.equals("") && !dBonus1.isEmpty() && !dStatus1.equals("") && !dStatus1.isEmpty()) {			
		Department d = departmentService.select(id1);		
		d.setdName(dName1);
		d.setdMoney(dMoney1);
		d.setdBonus(dBonus1);
		d.setdStatus(dStatus1);
		System.out.println(d.toString());
		departmentService.update(d);
		selectAll();
		return SUCCESS;
		}else {
			getRequest().setAttribute("error", "更新失败,输入不能为空");
			return ERROR;
		}
		
	}
	
	public String add(){		
		String dName1 = department.getdName();
		String dMoney1 = department.getdMoney();
		String dBonus1 = department.getdBonus();
		String dStatus1 = department.getdStatus();
		Department de = departmentService.select(dName1);
		if(!dName1.equals("") && !dName1.isEmpty() && !dMoney1.equals("") && !dMoney1.isEmpty()
				 && !dBonus1.equals("") && !dBonus1.isEmpty() && !dStatus1.equals("") && !dStatus1.isEmpty() 
				 && de==null) {			
			Department d = new Department(null,dName1,dMoney1,dBonus1,dStatus1);			
			System.out.println(d.toString());
			departmentService.add(d);
			selectAll();			
			return SUCCESS;
			
		}else {
			getRequest().setAttribute("error", "添加失败,输入不能为空且不能重复添加部门");
			return ERROR;
		}		
	}
	
}
package cn.xxs.action;

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

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.interceptor.RequestAware;
import org.apache.struts2.interceptor.SessionAware;

import cn.xxs.entity.Department;
import cn.xxs.entity.SystemUser;
import cn.xxs.entity.User;
import cn.xxs.service.SystemUserService;

public class SystemUserAction extends BaseAction implements SessionAware{
	@Resource
	private SystemUserService systemUserService;
	
	Map<String, Object> session = new HashMap<String, Object>();
	
	private SystemUser systemUser;

	public SystemUser getSystemUser() {
		return systemUser;
	}

	public void setSystemUser(SystemUser systemUser) {
		this.systemUser = systemUser;
	}
	private int result;
	public int getResult() {
		return result;
	}
	public void setResult(int result) {
		this.result = result;
	}	
	public String checkUser(){
		SystemUser u = systemUserService.select(systemUser.getName());	
		if (u!=null) {	
			//用户名存在
			result = 1;	
		} else {
			//用户名不存在
			result = 2;	
		}		
		return SUCCESS;
	}
	private HttpServletRequest request = ServletActionContext.getRequest();
	private HttpSession session1 = request.getSession();
	public String login(){
		SystemUser u = systemUserService.select(systemUser.getName(),systemUser.getPwd());
		System.out.println(u);
		System.out.println(systemUser.getName());
		if (u!=null) {										
			session1.setAttribute("name", systemUser.getName());
			session1.setAttribute("s", u);
			//登陆成功			
			return "success";
		} else {
			//登陆失败
			session1.setAttribute("Message", "用户名或密码错误");
			return ERROR;
		}				
	}
		
	public String mselect(){		
		SystemUser d = systemUserService.select(systemUser.getId());
		getRequest().setAttribute("s", d);
		return SUCCESS;
	}	
	public String updatePwd(){		
			Integer id1 = systemUser.getId();
			String name1 = systemUser.getName();
			String pwd1 = systemUser.getPwd();
						
		if(!name1.equals("") && !name1.isEmpty() && !pwd1.equals("") && !pwd1.isEmpty()) {
			
			SystemUser d = systemUserService.select(id1);
			d.setName(name1);
			d.setPwd(pwd1);
			System.out.println(d.toString());
			systemUserService.update(d);							
			mselect();			
			return SUCCESS;
			
		}else {	
			
			getRequest().setAttribute("error", "更新失败,密码不能为空");
			return ERROR;
		}										
	}		

	@Override
	public void setSession(Map<String, Object> session) {
		this.session=session;
		
	}
	

}
package cn.xxs.action;

import java.io.IOException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;

import cn.xxs.entity.Department;
import cn.xxs.entity.User;
import cn.xxs.service.DepartmentService;
import cn.xxs.service.UserService;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

/**
 * 
 * @author xxs
 *
 */

public class UserAction  extends BaseAction{
	
	@Resource
	private UserService userService;
	
	@Resource
	private DepartmentService departmentService;
	
	private User user;
	
	public User getUser() {
		return user;
	}
	public void setUser(User user) {
		this.user = user;
	}

	
	private int result;
	public int getResult() {
		return result;
	}
	public void setResult(int result) {
		this.result = result;
	}	
	
	public String selectAll(){
		List<User> list = userService.selectAll();
		getRequest().setAttribute("userList", list);
		return SUCCESS;		
	}
	
		
	public String checkUser(){
		//获取用户名
		String uPhone1 = user.getuPhone();
		User u = userService.select(uPhone1);	
		if (u!=null) {	
			//用户名存在
			result = 1;	
		} else {
			//用户名不存在
			result = 2;	
		}		
		return SUCCESS;
	}
	public String login(){
		//获取用户名
		String uPhone1 = user.getuPhone();
		//获取密码
		String uIdcard1 = user.getuIdcard();
		User u = userService.select(uPhone1,uIdcard1);		
		if (u!=null) {	
			if(u.getuState().equals("0") && u.getuDuty().equals("0")) {
				System.out.println(u.toString());
				//登陆成功
				getRequest().setAttribute("user", u);
				return SUCCESS;
			}else {
				//登陆失败
				getRequest().setAttribute("msg", "您未经审核或者您应该去管理员登录");
				return ERROR;
			}
			
		} else {
			//登陆失败
			getRequest().setAttribute("msg", "用户名或密码错误");
			return ERROR;
		}				
	}
	
	
	public String delete(){		
		User u = userService.select(user.getuId());
		userService.delete(u);
		 selectAll();
		return SUCCESS;		
	}
	public String update(){		
		String uName1 = user.getuName();
		String uIdcard1 = user.getuIdcard();
		String uSex1 = user.getuSex();
		String uAddress1 = user.getuAddress();
		String uPhone1 = user.getuPhone();
		String uCreatetime1 = user.getuCreatetime();
		String uPicture1 = user.getuPicture();
		String uDuty1 = user.getuDuty();
		String uState1 = user.getuState();
		String uDname1 = user.getuDname();									
						
		if(uName1.equals("") && uName1.isEmpty() && uIdcard1.equals("") && uIdcard1.isEmpty()
				 && uAddress1.equals("") && uAddress1.isEmpty() && uPhone1.equals("") && uPhone1.isEmpty() 
				 && uCreatetime1.equals("") && uCreatetime1.isEmpty() && uPicture1.equals("") && uPicture1.isEmpty()
				 && uDuty1.equals("") && uDuty1.isEmpty() && uDname1.equals("") && uDname1.isEmpty()
				 && uSex1.equals("") && uSex1.isEmpty()) {
			
			getRequest().setAttribute("error", "更新失败,输入不能为空");
			return ERROR;
			
		}else {	
			Department department = departmentService.select(uDname1);		
				if(department == null) {
					getRequest().setAttribute("error", "更新失败,此部门不存在");
					return ERROR;
				}else {
					User u = userService.select(user.getuId());	
					u.setuName(uName1);
					u.setuIdcard(uIdcard1);
					u.setuSex(uSex1);
					u.setuAddress(uAddress1);
					u.setuPhone(uPhone1);
					u.setuCreatetime(uCreatetime1);
					u.setuPicture(uPicture1);
					u.setuDuty(uDuty1);
					u.setuState(uState1);
					u.setuDname(uDname1);					
					System.out.println(u.toString());
					userService.update(u);
					selectAll();			
					return SUCCESS;
				}										
		}		
		
	}
	public String updateUser(){		
		String uName1 = user.getuName();
		String uIdcard1 = user.getuIdcard();
		String uSex1 = user.getuSex();
		String uAddress1 = user.getuAddress();
		String uPhone1 = user.getuPhone();
		String uCreatetime1 = user.getuCreatetime();
		String uPicture1 = user.getuPicture();
		String uDuty1 = user.getuDuty();
		String uState1 = user.getuState();
		String uDname1 = user.getuDname();									
						
		if(uName1.equals("") && uName1.isEmpty() && uIdcard1.equals("") && uIdcard1.isEmpty()
				 && uAddress1.equals("") && uAddress1.isEmpty() && uPhone1.equals("") && uPhone1.isEmpty() 
				 && uCreatetime1.equals("") && uCreatetime1.isEmpty() && uPicture1.equals("") && uPicture1.isEmpty()
				 && uDuty1.equals("") && uDuty1.isEmpty() && uDname1.equals("") && uDname1.isEmpty()
				 && uSex1.equals("") && uSex1.isEmpty()) {
			
			getRequest().setAttribute("error", "更新失败,输入不能为空");
			return ERROR;
			
		}else {	
			Department department = departmentService.select(uDname1);		
				if(department == null) {
					getRequest().setAttribute("error", "更新失败,此部门不存在");
					return ERROR;
				}else {
					User u = userService.select(user.getuId());	
					u.setuName(uName1);
					u.setuIdcard(uIdcard1);
					u.setuSex(uSex1);
					u.setuAddress(uAddress1);
					u.setuPhone(uPhone1);
					u.setuCreatetime(uCreatetime1);
					u.setuPicture(uPicture1);
					u.setuDuty(uDuty1);
					u.setuState(uState1);
					u.setuDname(uDname1);					
					System.out.println(u.toString());
					userService.update(u);
					selectAll();			
					return SUCCESS;
				}										
		}		
		
	}
	public String select() {		
		User u = userService.select(user.getuId());
		getRequest().setAttribute("u", u);
		return SUCCESS;
		
	}
	public String selectuDuty() {	
		List<User> u = (List<User>) userService.selectuDuty(user.getuDuty());
		getRequest().setAttribute("user", u);
		return SUCCESS;
		
	}
	public String add(){		
		String uName1 = user.getuName();
		String uIdcard1 = user.getuIdcard();
		String uSex1 = user.getuSex();
		String uAddress1 = user.getuAddress();
		String uPhone1 = user.getuPhone();
		DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String uCreatetime1 = df.format(new Date());
		String uPicture1 = user.getuPicture();
		String uDuty1 = user.getuDuty();
		String uState1 = user.getuState();
		String uDname1 = user.getuDname();
		Department department = departmentService.select(uDname1);		
			
		if(!uName1.equals("") && !uName1.isEmpty() && !uIdcard1.equals("") && !uIdcard1.isEmpty()
				 && !uAddress1.equals("") && !uAddress1.isEmpty() && !uPhone1.equals("") && !uPhone1.isEmpty() 
				 && !uCreatetime1.equals("") && !uCreatetime1.isEmpty() && !uPicture1.equals("") && !uPicture1.isEmpty()
				 && !uDuty1.equals("") && !uDuty1.isEmpty() && !uDname1.equals("") && !uDname1.isEmpty()
				 && !uSex1.equals("") && !uSex1.isEmpty()) {
			
			User de = userService.select(uIdcard1);				
			if(de==null) {
				if(department == null) {
					getRequest().setAttribute("error", "操作失败,此部门不存在");
					return ERROR;
				}else {
					User u = new User();
					u.setuName(uName1);
					u.setuIdcard(uIdcard1);
					u.setuSex(uSex1);
					u.setuAddress(uAddress1);
					u.setuPhone(uPhone1);
					u.setuCreatetime(uCreatetime1);
					u.setuPicture(uPicture1);
					u.setuDuty(uDuty1);
					u.setuState(uState1);
					u.setuDname(uDname1);					
					System.out.println(u.toString());
					userService.add(u);
					selectAll();			
					return SUCCESS;
				}				
				
			}else {
				getRequest().setAttribute("error", "操作失败,身份证唯一,员工已存在");
				return ERROR;
			}			
			
		}else {
			getRequest().setAttribute("error", "操作失败,输入不能为空");
			return ERROR;			
		}		
	}	
	public String register(){		
		String uName1 = user.getuName();
		String uIdcard1 = user.getuIdcard();
		String uSex1 = user.getuSex();
		String uAddress1 = user.getuAddress();
		String uPhone1 = user.getuPhone();
		DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String uCreatetime1 = df.format(new Date());
		String uPicture1 = user.getuPicture();
		String uDuty1 = user.getuDuty();
		String uState1 = "1";
		String uDname1 = user.getuDname();
		Department department = departmentService.select(uDname1);		
		User de = userService.select(uIdcard1);		
		if(!uName1.equals("") && !uName1.isEmpty() && !uIdcard1.equals("") && !uIdcard1.isEmpty()
				 && !uAddress1.equals("") && !uAddress1.isEmpty() && !uPhone1.equals("") && !uPhone1.isEmpty() 
				 && !uCreatetime1.equals("") && !uCreatetime1.isEmpty() && !uPicture1.equals("") && !uPicture1.isEmpty()
				 && !uDuty1.equals("") && !uDuty1.isEmpty() && !uDname1.equals("") && !uDname1.isEmpty()
				 && !uSex1.equals("") && !uSex1.isEmpty()) {									
			if(de==null) {
				if(department == null) {
					getRequest().setAttribute("error", "操作失败,此部门不存在");
					return ERROR;
				}else {
					User u = new User();
					u.setuName(uName1);
					u.setuIdcard(uIdcard1);
					u.setuSex(uSex1);
					u.setuAddress(uAddress1);
					u.setuPhone(uPhone1);
					u.setuCreatetime(uCreatetime1);
					u.setuPicture(uPicture1);
					u.setuDuty(uDuty1);
					u.setuState(uState1);
					u.setuDname(uDname1);					
					System.out.println(u.toString());
					userService.add(u);
					selectAll();			
					return SUCCESS;
				}				
				
			}else {
				getRequest().setAttribute("error", "操作失败,身份证唯一,员工已存在");
				return ERROR;
			}			
			
		}else {
			getRequest().setAttribute("error", "操作失败,输入不能为空");
			return ERROR;			
		}		
	}		
}

前台页面:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
	<meta charset="utf-8" />
<title>Home</title>
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false);
function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<link href="css/style.css" rel='stylesheet' type='text/css' /> 
<link rel="stylesheet" href="css/smoothbox.css" type='text/css' >
<!-- //Custom Theme files -->
<!-- js -->
<script src="js/jquery.min.js"></script>
<!-- //js -->
<!-- web font -->

<!-- //web font -->
</head>
<body> 
	<div class="w3ls-banner">
		<div class="center-container"> 
			<div class="navigation">
				<div class="container">
					<div class="agileits-logo">
						<h1><a href="index.html">Weclome To SWLF <span class="w3agile"></span></a></h1>
					</div>
					<div class="navigation-right">
						<span class="menu"><img src="images/menu.png" alt=" " /></span>
						<nav class="link-effect-3" id="link-effect-3">
							<ul class="nav1 nav">
								<li class="active"><a data-hover="Home" href="#">Home</a></li>								
								<li><a href="#agents" class="scroll" data-hover="leader ">leader </a></li> 
								<li><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false" data-hover="Pages">Pages <span class="caret"></span></a>
									<ul class="dropdown-menu"> 
										<li><a data-hover="register" href="#gallery" class="scroll">register</a></li>
										<li><a data-hover="login" href="#testimonial" class="scroll">login</a></li>
									</ul>
								</li>  
								<li><a data-hover="Contact" href="#contact" class="scroll">Contact</a></li>
							</ul>
						</nav>
							<!-- script-for-menu -->
							<script>
							   $( "span.menu" ).click(function() {
								 $( "ul.nav1" ).slideToggle( 300, function() {
								 // Animation complete.
								  });
								 });
							</script>
							<!-- //script-for-menu -->
					</div>
					<div class="clearfix"></div>
				</div>
			</div>
			<div class="w3ls_banner_info">
				<div class="container">
					<div class="w3l_banner_logo">
						<h2>SWLF</h2>
					</div>
					<h3>成功是百分之一的灵感和百分之九十九的汗水</h3>
					<div class="more">
						<a href="#" class="hvr-underline-from-center" data-toggle="modal" data-target="#myModal">了解更多</a>
					</div>
					<!-- modal-->
					<div class="modal video-modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModal">
						<div class="modal-dialog" role="document">
							<div class="modal-content">
								<div class="modal-header">
									一角 
									<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>						
								</div> 
								<div class="modal-body">
									<img src="images/17.jpg" alt=" " class="img-responsive" />
									<p>但是,我们的身体是怎样锻炼的呢?如果结果是一样的呢?在一个没有任何结果的地方,所有的一切都是真实的。</p>
								</div> 
							</div>
						</div>
					</div> <!-- //modal-->
				</div>
			</div>
		</div>
	</div>
	
	
	<!-- team -->
	<div class="team" id="agents">
		<div class="container">
			<h3>合作人</h3>
			<p class="nostrud"></p>
			<div class="agile_team_grids">
				<div class="col-md-3 agile_team_grid">
					<div class="view w3-agile-view">
						<img src="images/3.jpg" alt=" " class="img-responsive" />
						<div class="w3lmask">
							<h5>SWLF</h5>
							<p>时间是一切财富中最宝贵的财富。</p>
							
						</div>
					</div>
					<h4>约翰</h4>
				</div>
				<div class="col-md-3 agile_team_grid">
					<div class="view w3-agile-view">
						<img src="images/6.jpg" alt=" " class="img-responsive" />
						<div class="w3lmask">
							<h5>SWLF</h5>
							<p>时间是一切财富中最宝贵的财富。</p>
							
						</div>
					</div>
					<h4>劳拉</h4>
				</div>
				<div class="col-md-3 agile_team_grid">
					<div class="view w3-agile-view">
						<img src="images/4.jpg" alt=" " class="img-responsive" />
						<div class="w3lmask">
							<h5>SWLF</h5>
							<p>时间是一切财富中最宝贵的财富。</p>
							
						</div>
					</div>
					<h4>詹姆斯</h4>
				</div>
				<div class="col-md-3 agile_team_grid">
					<div class="view w3-agile-view">
						<img src="images/5.jpg" alt=" " class="img-responsive" />
						<div class="w3lmask">
							<h5>SWLF</h5>
							<p>时间是一切财富中最宝贵的财富。</p>
							
						</div>
					</div>
					<h4>马丁</h4>
				</div>
				<div class="clearfix"> </div>
			</div>
		</div>
	</div>
	<!-- //team -->
	<div class="tlinks">Collect from <a href="http://www.cssmoban.com/" >网页模板</a></div>
	<!-- team-bottom -->
	<div class="team-bottom">
		<div class="container">
			<h3>注册</h3>
			<p>好工作成就好生活。如果您想加入我们,请注册以下信息,并等待我们的审核通知您。</p>
			<div class="reservation resrv-agileits-w3layout">
				
				
				<form action="register" method="post">
					<div class="w3_book_date"> 
						<input id="country" type="text" name="user.uName" placeholder="输入名字"/><br><br>
						<input id="country1" type="text" name="user.uIdcard" placeholder="输入身份证号"/><br><br>
						<input id="country2" type="text" name="user.uSex" placeholder="输入性别"/><br><br>
						<input id="country1" type="text" name="user.uAddress" placeholder="输入地址"/><br><br>
						
					</div>
					<div class="w3_book_date">
					<input id="country2" type="text" name="user.uPhone" placeholder="输入手机号"/><br><br>
						<input id="country2" type="text" name="user.uPicture" placeholder="输入形象"/><br><br>
						<select id="country1" name="user.uDuty" >
							<option value="0" style="color: black;">员工</option>
							<option value="1" style="color: black;">管理员</option>
						</select><br><br>						
						<input id="country1" type="text" name="user.uDname" placeholder="输入部门名称"/>	<br><br>					
					</div>							
					<div class="clearfix"> </div> 
					<input type="submit" value="提交">
				</form>
				
				
			</div> 
		</div>
	</div>
	<!-- //team-bottom -->
	<!-- gallery -->
	<div class="gallery" id="gallery">
		<h3>工作环境</h3>
		<p class="nostrud agileits-w3layouts"></p>
		<div class="w3agile_gallery_grids">
			<div class="col-md-3 w3agile_gallery_grid">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/8.jpg" >
						<figure>
							<img src="images/8.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/9.jpg">
						<figure>
							<img src="images/9.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/10.jpg">
						<figure>
							<img src="images/10.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid w3-agileits">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/11.jpg">
						<figure>
							<img src="images/11.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid w3-agileits">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/12.jpg">
						<figure>
							<img src="images/12.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid w3-agileits">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/13.jpg">
						<figure>
							<img src="images/13.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/14.jpg">
						<figure>
							<img src="images/14.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
			<div class="col-md-3 w3agile_gallery_grid">
				<div class="w3agile_gallery_image">
					<a class="sb" href="images/15.jpg">
						<figure>
							<img src="images/15.jpg" alt="" class="img-responsive" />
							<figcaption>
								<h4>S W L F</h4>
								<p>
									开心是一种觉悟的境界,是一种宽容、安详的心态:人能够活得无忧无愁,没有烦恼,心无挂碍,你就会感悟到世间上最美丽的
									表情就是开心微笑,因此人要拥有一颗乐观的心态是最重要的。但愿众生能够“开开心心过一生,自自在在活到老”。
								</p>
							</figcaption>
						</figure>
					</a>
				</div>
			</div>
		   <div class="clearfix"> </div>
		</div>
		<script type="text/javascript" src="js/smoothbox.jquery2.js"></script>
	</div>
	<!-- //gallery -->
	<!-- testimonials -->
	<div class="team-bottom" id="testimonial">
		<div class="container">
			<h3>登录</h3>
			
			<div class="testimonials-agileinfo-grids">
				<div class="bs-example bs-example-tabs" role="tabpanel" data-example-id="togglable-tabs">
					<ul id="myTab" class="nav nav-tabs" role="tablist">
						<li role="presentation" class="active"><a href="#home" id="home-tab" role="tab" data-toggle="tab" aria-controls="home" aria-expanded="true">员工登录</a></li>
						<li role="presentation"><a href="#carl" id="carl-tab" data-toggle="tab" aria-controls="carl">管理员登录</a></li>			
					</ul>
					<div id="myTabContent" class="tab-content">
						<div role="tabpanel" class="tab-pane fade in active" id="home" aria-labelledby="home-tab">
							<div class="tabcontent-grids">
								<form action="checkUserLogin" method="post">									
									<div class="form-group form-group-lg">									
										<input type="text" name="user.uPhone" class="phone" id="lo" placeholder="请输入您的手机号" >
										<span id="nameError" class="error"></span><br />	<br />								
										<input type="password" name="user.uIdcard" class="idCard" id="lo" placeholder="请输入您的身份证号">
										<span class="span" class="error">${msg }</span>
									</div>
									<div class="form-group form-group-lg">
										<button type="submit" class="btn btn-default btn-lg">登录</button>
									</div>
								</form>
							</div>
						</div>
						<div role="tabpanel" class="tab-pane fade" id="carl" aria-labelledby="carl-tab">
							<div class="tabcontent-grids">
								<form action="checkLogin" method="post">									
									<div class="form-group form-group-lg">									
										<input type="text" name="systemUser.name" class="name" id="lo" placeholder="请输入您的用户名">
										<span id="error" class="error"></span><br />	<br />								
										<input type="password" name="systemUser.pwd" class="pwd" id="lo"  placeholder="请输入您的密码">
										<span class="span" class="error">${Message }</span>
									</div>
									<div class="form-group form-group-lg">
										<button type="submit" class="btn bg-primary btn-default btn-lg">登录</button>
									</div>
								</form>
							</div>
						</div>
						
					</div>
				</div>
			</div>
		</div>
	</div>
	<!-- //testimonials -->
	<!-- contact -->
	<div class="contact" id="contact">
		<div class="col-md-6 w3agile_contact_left">
			<h3>联系我们</h3>
			<p>除了我们的国家不安全之外,在这个国家里,没有一个人是被遗弃的,而在这个国家里,只有一个人是被遗弃的。</p>
			<form action="#" method="post">
				<input type="text" name="Name" placeholder="姓名" required="">
				<input type="email" name="Email" placeholder="邮箱" required="">
				<textarea name="Message" placeholder="建议" required></textarea> 
				<input type="submit" value="提交">
			</form>
		</div>
		<div class="col-md-6 w3agile_contact_right">
			<h3><a href="index.html">欢迎加入我们</a></h3>
			<div class="col-xs-6 w3agile_contact_right_agileinfo">
				<h4>地址</h4>
				<p><span class="glyphicon glyphicon-map-marker" aria-hidden="true"></span>河南省郑州市<i>学府广场B座</i></p>
				<p><span class="glyphicon glyphicon-earphone" aria-hidden="true"></span>(+) 8888 8888 88</p>
				<p><span class="glyphicon glyphicon-envelope" aria-hidden="true"></span><a href="mailto:info@example.com">2425604388@qq.com</a></p>
			</div>
			<div class="clearfix"> </div>
			<div class="w3_copy_right">
				<p>Copyright &copy; Copynight© 2009-2016 SWLF.com-- &nbsp;&nbsp;<i>京公网安备11010502014900号 |京ICP备11024134号-1</i></p>
			</div>
		</div>
		<div class="clearfix"> </div>
	</div>
	<!-- //contact -->
	<!-- bootstrap js -->
	<script src="js/bootstrap.js"></script>
	<!-- //bootstrap js -->
	<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script type="text/javascript">
		$(function() {	
			//失去焦点事件
			$(".name").blur(function() {
				//获取用户名
				var name = $(".name").val();
				//判断用户名为空
				if (name == null || name == "") {
					$("#error").html("请输入用户名!").css("color","red");			
				} else {
					$.ajax({
						type:"post",
						url : "checkName",	//配置的action名
						data:{name:name},  //name值
						dataType : "json",	//json类型
						success : function(data) {	//回调函数
							if (data == 1) {
								//name1.equals("xxs")
								$("#error").html("手机号存在").css("color","green");						
							}else if(data == 2){
								$("#error").html("手机号不存在").css("color","red");
							}
						}
					});
				}
			}).focus(function() {
				
				$("#error").text("");
				$(".span").text("");
			});	
			$(".pwd").focus(function() {
				//获取用户名
				var name = $(".name").val();				
				if(name == null || name == ""){
					$("#error").html("请输入用户名 !").css("color","red");	
				}
				$(".span").text("");
			});
		});
	</script>
	<script type="text/javascript">
		$(function() {	
			//失去焦点事件
			$(".phone").blur(function() {
				//获取用户名
				var uPhone = $(".phone").val();
				//判断用户名为空
				if (uPhone == null || uPhone == "") {
					$("#nameError").html("请输入手机号 !").css("color","red");			
				} else {
					$.ajax({
						type:"post",
						url : "checkUser",	//配置的action名
						data:{uPhone:uPhone},  //name值
						dataType : "json",	//json类型
						success : function(data) {	//回调函数
							if (data == 1) {
								//name1.equals("xxs")
								$("#nameError").html("手机号存在").css("color","green");						
							}else if(data == 2){
								$("#nameError").html("手机号不存在").css("color","red");
							}
						}
					});
				}
			}).focus(function() {
				
				$("#nameError").text("");
				$("#span").text("");
			});	
			$(".idCard").focus(function() {
				//获取用户名
				var uPhone = $(".phone").val();				
				if(uPhone == null || uPhone == ""){
					$("#nameError").html("请输入手机号 !").css("color","red");	
				}
				$("#span").text("");
			});
		});
	</script>
	<!-- start-smooth-scrolling -->
	<script type="text/javascript" src="js/move-top.js"></script>
	<script type="text/javascript" src="js/easing.js"></script>
	<script type="text/javascript">
		jQuery(document).ready(function($) {
			$(".scroll").click(function(event){		
				event.preventDefault();
				$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
			});
		});
	</script>
	<!-- start-smooth-scrolling -->
	<!-- here stars scrolling icon -->
	<script type="text/javascript">
		$(document).ready(function() {
			/*
				var defaults = {
				containerID: 'toTop', // fading element id
				containerHoverID: 'toTopHover', // fading element hover id
				scrollSpeed: 1200,
				easingType: 'linear' 
				};
			*/
								
			$().UItoTop({ easingType: 'easeOutQuart' });
								
			});
	</script>
	<!-- //here ends scrolling icon -->	
	
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Home</title>
<script type="application/x-javascript">
	
	 addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false);
function hideURLbar(){ window.scrollTo(0,1); } 

</script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<link href="css/style.css" rel='stylesheet' type='text/css' />
<link rel="stylesheet" href="css/smoothbox.css" type='text/css'>
<!-- //Custom Theme files -->
<!-- js -->
<script src="js/jquery.min.js"></script>
<!-- //js -->
<!-- web font -->
<link
	href="http://fonts.googleapis.com/css?family=Work+Sans:100,200,300,400,500,600,700,800,900"
	rel="stylesheet">
<link
	href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,300italic,400italic,600,600italic,700,700italic,800,800italic'
	rel='stylesheet' type='text/css'>
<!-- //web font -->
</head>
<script type="text/javascript">
	$(function() {
		$('.phone').change(function() {
			$('#span').text("");
		});
		$('.idcard').change(function() {
			$('#span').text("");
		});
		
		$('#modal').on('shown.bs.modal', function () {
			  $('#myInput').focus()
			})
	})
</script>
<body>

	<div class="w3ls-banner">
		<div class="center-container">
			<div class="navigation">
				<div class="container">
					<div class="agileits-logo">
						<h1>
							<a href="index.jsp">Weclome To SWLF <span class="w3agile"></span></a>
						</h1>
					</div>
					<div class="navigation-right">
						<span class="menu"><img src="images/menu.png" alt=" " /></span>
						<nav class="link-effect-3" id="link-effect-3">
						<ul class="nav1 nav">
							<li class="active"><a data-hover="Home" href="#">Home</a></li>
							<li><a href="#agents" class="scroll" data-hover="leader ">select
							</a></li>
							<li><a data-hover="Contact" href="#contact" class="scroll">Contact</a></li>
							<li><a data-hover="Contact" href="index.jsp">exit</a></li>
						</ul>
						</nav>
						<!-- script-for-menu -->
						<script>
							$("span.menu").click(function() {
								$("ul.nav1").slideToggle(300, function() {
									// Animation complete.
								});
							});
						</script>
						<!-- //script-for-menu -->
					</div>
				</div>
			</div>
			<div class="w3ls_banner_info">
				<div class="container">
					<div class="w3l_banner_logo">
						<h2>SWLF</h2>
					</div>
					<h3>成功是百分之一的灵感和百分之九十九的汗水</h3>
					<div class="more">
						<a href="#" class="hvr-underline-from-center" data-toggle="modal"
							data-target="#myModal">了解更多</a>
					</div>
					<!-- modal-->
					<div class="modal video-modal fade" id="myModal" tabindex="-1"
						role="dialog" aria-labelledby="myModal">
						<div class="modal-dialog" role="document">
							<div class="modal-content">
								<div class="modal-header">
									一角
									<button type="button" class="close" data-dismiss="modal"
										aria-label="Close">
										<span aria-hidden="true">&times;</span>
									</button>
								</div>
								<div class="modal-body">
									<img src="images/17.jpg" alt=" " class="img-responsive" />
									<p>但是,我们的身体是怎样锻炼的呢?如果结果是一样的呢?在一个没有任何结果的地方,所有的一切都是真实的。</p>
								</div>
							</div>
						</div>
					</div>
					<!-- //modal-->
				</div>
			</div>
		</div>
	</div>


	<!-- team -->
	<div class="team" id="agents">
		<div class="container">
			<h3>我的个人信息</h3>
			<p class="nostrud agileits-w3layouts"></p>
			<table class="table table-bordered table-hover table-striped">
				<tbody>
					<tr>
						<th>姓名</th>
						<td>${user.uName }</td>

						<th>身份证号</th>
						<td>${user.uIdcard }</td>
					</tr>
					<tr>
						<th>性别</th>
						<td>${user.uSex }</td>

						<th>地址</th>
						<td>${user.uAddress}</td>
					</tr>
					<tr>
						<th>电话</th>
						<td>${user.uPhone }</td>

						<th>注册时间</th>
						<td>${user.uCreatetime }</td>
					</tr>
					<tr>
						<th>个人形象</th>
						<td>${user.uPicture }</td>

						<th>角色</th>
						<c:if test="${user.uDuty==0 }">
							<td>员工</td>
						</c:if>
						<c:if test="${user.uDuty==1 }">
							<td>管理员</td>
						</c:if>
					</tr>
					<tr>
						<th>状态</th>
						<c:if test="${user.uState==0 }">
							<td>审核</td>
						</c:if>
						<c:if test="${user.uState==1 }">
							<td>审核</td>
						</c:if>

						<th>部门名称</th>
						<td>${user.uDname }</td>
					</tr>
				</tbody>
			</table>
			
			<!-- 模态框 -->
			<!-- Button trigger modal -->
			<button type="button" class="btn btn-primary btn-lg"
				data-toggle="modal" data-target="#modal">更新
			</button>

			<!-- Modal -->
			<div class="modal fade" id="modal" tabindex="-1" role="dialog"
				aria-labelledby="myModalLabel">
				<div class="modal-dialog" role="document">
					<div class="modal-content">
						<div class="modal-header">							
							<h4 class="modal-title" id="myModalLabel">更新个人信息</h4>
						</div>
						<div class="modal-body">
							<form action="updateUser" method="post" class="layui-form layui-form-pane">							
								<div class="form-group">
						            <label for="recipient-name" class="control-label">编号:</label>
						            <input type="text" name="user.uId" class="form-control" value="${user.uId }" readonly="readonly" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">姓名:</label>
						            <input type="text" name="user.uName" class="form-control" value="${user.uName }" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">身份证号:</label>
						            <input type="text" name="user.uIdcard" class="form-control" value="${user.uIdcard}" readonly="readonly" id="recipient-name">
						          </div>						          
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">性别:</label>
						            <input type="text" name="user.uSex" class="form-control" value="${user.uSex }" readonly="readonly" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">地址:</label>
						            <input type="text" name="user.uAddress" class="form-control" value="${user.uAddress}" id="recipient-name">
						          </div>						          
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">手机号:</label>
						            <input type="text" name="user.uPhone" class="form-control" value="${user.uPhone }" readonly="readonly" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">时间:</label>
						            <input type="text" name="user.uCreatetime" class="form-control" value="${user.uCreatetime}" readonly="readonly" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">形象:</label>
						            <input type="text" name="user.uPicture" class="form-control" value="${user.uPicture}" id="recipient-name">
						          </div>						          
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">角色:</label>
						            <input type="text" name="user.uDuty" class="form-control" value="${user.uDuty}" readonly="readonly" id="recipient-name">
						          </div>
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">审核:</label>
						            <input type="text" name="user.uState" class="form-control" value="${user.uState}" readonly="readonly" id="recipient-name">
						          </div>						          
						          <div class="form-group">
						            <label for="recipient-name" class="control-label">部门名:</label>
						            <input type="text" name="user.uDname" class="form-control" value="${user.uDname}" readonly="readonly" id="recipient-name">
						          </div>						          
						          <div class="form-group">						           
						            <input type="submit" class="form-control" value="更新" id="recipient-name">
						          </div>						          						       		
							</form>
						</div>
						<div class="modal-footer">
							<button type="button" class="btn btn-default"
								data-dismiss="modal">Close</button>
							<button type="button" class="btn btn-primary">Save
								changes</button>
						</div>
					</div>
				</div>
			</div>			
			<!-- 模态框end -->
		</div>
	</div>


	<!-- //testimonials -->
	<!-- contact -->
	<div class="contact" id="contact">
		<div class="col-md-6 w3agile_contact_left">
			<h3>联系我们</h3>
			<p>除了我们的国家不安全之外,在这个国家里,没有一个人是被遗弃的,而在这个国家里,只有一个人是被遗弃的。</p>
			<form action="#" method="post">
				<input type="text" name="Name" placeholder="姓名" required="">
				<input type="email" name="Email" placeholder="邮箱" required="">
				<textarea name="Message" placeholder="建议" required></textarea>
				<input type="submit" value="提交">
			</form>
		</div>
		<div class="col-md-6 w3agile_contact_right">
			<h3>
				<a href="index.html">欢迎加入我们</a>
			</h3>
			<div class="col-xs-6 w3agile_contact_right_agileinfo">
				<h4>地址</h4>
				<p>
					<span class="glyphicon glyphicon-map-marker" aria-hidden="true"></span>河南省郑州市<i>学府广场B座</i>
				</p>
				<p>
					<span class="glyphicon glyphicon-earphone" aria-hidden="true"></span>(+)
					8888 8888 88
				</p>
				<p>
					<span class="glyphicon glyphicon-envelope" aria-hidden="true"></span><a
						href="mailto:info@example.com">2425604388@qq.com</a>
				</p>
			</div>
			<div class="clearfix"></div>
			<div class="w3_copy_right">
				<p>
					Copyright &copy; Copynight© 2009-2016 SWLF.com-- &nbsp;&nbsp;<i>京公网安备11010502014900号
						|京ICP备11024134号-1</i>
				</p>
			</div>
		</div>
		<div class="clearfix"></div>
	</div>
	<!-- //contact -->
	<!-- bootstrap js -->
	<script src="js/bootstrap.js"></script>
	<!-- //bootstrap js -->
	<!-- start-smooth-scrolling -->
	<script type="text/javascript" src="js/move-top.js"></script>
	<script type="text/javascript" src="js/easing.js"></script>
	<script type="text/javascript">
		jQuery(document).ready(function($) {
			$(".scroll").click(function(event) {
				event.preventDefault();
				$('html,body').animate({
					scrollTop : $(this.hash).offset().top
				}, 1000);
			});
		});
	</script>
	<!-- start-smooth-scrolling -->
	<!-- here stars scrolling icon -->
	<script type="text/javascript">
		$(document).ready(function() {
			/*
				var defaults = {
				containerID: 'toTop', // fading element id
				containerHoverID: 'toTopHover', // fading element hover id
				scrollSpeed: 1200,
				easingType: 'linear' 
				};
			 */

			$().UItoTop({
				easingType : 'easeOutQuart'
			});

		});
	</script>
	<!-- //here ends scrolling icon -->

</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
<script type="text/javascript" >
$(function() {
	window.parent.location.href="/StaffManager/index.jsp"
})
</script>
</head>
<body>

</body>
</html>

后台页面:

1.后台首页

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>首页</title>
<link rel="stylesheet" href="layui/css/layui.css">

<style type="text/css">
.body {
	height: 1000px;
}

body {
	height: 1000px;
}
</style>
</head>
<body class="layui-layout-body ">
	
	<div class="layui-layout layui-layout-admin ">
		
		 <div class="layui-header layui-bg-black">
		    <div class="layui-logo">欢迎来到SWLF后台管理</div>		   		    
		    <ul class="layui-nav layui-layout-right">
		      <li class="layui-nav-item">
		        <a href="javascript:;">
		          <img src="images/u.jpg" class="layui-nav-img">
		          ${name }
		        </a>
		        
		      </li>
		      <li class="layui-nav-item"><a href="index.jsp">退出</a></li>
		    </ul>
		  </div>
		<div class="layui-side layui-bg-black">
			<div class="layui-side-scroll">
				<!-- 左侧导航区域(可配合layui已有的垂直导航) -->
				<ul class="layui-nav layui-nav-tree" lay-filter="tabTitleList">
					<!--<li class="layui-nav-item"><a href="javascript:;"
						data-href="#" data-layid="11">首页</a></li> -->
					<li class="layui-nav-item"><a class="" href="javascript:;">首页</a>
					</li>
					<li class="layui-nav-item layui-nav-itemed"><a class=""
						href="javascript:;">员工管理</a>
						<dl class="layui-nav-child">
							<dd>
								<a href="javascript:;" data-href="back/uAdd.jsp"
									data-layid="01">添加员工</a>
							</dd>							
							<dd>
								<a href="javascript:;" data-href="selectAll"
									data-layid="03">员工信息</a>
							</dd>														
							
							<dd>
								<a href="javascript:;" data-href="back/sList.jsp"
									data-layid="12">模糊查询</a>
							</dd>																																
						
						</dl></li>
					<!-- <li class="layui-nav-item"><a href="javascript:;">管理员管理</a>
						<dl class="layui-nav-child">
							<dd>
								<a href="javascript:;" data-href="back/sAdd.jsp"
									data-layid="11">添加管理员</a>
									
							</dd>
														
						</dl>
					</li> -->
					<li class="layui-nav-item"><a href="javascript:;">部门管理</a>
						<dl class="layui-nav-child">
							<dd>
								<a href="javascript:;" data-href="dselectAll"
									data-layid="11">所有部门信息</a>
									
							</dd>
							<dd>
								<a href="javascript:;" data-href="back/dAdd.jsp"
									data-layid="11">添加部门</a>
									
							</dd>																											
						</dl>
					</li>
					<li class="layui-nav-item"><a href="javascript:;">账号管理</a>
						<dl class="layui-nav-child">
							<dd>
								<a href="javascript:;" data-href="back/code.jsp"
									data-layid="11">账号信息</a>								
							</dd>																																
						</dl>
					</li>										
				</ul>
			</div>
		</div>
		
		<div class="layui-body">
			<!-- 内容主体区域 -->
			<div class="layui-tab body" lay-allowClose="true" lay-filter="tabs">
				<ul class="layui-tab-title">
					<li class="layui-this">首页</li>
				</ul>
				<div class="layui-tab-content">
					<div class="layui-tab-item layui-show">
						<h1>欢迎${name }来到SWLF后台管理</h1>
					</div>

					
				</div>
			</div>
			<div class="layui-footer">
				<!-- 底部固定区域 -->
				@小小舍
			</div>
		</div>

		<script src="layui/layui.js"></script>
		<script type="text/javascript" src="js/index.js"></script>
		<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
		<script>
			
		</script>
</body>
</html>

主要js(index.js):

layui.use('element', function(){
	//1.首先为了确定点击的是纵向导航栏里的哪一个,我们需要给导航ul添加lay-filter="tabTitleList"(筛选器),点击某一个时返回相对应页标签
	//2.然后为了点击时出现相对应页标签,我们需要给页标签区域ul外的div一个lay-filter="tabs"(切换的筛选器)	
	  var element = layui.element;//应用模块
	  var $ = layui.jquery;//应用jquery
	  //3.在点击nav导航tabTitleList被点击时
	  element.on('nav(tabTitleList)', function(elem){
		 //4.返回我们自己给出的 伪的data-href 跳转地址,data-layid 跳转id
		  var url = elem.data('href');//获取跳转地址
		  var layId = elem.data('layid');//获取跳转标题需要的准确的lay-id
		  //5.判断标签页里边是否已经有这个标签了
		  var idHasText = $('.layui-tab-title').text();//获取标签标题里的文字内容
		  //console.log(idHasText.indexOf(elem.text()));
		  //elem.text()就是当前点击的这个nav导航的文字,indexOf()是一个检测方法,检测不到返回-1
		  //6.检测当前tab标题里是否含有已有页标题
		  var idHasTitle = idHasText.indexOf(elem.text());
		  //排除三个管理
			if(layId!=null){
				if(idHasTitle == -1){
			  	//7.如果检测不到,执行添加新页签和内容
			  	element.tabAdd('tabs', {
					  title: elem.text()//选项卡的标题
					  //content支持传入html选项卡的内容
					  ,content: '<iframe src="'+url+'" scrolling="no" frameborder="no" width="100%" style="height: calc(100vh - 190px);"></iframe>' 
					  ,id: layId //选项卡标题的lay-id属性值
					}); 
			  }
			}		  
		  //8.如果检测到,执行切换(若已经含有查看图书,则直接切换到查看图书)
			element.tabChange('tabs',layId );//切换页签
		});
});

主要css:

body, html {height:100%;width:100%;}
.sb-prev:focus, .sb-next:focus, .sb-cancel:focus {outline: none;outline-offset: 0;text-decoration: none;}
/* wrapper */
.smoothbox {position: fixed;top:0;left:0;background:rgb(0,0,0);background: rgba(0, 0, 0, 0.9);height:100%;width:100%;z-index: 9999;}
/* wrapper after loading */
.sb-load {background:url('images/load.gif') center no-repeat rgba(0,0,0,.9);}
/* vertical centering */
.smoothbox-table {top:0;height:100%;width:100%;display:table;}
.smoothbox-centering {display:table-cell;vertical-align:middle;top:0;height:100%;width:100%;}
/* horizontal centering & sizing */
.smoothbox-sizing {display:none;position: relative;margin: 0 auto;padding: 0px;width: 80%;}
/* item wrapper */
.sb-items {margin: 0 auto;width: auto;padding: 0;list-style: none;    border-radius: 2px;display: table;}
.sb-items:after {content: "";display: block;clear: both;visibility: hidden;line-height: 0;height: 0;}
/* items */
.sb-item {left: 0;top:0;width: 100%;max-height: 80%;float: left;margin-right: -100%;position: relative;zoom: 1;border-radius: 2px;box-shadow: 0px 0px 0px 5px rgba(0, 0, 0, 1), 0px 0px 0px 6px #292929;
-webkit-backface-visibility: hidden;-webkit-transition: all .4s ease-out;-moz-transition:all .4s ease-out;transition: all .4s ease-out;}
.no-trans {-webkit-transition:none;-moz-transition:none;transition:none;}
.sb-item img {max-width: 100%;max-height: 100%;display: block;border-radius: 2px;position: relative;}
/* forward animation */
.sb-item-ani {top: 400px;opacity:0;-webkit-transform:scale(.5)rotate(25deg);-moz-transform:scale(.5)rotate(25deg);transform:scale(.5)rotate(25deg);-o-transform:scale(.5)rotate(25deg);-ms-transform:scale(.5)rotate(25deg);}
/* back animation */
.sb-item-ani2 {top:400px;-webkit-transform:scale(.5) rotate(25deg);-moz-transform:scale(.5) rotate(25deg);
transform:scale(.5) rotate(25deg);-o-transform:scale(.5) rotate(25deg);-ms-transform:scale(.5) rotate(25deg);opacity:0;}
.sb-caption {position: absolute;bottom: 0px;width: 100%;background: rgb(0,0,0);background: rgba(95, 94, 94, 0.9);color: #CCC;text-transform: capitalize;padding: 2em;
    line-height: 1.8em;box-sizing: border-box;-moz-box-sizing: border-box;z-index: 1;text-align: center;font-size: 14px;-ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=80)";}
/* buttons */
.sb-nav {position:absolute;top: 10px;width: 100%;margin: 0 auto;display: none;z-index: 10;text-align: center;opacity: .5;
    -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=50)";filter: alpha(opacity=50);font-size: 0;-webkit-transition:all .15s ease-out;
    -moz-transition:all .15s ease-out;transition:all .15s ease-out;-o-transition:all .15s ease-out;-ms-transition:all .15s ease-out;zoom:1;}
.sb-nav:hover { opacity:1;-ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";filter: alpha(opacity=100);}

.sb-prev, .sb-next, .sb-cancel {display: inline-block;background:rgb(0,0,0);background: rgba(0, 0, 0, 0.9);position: relative;zoom:1;outline:none;
    margin-right:1px;color: #fff!important;width: 50px;height: 35px;text-align: center;text-decoration: none;font-size: 21px;
    font-weight: bold;line-height: 33px;-webkit-transition:all .15s ease-out;-moz-transition:all .15s ease-out;
    transition:all .15s ease-out;-o-transition:all .15s ease-out;-ms-transition:all .15s ease-out;}
.sb-prev {border-radius: 15px 0 0 15px;}
.sb-next {border-radius: 0 15px 15px 0;}
.sb-nav a:hover {background: #fff;color: #000!important;text-decoration: none;}
.sb-cancel:hover {background:#820001;}
@media (max-width:480px){
	.sb-caption {bottom: -125px;padding: 1em;}
}
@media (max-width:320px){
	.sb-caption {font-size: 12px;}
}

员工列表ulist.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>

		
<!-- JSTL: jsp Standard<标准> Tag<标签> Lib<库> -->
	<c:if test="${userList!=null}">
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>用户名</th>
				<th>身份证号</th>
				<th>性別</th>
				<th>地址</th>						
				<th>手机号</th>				
				<th>创建时间</th>
				<th>员工形象</th>	
				<th>员工角色</th>				
				<th>员工状态</th>	
				<th>部门名称</th>
				<th>操作</th>		
			</tr>
			<c:forEach items="${userList }" var="u" varStatus="vs">
				<tr>
					<td>${vs.count}</td>
					<td>${u.uName}</td>
					<td>${u.uIdcard}</td>
					<td>${u.uSex}</td>
					<td>${u.uAddress}</td>
					<td>${u.uPhone}</td>
					<td>${u.uCreatetime}</td>
					<td>${u.uPicture}</td>					
					<c:if test="${u.uDuty==0 }">
					<td>员工</td>
					</c:if>
					<c:if test="${u.uDuty==1 }">
					<td>管理员</td>
					</c:if>
					<c:if test="${u.uState==0 }">
					<td>审核</td>
					</c:if>
					<c:if test="${u.uState==1 }">
					<td>未审核</td>
					</c:if>					
					<td>${u.uDname}</td>					
					<td><a href="delete?user.uId=${u.uId}">删除</a>
					<a href="select?user.uId=${u.uId}">更新</a></td>				
				</tr>
			</c:forEach>
		</table>
	</c:if>

<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  
	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	</script>
  </body>
</html>

添加用户uAdd.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>

		
<!-- JSTL: jsp Standard<标准> Tag<标签> Lib<库> -->
	<c:if test="${userList!=null}">
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>用户名</th>
				<th>身份证号</th>
				<th>性別</th>
				<th>地址</th>						
				<th>手机号</th>				
				<th>创建时间</th>
				<th>员工形象</th>	
				<th>员工角色</th>				
				<th>员工状态</th>	
				<th>部门名称</th>
				<th>操作</th>		
			</tr>
			<c:forEach items="${userList }" var="u" varStatus="vs">
				<tr>
					<td>${vs.count}</td>
					<td>${u.uName}</td>
					<td>${u.uIdcard}</td>
					<td>${u.uSex}</td>
					<td>${u.uAddress}</td>
					<td>${u.uPhone}</td>
					<td>${u.uCreatetime}</td>
					<td>${u.uPicture}</td>					
					<c:if test="${u.uDuty==0 }">
					<td>员工</td>
					</c:if>
					<c:if test="${u.uDuty==1 }">
					<td>管理员</td>
					</c:if>
					<c:if test="${u.uState==0 }">
					<td>审核</td>
					</c:if>
					<c:if test="${u.uState==1 }">
					<td>未审核</td>
					</c:if>					
					<td>${u.uDname}</td>					
					<td><a href="delete?user.uId=${u.uId}">删除</a>
					<a href="select?user.uId=${u.uId}">更新</a></td>				
				</tr>
			</c:forEach>
		</table>
	</c:if>

<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  
	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	</script>
  </body>
</html>

更新用户信息uUpdate.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">   
    <title>添加页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <form action="update" method="post" class="layui-form layui-form-pane">
		
		<h2>更新数据</h2>
		<br />
		<div class="layui-form-item pane">
			<label class="layui-form-label">编号</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uId" value="${u.uId}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">用户名</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uName" value="${u.uName}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">身份证号</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uIdcard" value="${u.uIdcard}"  readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item">
		    <label class="layui-form-label">性别</label>
		    <div class="layui-input-block">
		      <input type="radio" name="user.uSex" value="男" title="男">
		      <input type="radio" name="user.uSex" value="女" title="女" checked>
		    </div>
		  </div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">地址</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uAddress" value="${u.uAddress}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">手机号</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uPhone" value="${u.uPhone}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">创建时间</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uCreatetime" value="${u.uCreatetime}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">员工形象</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uPicture"  value="${u.uPicture}" autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">员工角色</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uDuty" value="${u.uDuty}"  autocomplete="off"
					class="layui-input ">
			</div>			
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">员工状态</label>			
			<div class="layui-input-inline">
		      <select name="user.uState" value="${u.uState}" lay-verify="required">		             
		        <option value="0">审核</option>
		        <option value="1">待审核</option>	       
		      </select>
		    </div>
		</div>	
		<div class="layui-form-item pane">
			<label class="layui-form-label">部门名称</label>
			<div class="layui-input-inline">
				<input type="text" name="user.uDname" value="${u.uDname}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>	
		<div class="layui-form-item ">
			<div class="layui-input-inline">
				<button class="layui-btn" lay-submit lay-filter="*">更新</button>
			</div>
		</div>	
			
	</form>
	${error }
	<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  
	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	</script>
  </body>
</html>

模糊查询员工信息(根据角色管理员或者员工查询)sList.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
<form action="selectuDuty" method="get" class="layui-form layui-form-pane">
		<div class="layui-form-item">
		    <label class="layui-form-label">角色</label>
		    <div class="layui-input-inline">
		      <select name="user.uDuty" lay-verify="required">
		      <option ></option>
		      	<option value="1">管理员</option>		             
		        <option value="0">员工</option>		        	       
		      </select>
		    </div>
		    	<c:if test="${user!=null}">
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>用户名</th>
				<th>身份证号</th>
				<th>性別</th>
				<th>地址</th>						
				<th>手机号</th>				
				<th>创建时间</th>
				<th>员工形象</th>	
				<th>员工角色</th>				
				<th>员工状态</th>	
				<th>部门名称</th>
				<th>操作</th>		
			</tr>
			<c:forEach items="${user }" var="u" varStatus="vs">
				<tr>
					<td>${vs.count}</td>
					<td>${u.uName}</td>
					<td>${u.uIdcard}</td>
					<td>${u.uSex}</td>
					<td>${u.uAddress}</td>
					<td>${u.uPhone}</td>
					<td>${u.uCreatetime}</td>
					<td>${u.uPicture}</td>					
					<c:if test="${u.uDuty==0 }">
					<td>员工</td>
					</c:if>
					<c:if test="${u.uDuty==1 }">
					<td>管理员</td>
					</c:if>
					<c:if test="${u.uState==0 }">
					<td>审核</td>
					</c:if>
					<c:if test="${u.uState==1 }">
					<td>未审核</td>
					</c:if>					
					<td>${u.uDname}</td>					
					<td><a href="delete?user.uId=${u.uId}">删除</a>
					<a href="select?user.uId=${u.uId}">更新</a></td>				
				</tr>
			</c:forEach>
		</table>
	</c:if>
		    <div class="layui-input-inline">
				<button class="layui-btn" lay-submit lay-filter="*">查询</button>
			</div>
		  </div>		
	
</form>	
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  
	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	</script>
  </body>
</html>

所有部门信息dList.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <!-- JSTL: jsp Standard<标准> Tag<标签> Lib<库> -->
	<c:if test="${dList!=null}">
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>部门名称</th>
				<th>基本工资</th>
				<th>奖金</th>						
				<th>部门状态</th>									
				<th>操作</th>		
			</tr>
			<c:forEach items="${dList}" var="u" varStatus="vs">
				<tr>
					<td>${vs.count}</td>
					<td>${u.dName}</td>
					<td>${u.dMoney}</td>
					<td>${u.dBonus}</td>
					<td>${u.dStatus}</td>										
					<td><a href="ddelete?dId=${u.dId}">删除</a>
					<a href="dselect?dId=${u.dId}">更新</a>
					<a href="selectDname?department.dName=${u.dName}">查询部门员工</a></td>				
				</tr>
			</c:forEach>
		</table>
	</c:if>
	
  </body>
</html>

更新部门dUpdate.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">   
    <title>添加页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <form action="dupdate" method="post" class="layui-form layui-form-pane">
		
		<h2>更新数据</h2>
		<br />
		<div class="layui-form-item pane">
			<label class="layui-form-label">编号</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dId" id="name" value="${u.dId}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">部门名称</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dName" id="name" value="${u.dName}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">基本工资</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dMoney" value="${u.dMoney}"  autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">奖金</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dBonus" value="${u.dBonus}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">部门状态</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dStatus" value="${u.dStatus}" autocomplete="off"
					class="layui-input ">
			</div>
		</div>		
		<div class="layui-form-item ">
			<div class="layui-input-inline">
				<button class="layui-btn" lay-submit lay-filter="*">更新</button>
			</div>
		</div>	
			
	</form>
	<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  if("" != "${error}"){
			layer.open({
				title : '友情提示',
				content : '${error}'
			})
		}

	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	
	</script>
  </body>
</html>

查询部门员工(根据部门查询员工信息)dSelect.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
<form action="selectDname" method="get" class="layui-form layui-form-pane">		
		 <c:if test="${user!=null}">
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>用户名</th>
				<th>身份证号</th>
				<th>地址</th>						
				<th>手机号</th>				
				<th>创建时间</th>
				<th>员工形象</th>	
				<th>员工角色</th>				
				<th>员工状态</th>	
				<th>部门名称</th>
				<th>操作</th>		
			</tr>
			<c:forEach items="${user }" var="u" varStatus="vs">
				<tr>
					<td>${vs.count}</td>
					<td>${u.uName}</td>
					<td>${u.uIdcard}</td>
					<td>${u.uAddress}</td>
					<td>${u.uPhone}</td>
					<td>${u.uCreatetime}</td>
					<td>${u.uPicture}</td>					
					<c:if test="${u.uDuty==0 }">
					<td>员工</td>
					</c:if>
					<c:if test="${u.uDuty==1 }">
					<td>管理员</td>
					</c:if>
					<c:if test="${u.uState==0 }">
					<td>审核</td>
					</c:if>
					<c:if test="${u.uState==1 }">
					<td>审核</td>
					</c:if>					
					<td>${u.uDname}</td>					
					<td><a href="delete?user.uId=${u.uId}">删除</a>
					<a href="select?user.uId=${u.uId}">更新</a></td>				
				</tr>
			</c:forEach>
		</table>
	</c:if>		   			
</form>	
<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  if("" != "${error}"){
			layer.open({
				title : '友情提示',
				content : '${error}'
			})
		}

	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	
	</script>
  </body>
</html>

添加部门dAdd.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">   
    <title>添加页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <form action="dadd" method="get" class="layui-form layui-form-pane">
		
		<h2>添加部门</h2>
		<br />
		<div class="layui-form-item pane">
			<label class="layui-form-label">部门名称</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dName" id="name" autocomplete="off"
					class="layui-input ">
			</div>
			<span id="nameError" style="color: red;" class="error"></span>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">基本工资</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dMoney" id="password" autocomplete="off"
					class="layui-input ">
			</div>
			<span id="passwordError" style="color: red; display: none" class="error"></span>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">奖金</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dBonus" autocomplete="off"
					class="layui-input ">
			</div>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">部门状态</label>
			<div class="layui-input-inline">
				<input type="text" name="department.dStatus" value="可用" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>
		</div>	
			
		<div class="layui-form-item ">
			<div class="layui-input-inline">
				<button class="layui-btn" lay-submit lay-filter="*">添加</button>
			</div>
		</div>	
		
	</form>
	<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  if("" != "${error}"){
			layer.open({
				title : '友情提示',
				content : '${error}'
			})
		}

	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	
	</script>
  </body>
</html>

管理员账号信息code.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <meta charset="utf-8">   
    <title>信息展示页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <!-- JSTL: jsp Standard<标准> Tag<标签> Lib<库> -->
	
		<table class="table table-bordered table-hover table-striped">
			<tr>
				<th>序号</th>
				<th>用户名</th>
				<th>密码</th>	
				<th>操作</th>				
			</tr>			
				<tr>
					<td>${s.id}</td>
					<td>${s.name}</td>
					<td>${s.pwd}</td>														
					<td><a href="mselect?systemUser.id=${s.id}">更新</a></td>				
				</tr>			
		</table>	
  </body>
</html>

修改账号密码updatePwd.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">   
    <title>添加页面</title>	
     <link rel="stylesheet" type="text/css" href="bootstrap-3.3.7/css/bootstrap.css" />	
     <link rel="stylesheet" type="text/css" href="layui/css/layui.css" />	
  </head> 
  
<body>
 <form action="updatePwd" method="post" class="layui-form layui-form-pane">
		
		<h2>更新数据</h2>
		<br />
		<div class="layui-form-item pane">
			<label class="layui-form-label">编号</label>
			<div class="layui-input-inline">
				<input type="text" name="systemUser.id" id="name" value="${s.id}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>
			<span id="nameError" style="color: red;" class="error"></span>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">用户名</label>
			<div class="layui-input-inline">
				<input type="text" name="systemUser.name" id="name" value="${s.name}" readonly="readonly" autocomplete="off"
					class="layui-input ">
			</div>
			<span id="nameError" style="color: red;" class="error"></span>
		</div>
		<div class="layui-form-item pane">
			<label class="layui-form-label">密码</label>
			<div class="layui-input-inline">
				<input type="text" name="systemUser.pwd" value="${s.pwd}"  autocomplete="off"
					class="layui-input ">
			</div>
			<span id="passwordError" style="color: red; display: none" class="error"></span>
		</div>		
		<div class="layui-form-item ">
			<div class="layui-input-inline">
				<button class="layui-btn" lay-submit lay-filter="*">更新</button>
			</div>
		</div>	
			
	</form>
	<script type="text/javascript" src="js/jquery-3.3.1.js"></script>
	<script src="layui/layui.js" charset="utf-8"></script>
	<!-- 注意:如果你直接复制所有代码到本地,上述js路径需要改成你本地的 -->
	<script>
	//Demo
	layui.use('form', function(){
	  var form = layui.form;
	  if("" != "${error}"){
			layer.open({
				title : '友情提示',
				content : '${error}'
			})
		}

	  //监听提交
	  form.on('submit(formDemo)', function(data){
	    layer.msg(JSON.stringify(data.field));
	    return false;
	  });
	});
	
	</script>
  </body>
</html>

数据库表:

/*创建最高管理员表*/
CREATE TABLE t_system(
id int(11) NOT NULL PRIMARY key auto_increment,
name varchar(255) NOT NULL,
pwd varchar(255) NOT NULL 
);

INSERT INTO t_system VALUES(1,'admin','123');

/*创建部门表*/
CREATE TABLE t_department (
  dId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
	dName varchar(255) DEFAULT NULL COMMENT '部门名称',
  dMoney varchar(255) DEFAULT NULL COMMENT '基本工资',
	dBonus varchar(25)  COMMENT '奖金',
	dStatus varchar(25) NOT NULL COMMENT '正常,不可用'
) ;

INSERT INTO t_department VALUES (1, '销售部', '4200','600','正常');
INSERT INTO t_department VALUES (2, '技术部', '5000','1000','正常');
INSERT INTO t_department VALUES (3, '后勤部', '3500','450','正常');
INSERT INTO t_department VALUES (4, '财务部', '3000','700','正常');
INSERT INTO t_department VALUES (5, '人事部', '2500','500','正常');

/*创建员工表*/
CREATE TABLE t_user (
  uId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
  uName varchar(255) NOT NULL COMMENT '员工姓名',
	uIdcard varchar(255) NOT NULL COMMENT '身份证号',
  uSex char(4) COMMENT '1代表男,0代表女',
	uAddress varchar(255) NOT NULL COMMENT '地址',
  uPhone varchar(255) NOT NULL COMMENT '电话', 
	uCreatetime varchar(25) NOT NULL COMMENT '创建时间',
	uPicture varchar(255) COMMENT '员工形象',
	uDuty varchar(255) NOT NULL COMMENT '角色',
	uState varchar(25) default 0 COMMENT '1待审核,0审核通过',
  uDname varchar(255) COMMENT '部门名称'
) ;

/*创建最高管理员表*/
CREATE TABLE t_system(
id int(11) NOT NULL PRIMARY key auto_increment,
name varchar(255) NOT NULL,
pwd varchar(255) NOT NULL 
);

INSERT INTO t_system VALUES(1,'admin','123');

/*创建部门表*/
CREATE TABLE t_department (
  dId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
	dName varchar(255) DEFAULT NULL COMMENT '部门名称',
  dMoney varchar(255) DEFAULT NULL COMMENT '基本工资',
	dBonus varchar(25)  COMMENT '奖金',
	dStatus varchar(25) NOT NULL COMMENT '正常,不可用'
) ;

INSERT INTO t_department VALUES (1, '销售部', '4200','600','正常');
INSERT INTO t_department VALUES (2, '技术部', '5000','1000','正常');
INSERT INTO t_department VALUES (3, '后勤部', '3500','450','正常');
INSERT INTO t_department VALUES (4, '财务部', '3000','700','正常');
INSERT INTO t_department VALUES (5, '人事部', '2500','500','正常');

/*创建员工表*/
CREATE TABLE t_user (
  uId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
  uName varchar(255) NOT NULL COMMENT '员工姓名',
	uIdcard varchar(255) NOT NULL COMMENT '身份证号',
  uSex char(4) COMMENT '1代表男,0代表女',
	uAddress varchar(255) NOT NULL COMMENT '地址',
  uPhone varchar(255) NOT NULL COMMENT '电话', 
	uCreatetime varchar(25) NOT NULL COMMENT '创建时间',
	uPicture varchar(255) COMMENT '员工形象',
	uDuty varchar(255) NOT NULL COMMENT '角色',
	uState varchar(25) default 0 COMMENT '1待审核,0审核通过',
  uDname varchar(255) COMMENT '部门名称'
) ;



/*创建请假表*/
CREATE TABLE t_leave (
  lId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
	lDid int(11) NOT NULL COMMENT '部门编号',
	lMsg varchar(255) NOT NULL COMMENT '请假原因',
	lCreatetime varchar(25) NOT NULL COMMENT '请假时间',
	lState varchar(25) COMMENT '请假状态',
	lUid int(11) DEFAULT NULL COMMENT '用户编号'
  
) 





/*创建请假表*/
CREATE TABLE t_leave (
  lId int(11) NOT NULL PRIMARY key auto_increment COMMENT '编号',
	lDid int(11) NOT NULL COMMENT '部门编号',
	lMsg varchar(255) NOT NULL COMMENT '请假原因',
	lCreatetime varchar(25) NOT NULL COMMENT '请假时间',
	lState varchar(25) COMMENT '请假状态',
	lUid int(11) DEFAULT NULL COMMENT '用户编号'
  
) 



更详细源码可去链接下载:

https://download.csdn.net/download/qq_43560721/11103821

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值