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();

    } 

Browse More Articles

Tweet

Written by Unknown

We are one of the initiators of the development of information technology in understanding the need for a solution that is familiar and close to us.