Share this page 

Tag(s): JDBC


Note:the MyConnection class was used to connect to the DB

PreparedStatement prepstmt;
try {     
  prepstmt = theConn.prepareStatement
   ("UPDATE tCust SET custName = ? "+
    " WHERE custId = ?");
  prepstmt.setString(1,"Smith");       
  prepstmt.setString(2, cust_id.getText());
  prepstmt.executeUpdate();
             
  theConn.commit();
  prepstmt.close();
  }
catch (Exception e) {
  e.printStackTrace();
}