Code used in video "Java prog#17.How to update/Edit a data in SQLite (MySql) Database in Netbeans java"

Here I am providing the downloadable code link of  the java code I have used in the video

 "Java prog#17.How to update/Edit a data in SQLite (MySql) Database in Netbeans java"  of my YouTube channel ProgrammingKnowledge

Click Link to watch the video LINK

This code below is for the txt_updateActionPerformed  method action perform

    private void txt_updateActionPerformed(java.awt.event.ActionEvent evt) {                                           

        try{

        

            String value1= txt_Empoyeeid.getText();

             String value2= txt_name.getText();

              String value3= txt_surname.getText();

              // String value4= txt_age.getText();

               

         String value4=combo_age.getSelectedItem().toString();

       

               

               String sql="update Empoyeeinfo set empoyeeid='"+value1+"' ,name ='"+value2+"',surname ='"+value3+"',age='"+value4+"' where empoyeeid='"+value1+"' ";

              pst=conn.prepareStatement(sql);

              pst.execute();

              JOptionPane.showMessageDialog(null, "Updated");

        

        }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.