newsbean.java

来自「该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索」· Java 代码 · 共 104 行

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

public class NewsBean 
{
	private ArrayList resultArrayList = new ArrayList();
	private String author;
	private int num=0;
	
	public NewsBean()
	{
		
	}
	
	public ArrayList getNews()
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query = "Select * from news";
			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				int num =result.getInt("newsnum");
				String title = result.getString("title");
				String content = result.getString("content");
				String date = result.getString("reportdate");
				String adminname = result.getString("adminname");
				News aNews = new News(num,title,content,date,adminname);
				resultArrayList.add(aNews);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return resultArrayList;
	}
	
	public String getOneNews(String aTitle)
	{
		String aContent="";
		
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query = "Select * from news where title='"+aTitle+"'";
			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				aContent = result.getString("content");
				author = result.getString("adminname");
			}
			
			String query1 = "Select * from replyofuser where title='"+aTitle+"'";
			ResultSet rs = sqlstatement.executeQuery(query1);
			
			int i=0;
			while(rs.next())
			{
				i++;
			}
			num = i;
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return aContent;
	}
	
	public String getAuthor()
	{
		return author;
	}
	
	public int getNumOfReply()
	{
		return num;
	}
}