Question: implement a GUI in this code / / Factories package package factories; import java.sql . Connection; import java.sql . DriverManager; import java.sql . SQLException; public

implement a GUI in this code
// Factories package
package factories;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnectorFactory {
private static Connection connection = null;
public static Connection getDatabaseConnection(){
try {
if (connection == null || connection.isClosed()){
// Establish connection to the database
String url ="jdbc:mysql://localhost:3306/dblab";
String username = "your_username";
String password = "your_password";
connection = DriverManager.getConnection(url, username, password);
}
} catch (SQLException e){
e.printStackTrace();
}
return connection;
}
}
// Models package
package models;
import factories.DBConnectorFactory;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
public class Student {
private Connection connection;
public Student(){
connection = DBConnectorFactory.getDatabaseConnection();
}
public void create(String id, String name){
try {
String sql = "INSERT INTO students (id, name) VALUES (?,?)";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, id);
statement.setString(2, name);
statement.executeUpdate();
System.out.println("Student created successfully.");
} catch (SQLException e){
e.printStackTrace();
}
}
public void readAll(){
try {
String sql = "SELECT * FROM students";
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()){
System.out.println("ID: "+ resultSet.getString("id")+", Name: "+ resultSet.getString("name"));
}
} catch (SQLException e){
e.printStackTrace();
}
}
public void update(String id, String name){
try {
String sql = "UPDATE students SET name =? WHERE id =?";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, name);
statement.setString(2, id);
statement.executeUpdate();
System.out.println("Student updated successfully.");
} catch (SQLException e){
e.printStackTrace();
}
}
public void delete(String id){
try {
String sql = "DELETE FROM students WHERE id =?";
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, id);
statement.executeUpdate();
System.out.println("Student deleted successfully.");
} catch (SQLException e){
e.printStackTrace();
}
}
}
// Main package
package main;
import models.Student;
import java.util.Scanner;
public class Driver {
public static void main(String[] args){
Student student = new Student();
Scanner scanner = new Scanner(System.in);
// Example usage: create, readAll, update, readAll, delete, readAll
System.out.println("Enter student ID:");
String id = scanner.nextLine();
System.out.println("Enter student name:");
String name = scanner.nextLine();
student.create(id, name);
student.readAll();
System.out.println("Enter updated name:");
String updatedName = scanner.nextLine();
student.update(id, updatedName);
student.readAll();
System.out.println("Enter student ID to delete:");
String deleteId = scanner.nextLine();
student.delete(deleteId);
student.readAll();
scanner.close();
}
}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!