querydata.java

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

package code;
import java.util.*;
import java.sql.Time;
import access.AccessDataBase;
import javax.swing.table.*;

public class QueryData
{
   AccessDataBase access=new AccessDataBase();
   
   public ArrayList getColumnsName(String tableName)
   {
   	
   	 return access.getConlumnsNameFromDB("select * from "+tableName+" where 1=2 ");
   }
   public ArrayList getQueryData(String str)
   {
   	  
   	  return access.getData("select * from Department where DepName like'%"+str+"%' order by DepID");
   }
   public ArrayList getOnTimeAndOffTime(String str)
   {
   	 
   	  return access.getData("select DepOnTime,DepOffTime from Department where DepName ='"+str+"'");
   }
   
   public ArrayList getDepartmentData()
   {
   	  
   	  return access.getData("select DepName from Department  order by DepID");
   }
   public ArrayList getEmployeeData(String str)
   {
   	  return access.getData("select * from Employee where EmpID like'%"+str+"%' order by EmpID");
   }
   public boolean getEmployee(int ID)
   {
   	  return access.queryEmployee(ID);
   }
   public String getOntime(int ID)
   {
   	  Time time=access.getEmpOntime(ID);
   	  return time.toString();
   }
   
   public ArrayList getDataFromRecord(int empid)
   {
   	
   	  return access.getEmp_TotalData(empid);
   }
   public ArrayList getDataFromTotalRecord(int empid)
   {
   	
   	  return access.getEmp_TotalData2(empid);
   }
   public ArrayList getColumnsFromRecord()
   {
    String sql="select Employee.EmpID,Employee.EmpName,Record.Type,Record.CardTime,Record.Result,Record.BeLastTime from Employee , Record where Employee.EmpID like Record.EmpID  and Employee.EmpID like 1";
   	return access.getEmp_TotalName(sql);
   }
   public ArrayList getColumnsFromTotalRecord()
   {
    String sql="select EmpID,left(CardTime,7) as YearMonth,Result,count(*) as Times from Record  group by EmpID,left(CardTime,7),Result";
   	return access.getEmp_TotalName2(sql);
   }
   public ArrayList getEmployeesWorkInformation()
   {
   	 String sql="select Employee.EmpID,Employee.EmpName,Record.Type,Record.CardTime,Record.Result,Record.BeLastTime from Employee , Record where Employee.EmpID=Record.EmpID order by Employee.EmpID";
   	 return access.getAllTotalData(sql);
   }
   public ArrayList getEmployeesTotalWorkInformation()
   {
   	 String sql="select EmpID,left(CardTime,7) as YearMonth,Result,count(*) as Times from Record where EmpID like '%' group by EmpID,left(CardTime,7),Result";
   	 return access.getAllTotalData2(sql);
   }
   public String getOfftime(int ID)
   {
   	  Time time=access.getEmpOfftime(ID);
   	  return time.toString();
   }
}