Update Data using MySQL Database and Java with Netbeans IDE

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

  1. In my last tutorial entitled Display Data from Selected Table Row to another Form in JavaWe 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.

"<yoastmark

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
Update Data using MySQL Database In Java– Project Information

Related Articles You May Like:

Leave a Comment