FULL DETAIL IS NOW AVAILBEL ====================== The aim of this assignment is to familiarize you with JDBC (Java Database Connectivity) in client-server environment. In this project, you have to develop an interface for students to request an appointment with their instructor. This interface will allow the user to select an appointment consisting of a time slot in a database. The database Will consist of a week with time slots for everyday. The user has to first select a day and select a time slot among all available time slots in that day. If the user does not find a suitable time slot, he/she goes back and simply selects another day. To ensure fairness, each user is allowed to select only one time slot over a given week. If the user needs to modify the appointment, he/she goes back to the database, deletes the previous appointment and requests a new appointment. Note that we will create a schema for this and populate the tables. In other words, you need not worry about creation and population of the database. The schema that will be created and populated for you, and stored in an URL, will consist of the following tables: create table Users( UserID varchar(20) primary key, LName varchar(20), FName varchar(20), Password varchar(20)); create table Appointment( Day date, Timeslot varchar(20), UserID varchar(20), UserComments varchar(100), Primary key(Day,Timeslot), foreign key(UserID) referencing Users);
You are required to: Write a Java Servlets program that will first validate the user on the basis of the UserId and password. Once, the user logs into the database, the user should be presented a GUI and asked to select a day. After a day is selected, all appointment times for the day will appear in a table, but only available time slots and the time slot already reserved by this user (if there is such a time slot) will be available for selection, indicated by the presence ofa button next to the time. Thus the time slots are protected by the UserID and password and one user cannot change time slots reserved by some other user. If a user does not see an appointment time that he or she would like to select, the user can simply select another day. Once the user selects an appointment time, a confirmation page will appear. The user will be instructed to enter a first name, last name, comments for the professor, and to confirm the appointment time and date. Clicking a submit button will complete the request to be submitted to the database. DEsCRIPTION OF GUI GUI 1: Title: Please enter your userid and password 2 text fields: UserID, password 2 buttons: submit, reset GUI 2: Title: Select a DAY 1 crollbar containing 30 days (from September 1st to September 30th)(pick out from database) Gui 3: Title: Time Slots display a table with 5 columns: Time slot, LastName, FirstName, Comments, and RequestAppointment. (The last column contains button can be clicked to select the time slot) ====================== please I want it on or before friday so please make the work ready and send me demo program I will select the bidder friday morning...and need work withint next 1 hours of acceptance of bid ALL THE BEST TO ALL PROGRAMMERS THANKS
## Deadline information
I want to give again chance to new Coder so it would be great if you give me demo program so based on that I will choose the Bid
I will choose the bid on Wednesday
and want work on Thirusday
thanks and Advanced....