replydao.java

一个非常简单的mvc留言板MVC框架是STRUTS框架的基础

package com.aptech.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.MessageFormat;
import java.util.ArrayList;
import java.util.List;

import com.aptech.bean.Reply;
import com.aptech.util.DatabaseTool;

public class ReplyDAO {
	/**
	 * 添加新回复
	 * 
	 * @param reply
	 *            Reply对象
	 * @return 如果回复成功,返回真,否则返回假
	 */
	public boolean addReply(Reply reply) {
		MessageFormat mf = new MessageFormat("insert into reply values(''{0}'',''{1}'', {2})");
		String sql = mf.format(new Object[]{
				reply.getRcontent(), 
				new java.util.Date().toLocaleString(),
				reply.getSid() + ""
		});
		
		return DatabaseTool.getInstance().insertOrUpdateOrDelete(sql);
	}

	/**
	 * 根据留言ID返回所有留言
	 * 
	 * @param sid
	 *            留言ID
	 * @return 返回留言集合
	 */
	public List getRepliesByReplyId(int sid) {
		String sql = "select * from reply where sid = " + sid;
		ResultSet rs = DatabaseTool.getInstance().select(sql);
		if(rs != null){
			List list = new ArrayList();
			Reply r = null;
			try {
				while(rs.next()){
					r = new Reply(
							rs.getInt("rid"),
							rs.getString("rcontent"),
							rs.getString("rdatetime"),
							rs.getInt("sid")
						);
					list.add(r);
				}
				return list;
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return null;
	}
}