c08d69c3c84b001d1ac8ed4714413604

一个简单的BBS论坛

package dao;

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

import javax.resource.cci.ResultSet;

import bean.Topic;

import util.DBUtil;

/**
 * 帖子的数据访问层
 * */
public class NoteDao {
	
	
	/**
	 * 查询全部帖子的内容
	 * */
	
	public ArrayList<Topic> findNoteAll()
	{
		ArrayList<Topic> notelist = new ArrayList<Topic>();
		
		Connection conn = null;
		
		conn = DBUtil.getJDBCConnection();
		
		String sql = "select [id],title,content,username,disttime,lasttime from NoteTBL order by lasttime desc";
		
		
		return notelist;
	}
	
	/**
	 * 按编号查询帖子内容
	 * */
	
	public Topic findNoteById(int id)
	{
		Topic topic = null;
		
		Connection conn = null;
		
		conn = DBUtil.getJDBCConnection();
		
		return topic;
	}
	
	
	/**
	 * 添加帖子
	 * */
	
	public boolean addNote(Topic topic)
	{
		boolean flag = false;
		
		Connection conn = null;
		
		conn = DBUtil.getJDBCConnection();
		
		
		return flag;
	}
	
	/**
	 * 删除帖子
	 * */
	
	/**
	 * 修改帖子
	 * */
	

	


}