listnews.java

一个关于商业的网站

package com.everstar.news;

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

public class ListNews{

public ListNews(){
}

private NewsData data;
private Vector vdata = new Vector();
private String[][] newslist;
private int listcount = 0;
private int page = 0;

public void setData(NewsData data)
{
}


public void init(){
Database conn = new Database();
vdata.clear();
try{
String sql = "select ID,title,source,summary,body,time,author from news order by ID";
ResultSet rs = conn.select(sql);
//if(rs==null)
//i=0;
//else
//i=conn.count("select * from news");
while(rs.next()){
	NewsData ndata=new NewsData();

	ndata.setID(rs.getInt("ID"));
	ndata.setTitle(rs.getString("title"));
	//ndata.setPhoto(rs.getString("photo"));
	ndata.setSource(rs.getString("source"));
	ndata.setSummary(rs.getString("summary"));
	ndata.setBody(rs.getString("body"));
	ndata.setNtime(rs.getString("time"));
	ndata.setAuthor(rs.getString("author"));

	vdata.add(ndata);

	}
rs.close();
conn.close();
}catch(SQLException E){
}

}

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

}

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;

}


public String[][] getNewslist(){

	int size = vdata.size();
	newslist = new String[size][2];
	NewsData listdata = new NewsData();
	for(int i=0;i<size;i++){
		listdata = (NewsData)vdata.elementAt(i);

		newslist[i][0]=String.valueOf(listdata.getID());
		if(listdata.getTitle()==null)
		newslist[i][1]="No Subject";
		else
		newslist[i][1]=listdata.getTitle();

	}
	return newslist;
}
}