viewnews.java

一个关于商业的网站

package com.everstar.news;

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

public class ViewNews{

public ViewNews(){
}

private NewsData data;
private NewsData lastnews;
private Vector vdata=new Vector();
private int ID;

public void setData(NewsData data)
{

}

public void setID(int id){
	this.ID = id;
}


public NewsData getLastnews(){

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);

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){
}
	int max=vdata.size();
	return getData(max-1);
}

public void init(){

Database conn = new Database();
vdata.clear();
try{
String sql="select ID,title,source,summary,body,time,author from news where ID="+ID+"";

ResultSet rs = conn.select(sql);
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){
}

}

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

}