makebean.java

来自「jsp+oracle书记的源代码」· Java 代码 · 共 32 行

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