replydao.java

一个很好的BBS论坛项目

package com.ibm.dao;

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

import com.ibm.common.DBConnection;
import com.ibm.vo.ReplyVO;



public class ReplyDAO {

	private static ReplyDAO rdao;
	private ReplyDAO()
	{
		
	}
	
	public static ReplyDAO gerInstance()
	{
		if(rdao == null)
		{
			rdao = new ReplyDAO();
		}
		return rdao;
	}
	
	public ArrayList queryAllReply(Connection conn)
	{
		ReplyVO rvo = null;
		ArrayList list = new ArrayList();
		String sql = "select * from reply";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			System.out.println(rs);
			while(rs.next())
			{
				rvo = new ReplyVO(); 
				System.out.println(rs.getInt(1));
				rvo.setReplyid(rs.getInt(1));
				rvo.setTitle(rs.getString(2));
				rvo.setContent(rs.getString(3));
				rvo.setPublishtime(rs.getTimestamp(4));
				rvo.setModifytime(rs.getTimestamp(5));
				rvo.setUid(rs.getInt(6));
				rvo.setTopicid(rs.getInt(7));
				list.add(rvo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			DBConnection.getInstance().close(null, ps, null, conn);
		}
		return list;
		
	}
	
}