20c488d2c24b001d1ac8ed4714413604

一个简单的BBS论坛

package dao;

import java.sql.Connection;
import java.util.ArrayList;

import util.DBUtil;

/**
 * 帖子的数据访问层
 * */
public class NoteDao {
	
	
	/**
	 * 查询全部帖子的内容
	 * */
	
	public ArrayList<Note> findNoteAll()
	{
		ArrayList<Note> notelist = new ArrayList<Note>();
		
		Connection conn = null;
		
		conn = DBUtil.getJDBCConnection();
		
		try{
			PreparedStatement stmt = conn.prepareStatement(sql);
			
			ResultSet rs = stmt.executeQuery();
			
			while(rs.next())
			{
				int id = rs.getInt(1);
				String title = rs.getString(2);
				String content = rs.getString(3);
				String username = rs.getString(4);
				String disttime = rs.getString(5);
				String lasttime = rs.getString(6);
				
				Note note = new Note();
				note.setId(id);
				note.setTitle(title);
				note.setContent(content);
				note.setUsername(username);
				note.setDisttime(disttime);
				note.setLasttime(lasttime);
				
				notelist.add(note);
			}
			
		}catch{
			
		}finally
		{
			DBUtil.closeConnection(conn);
		}
		
		return notelist;
	}
	
	/**
	 * 按编号查询帖子内容
	 * */
	
	
	
	/**
	 * 添加帖子
	 * */
	
	
	/**
	 * 删除帖子
	 * */
	
	/**
	 * 修改帖子
	 * */
	

	


}