I have a problem with autoincremented column with jsp select tag

[satyaram]

System.out.println("in jsp tag");
DataCon dc=new DataCon();
System.out.println(dc);
Connection con=null;
Statement st=null;
ResultSet rs=null;
try{
con=dc.getConnection1();
System.out.println(con);
st=con.createStatement();
System.out.println(st);
rs=st.executeQuery("select max(CUST_NO) from CUSTOMER_MASTER");
System.out.println(rs);
while(rs.next())
{
id=rs.getInt(1);
//System.out.println(id);
id=id+1;
}
System.out.println("id"+id);
%>
<option value="<%=id%>"><%=id%></option>
<%
con.close();
}
catch(Exception e)

above code is respect to the select tag in registration form

select tag is respected auto incremented column,auto incremented value is not adding to the combo box.......please help me...........

[satyaram]

solve my prob please

[serjant]

You got an exception there, that is why it is not incremented.Add try and catch statements when you extract data from database, then when finished close the database connection.