Friday, October 26, 2012

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

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com


Stuff I use to make videos

Windows notebook - http://amzn.to/2ADOPrW

Apple MacBook Pro - http://amzn.to/2AC0WG2

Microphone - http://amzn.to/2AC1kV0

notebook mouse - http://amzn.to/2BmeZ2d