//Note: create a DSN in the name of sql that is pointing the table name limbs in the database with three String column names things,legs,arms
//PreparedStatement update sql
import java.sql.*;
class Jdbc10{
public static void main(String...arg) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:sql");
PreparedStatement pstmt = c.prepareStatement
("update limbs set legs =? where arms =?");
pstmt.setInt(1,5); //legs 8
pstmt.setInt(2,0);
int i = pstmt.executeUpdate();
System.out.println("No of records updated :"+i);
pstmt.close();
c.close();
}
}
No comments:
Post a Comment