searchnews.java

一个关于商业的网站

package com.everstar.news;

import java.sql.*;
import java.util.*;
import com.everstar.database.*;

public class SearchNews{

public SearchNews(){
}


private NewsData data;
private Vector vdata = new Vector();
private String search = null;
private int page = 0;
private int listcount = 0;

public void init(){
Database conn = new Database();
int i=0;
vdata.clear();
try{
String sql = "select ID,title,source,summary,body,time,author from news where title like '%"+search+"%' or body like '%"+search+"%' order by ID";
ResultSet rs = conn.select(sql);
if(rs!=null)
i=1;
else
i=-1;
while(rs.next()){
	NewsData ndata=new NewsData();

	int ID = 0;
	ID = rs.getInt("ID");
	String title = rs.getString("title");
	//String photo = rs.getString("photo");
	String source = rs.getString("source");
	String summary = rs.getString("summary");
	String body = rs.getString("body");
	String ntime = rs.getString("time");
	String author = rs.getString("author");


	ndata.setID(ID);
	ndata.setTitle(title);
	//ndata.setPhoto(photo);
	ndata.setSource(source);
	ndata.setSummary(summary);
	ndata.setBody(body);
	ndata.setNtime(ntime);
	ndata.setAuthor(author);

	vdata.add(ndata);

	}
rs.close();
conn.close();
}catch(SQLException E){
	System.out.println(E.getMessage());
}
//return i;
}

public void setData(NewsData ndata)
{

}

public NewsData getData(int idx){
	return (NewsData)vdata.elementAt(idx);
}

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

public String getSearch(){
	return search;
}

public int getListcount(){
	return vdata.size();
}

public int getPage(int count){
	int size=vdata.size();
	if(size%count==0)
	page=size/count;
	else
	page=size/count+1;
	return page;
}

}