PREPARED INSERT STATEMENTS

1 package jdbcapplication;  2 import java.sql.*;  3 public class InsertDemo   4 {  5     Connection cnt;  6     PreparedStatement pstm;  7     String driver,url;  8     String qry="insert into emp(eid,ename,esal,ejob) values(?,?,?,?)";  9     InsertDemo()  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.setInt(1,104); 18     pstm.setString(2,"Ros"); 19     pstm.setInt(3,10300); 20     pstm.setString(4,"Trainer"); 21     pstm.execute(); 22     System.out.println("Sucessfull"); 23     cnt.close(); 24     } 25         catch (SQLException ex) { 26             System.out.println("Error : "+ex.getMessage()); 27         } 28     } 29 public static void main(String args[]) 30 { InsertDemo demo=new InsertDemo();  31 } 32 }