PREPARED DELETE STATEMENTS

1 package jdbcapplication;  2 import java.sql.*;  3 public class Deleteinfo   4 {  5     Connection cnt;  6     PreparedStatement pstm;  7     String driver,url;  8     String qry="delete from emp where eid=101";  9     Deleteinfo()  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.execute(); 18     System.out.println("Deletion Done"); 19     pstm.close(); 20     cnt.close(); 21     } 22    catch (SQLException ex) { 23     System.out.println("Error : "+ex.getMessage()); 24      } 25    } 26 public static void main(String args[]) 27 { 28     Deleteinfo demo=new Deleteinfo();  29 } 30 }