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();
}
Hey ;) i need your help for this method because im getting Error all the time and cannot find the problem for it...
ReplyDeletetry{
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
found the problem !! the value Alter cannot be set in SQL .. so i changed it to Mitarbeiter_Alter and all problems gone..
ReplyDelete