What is the use of rs.getString(1) in jsp?

[jerald m]

Hi,

i need help in JSP.

String stateId = request.getParameter("State");
 
   String query = "select distinct CITY from STATES where STATE = '"+stateId+"'";
 
    stmt = con.prepareStatement(query);
 
    rs = stmt.executeQuery();
       String City=null;
    while(rs.next())
    { 
         City=""+rs.getString(1)'
}
         out.print(City);
}
rs.close();
 
 

i'm getting only the last data of city in the table.
i want to get all city in the table.
how i want to write the code to get all city.,
i'm new to JSP Please Help me........,
Please Help me...,

[Rabbit]

You need to append to City, right now you're replacing it.

City=City+","+rs.getString(1)

[jerald m]

now i'm getting all the city. Thanks for Reply Rabbit.

another doubt please help me..,

This code is javaScript

//Here i'm getting all the City
 var result = xmlhttp.responseText;
//Split the responseText  
var s = result.split(" ");
 
 var indx = 1;
 for(indx=1; indx < s.length; indx++)
    {
  var boxLength = document.form1.City.length;
  document.form1.City.options[boxLength] = new Option(s[indx]);
}
document.form1.City.selectedIndex=-1;
 

in the above code i'm split the response text k.
getting the result in Id="City" OPTION.

but in the option it is adding data to the previous data.

for example if i selecting KARNATAKA STATE.In the city option what r all the city store in the table under karnataka is coming k. keep this
and try one more time

if i selecting tamilnadu state.In the city option what are all the city store in the table under tamilnadu is coming but before karanataka city are not clearing.
this tamilnadu cities are adding with previous karnataka cities in option.

Please help me..

Form Code:

<select name="City" id="City" >
 
</select>
 

[jerald m]

Rabbit i got the output for past post
corrected lines r coming down and i have last doubt please help me Rabbit
old code

var boxLength = document.form1.City.length;
 document.form1.City.options[boxLength] = new Option(s[indx]);
 

i changed here

//var boxLength = document.form1.City.length;
document.form1.City.options[indx] = new Option(s[indx]);
 

now i need another help please help me..,

Two forms have ProjectCode field
it wants to have auto increment value of database
i did not try yet.this is the last doubt i completed all the thing in the Form please help me..,
please Rabbit.

i need auto increment value of database due to my HR said that once typed number in the "Project code field" not to save in the database. Example:
for the first time i enter 1 in the project code field means that number 1 not valid for another time(not to save one more time with the same project code).,

i believe u understand. please help me..,