dispnews.java

小虫新闻管理系统 V1.0(jsp+javabean+mysql)

/**
*  Title  新闻管理系统
*  @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(){};

/*
* 根据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;
}

/*
* 根据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;
}

/*
* 查询所有的新闻(按点击数排序)
*/
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;
}

/*
* 计算某类别新闻的总数
*/
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;
}

/*
* 计算某新闻的最大点击数
*/
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;
}

/*
* 根据条件在所有的新闻中查询
*/
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;
}


}