This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc update help  RSS feed

Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys
i am trying to update some value in the database which i haved inserted before. it's not givifng any error but it's not updating in the database. pls help
here the codeimport java.sql.*;
public class JdbcTest {

public void doTest(){
Connection con = DriverManager.getConnection("jdbc dbc:rajesh","sa","") ;
Statement stmt = con.createStatement();
//System.out.println("Table Created?"+stmt.executeUpdate("create table mytable (sno integer, name
//varchar(20) )"));
//System.out.println("Inserted?"+stmt.executeUpdate("insert into mytable values (3, 'shane')"));
//System.out.println("Inserted?"+stmt.executeUpdate ("insert into mytable values (4, 'warne')"));
PreparedStatement pre=con.prepareStatement("update mytable set name=? WHERE name LIKE ?");
int n=pre.executeUpdate();
ResultSet rs = stmt.executeQuery("select * from mytable");
while ( ){
System.out.println("SNO ==>"+rs.getInt("sno")+"\n");
System.out.println("NAME ==>"+rs.getString("name")+"\n");
}catch (Exception e){
System.out.println("Error Creating Record");
public static void main( String[] args ) {
JdbcTest test = new JdbcTest();

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!