package?com.leave.dao;

import?java.sql.SQLException;
import?java.util.List;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;
import?org.apache.commons.dbutils.handlers.BeanListHandler;

import?com.leave.entity.Apply;
import?com.leave.util.JdbcUtils;

public?class?ApplyDao?{
	private?QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;

	/**
	?*?假條申請
	?*?
	?*?@param?apply
	?*?@throws?SQLException
	?*/
	public?void?add（Apply?apply）?throws?SQLException?{
		String?sql?=?“insert?into?leave_apply（l_s_cards_usernameg_namec_names_phone“
				+?“l(fā)_begintimel_endtimel_addressl_cause）?“?+?“values（?????????）“;
		object[]?params?=?{?apply.getL_s_card（）?apply.getS_username（）?apply.getG_name（）?apply.getC_name（）
				apply.getS_phone（）?apply.getL_begintime（）?apply.getL_endtime（）?apply.getL_address（）
				apply.getL_cause（）?};
		qr.update（sql?params）;
	}

	/**
	?*?通過學號查詢請假記錄
	?*?
	?*?@param?id
	?*?@return
	?*?@throws?SQLException
	?*/
	public?List?show（String?id）?throws?SQLException?{
		String?sql?=?“select?*?from?leave_apply?where?l_s_card?=??“;
		return?qr.query（sql?new?BeanListHandler<>（Apply.class）?id）;
	}

	/**
	?*?通過aid查詢請假詳情
	?*?
	?*?@param?aid
	?*?@return
	?*?@throws?SQLException
	?*/
	public?Apply?show_apply（int?aid）?throws?SQLException?{
		String?sql?=?“select?*?from?leave_apply?where?aid?=??“;
		return?qr.query（sql?new?BeanHandler<>（Apply.class）?aid）;
	}

	/**
	?*?通過aid修改請假信息
	?*?@param?apply
	?*?@throws?SQLException
	?*/
	public?void?update_apply（Apply?apply）?throws?SQLException?{
		String?sql?=?“update?leave_apply?set?g_name=?c_name=?s_phone=?l_begintime=?“
				+?“l(fā)_endtime=?l_address=?l_cause=??where?aid=?“;
		object[]?params?=?{?apply.getG_name（）?apply.getC_name（）?apply.getS_phone（）?apply.getL_begintime（）
				apply.getL_endtime（）?apply.getL_address（）?apply.getL_cause（）?apply.getAid（）?};
		qr.update（sql?params）;
	}
	/**
	?*?通過aid刪除請假申請
	?*/
	public?void?delete_apply（int?aid）?throws?SQLException?{
		String?sql?=?“delete?from?leave_apply?where?aid=?“;
		qr.update（sqlaid）;
		
	}

	/**
	?*?通過status查詢未銷假
	?*?
	?*?@param?status
	?*?@return
	?*?@throws?SQLException
	?*/
	public?List?show_cancle（int?statusString?l_s_card）?throws?SQLException?{
		String?sql?=?“select?*?from?leave_apply?where?status?=???and?l_s_card?=??“;
		return?qr.query（sql?new?BeanListHandler<>（Apply.class）?statusl_s_card）;
	}
	
	/**
	?*?通過aid來修改status
	?*?@param?status
	?*?@param?aid
	?*?@throws?SQLException
	?*/
	?
	public?void?leave_cancle（int?statusint?aid）?throws?SQLException?{
		String?sql?=?“update?leave_apply?set?status?=???where?aid=?“;
		qr.update（sql?statusaid）;
		
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\
?????文件?????????909??2019-05-01?08:21??學生請假管理系統(tǒng)\Leave_System\.classpath
?????文件?????????912??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.project
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\.settings\
?????文件?????????567??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.settings\.jsdtscope
?????文件??????????84??2019-05-01?08:21??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.jdt.core.prefs
?????文件?????????565??2019-04-30?14:28??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.wst.common.component
?????文件?????????345??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-04-29?08:19??學生請假管理系統(tǒng)\Leave_System\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\
?????文件?????????557??2019-04-30?20:26??學生請假管理系統(tǒng)\Leave_System\build\classes\c3p0-config.xml
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\dao\
?????文件????????3403??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\dao\ApplyDao.class
?????文件????????1505??2019-05-04?23:15??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\dao\ApproveDao.class
?????文件????????1338??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\dao\UserDao.class
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\entity\
?????文件????????2567??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\entity\Apply.class
?????文件????????1450??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\entity\User.class
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\filter\
?????文件????????1447??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\filter\EncodeFilter.class
?????文件????????2316??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\filter\VisitFilter.class
?????目錄???????????0??2019-05-31?22:36??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\service\
?????文件????????1637??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\service\ApplyService.class
?????文件?????????814??2019-05-04?23:15??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\service\ApproveService.class
?????文件?????????622??2019-05-04?22:08??學生請假管理系統(tǒng)\Leave_System\build\classes\com\leave\service\UserService.class
............此處省略367個文件信息