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.sqlConnection;
import java.sqlDriverManager;
import java.sqlSQLException;
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:dblab;
String username "yourusername";
String password "yourpassword";
connection DriverManager.getConnectionurl username, password;
catch SQLException e
eprintStackTrace;
return connection;
Models package
package models;
import factories.DBConnectorFactory;
import java.sqlConnection;
import java.sqlPreparedStatement;
import java.sqlResultSet;
import java.sqlSQLException;
import java.util.Scanner;
public class Student
private Connection connection;
public Student
connection DBConnectorFactory.getDatabaseConnection;
public void createString id String name
try
String sql "INSERT INTO students id name VALUES ;
PreparedStatement statement connection.prepareStatementsql;
statement.setString id;
statement.setString name;
statement.executeUpdate;
System.out.printlnStudent created successfully.";
catch SQLException e
eprintStackTrace;
public void readAll
try
String sql "SELECT FROM students";
PreparedStatement statement connection.prepareStatementsql;
ResultSet resultSet statement.executeQuery;
while resultSetnext
System.out.printlnID: resultSet.getStringid Name: resultSet.getStringname;
catch SQLException e
eprintStackTrace;
public void updateString id String name
try
String sql "UPDATE students SET name WHERE id ;
PreparedStatement statement connection.prepareStatementsql;
statement.setString name;
statement.setString id;
statement.executeUpdate;
System.out.printlnStudent updated successfully.";
catch SQLException e
eprintStackTrace;
public void deleteString id
try
String sql "DELETE FROM students WHERE id ;
PreparedStatement statement connection.prepareStatementsql;
statement.setString id;
statement.executeUpdate;
System.out.printlnStudent deleted successfully.";
catch SQLException e
eprintStackTrace;
Main package
package main;
import models.Student;
import java.util.Scanner;
public class Driver
public static void mainString args
Student student new Student;
Scanner scanner new ScannerSystemin;
Example usage: create, readAll, update, readAll, delete, readAll
System.out.printlnEnter student ID:;
String id scanner.nextLine;
System.out.printlnEnter student name:";
String name scanner.nextLine;
student.createid name;
student.readAll;
System.out.printlnEnter updated name:";
String updatedName scanner.nextLine;
student.updateid updatedName;
student.readAll;
System.out.printlnEnter student ID to delete:";
String deleteId scanner.nextLine;
student.deletedeleteId;
student.readAll;
scanner.close;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
