rs=con.maxQuery("select max(sheetid) maxi from tguid_sheet" );try { if (Rs.next()) { id = rs.getInt("MAXI"); System.err.print("the Max id is:"+rs.getInt("MAXI")+"\n"); } catch (SQLException ex) { }
rs=con.maxQuery("select max(sheetid) maxi from tguid_sheet" );try { if (rs.next()) { id = rs.getInt("maxi"); System.err.print("the Max id is:"+rs.getInt("maxi")+"\n"); } } catch (SQLException ex) { }
select top 1 maxi from tguid_sheet order by sheetid desc
rs=con.maxQuery("select max(sheetid) maxi from tguid_sheet" );try { if (rs.next()) { id = rs.getInt("maxi"); 或者 id = rs.getInt(1); System.err.print("the Max id is:"+rs.getInt("maxi")+"\n"); } } catch (SQLException ex) { }
"select max(voucher_number) as voucher_number from expence_payment";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String maxNumber = "0";
if (rs.next()) {
maxNumber = rs.getString("voucher_number");
if (maxNumber == null || maxNumber == "") {
maxNumber = "0";
}
try {
long lngMaxNumber = Long.parseLong(maxNumber);
maxNumber = Long.toString(lngMaxNumber + 1);
maxNumber = com.valueobject.app.StringFunction.
updateZero(maxNumber, 10); // form.setVoucherNumber(maxNumber);
}
catch (Exception ex) {}
}
这是我得出最大凭证号的办法,最后得出的maxNumber为数据库中的最大值+1,并为10位
if (Rs.next())
{
id=........................
}
if (Rs.next())
{ id = rs.getInt("MAXI");
System.err.print("the Max id is:"+rs.getInt("MAXI")+"\n");
}
catch (SQLException ex) {
}
if (rs.next())
{
id = rs.getInt("maxi");
System.err.print("the Max id is:"+rs.getInt("maxi")+"\n");
}
}
catch (SQLException ex) {
}
所以要用rs.next()
if (rs.next())
{
id = rs.getInt("maxi");
或者
id = rs.getInt(1);
System.err.print("the Max id is:"+rs.getInt("maxi")+"\n");
}
}
catch (SQLException ex) {
}
{
rs.beforeFirst();
while(rs.next())
{
int a=rs.getInt("MAXI");
}
}
取一条记录
<%
ResultSet rs;
rs=con.executeQuery("select max(sheetid) maxi from tguid_sheet");
if(rs.next())
{
rs.first();
out.println(rs.getInt("MAXI"));
}
else
{
out.println("no record");
}
%>