This tutorial entitled Update Data using MySQL Database and Java with Netbeans IDE will teach you on how to update a data stored in MySQL Database using Java and Netbens IDE.
Before we start, be sure that you already follow and learned my last tutorial on how to Load Data into another form.
Update Data using MySQL Database and Java with Netbeans IDE Steps
- In my last tutorial entitled Display Data from Selected Table Row to another Form in Java. We already created a new JFrame Form for our update function. The form should look like the image below.
2. Double click the button “UPDATE” and insert the following codes below.
[java]try{
String fname = jLabel1.getText();
String lname = jLabel2.getText();
String address = jLabel3.getText();
String contact = jLabel4.getText();
String email = jLabel5.getText();
String str=”UPDATE userinfo SET ”
+ “FirstName='” + fname + “‘,LastName='” + lname + “‘,Address='” + address + “‘,Contact='” + contact + “‘,Email='” + email + “‘”
+ “WHERE idUserInfo='” + idn + “‘”;
pst=conn.prepareStatement(str);
pst.execute();
JOptionPane.showMessageDialog(null,”Data Successfully Updated!”);
clear_fields();
}catch (HeadlessException | SQLException e){
JOptionPane.showMessageDialog(this, e.getMessage());
}[/java]
3. Run your program and the output should look like the image below. When I click the update button, a dialog box appear saying “Data Successfully Updated!”. It means that the update function is successfully executed.
About The Update Data using MySQL Database
| Project Name: | Update Data using MySQL Database |
| Language/s Used: | JAVA |
| Database: | MySQL |
| Type: | Desktop Application |
| Developer: | IT SOURCECODE |
| Updates: | 0 |
Related Articles You May Like: