package?com;
import?java.util.*;
import?java.sql.*;
import?java.text.*;

public?class?Attendance?extends?db
{
	//定義成員變量
????private?int?UserID;
????private?int?Schuqin?;
????private?int?RequireTime;
????//執行各種操作的sql語句
????private?String?strSql;
???
????//構造函數，初始化成員變量
????public?Attendance（）
????{???????
????????UserID=0;
????????Schuqin=0;
????????RequireTime=0;
	strSql=““;???
???}???

????/**??
	*@添加員工出勤信息
	*/
???public?boolean?add_attendance（）
???{
????????
????????strSql=“insert?into?Attendance?“;
????????strSql=strSql?+?“（“;
???????strSql=strSql?+?“UserID“;
????????strSql=strSql?+?“Schuqin“;
????????strSql=strSql?+?“?RequireTime“;???????
????????strSql=strSql?+?“）?“;
		strSql=strSql?+?“values（“;
		strSql=strSql?+?“‘“?+?UserID?+?“‘“;
		strSql=strSql?+?“‘“?+?Schuqin?+?“‘“;
????????????????strSql=strSql?+?“‘“?+?RequireTime?+?“‘“;		
		strSql=strSql?+?“）“;
		boolean?isAdd?=?super.exeSql（strSql）;
		return?isAdd;
???}?
???/**
????
??
*@更新員工出勤信息
	*/
???public?boolean?update_attendance（）
???{??
????????strSql=“update?Attendance?set?“;
????????strSql=strSql?+?“??Schuqin“;?
????????strSql=strSql?+?“=?“;?
????????strSql=strSql?+?“‘“?+??Schuqin?+?“‘“;?????
????????strSql=strSql?+?“?RequireTime“;
????????strSql=strSql?+?“=?“;
????????strSql=strSql?+?“‘“?+??RequireTime?+?“‘“;
???????
????????strSql=strSql?+“?where?UserID=“;
????????strSql=strSql+UserID?;
	boolean?isUpdate?=?super.exeSql（strSql）;
	return?isUpdate;
???}?????
???/**
*@顯示更新員工出勤信息
	*/
??public?ResultSet?show_update（）
???{
????	strSql=“select?*?from?‘Attendance‘?where?UserID=“+UserID;
????????ResultSet?rs?=?null;
??????????????
????????try
		{
???		?	rs?=?super.exeSqlQuery（strSql）;?
		}
		catch（Exception?ex）
		{
			System.out.println（ex.toString（））;?
		}
		return?rs;
???}??
/**?
*@刪除某個員工出勤信息?by?UserID
????*/
???public?boolean?delete_attendance（）
???{
????	strSql=“delete?from?‘Attendance‘?where?UserID=“;
????????strSql=strSql?+?UserID;?????????
????????try
		{
???			boolean?rs?=?super.exeSql（strSql）;
????????????if?（rs）
????????????{
?????????????????????????????
????????????????return?true;
????????????}
????????????else
????????????{
???????????????return?false;
????????????}
		}
		catch（Exception?ex）
		{
			System.out.println（ex.toString（））;?
????????????return?false;
		}
???}???
???/**
*@顯示所有員工出勤信息?
????*/
???public?ResultSet?show_all_attendance（）
???{
????	strSql=“select?*?from?‘Attendance‘“;
????????ResultSet?rs?=?null;
??????????????
????????try
		{
???		?	rs?=?super.exeSqlQuery（strSql）;?
		}
		catch（Exception?ex）
		{
			System.out.println（ex.toString（））;?
		}
		return?rs;
???}???
???/**
????*@獲取某個用戶的出勤信息?by?UserID
????*/
???public?boolean?init（）
???{
????	strSql=“select?*?from?‘Attendance‘?where?UserID=“;
????????strSql=strSql?+UserID;????????
????????try
		{
???			ResultSet?rs?=?super.exeSqlQuery（strSql）;
????????????if?（rs.next（））
????????????{
???

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????I.A....??????2121??2012-06-04?15:36??Salary\add1.jsp

????I.A....??????1932??2012-06-04?15:36??Salary\add3.jsp

????I.A....??????1353??2012-06-04?15:36??Salary\add4.jsp

????I.A....??????1287??2012-06-04?14:07??Salary\add_attendance_save.jsp

????I.A....??????1688??2012-06-04?14:07??Salary\add_salary_save.jsp

????I.A....??????1846??2012-06-04?20:54??Salary\add_users_save.jsp

????I.A....??????4331??2012-06-04?14:07??Salary\background1.jpg

????I.A....??????2413??2012-06-04?14:07??Salary\database\message.sql

????I.A....??????3035??2012-06-04?15:23??Salary\delete1.jsp

????I.A....??????2856??2012-06-04?15:24??Salary\delete3.jsp

????I.A....??????2335??2012-06-04?15:24??Salary\delete4.jsp

????I.A....???????965??2012-06-04?14:07??Salary\delete_attendance_save.jsp

????I.A....???????945??2012-06-04?14:07??Salary\delete_salary_save.jsp

????I.A....???????936??2012-06-04?14:07??Salary\delete_users_save.jsp

????I.A....??????2053??2012-06-04?15:28??Salary\execute-attendance-Update1.jsp

????I.A....??????1399??2012-06-04?14:07??Salary\execute-attendance-Update2.jsp

????I.A....??????2739??2012-06-04?15:27??Salary\execute-salary-Update1.jsp

????I.A....??????1795??2012-06-04?14:07??Salary\execute-salary-Update2.jsp

????I.A....??????2976??2012-06-04?15:25??Salary\execute-users-Update1.jsp

????I.A....??????1930??2012-06-04?20:55??Salary\execute-users-Update2.jsp

????I.A....???????294??2012-06-04?15:39??Salary\f2.jsp

????I.A..H.?????26624??2012-06-04?14:07??Salary\images\Thumbs.db

????I.A....???????390??2012-06-04?20:29??Salary\index.html

????I.A....??????2115??2012-06-04?14:07??Salary\index1.html

????I.A....????253285??2012-06-04?14:07??Salary\left.jpg

????I.A....??????2262??2012-06-04?15:32??Salary\list1.jsp

????I.A....??????1452??2012-06-04?15:22??Salary\list2.jsp

????I.A....??????2081??2012-06-04?15:22??Salary\list3.jsp

????I.A....??????1589??2012-06-04?15:22??Salary\list4.jsp

????I.A....???????587??2012-06-04?14:07??Salary\login_admin.html

............此處省略39個文件信息