package?com.wy.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Arrays;
import?java.util.List;

import?com.wy.form.Photo;
import?com.wy.form.UserInfo;
import?com.wy.tools.JDBConnection;
/*************************************

版權(quán)所有:?	吉林省明日科技有限公司

完成日期：	2010-09-15

項目出處：	編程詞典

服務(wù)社區(qū)：	www.mingribook.com

學(xué)習(xí)社區(qū)：	www.mrbccd.com

*************************************/

public?class?OperationData?{
	private?JDBConnection?connection?=?null;?//定義數(shù)據(jù)庫連接類JDBConnection對象并賦值為null
	private?List?list?=?null;????????????????//定義一個List集合類，并賦值為null
	String?sql?=?““;?????????????????????????//定義一個SQL類型的對象，并賦值為一個空字符串
	????????????????????????//以用戶名為條件，查詢用戶的Form，返回是單個用戶的數(shù)據(jù)
	public?UserInfo?user_query（String?username）?{
		UserInfo?userInfo?=?null;?????????//設(shè)置用戶的UserInfo類對象
		connection?=?new?JDBConnection（）;?//將JDBCOnnection對象進(jìn)行實(shí)例化
		sql?=?“SELECT?*?FROM?tb_userInfo?WHERE?username=‘“?+?username?+?“‘“;
		//設(shè)置查詢的SQL語句
		ResultSet?rs?=?connection.executeQuery（sql）;?//執(zhí)行查詢操作，返回結(jié)果是ResultSet結(jié)果集
		try?{
			//對結(jié)果集對象進(jìn)行循環(huán)數(shù)據(jù)
			while?（rs.next（））?{
				userInfo?=?new?UserInfo（）;???????????????????????//?實(shí)例化UserInfo對象
				userInfo.setId（rs.getInt（“id“））;?????????????????//?將數(shù)據(jù)表中id字段內(nèi)容進(jìn)行賦值
				userInfo.setUsername（rs.getString（“username“））;??//?將數(shù)據(jù)表中username字段內(nèi)容進(jìn)行賦值
				userInfo.setPassword（rs.getString（“password“））;??//?將數(shù)據(jù)表中passwrod字段內(nèi)容進(jìn)行賦值
				userInfo.setRealname（rs.getString（“realname“））;??//?將數(shù)據(jù)表中realname字段內(nèi)容進(jìn)行賦值
				userInfo.setEmail（rs.getString（“email“））;????????//?將數(shù)據(jù)表中email字段內(nèi)容進(jìn)行賦值
				userInfo.setQuestion（rs.getString（“question“））;??//?將數(shù)據(jù)表中question字段內(nèi)容進(jìn)行賦值
				userInfo.setResult（rs.getString（“result“））;??????//?將數(shù)據(jù)表中result字段內(nèi)容進(jìn)行賦值
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;

		}?finally?{
			connection.closeConnection（）;???????????????????????//?執(zhí)行關(guān)閉數(shù)據(jù)庫鏈接的操作
		}
		return?userInfo;????????????????????????????????????????//?返回以用戶名為條件進(jìn)行查詢用戶的一組數(shù)據(jù)
	}

	//?實(shí)現(xiàn)用戶保存操作，該方法以用戶信息類的對象為參數(shù)
	public?boolean?user_save（UserInfo?userinfo）?{
		connection?=?new?JDBConnection（）;?//將JDBConnection對象進(jìn)行實(shí)例化
		sql?=?“INSERT?INTO?tb_userInfo?VALUES?（‘“?+?userinfo.getUsername（）
				+?“‘‘“?+?userinfo.getPassword（）?+?“‘‘“
				+?userinfo.getRealname（）?+?“‘‘“?+?userinfo.getEmail（）?+?“‘‘“
				+?userinfo.getQuestion（）?+?“‘‘“?+?userinfo.getResult（）?+?“‘）“;
		boolean?flag?=?connection.executeUpdate（sql）;?//執(zhí)行保存用戶的操作，flag對象值顯示的內(nèi)容可以表示執(zhí)行的結(jié)果
		connection.closeConnection（）;?????????????????//關(guān)閉數(shù)據(jù)庫連接操作
		return?flag;??????????????????????????????????//將flag對象作為這個方法的返回結(jié)果
	}

	//?實(shí)現(xiàn)相片數(shù)據(jù)保存操作，該方法以相片信息類的對象為參數(shù)
	public?boolean?photo_save（Photo?photo）?{
		connection?=?new?JDBConnection（）;?//?將JDBConnection對象進(jìn)行實(shí)例化
		sql?=?“insert?into?tb_photo?values?（‘“?+?photo.getPhotoName（）?+?“‘‘“
				+?photo.getPhotoSize（）?+?“‘‘“?+?photo.getPhotoType（）?+?“‘‘“
				+?photo.getPhotoTime（）?+?“‘‘“?+?photo.getPhotoAddress（）
				+?“‘‘“?+?photo.getUsername（）?+?“‘0‘“?+?photo.getSmallPhoto

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????3163??2015-06-29?09:46??安下下載說明.html
?????文件?????????102??2015-06-29?09:46??114la網(wǎng)址導(dǎo)航.html
?????目錄???????????0??2015-05-23?20:23??coldfenng.com\
?????目錄???????????0??2014-05-30?15:52??coldfenng.com\css\
?????文件????????3421??2008-09-04?17:51??coldfenng.com\css\style.css
?????文件????????4343??2008-09-05?15:52??coldfenng.com\css\style1.css
?????目錄???????????0??2014-05-30?15:52??coldfenng.com\Database\
?????文件?????1048576??2008-11-17?11:33??coldfenng.com\Database\db_photo_Data.MDF
?????文件?????1048576??2008-11-17?11:33??coldfenng.com\Database\db_photo_Log.LDF
?????文件?????????221??2008-09-02?18:36??coldfenng.com\dealwith.jsp
?????文件?????????240??2008-09-03?11:31??coldfenng.com\down.jsp
?????文件????????1994??2008-09-02?18:36??coldfenng.com\image.jsp
?????目錄???????????0??2014-05-30?15:52??coldfenng.com\images\
?????文件??????149346??2008-09-02?19:23??coldfenng.com\images\1.jpg
?????文件????????2225??2008-09-03?14:01??coldfenng.com\images\10.gif
?????文件???????23355??2008-09-04?09:34??coldfenng.com\images\10.jpg
?????文件????????3952??2008-09-04?15:40??coldfenng.com\images\11.gif
?????文件???????23981??2008-09-04?09:36??coldfenng.com\images\11.jpg
?????文件??????148851??2008-09-04?09:37??coldfenng.com\images\12.jpg
?????文件???????21180??2008-09-04?13:53??coldfenng.com\images\13.jpg
?????文件???????25102??2008-09-04?14:01??coldfenng.com\images\14.jpg
?????文件??????211473??2008-09-04?14:38??coldfenng.com\images\15.jpg
?????文件???????21712??2008-09-04?15:53??coldfenng.com\images\16.jpg
?????文件???????23431??2008-09-04?15:56??coldfenng.com\images\17.jpg
?????文件??????113790??2008-09-04?16:06??coldfenng.com\images\18.jpg
?????文件???????17279??2008-09-03?09:00??coldfenng.com\images\2.jpg
?????文件????????1982??2008-09-04?09:17??coldfenng.com\images\21.gif
?????文件????????1883??2008-09-04?09:18??coldfenng.com\images\22.gif
?????文件??????105424??2008-09-03?14:03??coldfenng.com\images\3.jpg
?????文件???????17812??2008-09-03?10:22??coldfenng.com\images\4.jpg
?????文件???????29460??2008-09-02?18:36??coldfenng.com\images\5.jpg
............此處省略88個文件信息