package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?com.mysql.jdbc.ResultSet;

import?entity.pic;
import?entity.user;
import?util.DBUtil;
public?class?FriendshipDAO?{
	List?users?=?new?ArrayList（）;
	public?List?findAllusers（）{
		int?count?=0;
		Connection?conn?=?null;		
			try?{
				conn?=?DBUtil.getConnection（）;
				String?sql?=?“select?*?from?f_user“;
			????PreparedStatement?pre?=?conn.prepareStatement（sql）;
			????ResultSet?rst?=?（ResultSet）?pre.executeQuery（）?;	
			???
			????
			????while（rst.next（））{
			????	user?use?=?new?user（）;	
			????	int?age?=?rst.getInt（“age“）;
			????	String?ask?=?rst.getString（“ask“）;
			????	String?gender?=?rst.getString（“gender“）;
			????	int?id?=?rst.getInt（“id“）;
			????	String?name?=?rst.getString（“name“）;
			????	String?phone?=?rst.getString（“phone“）;
			????	String?pwd?=?rst.getString（“pwd“）?;
			????	String?username?=?rst.getString（“username“）?;
			????	use.setAge（age）;
			????	use.setAsk（ask）;
			????	use.setGender（gender）;
			????	use.setId（id）;
			????	use.setName（name）;
			????	use.setPhone（phone）;
			????	use.setPwd（pwd）;
			????	use.setUsername（username）;
			????	users.add（use）;
			????	count++?;
			????	
			????}
			}?catch?（Exception?e）?{				
				e.printStackTrace（）;
			}
			System.out.println（“users的長度是:“+users.size（））;
			System.out.println（“循環的次數是:“+count）;
			return?users?;			
	}
	public?void?saveUser（user?use）?{
		Connection?conn?=?null;
		try?{
			conn?=?DBUtil.getConnection（）;

			String?sql?=?“insert?into?f_user?（username??pwd??name??age??gender?phone??ask?）?values（“
					+?“????????）“;
			PreparedStatement?pre?=?conn.prepareStatement（sql）;
			String?username?=?use.getUsername（）;
			String?pwd?=?use.getPwd（）;
			String?name?=?use.getName（）;
			int?age?=?use.getAge（）;
			String?gender?=?use.getGender（）;
			String?phone?=?use.getPhone（）;
			String?ask?=?use.getAsk（）;
			pre.setString（1?username）;
			pre.setString（2?pwd）;
			pre.setString（3?name）;
			pre.setInt（4?age）;
			pre.setString（5?gender）;
			pre.setString（6?phone）;
			pre.setString（7?ask）;
			pre.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBUtil.close（conn）;
		}
	}
	public?void?savePic（pic?pi）?{
		Connection?conn?=?null;			
			try?{
				conn?=?DBUtil.getConnection（）;
				System.out.println（“conn連接成功“）;
				String?sql?=?“insert?into?f_pic?（?picName??userId?）?values（???）?“;
				PreparedStatement?pre?=?conn.prepareStatement（sql）;
				pre.setString（1?pi.getPicName（））;
				pre.setInt（2?pi.getUserid（））;
				pre.executeUpdate（）;
				System.out.println（“pic已存入數據庫“）;
			}?catch?（Exception?e）?{				
				e.printStackTrace（）;
			}finally?{
				DBUtil.close（conn）;
			}
	}
	public?List?findPicName（in

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

?????文件???????1228??2013-02-23?16:06??friendship\.classpath

?????文件????????303??2013-05-03?21:31??friendship\.mymetadata

?????文件???????1283??2013-02-18?14:23??friendship\.project

?????文件????????330??2013-02-18?14:18??friendship\.settings\org.eclipse.jdt.core.prefs

?????文件???????5410??2013-02-23?17:13??friendship\src\dao\FriendshipDAO.java

?????文件????????455??2013-02-18?14:45??friendship\src\entity\pic.java

?????文件???????1125??2013-02-18?15:03??friendship\src\entity\user.java

?????文件????????894??2013-02-16?17:50??friendship\src\util\DBUtil.java

?????文件???????8359??2013-02-23?17:15??friendship\src\web\ActionServlet.java

?????文件???????8915??2013-02-18?18:35??friendship\WebRoot\css\style.css

?????文件????????446??2013-02-18?18:35??friendship\WebRoot\img\bg.gif

?????文件????????182??2013-02-18?18:35??friendship\WebRoot\img\bullet_green.gif

?????文件????????128??2013-02-18?18:35??friendship\WebRoot\img\bullet_grey.gif

?????文件????????104??2013-02-18?18:35??friendship\WebRoot\img\button.gif

?????文件????????143??2013-02-18?18:35??friendship\WebRoot\img\content_bg.gif

?????文件???????2139??2013-02-18?18:35??friendship\WebRoot\img\footer.gif

?????文件????????439??2013-02-18?18:35??friendship\WebRoot\img\footer_bg.gif

?????文件??????12364??2013-02-18?18:35??friendship\WebRoot\img\nane.gif

?????文件???????1293??2013-02-18?18:35??friendship\WebRoot\img\tableheader-bg-grey.gif

?????文件???????2740??2013-02-18?18:35??friendship\WebRoot\img\tableheader-bg.gif

?????文件??????16384??2013-02-18?18:35??friendship\WebRoot\img\Thumbs.db

?????文件????????258??2013-02-18?18:35??friendship\WebRoot\img\top_left.gif

?????文件????????834??2013-02-18?14:18??friendship\WebRoot\index.jsp

?????文件?????180459??2013-02-25?14:51??friendship\WebRoot\js\jQuery-1.4.3.js

?????文件???????1751??2013-02-21?09:27??friendship\WebRoot\login.jsp

?????文件?????????36??2013-02-18?14:18??friendship\WebRoot\meta-INF\MANIFEST.MF

?????文件???????4138??2013-03-09?11:00??friendship\WebRoot\regist.jsp

?????文件????????281??2013-02-18?14:21??friendship\WebRoot\script.sql

?????文件??????14194??2013-02-18?18:35??friendship\WebRoot\t1.jpg

?????文件??????25533??2013-02-18?18:35??friendship\WebRoot\upload\pretty.jpg

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