Create a simple java program that connects to database

Reference no: EM131556703

Assignment: Java Database Program

Part 1

1. Create a file with your name as the data (Use the name Precious Benz). Save the file using your first initial and last name as part of the file name. Include code to copy the file. Check if the file exists first and throw a message if the file already exists. Include code to read the file using a data stream. Display the file's data on screen.

2. Using JFileChooser, build a dialog box to open and save files. The dialog box should allow you to browse directories and type in a file name. You need to consider what you will do with the file once you open it and code accordingly.

Part 2

Database Access

The objective of this assignment is to allow you to work with JDBC via an ODBC-connected Access database.

Your first task for this assignment is to locate and set up the "exampleMDB.mdb" file in the supplemental chapters section of the CD-rom that came with your Liang text. Copy this file to your hard drive. Next, create an ODBC connection to this database called "assignment8".

Next, create a simple Java program that connects to this database using JDBC. Your program should then query this database's "student" table and display a list of all the students' names in alphabetic order (based upon last name).

If you implement your program correctly, this is the output you should see:

Rick R. Carter

Frank E. Jones

Joy P. Kennedy

Toni R. Peterson

Josh R. Smith

Jean K. Smith

George K. Smith

Jacob R. Smith

John K. Stevenson

Patrick R. Stoneman

Josh R. Woo

Please do not waste my time if you do not know Java

Access database cannot be uploaded as file type is not allowed. Will email it separately.

Reference no: EM131556703

Questions Cloud

Importance of information technology and systems : Explain the importance of information technology and systems in businesses today. Include at least one (1) real-world industry example.

What is the required rate of return for rich company shares : FINA 202 Business Finance Exam. The Rich Company has a dividend growth rate of 14 percent, What is the required rate of return for Rich Company shares

Creating a training and development program : Imagine that you have been tasked with creating a training and development program for midlevel business managers in an organization.

How much less can they expect to pay over the life of loan : FINANCING A HOME The Sandersons are planning to refinance their home. The outstanding principal on their original loan is $100,000 and was to be amortized.

Create a simple java program that connects to database : create a simple Java program that connects to this database using JDBC. Your program should then query this database's "student" table.

How much larry should deposit each month : INVESTMENT ANALYSIS Since he was 22 years old, Ben has been depositing $200 at the end of each month into a taxfree retirement account earning interest.

Natural rate of unemployment : Potential GDP is $25 trillion; expectations are adaptive; the natural rate of unemployment is 5.5%; the 2010 inflation rate was 3.5%. The phillips curve is:

Warehouse management processes : Research at least 2 companies, and familiarize yourself with their warehouse management processes, and then discuss the following:

Which will provide the program user some basic information : DisplayApplicationInformation, which will provide the program user some basic information about the program.

User Account

All Pages