新闻发布项目——数据实现类（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;
	}

}