package?test.service;

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

import?test.util.DbConnectionService;
import?test.vo.AdminInfo;

public?class?AdminServiceImpl?implements?IAdminService?{

	private?Connection?connection;
	private?Statement?statement;
	private?ResultSet?resultSet;

	public?AdminServiceImpl（）?{
		connection?=?DbConnectionService.getConnection（）;
		try?{
			statement?=?connection.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

	public?List?getAdmin（AdminInfo?adminInfo）?{

		String?sql?=?“select?*?from?admininfo?where?admin_name=‘“
				+?adminInfo.getAdmin_name（）?+?“‘?and?admin_password=‘“
				+?adminInfo.getAdmin_password（）?+?“‘“;
		
		List?list?=?new?ArrayList（）;

		try?{
			resultSet?=?statement.executeQuery（sql）;

			while?（resultSet.next（））?{
				list.add（new?AdminInfo（resultSet.getInt（1）?resultSet
						.getString（2）?resultSet.getString（3）））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?list;
	}

}

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

?????文件????????571??2008-06-21?18:24??軟件0611?鐘銀福?第二組\Demo\.classpath

?????文件????????285??2008-06-21?18:24??軟件0611?鐘銀福?第二組\Demo\.mymetadata

?????文件???????1222??2008-06-02?13:45??軟件0611?鐘銀福?第二組\Demo\.project

?????文件???????1375??2008-06-11?21:50??軟件0611?鐘銀福?第二組\Demo\WebRoot\administer.jsp

?????文件???????4067??2008-06-21?18:31??軟件0611?鐘銀福?第二組\Demo\WebRoot\bookinfo.jsp

?????文件???????2031??2008-06-06?09:54??軟件0611?鐘銀福?第二組\Demo\WebRoot\booklist.jsp

?????文件???????1998??2008-06-19?22:18??軟件0611?鐘銀福?第二組\Demo\WebRoot\cartItem.jsp

?????文件???????2628??2008-06-16?15:17??軟件0611?鐘銀福?第二組\Demo\WebRoot\catagoryinfo.jsp

?????文件???????2457??2008-06-20?08:53??軟件0611?鐘銀福?第二組\Demo\WebRoot\catagorylist.jsp

?????文件???????4121??2008-06-18?23:07??軟件0611?鐘銀福?第二組\Demo\WebRoot\chanpin.jsp

?????文件????????931??2008-06-06?09:52??軟件0611?鐘銀福?第二組\Demo\WebRoot\error.jsp

?????文件????????960??2008-06-18?23:09??軟件0611?鐘銀福?第二組\Demo\WebRoot\foot.jsp

?????文件???????1882??2008-06-21?18:35??軟件0611?鐘銀福?第二組\Demo\WebRoot\heat.jsp

?????文件???????2007??2008-06-18?23:09??軟件0611?鐘銀福?第二組\Demo\WebRoot\huankui.jsp

?????文件???????1387??2008-06-18?23:07??軟件0611?鐘銀福?第二組\Demo\WebRoot\huwu.jsp

?????文件???????1619??2008-06-20?08:48??軟件0611?鐘銀福?第二組\Demo\WebRoot\index.jsp

?????文件???????4346??2008-06-09?00:26??軟件0611?鐘銀福?第二組\Demo\WebRoot\jieshao.jsp

?????文件???????2374??2008-06-16?14:30??軟件0611?鐘銀福?第二組\Demo\WebRoot\liuyan.jsp

?????文件????????820??2008-06-02?14:01??軟件0611?鐘銀福?第二組\Demo\WebRoot\login.jsp

?????文件???????1322??2008-06-19?19:18??軟件0611?鐘銀福?第二組\Demo\WebRoot\manage.jsp

?????文件???????3642??2008-06-21?18:36??軟件0611?鐘銀福?第二組\Demo\WebRoot\menu.jsp

?????文件????????717??2008-06-19?22:19??軟件0611?鐘銀福?第二組\Demo\WebRoot\myOrders.jsp

?????文件????????882??2008-06-19?22:20??軟件0611?鐘銀福?第二組\Demo\WebRoot\orderdetail.jsp

?????文件????????977??2008-06-19?22:20??軟件0611?鐘銀福?第二組\Demo\WebRoot\ordersList.jsp

?????文件???????2207??2008-06-20?09:11??軟件0611?鐘銀福?第二組\Demo\WebRoot\searchBooks.jsp

?????文件???????1421??2008-06-17?15:56??軟件0611?鐘銀福?第二組\Demo\WebRoot\showUser.jsp

?????文件???????1231??2008-06-12?10:42??軟件0611?鐘銀福?第二組\Demo\WebRoot\updatebookinfo.jsp

?????文件???????1255??2008-06-11?23:45??軟件0611?鐘銀福?第二組\Demo\WebRoot\updateCatagoryinfo.jsp

?????文件???????1329??2008-06-06?09:48??軟件0611?鐘銀福?第二組\Demo\WebRoot\updateUserinfo.jsp

?????文件???????6385??2008-06-21?18:56??軟件0611?鐘銀福?第二組\Demo\WebRoot\userRegist.jsp

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