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

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

?????文件????????794??2012-06-09?23:46??179JSP失物招領系統\swzlxt\.classpath

?????文件????????291??2012-06-07?07:32??179JSP失物招領系統\swzlxt\.mymetadata

?????文件???????1412??2012-06-01?20:31??179JSP失物招領系統\swzlxt\.project

?????文件????????500??2012-06-02?11:22??179JSP失物招領系統\swzlxt\.settings\.jsdtscope

?????文件????????334??2012-06-07?00:59??179JSP失物招領系統\swzlxt\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2012-06-09?12:59??179JSP失物招領系統\swzlxt\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-06-09?05:03??179JSP失物招領系統\swzlxt\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3047??2012-06-07?16:44??179JSP失物招領系統\swzlxt\src\bean\AllBean.java

?????文件???????3190??2012-06-06?00:31??179JSP失物招領系統\swzlxt\src\servlet\AdminAddServlet.java

?????文件???????2536??2012-06-10?18:39??179JSP失物招領系統\swzlxt\src\servlet\LeaveServlet.java

?????文件???????2922??2012-06-02?03:09??179JSP失物招領系統\swzlxt\src\servlet\LostServlet.java

?????文件???????1338??2012-06-09?19:59??179JSP失物招領系統\swzlxt\src\util\DBConn.java

?????文件???????2740??2012-06-07?01:46??179JSP失物招領系統\swzlxt\src\util\Validate.java

?????文件????????842??2012-06-07?17:49??179JSP失物招領系統\swzlxt\WebRoot\admin\head.jsp

?????文件???????2513??2012-06-11?03:47??179JSP失物招領系統\swzlxt\WebRoot\admin\index.jsp

?????文件???????3263??2012-06-07?02:15??179JSP失物招領系統\swzlxt\WebRoot\admin\leave.jsp

?????文件????????510??2012-06-03?03:25??179JSP失物招領系統\swzlxt\WebRoot\admin\left.jsp

?????文件????????123??2013-02-25?17:31??179JSP失物招領系統\swzlxt\WebRoot\admin\login.jsp

?????文件???????1767??2012-06-11?00:27??179JSP失物招領系統\swzlxt\WebRoot\css\admin-css.css

?????文件???????1476??2012-06-05?02:06??179JSP失物招領系統\swzlxt\WebRoot\css\base.css

?????文件???????3267??2012-06-09?00:00??179JSP失物招領系統\swzlxt\WebRoot\css\css.css

?????文件??????27668??2012-06-03?12:41??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\easyui.css

?????文件???????2937??2012-06-08?11:03??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\accordion_collapse.png

?????文件???????2946??2012-06-01?19:27??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\accordion_expand.png

?????文件???????1194??2012-06-03?11:03??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\button_a_bg.gif

?????文件????????144??2012-06-01?19:26??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\button_plain_hover.png

?????文件???????2061??2012-06-08?13:37??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\button_span_bg.gif

?????文件?????????64??2012-06-10?20:24??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\calendar_nextmonth.gif

?????文件?????????75??2012-06-03?12:07??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\calendar_nextyear.gif

?????文件?????????66??2012-06-06?01:29??179JSP失物招領系統\swzlxt\WebRoot\css\themes\default\images\calendar_prevmonth.gif

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