advicereportbean.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuBean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;

public class AdviceReportBean {
	
	private ArrayList adviceList = new ArrayList();
	private ArrayList reportList = new ArrayList();
	
	public AdviceReportBean()
	{
		//default
	}
	
	public ArrayList getAdvices()
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			//查找用户的余额
			String query = "select * from advice";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				int advicenum = rs.getInt("advicenum");
				String content = rs.getString("content");
				String datetime = rs.getString("date");
				String adminname = rs.getString("adminname");
				Advice aAdvice = new Advice(advicenum,content,datetime,adminname);
				adviceList.add(aAdvice);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return adviceList;
	}
	
	public ArrayList getReports()
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			//查找用户的余额
			String query = "select * from news";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				int newsnum = rs.getInt("newsnum");
				String title = rs.getString("title");
				String content = rs.getString("content");
				String datetime = rs.getString("reportdate");
				String adminname = rs.getString("adminname");
				News aNew = new News(newsnum,title,content,datetime,adminname);
				reportList.add(aNew);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return reportList;
	}
}