commentdao.java

点餐系统 非常好的 jsp mysql 我也是别人那里下载来的

package DAO;
import Entity.CommentBean;
import Entity.UserBean;

import java.util.*;
import java.sql.*;

public class CommentDAO {
	OperateDB db=new OperateDB();
	GoodsDAO gd=new GoodsDAO();
	ResultSet rs=null;	
	UserDAO ud=new UserDAO();
	public ArrayList<CommentBean> GetComments()
	{
		ArrayList<CommentBean> list=new ArrayList<CommentBean>();			
		try{
			String sql="select * from comment order by ctime desc";
			 rs=db.GetQuery(sql);
			while(rs.next())
			{
				CommentBean bean=new CommentBean();
                bean.setCid(rs.getInt(1));
                bean.setCGid(gd.GetGoodsById(rs.getInt(2)));
                bean.setCuid(ud.GetUserById(rs.getString(3)));
                bean.setCip(rs.getString(4));
                bean.setCtitle(rs.getString(5));
			    bean.setContent(rs.getString(6));
			    bean.setCtime(rs.getDate(7));
			    bean.setCremark(rs.getString(8));			
				list.add(bean);
				}		
			
		}catch(Exception ex)
		{
			System.out.println("查询前10位评论的信息出现异常！"+ex.toString());
		}
		return list;
	
		
	}
	//添加新的评论
	public int AddComment(CommentBean bean)
	{
		int count=0;				
		try{
			String sql="insert into comment(cgid,cuid,Cip,ctitle,[content]) values("+bean.getCGid().getGid()+",'"+bean.getCuid().getUid()+"','"+bean.getCip()+"','"+bean.getCtitle()+"','"+bean.getContent()+"')";
			count=db.ReturnLine(sql);	
			
		}catch(Exception ex)
		{
			System.out.println("添加新的评论出现异常！"+ex.toString());
		}
		return count;
		
		
	}
	

}