DB Application Java Project

The main objective of developing this DB Application Java Project is to create powerful database application using java programming language.

Find the below steps to create DB Application Java Project effeciently without any bugs.

How to set up the “DBApplication“project:

1. At first must be creating a database in mysql.
2. Put or set your database name in DataBaseInformation java class in com.dbmanagement.bean package.

How to run the “DBApplication“ project:

1. To open the main window you must be put the mysql database userid and password. After entering the login credentials press ‘Enter’ or click on ‘Login’ button. If userid or password is wrong then it displays alert message.
2. It shows the main window with four buttons ‘Create Table’, ‘View Table’, ‘Update Table, ‘Run Query’. All section is described below. 

1. Create Table:

1. Displays the one row where you should enter the field name, type, length etc after entering all information please press ‘Tab’ key on the ‘Primary Key’ column for add a new field of the table.

After all data enter put the table name and press ‘Save’ to create a new table in the database.

1. Click on ‘Cancel’ button returns to the main window.

2. View Table:

1. Select any table from selection box and click on ‘View Button’ displays the all records of the selected table.
2. Click on ‘Exit’ button returns to the main window.

3. Update Table:

It displays two tabs, one design to displays the design structure of particular table and another is data to displays the data of particular table.

1. Design: select any table from selection box and click on ‘View’ Button displays the design structure of the selected table.

1.  To alter the selected table name enter the new table name in the text field and click on ‘Rename Table’ button.
2. Click on ‘Add’ button to add the new column of the selected table.
3. Modify any table field and click on ‘Edit’ to alter that field. Select any row and then modify that column and click on ‘Edit’ button to modify the column name.
4. Select any field and click on ‘Delete’ button to delete the existing field.
5. Click on ‘Cancel’ button to return to previous state.
6. Click on ‘Exit’ button returns to the main window.
7. Click on ‘Add’ button to add the new record of the selected table.
8. Modify any table record and click on ‘Edit’ to alter that record.

2. Data: select any table from selection box and click on ‘View’ Button displays the all records of the selected table

You can not change or modify primary key field data.

1. Select any record and click on ‘Delete’ button to delete the existing record.
2. Click on ‘Cancel’ button to return to previous state.
3. Click on ‘Exit’ button returns to the main window.

4. Run Query:

1. Please type the query in query text field and click on ‘Run Query’ then it displays the result below in table format on the basis of query. If you does not enter any query and press on ‘Run Query’ button then it displays the alert box.
2. Click on ‘Exit’ button returns to the main window.