Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rs.updateInt() not working. . please help

 
vikhyath reddy
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everybody... i have a program code which needs to update the fields provided by the user . i am doing something like this.. i have a mysql table which has 27 rows and 20 columns in each row.


<%
String url="jdbc:mysql://localhost:3306/vikh?user=root&password=admin";

con=DriverManager.getConnection(url);
stmt=con.createStatement();
rst=stmt.executeQuery("select * from it_21;");
while(rst.next())
{

out.print("inside while"); //this is getting displayed

rst.updateInt(3,123445); // the program flow is stopping at this point.

rst.updateRow();

out.print("In while"); // this is not getting displayed

}

---- rest of the code ------

%> Thanks in advnace
 
Masoud Kalali
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to create an update-able ResultSet, something similar to



The ResultSet object will be forward only meaning that you can not go backward in the ResultSet by calling previous() method.
 
vikhyath reddy
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot Masoud ... Im a newbie so learning things ... thanks once again ! : )
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic