package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?entity.Fpic;

import?util.DBUtil;

public?class?FpicDAO?{
	public?void?savePic（Fpic?fpic）{
		Connection?con?=null;
		PreparedStatement?pst?=?null;
		String?sql?=“insert?into?f_pic（usernamepicName）values（??）“;
		try?{
			con?=?DBUtil.getConnection（）;
			pst?=con.prepareStatement（sql）;
			pst.setString（1?fpic.getUsername（））;
			pst.setString（2?fpic.getPicname（））;
			pst.executeUpdate（）;
			
		}?catch?（Exception?e）?{
			
			e.printStackTrace（）;
		}
	}
	public?List?findByUsername（String?username）{
		List?fpics?=?new?ArrayList（）;
		Connection?con?=null;
		PreparedStatement?pst?=?null;
		ResultSet?rs?=?null;
		String?sql?=“select?*?from?f_pic?where?username?=??“;
		try?{
			con?=?DBUtil.getConnection（）;
			pst?=con.prepareStatement（sql）;
			pst.setString（1?username）;
			rs?=?pst.executeQuery（）;
			while（rs.next（））{
				Fpic?pic?=?new?Fpic（）;
				pic.setId（rs.getInt（“id“））;
				pic.setUsername（rs.getString（“username“））;
				pic.setPicname（rs.getString（“picName“））;
				fpics.add（pic）;
				}
			
		}?catch?（Exception?e）?{
			
			e.printStackTrace（）;
		}
		return?fpics;
	}
	
}

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

?????文件????????861??2014-02-24?20:39??friend\.classpath

?????文件????????291??2014-04-01?09:47??friend\.mymetadata

?????文件???????1412??2014-02-20?20:14??friend\.project

?????文件????????500??2014-02-20?16:32??friend\.settings\.jsdtscope

?????文件????????330??2014-02-20?16:32??friend\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2014-02-20?16:32??friend\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-02-20?16:32??friend\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1325??2014-02-24?11:31??friend\src\dao\FpicDAO.java

?????文件???????2627??2014-02-24?09:54??friend\src\dao\FUserDAO.java

?????文件????????231??2014-02-15?15:48??friend\src\db.properties

?????文件????????470??2014-02-20?17:13??friend\src\entity\Fpic.java

?????文件???????1109??2014-02-20?17:14??friend\src\entity\Fuser.java

?????文件???????2991??2014-02-19?20:32??friend\src\util\DBUtil.java

?????文件????????602??2014-02-20?11:06??friend\src\util\MD5Util.java

?????文件???????3648??2014-02-25?08:33??friend\src\web\ActionServlet.java

?????文件???????2487??2014-02-24?11:47??friend\src\web\CheckCodeServlet.java

?????文件???????4522??2014-02-24?20:44??friend\src\web\UserServlet.java

?????文件????????515??2014-02-18?16:27??friend\WebRoot\check.jsp

?????文件???????8915??2014-02-20?16:39??friend\WebRoot\css\style.css

?????文件????????492??2014-02-17?10:36??friend\WebRoot\error.jsp

?????文件????????524??2014-02-14?15:28??friend\WebRoot\footer.jsp

?????文件????????960??2014-02-21?09:39??friend\WebRoot\header.jsp

?????文件????????446??2014-02-20?16:39??friend\WebRoot\img\bg.gif

?????文件????????182??2014-02-20?16:39??friend\WebRoot\img\bullet_green.gif

?????文件????????128??2014-02-20?16:39??friend\WebRoot\img\bullet_grey.gif

?????文件????????104??2014-02-20?16:39??friend\WebRoot\img\button.gif

?????文件????????143??2014-02-20?16:39??friend\WebRoot\img\content_bg.gif

?????文件???????2139??2014-02-20?16:39??friend\WebRoot\img\footer.gif

?????文件????????439??2014-02-20?16:39??friend\WebRoot\img\footer_bg.gif

?????文件??????12364??2014-02-20?16:39??friend\WebRoot\img\nane.gif

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