PREPARED UPDATE STATEMENTS

1 package jdbcapplication;  2 import java.sql.*;  3 public class Updateinfo   4 {  5     Connection cnt;  6     PreparedStatement pstm;  7     String driver,url;  8     String qry="update emp set ename='Sumit',        esal=21000,ejob='Manager' where eid=103";  9     Updateinfo()  10     { 11     driver="com.mysql.jdbc.Driver"; 12     url="jdbc:mysql://localhost/bhupesh"; 13     try 14     { 15     cnt=DriverManager.getConnection      (url,"root","ashok"); 16     pstm=cnt.prepareStatement(qry); 17     pstm.executeUpdate(); 18     System.out.println("Updation Sucessfull Done"); 19     cnt.close(); 20     } 21      catch (SQLException ex) { 22      System.out.println("Error : "+ex.getMessage()); 23         } 24     } 25 public static void main(String args[]) 26 { Updateinfo demo=new Updateinfo();  27 } 28 }