Create a database named
MyCustomers, with the following
MySQL. Use the appropriate data types
and note that the underlined fields
denotes a field to be either a primary key or a foreign key Customers(CustomerID, Name,
Address, City) Orders(OrderID, CustomerID, Amount,
Date) Insert at least 5 records in each of the
tables appropriately. Include the
output for your database design and
the records for your tables.
Write a Java program to establish
a connection to the MyCustomers
database using the JDBC driver to
retrieve the entire Customers and
table. Use the Swing component TextArea to display the data and your
interface must use either menu items
or command buttons to trigger the
actions for retrieving the data.
Write a servlet program that searches
for a customer in the database you
designed in Question above. If the
customer is not in the database, add
the customer details to the database
and display the message “Customer is added to the database”. If the
customer is in the database, display
message “Already Existing Customer”
The first step is to create a DB - that has nothing to do with Java, or any kind of coding. It involves installing MySQL, and familiarizing yourself with it as much as you need in order to create DB.
The next step is to create a Java program using JDBC and Swing. If you aren't familier with them (which you should be through the course you took for which this is apparently a problem set), ask your teacher for some introductory material, or links to same.
The last step is to write a servlet that also accesses the DB through JDBC. If you haven't done that before, download a servlet container such as Tomcat, and familiarize yourself with it. Again, introductory material should be available through your teacher, or he should be able to point you to it.