Question

Problem: Contact Information

Sometimes we need a program that have all the contact information like name, last name, telephone, direction and something we need to know about that person (notes).

Write a program in java language with GUI, classes, arrays, files and inheritance that make this possible.

In the first layer, the user should see all the contacts and three buttons (add, delete, edit).

*Add button: If the user click the button add, a new layer should appear and should allow the user add a new contact (name, last name, phone number, extra information).

*Delete button: Should allow the user delete a contact.

*Edit button: Should allow the user edit whatever contact he want to edit.

*No more than 5 contacts.

Answer 1

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
// Create Referesh Method
public void Referesh() {
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.jdbc.Driver");
// establish connection
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Studentinformation", "root", "");
Statement statement = con.createStatement();
statement.executeUpdate("INSERT INTO student VALUES(" + jTextField1.getText() + ",'" + jTextField2.getText() + "'," + jTextField3.getText() + ")");
JOptionPane.showMessageDialog(null, "Record inserted...");
statement.close();
con.close();
Referesh(); //Calling Referesh() method
} catch (SQLException | ClassNotFoundException e) {
JOptionPane.showMessageDialog(null, e);
}
}

Right-click the "Delete" button. Go to Event -> action -> actionPerformed and add the below code.
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.jdbc.Driver");
// establish connection
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Studentinformation", "root", "");
Statement statement = con.createStatement();
statement.executeUpdate("DELETE FROM student WHERE contactno=" + jTextField1.getText() + "");
JOptionPane.showMessageDialog(null, "Record deleted...");
statement.close();
con.close();
Referesh(); //Calling Referesh() method
} catch (SQLException | ClassNotFoundException e) {
JOptionPane.showMessageDialog(null, e);
}
}