新闻发布项目——数据实现类（commentDaoImpl）

package bdqn.newsMange.Dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import bdqn.newsMange.Dao.BaseDao;
import bdqn.newsMange.Dao.commentDao;
import bdqn.newsMange.entity.comment;
/**
 * 新闻评论的实现类
 * @author Administrator
 *
 */
public class commentDaoImpl extends BaseDao implements commentDao {
  //查询
  public List<comment> getCommentAll() {
    List<comment>clist=new ArrayList<comment>();
    String sql="select * from comment";
    
    try {
      ResultSet rs=executeQurey(sql, null);
      while(rs.next()){
        comment comm=new comment();
        comm.setCommentID(rs.getInt("CommentID"));
        comm.setCmmUser(rs.getString("CmmUser"));
        comm.setIp(rs.getString("Ip"));
        comm.setCmmContent(rs.getString("CmmContent"));
        comm.setNewsID(rs.getInt("NewsID"));
        comm.setCmmDate(rs.getDate("CmmDate"));
        clist.add(comm);
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }finally{
      closeAll();
    }
    return clist;
  }
  //根据新闻的id查询新闻评论
  public List<comment> getCommentAllByNewsid(int newsid) {
    List<comment>comlist=new ArrayList<comment>();
    String sql="select * from comment where CommentID=?";
    List<Object> prams=new ArrayList<Object>();
    comment comm=null;
    prams.add(newsid);
    try {
      ResultSet rs=executeQurey(sql, prams);
      while(rs.next()){
        comm=new comment();
        comm.setCommentID(rs.getInt("CommentID"));
        comm.setCmmUser(rs.getString("CmmUser"));
        comm.setIp(rs.getString("Ip"));
        comm.setCmmContent(rs.getString("CmmContent"));
        comm.setNewsID(rs.getInt("NewsID"));
        comm.setCmmDate(rs.getDate("CmmDate"));
        comlist.add(comm);
        
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }finally{
      closeAll();
    }
    return comlist;
  }
  //添加
  public int addComment(comment comm) {
    int rel=0;
    String sql="insert comment (cmmUser,ip,cmmContent,newsID,cmmDate)values(?,?,?,?,?)";
    List<Object>prams=new ArrayList<Object>();
    Date date=new Date();
    SimpleDateFormat fora=new SimpleDateFormat("yyyy-MM-dd");
    prams.add(comm.getCmmUser());
    prams.add(comm.getIp());
    prams.add(comm.getCmmContent());
    prams.add(comm.getNewsID());
    prams.add(fora.format(date));
    try {
      rel=executeUpdate(sql, prams);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }finally{
      closeAll();
    }
    return rel;
  }
  
  public int updateComment(comment comm) {
    int rel=0;
    return rel;
  }
  public int delComment(int id) {
    int rel=0;
    return rel;
  }
}