CREATE DATABASE IF NOT EXISTS hrSystem COLLATE = 'utf8_general_ci' CHARACTER SET = 'utf8';
 
use hrSystem;

create table attend_type_inf
(
 type_id int auto_increment,
 amerce_amount double not null,
 type_name varchar(50) not null,
 primary key(type_id)
);
 
 
create table employee_inf
(
 emp_id int auto_increment,
 emp_type int,
 emp_name varchar(50) not null,
 emp_pass varchar(50) not null,
 emp_salary double not null,
 mgr_id int,
 dept_name varchar(50),
 primary key(emp_id),
 unique key(emp_name),
 foreign key(mgr_id) references employee_inf(emp_id)
);
 
 
create table attend_inf
(
 attend_id int auto_increment,
 duty_day varchar(50) not null,
 punch_time datetime,
 is_come boolean not null,
 type_id int not null,
 emp_id int not null,
 primary key(attend_id),
 foreign key(type_id) references attend_type_inf(type_id),
 foreign key(emp_id) references employee_inf(emp_id)
);
 
 
create table application_inf
(
 app_id int auto_increment,
 attend_id int not null,
 app_reason varchar(255),
 app_result boolean,
 type_id int not null,
 primary key(app_id),
 foreign key(type_id) references attend_type_inf(type_id),
 foreign key(attend_id) references attend_inf(attend_id)
);
 
 
create table payment_inf
(
 pay_id int auto_increment,
 pay_month varchar(50) not null,
 pay_amount double not null,
 emp_id int not null,
 primary key(pay_id),
 foreign key(emp_id) references employee_inf(emp_id)
);
 
 
create table checkback_inf
(
 check_id int auto_increment,
 app_id int not null,
 check_result boolean not null,
 check_reason varchar(255),
 mgr_id int not null,
 primary key(check_id),
 foreign key(app_id) references application_inf(app_id),
 foreign key(mgr_id) references employee_inf(emp_id)
);
 
 
INSERT INTO `test_user` VALUES ('1', '123455@qq.com','12345', 'test');
 
 
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '正常', 0);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '事假', -20);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '病假', -10);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '遲到', -10);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '早退', -10);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '曠工', -30);
insert into attend_type_inf ( type_name , amerce_amount)
 values ( '出差', 10);
 
 
# 插入經(jīng)理
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id , dept_name)
 values (2, 'oracle', 'oracle' , 5000 , null , 'DB部');
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id , dept_name)
 values (2, 'weblogic', 'weblogic' , 6000 , null , 'Server部');
# 員工
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id)
 values (1 , 'mysql', 'mysql' , 3000 , 1);
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id)
 values (1 , 'hsql', 'hsql' , 3200 , 1);
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id)
 values (1 , 'tomcat', 'tomcat' , 2800 , 2);
insert into employee_inf (emp_type , emp_name , emp_pass , emp_salary , mgr_id)
 values (1 , 'jetty', 'jetty' , 2560 , 2);

package com.kevin.HRSystem.model;
 
public class Employee {
 private long id;
 private int type;
 private String name;
 private String password;
 private double salary;
 private Manager manager;
 
 public long getId() {
  return id;
 }
 
 public void setId(long id) {
  this.id = id;
 }
 
 public int getType() {
  return type;
 }
 
 public void setType(int type) {
  this.type = type;
 }
 
 public String getName() {
  return name;
 }
 
 public void setName(String name) {
  this.name = name;
 }
 
 public String getPassword() {
  return password;
 }
 
 public void setPassword(String password) {
  this.password = password;
 }
 
 public double getSalary() {
  return salary;
 }
 
 public void setSalary(double salary) {
  this.salary = salary;
 }
 
 public Manager getManager() {
  return manager;
 }
 
 public void setManager(Manager manager) {
  this.manager = manager;
 }
 
 @Override
 public String toString() {
  String rsl = "Employee [id=" + this.id + ", name=" + this.name + ", password=" + this.password + ", type=" + this.type + ", salary=" + this.salary;
  if(this.manager != null) {
   rsl += ", managerId=" + this.manager.getId() + ", managerName=" + this.manager.getName() + "]";
  }
  return rsl;
 }
}

package com.kevin.HRSystem.dao; 
import java.util.List; 
public interface BaseDao<T> { 
 void save(T entity); //保持持久化實(shí)例 
 void delete(long id); //根據(jù)主鍵刪除持久化實(shí)例 
 void update(T entity); //更新持久化實(shí)例 
 T findById(long id); //根據(jù)主鍵加載持久化實(shí)例
  List<T> findAll(); //獲取數(shù)據(jù)表中全部的持久化實(shí)例
}

package com.kevin.HRSystem.dao;
 
import com.kevin.HRSystem.model.Employee;
import com.kevin.HRSystem.model.Manager;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
public interface EmployeeDao extends BaseDao<Employee>{
 /**
  * 根據(jù)用戶名和密碼查詢員工
  * @param name 用戶名
  *  password 密碼
  * @return 返回員工
  */
 public Employee findByNameAndPass(@Param("name")String name, @Param("password") String password);
 
 public Employee findByName(@Param("name")String name);
 
 public List<Employee> findEmployeesByMgrId(@Param("id") long id);
 
 public void saveAsEmployee(Employee employee);
 
 public void saveAsManager(Manager manager);
}

<?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: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.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
 
 <!--掃描service包下所有注解的類型-->
 <context:component-scan base-package="com.kevin.HRSystem.service"/>
 
 <!--配置數(shù)據(jù)庫相關(guān)參數(shù)properties的屬性-->
 <context:property-placeholder location="classpath:jdbc.properties"/>
 
 <!--配置數(shù)據(jù)源-->
 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  <property name="driverClass" value="${jdbc.driver}"/>
  <property name="jdbcUrl" value="${jdbc.url}"/>
  <property name="user" value="${jdbc.username}"/>
  <property name="password" value="${jdbc.password}"/>
  <property name="maxPoolSize" value="${c3p0.maxPoolSize}"/>
  <property name="minPoolSize" value="${c3p0.minPoolSize}"/>
  <property name="autoCommitOnClose" value="${c3p0.autoCommitOnClose}"/>
  <property name="checkoutTimeout" value="${c3p0.checkoutTimeout}"/>
  <property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}"/>
 </bean>
 
 <!--配置sqlSessionFactory-->
 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="dataSource"/>
  <!--掃描Model包，使用別名-->
  <property name="typeAliasesPackage" value="com.kevin.HRSystem.model"/>
  <property name="mapperLocations" value="classpath:mapper/*.xml"/>
 </bean>
 
 <!--配置掃描DAO接口包，動態(tài)實(shí)現(xiàn)Dao接口，注入到spring容器中-->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  <property name="basePackage" value="com.kevin.HRSystem.dao"/>
 </bean>
 
 <!--配置事務(wù)管理器-->
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <!--注入數(shù)據(jù)庫連接池-->
  <property name="dataSource" ref="dataSource"/>
 </bean>
 
 <tx:annotation-driven transaction-manager="transactionManager"/>
 
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 
 
<mapper namespace="com.kevin.HRSystem.dao.EmployeeDao">
 <insert id="save" parameterType="Employee" useGeneratedKeys="true" keyProperty="id">
  INSERT INTO employee_inf(emp_type, emp_name, emp_pass, emp_salary, mgr_id, dept_name) VALUES (#{type}, #{name}, #{password}, #{salary}, #{manager.id}, #{departmentName})
 </insert>
 
 <insert id="saveAsEmployee" parameterType="Employee" useGeneratedKeys="true" keyProperty="id">
  INSERT INTO employee_inf(emp_type, emp_name, emp_pass, emp_salary, mgr_id) VALUES (#{type}, #{name}, #{password}, #{salary}, #{manager.id})
 </insert>
 
 <insert id="saveAsManager" parameterType="Manager" useGeneratedKeys="true" keyProperty="id">
  INSERT INTO employee_inf(emp_type, emp_name, emp_pass, emp_salary, dept_name) VALUES (#{type}, #{name}, #{password}, #{salary}, #{departmentName})
 </insert>
 
 
 <delete id="delete" parameterType="long">
  DELETE FROM employee_inf WHERE emp_id=#{id}
 </delete>
 
 <update id="update" parameterType="Employee">
  UPDATE employee_inf SET emp_name=#{name}, emp_pass=#{password}, emp_salary=#{saraly}, emp_type=#{type}, mgr_id=#{manager.id} WHERE emp_id=#{id}
 </update>
 
 <!--查詢語句 start-->
 
 <select id="findAll" resultMap="employeeResultMap">
  SELECT * FROM employee_inf
 </select>
 
 <select id="findById" parameterType="long" resultMap="employeeResultMap">
  SELECT * FROM employee_inf WHERE emp_id=#{id}
 </select>
 
 <select id="findByNameAndPass" resultMap="employeeResultMap">
  SELECT * FROM employee_inf WHERE emp_name=#{name} and emp_pass=#{password}
 </select>
 
 <select id="findByName" resultMap="employeeResultMap">
  SELECT * FROM employee_inf WHERE emp_name=#{name}
 </select>
 
 <!--根據(jù)mgr_id查找員工-->
 <select id="findEmployeesByMgrId" parameterType="long" resultMap="employeeResultMap">
  SELECT * FROM employee_inf WHERE mgr_id=#{id}
 </select>
 
 <!--查詢語句 end -->
 
 <!-- resultMap設(shè)置，使用鑒別器來區(qū)分employee和manager-->
 <resultMap id ="employeeResultMap" type="com.kevin.HRSystem.model.Employee">
  <id property="id" column="emp_id"/>
  <result property="type" column="emp_type"/>
  <result property="name" column="emp_name"/>
  <result property="password" column="emp_pass"/>
  <result property="salary" column="emp_salary"/>
  <discriminator javaType="int" column="emp_type">
   <case value="1" resultMap="originalEmployeeResultMap"/>
   <case value="2" resultMap="managerResultMap"/>
  </discriminator>
 </resultMap>
 
 
 <resultMap id="originalEmployeeResultMap" type="com.kevin.HRSystem.model.Employee" extends="employeeResultMap">
  <association property="manager" javaType="com.kevin.HRSystem.model.Manager">
   <id property="id" column="mgr_id"/>
  </association>
 </resultMap>
 
 <resultMap id="managerResultMap" type="com.kevin.HRSystem.model.Manager" extends="employeeResultMap">
  <result property="departmentName" column="dept_name"/>
  <collection property="employees" column="emp_id" ofType="com.kevin.HRSystem.model.Employee" select="com.kevin.HRSystem.dao.EmployeeDao.findEmployeesByMgrId"/>
 </resultMap>
 
 <!--基礎(chǔ)resultMap end-->
 
 
 <select id="selectByIdWithForeign" parameterType="long" resultMap="employeeWithForeignResultMap">
  SELECT e.emp_id, e.emp_name, e.emp_pass, e.emp_type, e.emp_salary, m.emp_id mgr_id, m.emp_name mgr_name, m.dept_name FROM employee_inf e, employee_inf m WHERE e.mgr_id = m.emp_id and e.emp_id = #{id}
 </select>
 
 <resultMap id ="employeeWithForeignResultMap" type="com.kevin.HRSystem.model.Employee">
  <id property="id" column="emp_id"/>
  <result property="type" column="emp_type"/>
  <result property="name" column="emp_name"/>
  <result property="password" column="emp_pass"/>
  <result property="salary" column="emp_salary"/>
  <association property="manager" javaType="com.kevin.HRSystem.model.Manager">
   <id property="id" column="mgr_id"/>
   <result property="name" column="mgr_name"/>
   <result property="departmentName" column="dept_name"/>
  </association>
 </resultMap>
 
</mapper>

package com.kevin.HRSystem.service;
 
import com.kevin.HRSystem.model.AttendType;
import com.kevin.HRSystem.model.Employee;
import com.kevin.HRSystem.model.Manager;
import com.kevin.HRSystem.vo.AttendVo;
import com.kevin.HRSystem.vo.PaymentVo;
 
import java.util.List;
 
public interface EmpManagerService {
 
 /**
  * 驗(yàn)證登錄
  * @param employee 登錄的身份
  * @return
  * 登錄后的身份確認(rèn)：0為登錄失敗，1為登錄emp，2為登錄mgr
  */
 int validLogin(Employee employee);
 
 
 /**
  * 自動打卡，周一到周五，早上7點(diǎn)為每個(gè)員工插入曠工記錄
  */
 void autoPunch();
 
 /**
  * 自動結(jié)算工資，每月1號，結(jié)算上個(gè)月工資
  */
 void autoPay();
 
 /**
  * 驗(yàn)證某個(gè)員工是否可以打卡，以及打卡的類型，上班打卡，還是下班打卡
  * @param user 員工名
  * @param dutyDay 日期
  * @return 可打卡的類別
  */
 int validPunch(String user, String dutyDay);
 
 
 /**
  * 實(shí)現(xiàn)普通員工的打卡
  * @param user 員工名
  * @param dutyDay 打卡日期
  * @param isCome 是否是上班打卡
  * @return 打卡結(jié)果
  */
 int punch(String user, String dutyDay, boolean isCome);
 
 /**
  * 根據(jù)員工瀏覽自己的工資
  * @param employeeName 員工名
  * @return 該員工的工資列表
  */
 List<PaymentVo> employeeSalary(String employeeName);
 
 
 /**
  * 員工查看自己的最近三天的非正常打卡
  * @param employeeName 員工名
  * @return 該員工最近三天的非正常打卡
  */
 List<AttendVo> getUnAttend(String employeeName);
 
 
 /**
  * 返回全部的出勤類別
  * @return 全部的出勤類別
  */
 List<AttendType> getAllType();
 
 /**
  * 添加申請
  * @param attId 申請的出勤ID
  * @param typeId 申請的類型ID
  * @param reason 申請的理由
  * @return 添加的結(jié)果
  */
 boolean addApplication(int attId, int typeId, String reason);
 
}

package com.kevin.HRSystem.service.impl;
 
import com.kevin.HRSystem.dao.*;
import com.kevin.HRSystem.model.*;
import com.kevin.HRSystem.service.EmpManagerService;
import com.kevin.HRSystem.vo.AttendVo;
import com.kevin.HRSystem.vo.PaymentVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
 
import static com.kevin.HRSystem.constant.ConstantManager.*;
 
@Service("EmpManagerService")
public class EmpManagerServiceImpl implements EmpManagerService {
 @Resource
 private ApplicationDao applicationDao;
 @Resource
 private AttendDao attendDao;
 @Resource
 private AttendTypeDao attendTypeDao;
 @Resource
 private CheckbackDao checkbackDao;
 @Resource
 private EmployeeDao employeeDao;
 @Resource
 private PaymentDao paymentDao;
 
 public int validLogin(Employee employee) {
 
  Employee employee1 = employeeDao.findByNameAndPass(employee.getName(), employee.getPassword());
  if(null != employee1) {
   if(employee1 instanceof Manager) {
    System.out.println("EmpManagerService: manager");
    System.out.println(employee);
    return LOGIN_MGR;
   } else {
    System.out.println("EmpManagerService:employee");
    System.out.println(employee);
    return LOGIN_EMP;
   }
  }
 
  return LOGIN_FALT;
 }
 
 public void autoPunch() {
  List<Employee> employees = employeeDao.findAll();
  System.out.println(employees.size());
  //獲取當(dāng)前時(shí)間
  String dutyDay = new java.sql.Date(System.currentTimeMillis()).toString();
  for(Employee employee : employees) {
   System.out.println(employee);
   //先設(shè)置出勤類型為曠工，然后真正出勤的時(shí)候由員工去修改出勤的狀態(tài)
   //6表示曠工；已經(jīng)插入數(shù)據(jù)庫了; 這里最好弄一個(gè)常量管理類；但為了方便先這樣吧
   AttendType attendType = attendTypeDao.findById(6);
   Attend a = new Attend();
   a.setAttendType(attendType);
   a.setDutyDay(dutyDay);
   //如果是早上，則對應(yīng)上班打卡
   if(Calendar.getInstance().get(Calendar.HOUR_OF_DAY) < AM_LIMIT) {
    a.setCome(true);
   } else {
    //下班打卡
    a.setCome(false);
   }
   a.setEmployee(employee);
   attendDao.save(a);
  }
 }
 
 public void autoPay() {
  List<Employee> employees = employeeDao.findAll();
  //獲取上個(gè)月時(shí)間
  Calendar c = Calendar.getInstance();
  c.add(Calendar.DAY_OF_MONTH, -15);
  SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
  String payMonth = sdf.format(c.getTime());
 
  for(Employee employee : employees) {
   Payment pay = new Payment();
   double amount = employee.getSalary();
   //獲取出勤記錄
   List<Attend> attends = attendDao.findByEmpAndMonth(employee, payMonth);
   //計(jì)算工資
   for(Attend attend : attends) {
    amount += attend.getAttendType().getAmerceAmount();
   }
   pay.setPayMonth(payMonth);
   pay.setEmployee(employee);
   pay.setPayAmount(amount);
   paymentDao.save(pay);
  }
 
 }
 
 @Override
 public int validPunch(String user, String dutyDay) {
  //不能查找到對應(yīng)的用戶，返回?zé)o法打卡
  Employee employee = employeeDao.findByName(user);
  if(null == employee) {
   return NO_PUNCH;
  }
  //打到員工指定日期的出勤記錄
  List<Attend> attends = attendDao.findByEmpAndDutyDay(employee, dutyDay);
  //系統(tǒng)沒有為用戶在當(dāng)前插入空打卡記錄，無法打卡
  if(null == attends || attends.size() == 0) {
   return NO_PUNCH;
  }
 
  //開始上班打卡
  if(attends.size() == 1 && attends.get(0).isCome() && null == attends.get(0).getPunchTime()) {
   return COME_PUNCH;
  }
  if(attends.size() == 1 && null == attends.get(0).getPunchTime()) {
   return LEAVE_PUNCH;
  }
  if(attends.size() == 2) {
   if(null == attends.get(0).getPunchTime() && null == attends.get(0).getPunchTime()) {
    return BOTH_PUNCH;
   } else if(null == attends.get(1).getPunchTime()) {
    return LEAVE_PUNCH;
   } else {
    return NO_PUNCH;
   }
  }
  return NO_PUNCH;
 }
 
 public int punch(String user, String dutyDay, boolean isCome) {
  Employee employee = employeeDao.findByName(user);
  if(null == employee) {
   return PUNCH_FALT;
  }
 
  //找到員工本次打卡對應(yīng)的出勤記錄
  Attend attend = attendDao.findByEmpAndDutyDayAndCome(employee, dutyDay, isCome);
  if(null == attend) {
   return PUNCH_FALT;
  }
  //如果已經(jīng)打卡
  if(null != attend.getPunchTime()) {
   return PUNCHED;
  }
 
  int punchHour = Calendar.getInstance().get(Calendar.HOUR_OF_DAY);
  attend.setPunchTime(new Date());
  //上班打卡
  if(isCome) {
   //9點(diǎn)之前算正常
   if(punchHour < COME_LIMIT) {
    //1表示正常
    attend.setAttendType(attendTypeDao.findById(1));
   } else if (punchHour < LATE_LIMIT) {
    //9點(diǎn)到11點(diǎn)之間算遲到
    attend.setAttendType(attendTypeDao.findById(4));
   }
   //11點(diǎn)之后算曠工，不用管，本來初始就是曠工
  } else {
   //下班打卡
   //18點(diǎn)之后算正常
   if(punchHour >= LEAVE_LIMIT) {
    attend.setAttendType(attendTypeDao.findById(1));
   } else if(punchHour >= LEAVE_LIMIT) {
    //16到18點(diǎn)算正常
    attend.setAttendType(attendTypeDao.findById(5));
   }
  }
  attendDao.update(attend);
  return PUNCH_SUCC;
 }
 
 public List<PaymentVo> employeeSalary(String employeeName) {
  Employee employee = employeeDao.findByName(employeeName);
 
  List<Payment> payments = paymentDao.findByEmp(employee);
  System.out.println(payments);
 
  List<PaymentVo> result = new ArrayList<PaymentVo>();
 
  for(Payment payment : payments) {
   result.add(new PaymentVo(payment.getPayMonth(), payment.getPayAmount()));
  }
  return result;
 }
 
 /**
  * 查看自己最近三天的非正常打卡
  * @param employeeName 員工名
  * @return 該員工的最近三天的非正常打卡
  */
 public List<AttendVo> getUnAttend(String employeeName) {
  AttendType type = attendTypeDao.findById(1);
  Employee employee = employeeDao.findByName(employeeName);
 
  //獲取最近三天非正常的出勤記錄
  List<Attend> attends = attendDao.findByEmpUnAttend(employee, type);
  List<AttendVo> result = new ArrayList<AttendVo>();
  for(Attend attend : attends) {
   result.add(new AttendVo(attend.getId(), attend.getDutyDay(), attend.getAttendType().getTypeName(), attend.getPunchTime()));
  }
  return result;
 
 }
 
 public List<AttendType> getAllType() {
  return attendTypeDao.findAll();
 }
 
 @Override
 public boolean addApplication(int attId, int typeId, String reason) {
  Application application = new Application();
  //獲取申請需要改變的出勤記錄
  Attend attend = attendDao.findById(attId);
  AttendType type = attendTypeDao.findById(typeId);
  application.setAttend(attend);
  application.setAttendType(type);
  if(reason != null) {
   application.setApplicationReason(reason);
  }
  applicationDao.save(application);
  return true;
 }
}

 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context-support</artifactId>
  <version>${spring.version}</version>
 </dependency>
 
  <!-- https://mvnrepository.com/artifact/org.quartz-scheduler/quartz -->
 <dependency>
  <groupId>org.quartz-scheduler</groupId>
  <artifactId>quartz</artifactId>
  <version>2.2.1</version>
 </dependency>

# 配置主調(diào)度器屬性
org.quartz.scheduler.instanceName = QuartzScheduler
org.quartz.scheduler.instanceId = AUTO
# 配置線程池
# Quartz線程池的實(shí)現(xiàn)類
org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
# 線程池的線程數(shù)量
org.quartz.threadPool.threadCount = 1
# 線程池里線程的優(yōu)先級
org.quartz.threadPool.threadPriority = 10
# 配置作業(yè)存儲
org.quartz.jobStore.misfireThreshold = 60000
org.quartz.jobStore.class = org.quartz.simpl.RAMJobStore

package com.kevin.HRSystem.schedule;
import com.kevin.HRSystem.service.EmpManagerService;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.springframework.scheduling.quartz.QuartzJobBean;
 
import javax.annotation.Resource;
 
public class PunchJob extends QuartzJobBean {
 //判斷作業(yè)是否執(zhí)行的標(biāo)志
 private boolean isRunning = false;
 
 @Resource
 private EmpManagerService empManagerService;
 
 public void setEmpManagerService(EmpManagerService empManagerService) {
  this.empManagerService = empManagerService;
 }
 
 public void executeInternal(JobExecutionContext ctx) throws JobExecutionException {
  if(!isRunning) {
   System.out.println("開始調(diào)度自動打卡");
   isRunning = true;
   empManagerService.autoPunch();
   System.out.println("打卡結(jié)束");
   isRunning = false;
  }
 }
}

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
 
 <!--croExpression指定cron表達(dá)式：每月3日2時(shí)啟動-->
 <bean id="cronTriggerPay"
   class="org.springframework.scheduling.quartz.CronTriggerFactoryBean"
   p:cronExpression="0 0 2 3 * ? *">
  <property name="jobDetail">
   <!--使用嵌套Bean的方法來定義任務(wù)Bean，jobClass指定任務(wù)bean的實(shí)現(xiàn)類-->
   <bean class="org.springframework.scheduling.quartz.JobDetailFactoryBean" p:jobClass="com.kevin.HRSystem.schedule.PayJob" p:durability="true" >
    <property name="jobDataAsMap">
     <map>
      <entry key="empManagerService" value-ref="EmpManagerService"/>
     </map>
    </property>
   </bean>
  </property>
 </bean>
 
 <!--定義觸發(fā)器來管理任務(wù) Bean cronExpression指定Cron表達(dá)式： 周一到周五7點(diǎn)和12點(diǎn)執(zhí)行調(diào)度-->
 <bean id="cronTriggerPunch" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean" p:cronExpression="0 0 7,12 ? * MON-FRI">
  <property name="jobDetail">
   <bean class="org.springframework.scheduling.quartz.JobDetailFactoryBean" p:jobClass="com.kevin.HRSystem.schedule.PunchJob" p:durability="true">
    <property name="jobDataAsMap">
     <map>
      <entry key="empManagerService" value-ref="EmpManagerService"/>
     </map>
    </property>
   </bean>
 
  </property>
 </bean>
 
 <!--執(zhí)行實(shí)際的調(diào)度-->
 <bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
  <property name="triggers">
   <list>
    <ref bean="cronTriggerPay"/>
    <ref bean="cronTriggerPunch"/>
   </list>
  </property>
 </bean>
 
</beans>

<?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:context="http://www.springframework.org/schema/context"
  xmlns:mvc="http://www.springframework.org/schema/mvc"
  xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context.xsd
  http://www.springframework.org/schema/mvc
  http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
 
 <!-- 掃描web相關(guān)的bean -->
 <context:component-scan base-package="com.kevin.HRSystem.controller"/>
 
 <!-- 開啟SpringMVC注解模式 -->
 <mvc:annotation-driven/>
 
 <!-- 靜態(tài)資源默認(rèn)servlet配置 -->
 <mvc:default-servlet-handler/>
 
 <!-- 配置jsp 顯示ViewResolver -->
 <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
  <property name="prefix" value="/WEB-INF/views/"/>
  <property name="suffix" value=".jsp"/>
 </bean>
</beans>

<?xml version="1.0" encoding="utf-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
 http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1">
 
 <display-name>Archetype Created Web Application</display-name>
 
 <!--編碼過濾器-->
 <filter>
 <filter-name>encodingFilter</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>
 </filter>
 <filter-mapping>
 <filter-name>encodingFilter</filter-name>
 <url-pattern>/*</url-pattern>
 </filter-mapping>
 
 <!--配置SpringMVC中心控制器 DispatcherServlet-->
 <!-- 配置DispatcherServlet -->
 <servlet>
 <servlet-name>SpringMVC</servlet-name>
 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
 <!-- 配置springMVC需要加載的配置文件-->
 <init-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath:spring-*.xml</param-value>
 </init-param>
 <load-on-startup>1</load-on-startup>
 <!--<async-supported>true</async-supported>-->
 </servlet>
 <servlet-mapping>
 <servlet-name>SpringMVC</servlet-name>
 <!-- 匹配所有請求，此處也可以配置成 *.do 形式 -->
 <url-pattern>/</url-pattern>
 </servlet-mapping>
 
 <welcome-file-list>
 <welcome-file>index.jsp</welcome-file>
 </welcome-file-list>
 
</web-app>

 <dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
 </dependency>
 
 <dependency>
  <groupId>taglibs</groupId>
  <artifactId>standard</artifactId>
  <version>1.1.2</version>
 </dependency>

<%--
 Created by IntelliJ IDEA.
 User: kevin
 Date: 18-3-3
 Time: 下午5:34
 To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>Java EE簡單工作流系統(tǒng)</title>
</head>
<body>
<%@include file="header.jsp"%>
<table width="960" align="center"
  background="${pageContext.request.contextPath}/resources/images/bodybg.jpg">
 <tr>
  <td colspan="3">請單擊后面鏈接開始使用系統(tǒng)<a href="loginPage" rel="external nofollow" >登錄系統(tǒng)</a></td>
 </tr>
 <tr>
  <td colspan="3">
   <br>
   <p align="center"><span class="pt11">這僅僅是一個(gè)Java EE的框架程序。應(yīng)用模擬一個(gè)簡單的工作流系統(tǒng)。系統(tǒng)包含兩個(gè)角色，<br>
 普通員工的功能包括員工出勤打卡，員工的人事異動申請，員工查看工資單。<br>
 經(jīng)理的功能包括管理部門員工，簽核申請，每月工資自動結(jié)算等。</span></p>
   <p align="center" class="pt11">應(yīng)用模擬了簡單的工作流，使用的輕量級Java EE架構(gòu)。技術(shù)包括：Struts 2.3、Spring 4.0、Hibernate 4.3、Quartz 2.2，整個(gè)應(yīng)用使用Spring提供的DAO支持操作數(shù)據(jù)庫，同時(shí)利用Spring的聲明式事務(wù)。<br>
    程序中的權(quán)限檢查使用Spring的AOP框架支持，也利用了Spring的任務(wù)調(diào)度抽象<br>
    Hibernate為底層的數(shù)據(jù)庫訪問提供支持,作為O/R Mapping框架使用。</p>
   <p align="center" class="pt11">本程序的源代碼隨程序一起發(fā)布，版權(quán)屬于李剛，<a  rel="external nofollow" >http://www.crazyit.org</a><br>
    任何個(gè)人可用來參考學(xué)習(xí)Java EE架構(gòu)，規(guī)范，但請勿在本程序的基礎(chǔ)上修改，用做任何商業(yè)用途。<br>
    本人保留依法追究相關(guān)責(zé)任的權(quán)利。轉(zhuǎn)載和學(xué)習(xí)請保留此信息。
    <br>
   </p>
  </td>
 </tr>
</table>
<%@include file="footer.jsp"%>
</body>
</html>

 @RequestMapping(value = "/loginPage", method = RequestMethod.GET)
 public ModelAndView showLoginPage() {
  return new ModelAndView("login", "employee", new Employee());
 }

<%--
 Created by IntelliJ IDEA.
 User: kevin
 Date: 18-3-3
 Time: 下午5:55
 To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
 <title>登錄系統(tǒng)</title>
</head>
 
<body>
 <%@include file="header.jsp"%>
 <table width="960" align="center"
   background="${pageContext.request.contextPath}/resources/images/bodybg.jpg">
  <tr>
   <td>
    請輸入用戶名和密碼來登錄<br />
    <c:if test="${error.length() > 0}">
     <div class="error">
       <c:out value="${error}"></c:out>
     </div>
    </c:if>
    <div class="center">
     <form:form method="POST" action="processLogin" modelAttribute="employee">
      <table>
       <tr>
        <td><form:label path="name">Name</form:label></td>
        <td><form:input path="name"/></td>
       </tr>
       <tr>
        <td><form:label path="password">Password</form:label></td>
        <td><form:password path="password"/></td>
       </tr>
       <tr>
        <td><input type="submit" value="登錄"></td>
        <td><input type="reset" value="重填"></td>
       </tr>
      </table>
     </form:form>
    </div>
   </td>
  </tr>
 </table>
<%@include file="footer.jsp"%>
 
</body>
</html>

@RequestMapping(value = "/processLogin", method = RequestMethod.POST)
 public ModelAndView processLogin(@ModelAttribute("employee") Employee employee, HttpServletRequest request) {
  System.out.println(employee);
  System.out.println(request.getProtocol());
  ModelAndView modelAndView;
  int result = empManagerService.validLogin(employee);
  String message;
  //登錄結(jié)果為普通員工
  System.out.println(result);
  if(result == ConstantManager.LOGIN_EMP) {
   //設(shè)置Session
   request.getSession().setAttribute(WebConstant.USER, employee.getName());
   request.getSession().setAttribute(WebConstant.LEVEL, WebConstant.EMP_LEVEL);
 
   message = "您已成功登錄系統(tǒng),您的身份是普通員工";
   System.out.println(message);
//   modelAndView = new ModelAndView("success");
   modelAndView = new ModelAndView("employee/index");
   modelAndView.addObject("message", message);
   return modelAndView;
  } else if(result == ConstantManager.LOGIN_MGR){
   request.getSession().setAttribute(WebConstant.USER, employee.getName());
   request.getSession().setAttribute(WebConstant.LEVEL, WebConstant.MGR_LEVEL);
 
   message = "您已成功登錄系統(tǒng),您的身份是經(jīng)理";
   System.out.println(message);
//   modelAndView = new ModelAndView("success");
   modelAndView = new ModelAndView("manager/index");
   modelAndView.addObject("message", message);
   return modelAndView;
  } else {
   message = "用戶名與密碼不匹配，登錄失敗";
   System.out.println(message);
   modelAndView = new ModelAndView("error");
   modelAndView.addObject("message", message);
   return modelAndView;
  }
 }

<%--
 Created by IntelliJ IDEA.
 User: kevin
 Date: 18-3-6
 Time: 下午4:36
 To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 <title>員工首頁</title>
</head>
<body>
 <%@include file="../header.jsp"%>
 <%@include file="empheader.jsp"%>
 <table width="960" align="center" background="${pageContext.request.contextPath}/resources/images/bodybg.jpg">
  <tr height="60">
   <td> </td>
  </tr>
  <tr>
   <td>
    <c:if test="${message.length()>0}">
     <div class="error">
      <c:out value="${message}"></c:out>
     </div>
    </c:if>
   </td>
  </tr>
  <tr height="80">
   <td> </td>
  </tr>
  <tr>
   <td><%=request.getSession().getAttribute("user")%>
    ，歡迎您使用JavaEE簡單工作流系統(tǒng)，您是普通員工</td>
  </tr>
  <tr height="60">
   <td> </td>
  </tr>
 </table>
<%@include file="../footer.jsp"%>
</body>
</html>