Create a Java FX GUI program that allows the user to insert data into a SQL data
ID: 3940132 • Letter: C
Question
Create a Java FX GUI program that allows the user to insert data into a SQL database. The goal of this project is to write a basic Java FX GUI database program. The program should have a list component which on launching the program shows the contents of the database. Also the program should present the user with a form of TextFields for capturing data to insert into a database (use the CPU database you created in previous projects). The form should also have a submit button which will attempt to create a new record in the database. The data should be validated first (numbers, text, blank, etc.). If the data is invalid nothing should be inserted into the database and a warning message should be presented to the user via a Label component. If a record is inserted into the database the List should be updated to include the new record. The report needs to be in the following format: Intel Core i7-6700HQ @ 2.60GHz: $1,509.00 Intel Core i7-3770K @ 3.50GHz: $560.50 Intel Core i5-3570K @ 3.40GHz: $477.23 Intel Core i7-4700MQ @ 2.40GHz: $467.40
SQL database:
create database intelprocessors;
use intelprocessors;
show tables;
create table computers(id int not null auto_increment primary key, cpuname varchar( 32 ) not null, performance varchar( 32 ) not null, price float);
describe computers;
Explanation / Answer
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.SQLException;
public class SelectStatementSample
{
public static void main(String[ ] args) throws Exception
{
Connection connection = null;
try
{
Class.forName("com.mysql.jdbc,Driver");
String url ="jdbc:mysql://localhost/testdb";
String user = "root";
String password =" ";
connection = DriverManager.getConnection(url, user, password);
Statement stmt = connection.createStatement();
String sql = "INSERT INTO users (id, cpuname, performance, price) " + " VALUES ( 1, ' intel ' , 'good ' , ' 10,111 ' )" ;
} catch(ClassNotFoundException e)
{
System.err.println( "Could not load database driver!");
}catch (SQLException e)
{
e.printstackTrace();
} finally
{
if (connection !=null)
{
connection.close();
}
}
}
}