±Û¾´ÀÌ :±è±¤¼ö 2000³â 4¿ù 02ÀÏ 02:52:29
DB¿¡¼ ¼ýÀÚ¸¦ ÀÐ¾î °¡Àå Å«°ª¿¡´Ù 1À» ´õÇؼ ¹ÝȯÇϴ°ǵ¥¿ä.
¹ÝȯµÇ´Â °ªÀÌ Ç×»ó 0À̳׿ä. ¹®Á¦´Â ¾ø¾î º¸À̴µ¥¿ä.
¾î¶»°Ô ¼öÁ¤À» ÇؾßÇÏ´ÂÁö µµ¿òÀ» Áֽʽÿä. ±ÞÇÕ´Ï´Ù.
public int getLastNumber()
throws ServletException, IOException
{
int max_number=0;
try {
String query = "SELECT MAX(NUM1) FROM BBSTable";
Statement stmt = con.createStatement();
ResultSet maxrs = stmt.executeQuery( query );
while (maxrs.next()){ // <-- Important !!
max_number = maxrs.getInt("NUM1") + 1;
}
maxrs.close();
stmt.close();
}catch(Exception e) {}
return max_number;
±×¸®°í maxrs.next()°¡ ¹¹ÇÏ´Â °ÇÁö Á» ´õºÒ¾î °¥ÄÑÁÖ½Ã¸é °í¸¿°Ú½À´Ï´Ù.
²À Á» ºÎŹµå·Á¿ä.