JAVA GUI FOR A MYSQL DATABASE. Selecting 3 tables from your database to implement the gui for. The tables must meet the following criteria. 1. At least one table must have one or more foreign key relationships 2. A second table must be part of the relationship of the first 3. The last table can be any table you want GUI Implementation For each database table, a JFrame must be created with all the necessary input for each table attribute on the screen, except the primary keys, which should be non-editable on the UI.
Each screen will provide the ability to insert, delete, or update the selected database row from the database
HERE IS MY DATABASE ITS ABOUT A BOOKSTORE create table address(street_address varchar(),area_number int(),city varchar(),state varchar(),pincode int());
create table BOOK(book_name varchar(),book_description varchar(100),book_genre varchar());
create table Transaction(transaction_id int(),book_name varchar(),customer_address varchar());
create table Publisher(name int(),location varchar(),street_address varchar(),area_number int(),city() varchar(),state varchar(),publisher_id());
create table customer_name(first_name varchar(),middle_name varchar(),last_line varchar());
create table customer_address(stree_address varchar(),area_number int(),city varchar(),state varchar(),zip_code int());
create table genre(genre_name varchar(),genre_id int());
insert into table_name(table fields)
E.g;
insert into author(T,Rama,Rao);
Syntax to create triggers
create trigger [trigger_name]
[before | after]
{insert | update | delete}
on [table_name]
[for each row]
[trigger_body]
CREATE FUNCTION [schema_name.]function_name
( [ @parameter [ AS ] [type_schema_name.] datatype
[ = default ] [ READONLY ]
, @parameter [ AS ] [type_schema_name.] datatype
[ = default ] [ READONLY ] ]
)
RETURNS return_datatype
[ WITH { ENCRYPTION
| SCHEMABINDING
| RETURNS NULL ON NULL INPUT
| CALLED ON NULL INPUT
| EXECUTE AS Clause ]
[ AS ]
BEGIN
[declaration_section]
executable_section
RETURN return_value
END;
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
Stored Procedure Syntax
CREATE PROCEDURE procedure_name
AS
sql_statement
GO;
Execute a Stored Procedure
EXEC procedure_name;
I have been trying but i am blank on this?