Friday, October 26, 2012

Code used in video "Java prog#14.How to Insert/Save data from netbeans java into database Sqlite (MySql)"



Here I am providing the downloadable code link of  the java code I have used in the video
 "Java prog#14.How to Insert/Save data from netbeans java into database Sqlite (MySql)"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the Cmd_saveActionPerformed  method action perform



 private void Cmd_saveActionPerformed(java.awt.event.ActionEvent evt) {                                         
       // File image=null;
       // image=new File(filename);
     //   System.out.println("fhjjjfxjdjdjhdhjdhjdjdj"+image);
       
        try{
           
         String sql ="Insert into Empoyeeinfo (Empoyeeid,name,surname,age,image,gander) values (?,?,?,?,?,?)";
            
         pst=conn.prepareStatement(sql);
         pst.setString(1, txt_Empoyeeid.getText());
         pst.setString(2, txt_name.getText());
         pst.setString(3, txt_surname.getText());
       
         String value=combo_age.getSelectedItem().toString();
         pst.setString(4,value);
         pst.setBytes(5,person_image);
         pst.setString(6,gander );
         
         
         
         //  fis = new FileInputStream(image);
       //   pst.setString(1, jTextField4.getText());
       // pst.setBinaryStream(5, (InputStream)fis, (int)(image.length()));
                //  pst.setBytes(5, person_image);
         pst.execute();
         
          JOptionPane.showMessageDialog(null, "Saved");
            }        
    
           catch(Exception e)
    {
           JOptionPane.showMessageDialog(null, e);

    }
        Update_table();
    } 

5 comments:

  1. hi, i am trying to this, but dnt know y PST = con is being underlined red. can u help me. thnx

    ReplyDelete
  2. My sql table does not show new values when entered in software

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete