package?com.DoggyHouse.DB?;

import?java.sql.*?;
import?java.util.*;
import?com.DoggyHouse.JavaBeans.*;

public?class?AdminDBOperator?{

	public?static?boolean?checkAdmin（String?nameString?password）
	{
		boolean?flag?=?false?;
		Connection?conn?=?null?;
		Statement?stat?=?null?;
		ResultSet?rs?=?null?;
		try
		{
			conn?=?DBFactory.getConn（）?;
			stat?=?DBFactory.getStat（conn）?;
			String?sql?=?“select?*?from?admin?where?loginname=‘“+name+“‘?and?password=‘“+password+“‘“?;
			rs?=?DBFactory.getRs（stat?sql）?;
			if（rs.next（））
			{
				flag?=?true?;
			}
		}catch（Exception?e）
		{
			System.out.println（e.getMessage（））;
			e.printStackTrace（）?;
		}
		return?flag?;
	}	
	
	public?static?AdminBean?getAdmin（）
	{
		AdminBean?admin?=?null?;
		Connection?conn?=?null?;
		Statement?stat?=?null?;
		ResultSet?rs?=?null?;
		try
		{
			conn?=?DBFactory.getConn（）?;
			stat?=?DBFactory.getStat（conn）?;
			String?sql?=?“select?loginnamepassword?from?admin“?;
			rs?=?DBFactory.getRs（stat?sql）?;
			if（rs.next（））
			{
				admin?=?new?AdminBean（rs.getString（1）rs.getString（2））?;
			}
		}catch（Exception?e）
		{
			System.out.println（e.getMessage（））;
			e.printStackTrace（）?;
		}finally
		{
			DBFactory.close（stat）?;
			DBFactory.close（conn）?;
		}
		return?admin?;
	}
	
	public?static?boolean?updateAdmin（String?nameString?password）
	{
		boolean?flag?=?false?;
		Connection?conn?=?null?;
		Statement?stat?=?null?;
		try
		{
			conn?=?DBFactory.getConn（）?;
			stat?=?DBFactory.getStat（conn）?;
			String?sql?=?“update?admin?set?loginname=‘“+name+“‘password=‘“+password+“‘“?;
			int?num?=?stat.executeUpdate（sql）?;
			if（num>0）
			{
				flag?=?true?;
			}
		}catch（Exception?e）
		{
			System.out.println（e.getMessage（））;
			e.printStackTrace（）?;
		}finally
		{
			DBFactory.close（stat）?;
			DBFactory.close（conn）?;
		}
		return?flag?;
	}
	
	public?static?int?addAdvice（String?userIDString?mydString?advice）
	{
		int?num?=?0?;
		Connection?conn?=?null?;
		Statement?stat?=?null?;
		try
		{
			conn?=?DBFactory.getConn（）?;
			stat?=?DBFactory.getStat（conn）?;
			String?sql?=?“insert?into?userAdvice（userIDpleasedadvice）?values（‘“+userID+“‘‘“+myd+“‘‘“+advice+“‘）“?;
			num?=?stat.executeUpdate（sql）?;			
		}catch（Exception?e）
		{
			System.out.println（e.getMessage（））;
			e.printStackTrace（）?;
		}finally
		{
			DBFactory.close（stat）?;
			DBFactory.close（conn）?;
		}
		return?num?;
	}
	
	public?static?ArrayList?getUsers（）
	{
		ArrayList?list?=?new?ArrayList（）?;
		Connection?conn?=?null?;
		Statement?stat?=?null?;
		ResultSet?rs?=?null?;
		try
		{
			conn?=?DBFactory.getConn（）?;
			stat?=?DBFactory.getStat（conn）?;
			String?sql?=?“select?userIDuserName?from?users“?;
			rs?=?DBFactory.getRs（stat?sql）?;
			UserBean?ub?=?null?;
			while（rs.next（））
			{
				ub?=?new?UserBean（rs.getString（1）rs.getString（2））?;
				list.add（ub）?;
			}
		}catch（Exception?e）
		{
			System

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\
?????文件?????????442??2010-04-20?09:04??DoggyHouse\DoggyHouse\.classpath
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\.myeclipse\
?????文件?????????303??2010-04-12?15:51??DoggyHouse\DoggyHouse\.mymetadata
?????文件????????1228??2010-04-12?15:51??DoggyHouse\DoggyHouse\.project
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\.settings\
?????文件?????????334??2010-04-12?15:51??DoggyHouse\DoggyHouse\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\com\
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\com\DoggyHouse\
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\
?????文件????????6913??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\AdminDBOperator.java
?????文件????????2448??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\DBFactory.java
?????文件????????3678??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\GoodsCategoryDB.java
?????文件???????39904??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\GoodsDB.java
?????文件???????22548??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\OrdersDB.java
?????文件?????????250??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\RegException.java
?????文件????????8911??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\DB\UserDBOperator.java
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\com\DoggyHouse\File\
?????文件????????1733??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\File\Cart.java
?????文件????????3495??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\File\UserInfo.java
?????目錄???????????0??2011-01-05?22:01??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\
?????文件?????????472??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\AdminBean.java
?????文件?????????972??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\BrandBean.java
?????文件????????7642??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\GoodsBean.java
?????文件?????????570??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\GoodsCategoryBean.java
?????文件????????1934??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\Order.java
?????文件????????3198??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\OrdersBean.java
?????文件????????2811??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\User.java
?????文件????????2256??2010-05-07?10:17??DoggyHouse\DoggyHouse\src\com\DoggyHouse\JavaBeans\UserBean.java
............此處省略402個(gè)文件信息