testdb.java

一个关于商业的网站

package com.everstar.news;

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

public class testdb {

  public testdb() {

  }

static 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 + ",'" +
"ss" + "','"+"ss" + "','" + "ss" + "','" + "ss" + "','"+ "sysdate" + "ss" + "','" + "ss" +"','" + "ss" + "')";
int i=conn.insert(sql);
//insert into news(ID,title,photo,source,body,time,author,summary) values(5,'ss','ss','ss','ss','ss','ss','ss')
conn.close();
return i;
}
public static void main( String[] args)
{
 init();

}

}