package?Dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
import?DBcon.DBconnection;
import?Entity.Picture;

public?class?PictureDao?{
	public?void?save（Picture?p）?throws?Exception?{
		Connection?conn?=?null;
		String?sql?=?“insert?into?f_pic?（picNameuserId）?values（??）“;
		try?{
			conn?=?DBconnection.getConnection（）;
			PreparedStatement?prep?=?conn.prepareStatement（sql）;
			prep.setString（1?p.getPicName（））;
			prep.setInt（2?p.getUserId（））;
			prep.executeUpdate（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?e;
		}?finally?{
			DBconnection.close（conn）;
		}
	}

	public?List?findAll（）?throws?Exception?{
		List?pictures?=?new?ArrayList（）;
		Connection?conn?=?null;
		try?{
			conn?=?DBconnection.getConnection（）;
			Statement?stat?=?conn.createStatement（）;
			ResultSet?rs?=?stat.executeQuery（“select?*?from?f_pic?order?by?id“）;
			while?（rs.next（））?{
				Picture?p?=?new?Picture（）;
				p.setId（rs.getInt（“id“））;
				p.setPicName（rs.getString（“picName“））;
				p.setUserId（rs.getInt（“userId?“））;
				pictures.add（p）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?e;
		}?finally?{
			DBconnection.close（conn）;
		}
		return?pictures;
	}

	public?List?findByuserId（int?userId）?throws?Exception?{
		Connection?conn?=?null;
		List?picture?=?new?ArrayList（）;
		try?{
			conn?=?DBconnection.getConnection（）;
			String?sql?=?“select?*?from?f_pic?where?userId=“?+?userId;
			Statement?stat?=?conn.createStatement（）;
			ResultSet?rs?=?stat.executeQuery（sql）;
			while?（rs.next（））?{
				Picture?p?=?new?Picture（）;
				p.setId（rs.getInt（“id“））;
				p.setPicName（rs.getString（“picName“））;
				p.setUserId（userId）;
				picture.add（p）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?e;
		}?finally?{
			DBconnection.close（conn）;
		}
		return?picture;
	}
	
	public?void?delete（）{
		Connection?conn=null;
		String?sql=“delete?from?f_pic?where?userId=?“;
		try?{
			conn=DBconnection.getConnection（）;
			PreparedStatement?prep=conn.prepareStatement（sql）;
			Picture?p=new?Picture（）;
			prep.setInt（1p.getUserId（））;
			prep.executeUpdate（）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		DBconnection.close（conn）;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-07?16:26??FriendWeb\
?????文件?????????300??2013-04-23?09:35??FriendWeb\?-?副本.mymetadata
?????文件?????????587??2013-02-19?23:27??FriendWeb\.classpath
?????目錄???????????0??2013-05-07?16:28??FriendWeb\.myeclipse\
?????文件?????????300??2013-04-23?09:35??FriendWeb\.mymetadata
?????文件????????1183??2013-02-18?23:55??FriendWeb\.project
?????目錄???????????0??2013-04-23?09:35??FriendWeb\WebRoot\
?????目錄???????????0??2013-04-23?09:35??FriendWeb\WebRoot\meta-INF\
?????文件??????????39??2013-02-18?22:31??FriendWeb\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2013-04-23?09:35??FriendWeb\WebRoot\WEB-INF\
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\DBcon\
?????文件????????1771??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\DBcon\DBconnection.class
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Dao\
?????文件????????3598??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Dao\PictureDao.class
?????文件????????4695??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Dao\UserDao.class
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Entity\
?????文件?????????617??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Entity\Filename.class
?????文件?????????928??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Entity\Picture.class
?????文件????????1826??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Entity\User.class
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Filter\
?????文件?????????915??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Filter\FriendFilter.class
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Web\
?????文件????????2302??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Web\CheckCodeServlet.class
?????文件????????6937??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\Web\FriendServlet.class
?????文件?????????102??2013-05-05?14:18??FriendWeb\WebRoot\WEB-INF\classes\connection.properties
?????目錄???????????0??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\tag\
?????文件????????1101??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\tag\DateTag.class
?????文件????????1311??2013-05-05?15:36??FriendWeb\WebRoot\WEB-INF\classes\tag\SessionValidateTag.class
?????目錄???????????0??2013-04-23?09:35??FriendWeb\WebRoot\WEB-INF\lib\
?????文件???????57779??2006-09-05?10:20??FriendWeb\WebRoot\WEB-INF\lib\commons-fileupload-1.2.1.jar
............此處省略43個(gè)文件信息