searchnews.java

动态网站管理发布系统

package com.ntsky.news;

import com.ntsky.common.CodeFilter;
import com.ntsky.common.Debug;
import com.ntsky.database.SQLDBOperator;
import com.ntsky.persistence.NEWSTable;

import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;

public class SearchNews {

	public SQLDBOperator sdbo;

	private String search;

	private int select;

	public SearchNews() {
		sdbo = null;
		search = null;
	}

	public void setSearch(String search) {
		this.search = search;
	}

	public String getSearch() {
		return CodeFilter.toHtml(search);
	}

	public void setSelect(int select) {
		this.select = select;
	}

	public int getSelect() {
		return select;
	}

	public int sumNews() {
		ResultSet rs = null;
		if (sdbo == null)sdbo = SQLDBOperator.getInstance("Connection");
		int sumNews = 0;
		if(search == null){
			search = "";
		}		
		switch (select) {
		default:
			break;

		case 0:
			String strSql1 = "select newsId from news where headTitle like '%" + search + "%';";
			try {
				rs = sdbo.executeQuery(strSql1);
				rs.last();
				sumNews = rs.getRow();
				rs.close();
			}catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			}catch (NullPointerException nullE) {
				System.out.print("SearchNews sumNews() "+ nullE.getMessage());
				Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			}finally {
				sdbo.Close();
			}
			break;

		case 1:
			String strSql2 = "select newsId from news where content like '%" + search + "%';";
			try {
			    rs = sdbo.executeQuery(strSql2);
				rs.last();
				sumNews = rs.getRow();
				rs.close();
			}catch (NullPointerException nullE) {
			    System.out.print("SearchNews sumNews() " + nullE.getMessage());
				Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			}catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			}finally {
				sdbo.Close();
			}
			break;
		}
		return sumNews;
	}

	public Iterator listNews() {
		ResultSet rs = null;
		Vector vector = new Vector();
		if (sdbo == null)sdbo = SQLDBOperator.getInstance("Connection");
		if(search == null){
			search = "";
		}		
		switch (select) {
		default:
			break;

		case 0:
			String strSql1 = "select classId,newsId,headTitle from news where headTitle like '%" + search + "%';";
			try {
				rs = sdbo.executeQuery(strSql1);
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setClassId(rs.getInt("classId"));
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(new String(CodeFilter.toUbbHtml(rs.getString("headTitle")).getBytes("ISO-8859-1"), "gbk"));
					vector.add(tableNews);
				}
				rs.close();
			} catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (NullPointerException nullE) {
				System.out.print("SearchNews sumNews() "+ nullE.getMessage());
				Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			} finally {
				sdbo.Close();
			}
			break;

		case 1:
			String strSql2 = "select classId,newsId,headTitle from news where content like '%" + search + "%';";
			try {
				rs = sdbo.executeQuery(strSql2);
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setClassId(rs.getInt("classId"));
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(new String(CodeFilter.toUbbHtml(rs.getString("headTitle")).getBytes("ISO-8859-1"), "gbk"));
					vector.add(tableNews);
				}	
				rs.close();
			}catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			}catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (NullPointerException nullE) {
				System.out.print("SearchNews sumNews() " + nullE.getMessage());
				Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			} finally {
				sdbo.Close();
			}
			break;
		}
		return vector.iterator();
	}

	public int sumNews(String user) {
		ResultSet rs = null;
		if (sdbo == null)sdbo = SQLDBOperator.getInstance("Connection");
		int sumNews = 0;
		if(search == null){
			search = "";
		}		
		switch (select) {
		default:
			break;

		case 0:
			String strSql1 = "select newsId from news where headTitle like '%" + search + "%' and author='" + user + "';";
			try {
				rs = sdbo.executeQuery(strSql1);
				try {
					rs.last();
					sumNews = rs.getRow();
					rs.close();
				} catch (NullPointerException nullE) {
					System.out.print("SearchNews sumNews() " + nullE.getMessage());
					Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
				}
			} catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :"
						+ sqlE.getLocalizedMessage());
			} finally {
				sdbo.Close();
			}
			break;

		case 1:
			String strSql2 = "select newsId from news where content like '%" + search + "%' and author='" + user + "';";
			try {
				try {
					rs = sdbo.executeQuery(strSql2);
					try {
						rs.last();
						sumNews = rs.getRow();
						rs.close();
					} catch (NullPointerException nullE) {
						System.out.print("SearchNews sumNews() " + nullE.getMessage());
						Debug.writeLog("SearchNews sumNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
					}
					break;
				} catch (SQLException sqlE) {
					System.out.print("NewsShow sumNews() " + sqlE.getMessage());
					Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
				}
				break;
			} finally {
				sdbo.Close();
			}
		}
		return sumNews;
	}

	public Iterator listNews(String user) {
		ResultSet rs = null;
		Vector vector = new Vector();
		if (sdbo == null)sdbo = SQLDBOperator.getInstance("Connection");
		if(search == null){
			search = "";
		}
		switch (select) {
		default:
			break;

		case 0:
			String strSql1 = "select newsId,headTitle,newsTime from news where headTitle like '%" + search + "%' and author='" + user + "';";
			try {
				rs = sdbo.executeQuery(strSql1);

				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(new String(rs.getString("headTitle").getBytes("ISO-8859-1"), "gbk"));
					tableNews.setNewsTime(rs.getString("newsTime"));
					vector.add(tableNews);
				}
				rs.close();

			} catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				sdbo.Close();
			}
			break;

		case 1:
			String strSql2 = "select newsId,headTitle,newsTime from news where content like '%" + search + "%' and author='" + user + "';";
			try {
				rs = sdbo.executeQuery(strSql2);
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(new String(rs.getString("headTitle").getBytes("ISO-8859-1"), "gbk"));
					tableNews.setNewsTime(rs.getString("newsTime"));
					vector.add(tableNews);
				}
				rs.close();
				break;
			} catch (SQLException sqlE) {
				System.out.print("NewsShow sumNews() " + sqlE.getMessage());
				Debug.writeLog("NewsShow sumNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				sdbo.Close();
			}
		}
		return vector.iterator();
	}

	public Iterator hotNews() {
		Vector vector = new Vector();
		if (sdbo == null)
			sdbo = SQLDBOperator.getInstance("Connection");
		ResultSet rs = null;
		String strSql = "select newsId,headTitle from news order by hits desc limit 0,8;";
		try {
			rs = sdbo.executeQuery(strSql);
			try {
				while (rs.next()) {
					NEWSTable tableNews = new NEWSTable();
					tableNews.setNewsId(rs.getInt("newsId"));
					tableNews.setHeadTitle(new String(rs.getString("headTitle").getBytes("ISO-8859-1"), "gbk"));
					vector.add(tableNews);
				}
				rs.close();
			} catch (NullPointerException nullE) {
				System.out.print("NewsShow hotNews() " + nullE.getMessage());
				Debug.writeLog("NewsShow hotNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
			}
		} catch (SQLException sqlE) {
			System.out.print("NewsShow hotNews() " + sqlE.getMessage());
			Debug.writeLog("NewsShow hotNews(), Exception Occured ! Info :" + sqlE.getLocalizedMessage());
		} catch (UnsupportedEncodingException nullE) {
			System.out.print("Personal unNews() info :" + nullE.getMessage());
			Debug.writeLog("Personal unNews(), Exception Occured ! Info :" + nullE.getLocalizedMessage());
		} finally {
			sdbo.Close();
		}
		return vector.iterator();
	}
}