wood burning stoves 2.0*
The moose likes JDBC and the fly likes jdbc update help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc update help" Watch "jdbc update help" New topic
Author

jdbc update help

paddy_1974
Greenhorn

Joined: Jan 06, 2001
Posts: 6
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(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
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 ?");
pre.setString(1,"warney");
pre.setString(2,"Charasala");
int n=pre.executeUpdate();
ResultSet rs = stmt.executeQuery("select * from mytable");
while ( rs.next() ){
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");
e.printStackTrace();
}
}
public static void main( String[] args ) {
JdbcTest test = new JdbcTest();
test.doTest();
}
}

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc update help
 
Similar Threads
how to run code in netbeans
jdbc in Unix
Help with my homework please
5 INSERT but only 4 in my access table
jdbc connect Access