Insert value in database using PreparedStatement in JDBC

 

  1: /*
  2:  * student.java
  3:  *
  4:  * Created on Dec 14, 2011, 7:06:14 PM
  5:  */
  6: 
  7: package pck;
  8: import java.sql.*;
  9: import javax.swing.JOptionPane;
 10: /*
 11:  *
 12:  * @author dell_pc
 13:  */
 14: public class student extends javax.swing.JFrame {
 15: 
 16:     Connection con;
 17: 
 18:     ResultSet rs;
 19:     /** Creates new form student */
 20:     public student() {
 21:         initComponents();
 22:     }
 23:                       
 24: 
 25:     private void btninsetActionPerformed(java.awt.event.ActionEvent evt) {                                         
 26:         try {
 27:             String name;
 28:             String add;
 29:             int rollno;
 30:             name = txtname.getText();
 31:             rollno = Integer.parseInt(txtroll.getText());
 32:             add = txtadd.getText();
 33:             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 34:             con = DriverManager.getConnection("Jdbc:Odbc:javadsn", "sa", "niitbpld95");
 35: 
 36:             String str="insert into std values(?,?,?)";
 37:             PreparedStatement ps=con.prepareStatement(str);
 38:              ps.setString(1,name );
 39:              ps.setInt(2,rollno );
 40:              ps.setString(3, add);
 41: 
 42:              int count=ps.executeUpdate();
 43:              if(count>0)
 44:              {
 45:                  JOptionPane.showMessageDialog(rootPane, "Insert successfully");
 46:              }
 47:              else
 48:              {
 49:                  JOptionPane.showMessageDialog(rootPane, "Insert Fail");
 50:              }
 51:              
 52:         } catch (ClassNotFoundException ex) {
 53:             System.out.println(ex.toString());
 54:         }catch (SQLException ex) {
 55:             System.out.println(ex.toString());
 56:         }
 57:     }                                        
        

Technorati Tags: PreparedStatement in JDBC,Netbeans,JDBC