replydao.java

具备留言的功能

package j2ee.pj.dao;

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

import j2ee.pj.db.DataBaseTool;
import j2ee.pj.javabean.ReplyBean;

public class ReplyDao {
	public boolean insertReply(ReplyBean reply){
		String sql="insert into reply values(''{0}'',''{1}'',''{2}'',''{3}'')";
		Object[] obj=new Object[]{
				reply.getR_sid(),
				reply.getRauthor(),
				new Date().toLocaleString(),
				reply.getRcontent()
		};
		MessageFormat mf=new MessageFormat(sql);
		sql=mf.format(obj);
		return DataBaseTool.getDataBaseTool().insertAndUpdateAndDelete(sql);
	}
	public boolean deleteReply(int  sid){
		String sql="delete reply where r_sid="+sid+"";
				
		return DataBaseTool.getDataBaseTool().insertAndUpdateAndDelete(sql);
	}
	public List queryReply(int sid){
		String sql="select * from reply where r_sid="+sid+"";
		ResultSet rs=DataBaseTool.getDataBaseTool().query(sql);
		List li=new ArrayList();
		ReplyBean reply=null;
		try {
			while(rs.next()){
				reply=new ReplyBean(
						rs.getInt(1),
						rs.getInt(2),
						rs.getString(3),
						rs.getString(4),
						rs.getString(5)
				);
				li.add(reply);
			}
			return li;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DataBaseTool.getDataBaseTool().closeConnection();
		}
		return null;
	}
}