(1)Oracle中
public String getMaxIdInfo(String table, String columname) {
String sql = "select max(to_number("+columname+")) from "+table;
String num = "";
con = dbc.getConnection();
try {
pst = con.prepareStatement(sql);
//pst.setString(1, columname);
//pst.setString(2, table);
rs = pst.executeQuery();
if (rs.next()) {
num = (rs.getInt(1)+1)+"";
}
} catch (Exception e) {
Menulogger.debug("获取最大ID信息失败!"+e);
e.printStackTrace();
// TODO: handle exception
}finally{
dbc.closeQuery(rs, pst, con);
}
return num;
}
(2)MySql中
public String getMaxIdInfo(String table, String columname) {
String sql = "select max("+columname+"+0) from "+table;
String num = "";
con = dbc.getConnection();
try {
pst = con.prepareStatement(sql);
//pst.setString(1, columname);
//pst.setString(2, table);
rs = pst.executeQuery();
if (rs.next()) {
num = (rs.getInt(1)+1)+"";
}
} catch (Exception e) {
Menulogger.debug("获取最大ID信息失败!"+e);
e.printStackTrace();
// TODO: handle exception
}finally{
dbc.closeQuery(rs, pst, con);
}
return num;
}