makebean.java

jsp+oracle书记的源代码

package net.acai.forum;
import net.acai.forum.*;
import net.acai.database.DBConnect;
import net.acai.util.*;
import java.util.Vector;
import java.sql.ResultSet;
import javax.servlet.http.*;
public class MakeBean
{
	public static String makeID(String tablename,String id)throws ForumNotFoundException{
		String sql = "";
		sql = "select max("+id+") as MAXID from  "+tablename+"";
		String strMaxId = "0";
		int intMaxId = 1;
		try{
			DBConnect dbc=new DBConnect(sql);
			ResultSet rs=dbc.executeQuery();
			if(rs.next()){
				strMaxId = (String)rs.getString("MAXID");
				if(strMaxId.equals("")||strMaxId.equals("null")){
					strMaxId = "0";
				}
				intMaxId = Integer.parseInt(strMaxId);
				intMaxId++;
			}
		}catch(Exception e){
			throw new ForumNotFoundException("字符出错");
		}
		strMaxId = String.valueOf(intMaxId);
		return strMaxId;
	}
}