Question Details: Problem Statement: Develop a simple GUI based databasedriven a

Question

Question Details:
Problem Statement:
Develop a simple GUI based databasedriven application for a Bank system.
Requirements:-
   * Building asimple GUI bases application for a Bank system    * Creating a MSAccess database    * Connecting to database    * Querying thedatabase using SQL statement    * Displayingresult of query from database to GUI
Detailed Description:-
   * Use MS Accessto create a database named “Bank” and add a table to itnamed “Account”.    * The Accounttable of Bank database must have following fields.    1.Account Number    2.Account Holder Name    3.Account Type    4.Account Balance
   * Enter at least15 records in the Account table.    * Create a SystemDSN named “bankDSN”. Use this DSN to connect todatabase.    * Write a programwhich will connect to this database and query all the records fromthe “Account” table using SQL statement and displaythem on GUI application.    * You can useGrid Layout to display the records from database to GUIapplication.    * You must useResultSetMetaData to display exact name of columns of databasetable on the top of GUI application. Marks will be deducted in caseof not using ResultSetMetaData.    * You should useJlabel in every cell of the grid layout to display a field fromdatabase table
Question Details:
Problem Statement:
Develop a simple GUI based databasedriven application for a Bank system.
Requirements:-
   * Building asimple GUI bases application for a Bank system    * Creating a MSAccess database    * Connecting to database    * Querying thedatabase using SQL statement    * Displayingresult of query from database to GUI
Detailed Description:-
   * Use MS Accessto create a database named “Bank” and add a table to itnamed “Account”.    * The Accounttable of Bank database must have following fields.    1.Account Number    2.Account Holder Name    3.Account Type    4.Account Balance
   * Enter at least15 records in the Account table.    * Create a SystemDSN named “bankDSN”. Use this DSN to connect todatabase.    * Write a programwhich will connect to this database and query all the records fromthe “Account” table using SQL statement and displaythem on GUI application.    * You can useGrid Layout to display the records from database to GUIapplication.    * You must useResultSetMetaData to display exact name of columns of databasetable on the top of GUI application. Marks will be deducted in caseof not using ResultSetMetaData.    * You should useJlabel in every cell of the grid layout to display a field fromdatabase table

Explanation / Answer

Question Details: Problem Statement: Develop a simple GUI based databasedriven a

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.