package news;
import java.sql.*;
import java.util.*;
public class CommentInfo {
  private int cid;
  private int nid;
  private String nickname;
  private String content;
  private String time;
  private String ip;
  public CommentInfo(){}
  public void setNid(int id){
  this.nid=id;
   }
  public Vector getComment(int nid,boolean flag){
    Vector vc=new Vector();
    DBConn conn=new DBConn();
    String sql="SELECT * FROM commentary WHERE nid="+nid;
    try{
      ResultSet rs = conn.query(sql);
    while(rs.next()){
      StringBuffer buffer=new StringBuffer() ;
      buffer.append("<TR><TD bgcolor=#8BB7F1>呢稱(chēng):"+rs.getString("nickname"));
      buffer.append("&nbsp;&nbsp;&nbsp;IP:"+rs.getString("ip"));
      buffer.append("&nbsp;&nbsp;&nbsp;時(shí)間:"+rs.getString("time"));
      if(flag){
        buffer.append("&nbsp;&nbsp;&nbsp;<a href='AdminAction?action=2&cid="+rs.getInt("id")+"'>");
        buffer.append("刪除</a>");
      }
      buffer.append("</TD></TR>");
      buffer.append("<TR><TD>評(píng)論內(nèi)容:"+rs.getString("content"));
      buffer.append("</TD></TR>");
      vc.add(buffer);  
      buffer=null;
    }
}
catch(Exception e){
  System.out.print(e.toString());
  vc=null;
}
return vc;
}


}