String sql="select xmdh from xtdm where fldh='"+fldh+"' order by xmdh desc";
rs=conn.executeQuery(sql);
if (!rs.next()){
xmdh="1";
}
else{
xmdh=String.valueOf(rs.getInt("xmdh")+1);
}
我是想弄一个当rs的记录集为空时,xmdh为1,不为空时,xmdh为库中最大的值加1.
String sql="select xmdh from xtdm where fldh='"+fldh+"' order by xmdh desc";
rs=conn.executeQuery(sql);
if (!rs.next()){
xmdh="1";
}
else{
xmdh=String.valueOf(rs.getInt("xmdh")+1);
}