advicesbean.java

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

package ynuBean;
import ynuBean.ConnectDataBase;
import java.util.*;
import java.sql.*;
import ynuBean.Advice;

public class AdvicesBean 
{
	private ArrayList resultArrayList = new ArrayList();
	
	public AdvicesBean()
	{
		
	}
	
	public ArrayList getAdvices()
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			//查找用户的余额
			String query = "Select * from advice";
			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				int advicenum= result.getInt("advicenum");
				String content = result.getString("content");
				String date = result.getString("date");
				String adminname = result.getString("adminname");
				Advice aAdvice = new Advice(advicenum,content,date,adminname);
				resultArrayList.add(aAdvice);
			}
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return resultArrayList;
	}
}