package?bean;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;

import?util.DBConn;

public?class?AdminLoginBean?{
	
	Connection?conn?=?null;
	Statement?st?=?null;
	ResultSet?rs?=?null;
	ArrayList?al?=?new?ArrayList（）;
	
	public?int?login（String?nameString?pwd）{
		int?temp?=?0;
		conn?=?DBConn.getConn（）;
		try?{
			st?=?conn.createStatement（）;
			rs?=?st.executeQuery（“select?*?from?admin?where?name=‘“+name+“‘“）;
			if（rs.next（））{
				String?id?=?rs.getString（“id“）;
				String?tname?=?rs.getString（“name“）;
				String?tpwd?=?rs.getString（“pwd“）;			
				if（pwd.equals（tpwd））{
					temp?=?1;
					al.add（id）;
					al.add（tname）;
					al.add（tpwd）;
				}else{
					temp?=?2;
				}
			}else{
				temp?=?3;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally{
			DBConn.close（connstrs）;
		}
		return?temp;
	}
	
	public?ArrayList?getArrayLst（）{
		return?al;
	}

}

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

?????文件????????411??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\.classpath

?????文件????????288??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\.mymetadata

?????文件???????1223??2013-11-07?21:52??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\.project

?????文件???????1026??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\AdminLoginBean.java

?????文件????????943??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\AllBean.java

?????文件????????652??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\InsertUpdateDelBean.java

?????文件???????1780??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\ReckoningBean.java

?????文件???????1336??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\SelectBean.java

?????文件????????375??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\UserBean.java

?????文件???????1004??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\bean\UserLoginBean.java

?????文件???????1785??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AddAfficheServlet.java

?????文件???????3545??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AddBookServlet.java

?????文件???????1650??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AddTypeServlet.java

?????文件???????1825??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AdminLoginServlet.java

?????文件???????1593??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AdminShowUserServlet.java

?????文件???????1934??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AfficheReworkServlet.java

?????文件???????2121??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AfficheShowServlet.java

?????文件???????2754??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\AfterServlet.java

?????文件???????2628??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\DelServlet.java

?????文件???????2147??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\KuXiaoServlet.java

?????文件???????2402??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\OrderListServlet.java

?????文件???????1753??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\OrderSelectServlet.java

?????文件???????3136??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\PwdNameUserServlet.java

?????文件???????2507??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\UpdateBookServlet.java

?????文件???????1895??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\admin\UpdateTypeServlet.java

?????文件???????2828??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\ListServlet.java

?????文件???????2024??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\qiantai\BookinfServlet.java

?????文件???????2382??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\qiantai\ModifyUserServlet.java

?????文件???????1856??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\qiantai\ReckoningServlet.java

?????文件???????2369??2013-11-07?21:51??JSP220?寵物狗銷售系統的設計與實現sqlserver\cwgxs\src\servlet\qiantai\RegServlet.java

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