package dao;

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

import util.DBUtil;
import entity.Pic;

public class PicDAO {
	// 1.保存上传的照片
	public void save(Pic pic) throws Exception {
		Connection conn = DBUtil.getConnection();
		PreparedStatement prep = conn
				.prepareStatement("insert into f_pic values(null,?,?)");
		prep.setString(1, pic.getPicName());
		prep.setInt(2, pic.getUserId());
		prep.executeUpdate();
		DBUtil.close(conn);
	}

	// 2.获取相片的列表
	public List<Pic> findPics(int userId) throws Exception {
		List<Pic> pics = new ArrayList<Pic>();
		Connection conn = DBUtil.getConnection();
		PreparedStatement prep = conn
				.prepareStatement("select*from f_pic where userId=?");
		prep.setInt(1, userId);
		ResultSet rs = prep.executeQuery();
		while (rs.next()) {
			Pic pic = new Pic();
			pic.setId(rs.getInt("id"));
			pic.setPicName(rs.getString("picName"));
			pic.setUserId(userId);
			pics.add(pic);
		}
		DBUtil.close(conn);
		return pics;
	}

}