package?com.dao;

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

import?com.entity.Admin_NewsInfo;
import?com.entity.Admin_UserInfo;
import?com.entity.GoodsSort;
import?com.entity.ImgInfo;
import?com.entity.SiteInfo;
import?com.entity.UserInfo;
/**
?*?后臺(tái)功能類(lèi)
?*?@author?Administrator
?*
?*/
public?class?AdinUserCrtl?{
	
	/*==用戶(hù)列表數(shù)據(jù)分頁(yè)==*/
	/**
	?*?根據(jù)當(dāng)前頁(yè)數(shù)和每頁(yè)顯示的行數(shù)來(lái)查詢(xún)相應(yīng)的結(jié)果
	?*?
	?*?@param?pageSize
	?*????????????每頁(yè)顯示的行數(shù)
	?*?@param?pageNow
	?*????????????當(dāng)前的頁(yè)數(shù)
	?*?@return
	?*/
	public?ArrayList?getUserForPage（int?pageSize?int?pageNow）?{
		ArrayList?al?=?null;
		Connection?conn?=?ConnDB.getConn（）;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		String?sql?=?“select?Top?“?+?pageSize
				+?“?*?from?UserInfo?where?userId?not?in（select?Top?（“?+?pageSize
				+?“?*?（“?+?pageNow?+?“-?1））?userId?from?UserInfo）“;
		try?{
			stmt=conn.createStatement（）;
			rs=stmt.executeQuery（sql）;
			while（rs.next（））{
				if（al==null）{
					al=new?ArrayList（）;					
				}
				UserInfo?userinfo?=?new?UserInfo（）;
				userinfo.setUserId（rs.getInt（“userId“））;
				userinfo.setUsername（rs.getString（“userName“））;				
				userinfo.setUserpwd（rs.getString（“userPwd“））;
				userinfo.setUserxm（rs.getString（“userXm“））;
				userinfo.setUsersex（rs.getInt（“userSex“））;
				userinfo.setUserye（rs.getDouble（“userYe“））;
				userinfo.setUseremail（rs.getString（“userEmail“））;
				userinfo.setUseryb（rs.getString（“userYb“））;
				userinfo.setUseraddr（rs.getString（“userAddr“））;	
				userinfo.setUserphone（rs.getString（“userPhone“））;
				userinfo.setUsersj（rs.getString（“userSj“））;
				userinfo.setUserdate（rs.getString（“userDate“））;
				userinfo.setUserzt（rs.getInt（“userZt“））;
				al.add（userinfo）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			ConnDB.close（rs?stmt?conn）;
		}
		return?al;
	}
	/**
	?*?獲取總頁(yè)數(shù)
	?*?@param?pageSize
	?*?@return
	?*/
	public?int?getPageCount（int?pageSize）{
		int?pageCount?=?0;
		int?userCount?=?0;//獲取到用戶(hù)的總數(shù)
		Connection?conn?=?ConnDB.getConn（）;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		String?sql?=?“select?count（*）?as?userCount?from?UserInfo“;
		try?{
			stmt?=?conn.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
			if（rs.next（））{
				userCount?=?rs.getInt（“userCount“）;
			}
			//頁(yè)數(shù)計(jì)算
			if（userCount?%?pageSize?==?0）{
				pageCount?=?userCount?/?pageSize;
			}else{
				pageCount?=?userCount?/?pageSize?+?1;?
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			ConnDB.close（rs?stmt?conn）;
		}
		return?pageCount;
	}
	/**
	?*?修改用戶(hù)資料方法
	?*/
	public?int?updateUser（UserInfo?user）{
		int?res?=?0;
		Connection?conn?=ConnDB.getConn（）;
		PreparedStatement?stmt?=?null;
		String?sql?=?“update?Use

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????????603??2015-04-16?07:20??購(gòu)物商城\.classpath

?????文件????????305??2015-07-02?10:31??購(gòu)物商城\.mymetadata

?????文件???????1751??2015-04-16?07:20??購(gòu)物商城\.project

?????文件????????500??2012-06-09?00:00??購(gòu)物商城\.settings\.jsdtscope

?????文件?????????95??2015-07-02?10:44??購(gòu)物商城\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2015-04-16?07:20??購(gòu)物商城\.settings\org.eclipse.jdt.core.prefs

?????文件????????470??2015-04-16?07:20??購(gòu)物商城\.settings\org.eclipse.wst.common.component

?????文件????????252??2015-04-16?07:20??購(gòu)物商城\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-04-16?07:20??購(gòu)物商城\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-04-16?07:20??購(gòu)物商城\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????3145728??2012-07-19?00:00??購(gòu)物商城\DB\ShopMall.mdf

?????文件????1048576??2012-07-19?00:00??購(gòu)物商城\DB\ShopMall_log.ldf

?????文件??????25811??2012-07-17?00:00??購(gòu)物商城\src\com\dao\AdinUserCrtl.java

?????文件???????1262??2012-07-03?00:00??購(gòu)物商城\src\com\dao\ConnDB.java

?????文件??????26164??2012-07-19?00:00??購(gòu)物商城\src\com\dao\GoodsCtrl.java

?????文件??????10323??2012-07-19?00:00??購(gòu)物商城\src\com\dao\OrderCtrl.java

?????文件???????1980??2012-07-19?00:00??購(gòu)物商城\src\com\dao\SumInfoCrtl.java

?????文件???????6978??2012-07-09?00:00??購(gòu)物商城\src\com\dao\UserCrtl.java

?????文件????????765??2012-07-08?00:00??購(gòu)物商城\src\com\entity\Admin_NewsInfo.java

?????文件????????681??2012-07-06?00:00??購(gòu)物商城\src\com\entity\Admin_UserInfo.java

?????文件????????996??2012-07-19?00:00??購(gòu)物商城\src\com\entity\CommentInfo.java

?????文件???????2348??2012-07-11?00:00??購(gòu)物商城\src\com\entity\GoodsInfo.java

?????文件????????362??2012-07-09?00:00??購(gòu)物商城\src\com\entity\GoodsSort.java

?????文件????????673??2012-07-10?00:00??購(gòu)物商城\src\com\entity\ImgInfo.java

?????文件???????2460??2012-07-16?00:00??購(gòu)物商城\src\com\entity\OrderInfo.java

?????文件????????440??2012-07-09?00:00??購(gòu)物商城\src\com\entity\SiteInfo.java

?????文件???????2099??2012-07-06?00:00??購(gòu)物商城\src\com\entity\UserInfo.java

?????文件???????2716??2012-07-19?00:00??購(gòu)物商城\src\com\servlet\AddCommentServlef.java

?????文件???????3528??2012-07-16?00:00??購(gòu)物商城\src\com\servlet\AddOrderServlef.java

?????文件???????2575??2012-07-03?00:00??購(gòu)物商城\src\com\servlet\AddUserServlef.java

............此處省略316個(gè)文件信息