rule.java

自己做的一个简单的JAVA考勤系统

package rule;
import access.AccessDataBase;
import java.util.Calendar;
import displayposition.position;
import queue.Queue;
public class Rule implements position
{
  //
 AccessDataBase access=new AccessDataBase();
 public int ExcuteInsertDepartment(String s[])
 {
 	  
 	String str="insert into Department (DepName,DepOntime,DepOfftime) values(";
	for (int i=0; i<s.length-1; i++){
		if(i==0)
		str=str + "'" + s[i] + "',";
		else
		str=str + "'" + this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+s[i] + "',";
		}
	str=str+"'" +s[s.length-1] + "')";
   
 	return access.doing(str);
 }
 public int ExcuteDeleteDepartment(String Depnum)
 {
 
 	String sql="delete from Department where DepID="+Depnum;
 	return access.doing(sql);
 }
 public int ExcuteUpdateDepartment(String[] Dep )
 {
 	
 	if(Dep.length==4)
 	{
 	 String sql="update Department set DepName='"+Dep[1]+"',DepOnTime='"+this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+Dep[2]+"',DepOffTime='"+this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+Dep[3]+"' where DepID="+Dep[0];
 	 	
 	 return access.doing(sql);
 	}
 	else
 	 return 0;
  
 }
  public int ExcuteInsertEmployee(String s[]){
  	
  	String str="insert into Employee (EmpName,EmpofDepartment,CheckStandard,EmpOnTime,EmpOffTime,EmpState) values(";
	for (int i=0; i<s.length-1; i++){
		if(i==3|i==4)
		str=str + "'" + this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+s[i] + "',";
		else
		str=str + "'" + s[i] + "',";
		}
	   str=str+"'" +s[s.length-1] + "')";
  	  	return access.doing(str);
  	
  }
  
 public int ExcuteDeleteEmployee(String Depnum)
 {
 	String sql="delete from Employee where EmpID="+Depnum;
 	return access.doing(sql);
 }
 
 public int UpdateEmployee(String[] Emp)
 {
 String sql="update Employee set EmpName='"+Emp[1]+"',EmpOfDepartment='"+Emp[2]+"',CheckStandard='"+Emp[3]+"',EmpOnTime='"+this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+Emp[4]+"',EmpOffTime='"+this.YEAR+"-"+this.MONTH+"-"+this.DAY+" "+Emp[5]+"',EmpState='"+Emp[6]+"' where EmpID="+Emp[0];
 return access.doing(sql);
 }
 
 public int InsertRecord(Queue red)
 {
 	Calendar ca=Calendar.getInstance();
 	String str="insert into Record (EmpID,CardTime,Type,Result,BelastTime) values(";
	for (int i=0; i<red.getlength()-1; i++){
		if(i==1)
		str=str + "'" +ca.get(Calendar.YEAR)+"-"+(ca.get(Calendar.MONTH)+1)+"-"+ca.get(Calendar.DAY_OF_MONTH)+" "+red.get(i) + "',";
		else
		str=str + "'" + red.get(i) + "',";
		}
	    str=str+"'" +red.get(red.getlength()-1) + "')";
	    
  	   return access.doing(str);
  	  
 }
}