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();
    } 
IT Certification Category (English)640x480

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Top Online Courses From ProgrammingKnowledge

Python Course http://bit.ly/2vsuMaS
Java Coursehttp://bit.ly/2GEfQMf
Bash Coursehttp://bit.ly/2DBVF0C
Linux Coursehttp://bit.ly/2IXuil0
C Course http://bit.ly/2GQCiD1
C++ Coursehttp://bit.ly/2V4oEVJ
PHP Coursehttp://bit.ly/2XP71WH
Android Coursehttp://bit.ly/2UHih5H
C# Coursehttp://bit.ly/2Vr7HEl
JavaFx Coursehttp://bit.ly/2XMvZWA
NodeJs Coursehttp://bit.ly/2GPg7gA
Jenkins Course http://bit.ly/2Wd4l4W
Scala Coursehttp://bit.ly/2PysyA4
Bootstrap Coursehttp://bit.ly/2DFQ2yC
MongoDB Coursehttp://bit.ly/2LaCJfP
QT C++ GUI Coursehttp://bit.ly/2vwqHSZ