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

2 comments:

  1. Hey ;) i need your help for this method because im getting Error all the time and cannot find the problem for it...

    try{



    String eintrag1= txt_Personalnr.getText();
    String eintrag2= txt_Name.getText();
    String eintrag3= txt_Nachname.getText();
    String eintrag4= txt_Alter.getText();

    String sql = "update Mitarbeiterinfo set Personalnr='"+eintrag1+"',Name='"+eintrag2+"',Nachname='"+eintrag3+"',Alter='"+eintrag4+"' where Personalnr='"+eintrag1+"'";


    pst=conn.prepareStatement(sql);
    pst.execute();

    JOptionPane.showMessageDialog(null, "Mitarbeiter wurde aktualisiert!");


    }catch(Exception e){

    JOptionPane.showMessageDialog(null, e);

    }//ende try-catch

    Update_table();

    }

    it always says near Alter syntax error ..

    i hope u can help to find the problem

    ReplyDelete
  2. found the problem !! the value Alter cannot be set in SQL .. so i changed it to Mitarbeiter_Alter and all problems gone..

    ReplyDelete