package?bean;

import?java.util.ArrayList;

public?class?AllBean?{
	SelectBean?sb?=?new?SelectBean（）;
	ArrayList?al?=?null;
	
	public?ArrayList?getAllAdmin（String?id）{
		String?sql?=?“select?*?from?admin?where?id!=1?and?id!=“+id+“?order?by?id?desc“;
		String?args[]?=?{“id““name““pwd““status“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getUsers（String?id）{
		String?sql?=?“select?*?from?users?where?id=“+id;
		String?args[]?=?{“id““name““pwd““number““college““classes““truename““phone““address““email““status“};
		al?=?sb.selectRow（args?sql）;
		return?al;
	}
	
	public?ArrayList?getUsers（）{
		String?sql?=?“select?*?from?users?order?by?id?desc“;
		String?args[]?=?{“id““name““pwd““number““college““classes““truename““phone““address““email““status“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLost（String?id）{
		String?sql?=?“select?*?from?lost?where?id=“+id;
		String?args[]?=?{“id““users““pickname““picktraint““pickplace““picktime““storeplace““storetime““handway““handintime““type“};
		al?=?sb.selectRow（args?sql）;
		return?al;
	}
	
	public?ArrayList?getLost（）{
		String?sql?=?“select?*?from?lost?order?by?id?desc“;
		String?args[]?=?{“id““users““pickname““picktraint““pickplace““picktime““storeplace““storetime““handway““handintime““type“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLostType（String?type）{
		String?sql?=?“select?*?from?lost?where?type=‘“+type+“‘?order?by?id?desc“;
		String?args[]?=?{“id““users““pickname““picktraint““pickplace““picktime““storeplace““storetime““handway““handintime““type“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLostUsers（String?users）{
		String?sql?=?“select?*?from?lost?where?users=“+users+“?order?by?id?desc“;
		String?args[]?=?{“id““users““pickname““picktraint““pickplace““picktime““storeplace““storetime““handway““handintime““type“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLostSearch（String?picknameString?type）{
		String?sql?=?“select?*?from?lost?where?pickname?like?‘%“+pickname+“%‘?and?type=‘“+type+“‘?order?by?id?desc“;
		String?args[]?=?{“id““users““pickname““picktraint““pickplace““picktime““storeplace““storetime““handway““handintime““type“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLeave（String?id）{
		String?sql?=?“select?*?from?leave?where?id=“+id;
		String?args[]?=?{“id““lost““name““content““dates“};
		al?=?sb.selectRow（args?sql）;
		return?al;
	}
	
	public?ArrayList?getLeave（）{
		String?sql?=?“select?*?from?leave?order?by?id?desc“;
		String?args[]?=?{“id““lost““name““content““dates“};
		al?=?sb.select（sql?args）;
		return?al;
	}
	
	public?ArrayList?getLeaveLost（String?lost）{
		String?sql?=?“select?*?from?leave?where?lost=“+lost+“?order?by?id?desc“;
		String?args[]?=?{“id““lost““name““content““dates“};
		al

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

?????文件???24962490??2017-01-05?05:43??失物招領系統—實習實訓材料\答辯驗收材料\bandicam?2017-01-05?05-40-29-314.avi

?????文件????????973??2017-01-02?21:36??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.classpath

?????文件????????291??2017-01-02?18:45??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.mymetadata

?????文件???????1412??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.project

?????文件????????500??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.settings\.jsdtscope

?????文件????????334??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????36675??2017-01-02?21:34??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\lib\w3c-dom.jar

?????文件?????194354??2017-01-02?21:18??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\lib\xml-apis.jar

?????文件???????3047??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\bean\AllBean.java

?????文件????????652??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\bean\InsertUpdateDelBean.java

?????文件???????2690??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\bean\SelectBean.java

?????文件???????3190??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\AdminAddServlet.java

?????文件???????2881??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\AdminLoginServlet.java

?????文件???????3202??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\DelServlet.java

?????文件???????2536??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\LeaveServlet.java

?????文件???????2922??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\LostServlet.java

?????文件???????2347??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\PwdUpdateServlet.java

?????文件???????2358??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\RemoveServlet.java

?????文件???????2881??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\servlet\UsersLoginServlet.java

?????文件???????1328??2013-05-20?14:50??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\util\DBConn.java

?????文件???????2740??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\src\util\Validate.java

?????文件????????842??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\head.jsp

?????文件???????2513??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\index.jsp

?????文件???????3263??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\leave.jsp

?????文件????????510??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\left.jsp

?????文件????????763??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\login.jsp

?????文件???????3637??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\lost.jsp

?????文件????????836??2011-05-18?22:19??失物招領系統—實習實訓材料\答辯驗收材料\代碼和數據庫文件\swzlxt\WebRoot\admin\pwd_update.jsp

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