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

来源：互联网发布：淘宝美术设计招聘编辑：程序博客网时间：2024/05/21 08:43
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 blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.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 blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.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 blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.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;}}
0 0