Database Management System and Java Database Connectivity

• implemented using Java, JavaFX.
• SQL Database Management System and Java Database Connectivity.
• Check The Application Here Link.

Features

• Java Database Connectivity API implementation.
• Graphical User Interface.
• Command Line Interface.
• Timeout For Queries.
• Batching Queries.
• Full Logger Of User Actions.

Supported SQL statements

CREATE

• CREATE DATABASE dbname.
• CREATE TABLE table_name (column_name1 data_type, column_name2 data_type).

DROP

• DROP TABLE table_name.
• DROP DATABASE database_name.

INSERT

• INSERT INTO table_name (ID,Name) VALUES (1,'youssef').
• INSERT INTO table_name VALUES (1,'youssef', ...).

SELECT

• SELECT col1, col2, col3 FROM table_name WHERE col1 < 8.
• SELECT * FROM table_name WHERE col1 = 5 or not col2 in ('yahia', 'omar') and col3 != 7.
• SELECT * FROM table_name where col1 <= col2.
• SELECT * FROM table_name where col1 between 5 and 7.
• SELECT * FROM table_name order by col1 ASC, col2, col3 DESC.

DELETE

• DELETE FROM table_name WHERE some_column=some_value.
• DELETE FROM table_name.
• DELETE * FROM table_name.

UPDATE

• UPDATE table_name SET column1= 'value1',column2='value2' WHERE column3 ='value'.
• UPDATE tableName SET column1 ='someValue', column2 ='someValue'.

Supported Data Types

int, varchar

Contribution Guidelines

This project is public, Feel free to create pull requests.

Screenshots

Graphical User Interface

Error Messages When Applying Wrong Queries

Command Line Interface