/**
*  Title  新聞管理系統(tǒng)
*  @author: 陳鋼
*  Company: http://www.pcccp.com
*  Copyright: Copyright (c) 2003
*  @version 1.0
*  新聞表中的一些查詢操作
*/
package news.news;

import news.database.DBConnect;
import news.news.*;
import news.util.*; 
import java.sql.*;
import java.util.*;

public class DispNews extends News{

public ResultSet rs;

public DispNews(){};

/*
* 根據(jù)rootid得到某欄目所有的新聞
*/
public Vector rootidToNews() {
	DBConnect dbc = null;
	Vector newsInfoVector = new Vector();
	
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM news WHERE rootid = ? order by id desc");
		dbc.setInt(1,rootID);
		rs = dbc.executeQuery();
			while(rs.next()){
			News news = new News();
			news.setID(rs.getInt("id"));
			news.setTopic(rs.getString("topic"));
			news.setBody(rs.getString("body"));
			news.setHits(rs.getInt("hits"));
			news.setAdddate(rs.getString("adddate"));
			news.setAdduser(rs.getString("adduser"));
			news.setRootID(rs.getInt("rootid"));
			news.setPic(rs.getString("pic"));
			newsInfoVector.add(news);
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return newsInfoVector;
}

/*
* 根據(jù)ID得到新聞
*/
public News idToNews() {
	DBConnect dbc = null;
	News news = new News();	
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM news WHERE id = ?");
		dbc.setInt(1,ID);
		rs = dbc.executeQuery();
			if(rs.next()){
			news.setID(rs.getInt("id"));
			news.setTopic(rs.getString("topic"));
			news.setBody(rs.getString("body"));
			news.setHits(rs.getInt("hits"));
			news.setAdddate(rs.getString("adddate"));
			news.setAdduser(rs.getString("adduser"));
			news.setRootID(rs.getInt("rootid"));
			news.setPic(rs.getString("pic"));
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return news;
}

/*
* 查詢所有的新聞(按點(diǎn)擊數(shù)排序)
*/
public Vector allNews() {
	DBConnect dbc = null;
	Vector allNewsVector = new Vector();
	
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM news order by hits desc");
		rs = dbc.executeQuery();
			while(rs.next()){
			News news = new News();
			news.setID(rs.getInt("id"));
			news.setTopic(rs.getString("topic"));
			news.setBody(rs.getString("body"));
			news.setHits(rs.getInt("hits"));
			news.setAdddate(rs.getString("adddate"));
			news.setAdduser(rs.getString("adduser"));
			news.setRootID(rs.getInt("rootid"));
			news.setPic(rs.getString("pic"));
			allNewsVector.add(news);
		}
	}catch(Exception e){
		System.err.println("error:"+e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return allNewsVector;
}

/*
* 計算某類別新聞的總數(shù)
*/
public int newsNum() {
	DBConnect dbc = null;
	int newsCount = 0;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT count(*) FROM news WHERE rootid = ?");
		dbc.setInt(1,rootID);
		rs = dbc.executeQuery();
		if(rs.next())	newsCount = rs.getInt(1);
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return newsCount;
}

/*
* 計算某新聞的最大點(diǎn)擊數(shù)
*/
public int maxHit() {
	DBConnect dbc = null;
	int maxhit = 0;
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT max(hits) FROM news");
		rs = dbc.executeQuery();
		if(rs.next())	maxhit = rs.getInt(1);
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return maxhit;
}

public String search;

public String getSearch(){
	return search;
}

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

/*
* 根據(jù)條件在所有的新聞中查詢
*/
public Vector searchNews() {
	DBConnect dbc = null;
	Vector searchNewsInfoVector = new Vector();
	try{
		dbc  = new DBConnect();
		dbc.prepareStatement("SELECT * FROM news WHERE topic like ? order by id desc");
		//dbc.setBytes(1,search.getBytes("GB2312"));
		dbc.setBytes(1,("%"+search+"%").getBytes("GB2312"));
		rs = dbc.executeQuery();
			while(rs.next()){
			News news = new News();
			news.setID(rs.getInt("id"));
			news.setTopic(rs.getString("topic"));
			news.setBody(rs.getString("body"));
			news.setHits(rs.getInt("hits"));
			news.setAdddate(rs.getString("adddate"));
			news.setAdduser(rs.getString("adduser"));
			news.setRootID(rs.getInt("rootid"));
			news.setPic(rs.getString("pic"));
			searchNewsInfoVector.add(news);
		}
	}catch(Exception e){
		System.err.println(e);
	}finally{
		try{
			dbc.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	return searchNewsInfoVector;
}


}