jsp "Valu incrementing Syntax""

[nHulk]

try
		{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			String url="jdbc:mysql://localhost/student";
			Connection con = DriverManager.getConnection(url,"root","");
			java.sql.Statement stmt = con.createStatement();
			ResultSet rs=stmt.executeQuery("Select max(cid) from citizen_info");
			while(rs.next()){
			
			int temp1=rs.getInt("max(cid)");
			break;
			}
			
			   temp1++;
			  stmt.executeUpdate("insert into citizen_info values("+temp1+",'"+uname+"','"+pass+"','"+addr+"',"+age+",'"+date1+"','"+gender+"','"+qualif+"','"+mob+"','"+email+"','"+proof+"')");
			  stmt.executeUpdate("insert into login values("+appln+",'"+uname+"','"+pass+"','"+email+"')");
			  out.println("You are successfully registered ");
			
			
			con.close();
		}
		catch(Exception e)
		{
		out.println("Error "+e);
		}
		
  
		}
		%>

problem is its giving error at temp1 ... it not getting incremented ...help me out

[go4soumya]

hi nHulk,

Try this...

int temp1=rs.getInt(1); // here 1 is the column index

Good luck.

[nHulk]

hi nHulk,

Try this...

int temp1=rs.getInt(1); // here 1 is the column index

Good luck.

its not working !!!! giving error as temp1 cannot be resolved

[nHulk]

I got solution to myself !!! i had not initialized temp variable to zero