insertnews.java

一个关于商业的网站

package com.everstar.news;

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

public class InsertNews{

public InsertNews(){

}

private NewsData data;

public void setData(NewsData ndata)
{
	data=new NewsData();
	try{
	data.setTitle(ndata.getTitle());
  	data.setSource(ndata.getSource());
  	data.setBody(ndata.getBody());
  	data.setPhoto(ndata.getPhoto());
  	data.setAuthor(ndata.getAuthor());
  	data.setSummary(ndata.getSummary());
}catch(java.lang.NullPointerException E){
}

}


public int init(){
int id=0;
int temp=1;

Database conn = new Database();
try{
ResultSet rs = conn.select("select ID from news");
while(rs.next()){
	id=rs.getInt("ID");
	temp=id+1;
}
rs.close();
}catch(SQLException E){
}

String sql="insert into news(ID,title,photo,source,body,time,author,summary) values(" + temp + ",'" +
data.getTitle() + "','"+ "ss" + "','" + data.getSource() + "','" + data.getBody() + "','" + "fewfwe" +"','"  +  data.getAuthor() + "','" + data.getSummary() + "')";
int i=conn.insert(sql);
conn.close();
return i;
}

}