CMPSC 211 assignment 6 room scheduler

Get your Assignment in a Minimum of 3 hours

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

Free Inquiry Order A Paper Now Cost Estimate

I need help with a Java question. All explanations and answers will be used to help me learn.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

The assignment discription is in the uploaded files underneath are some supporting materials. There are multiple videos that I can’t upload through studypool, you can give me a email address so that I can send you all the


Programming Assignment 6 Test Script

This is a scenario that you can use to test Programming Assignment 6. It is not an exhaustive test, but tests almost all of the conditions your program should handle.

When you submit your PA 6, all the tables in the database should be empty except the Rooms Table and the Dates Table. The Rooms table should contain three rooms, such as 101 with 60 seats, 102 with 40 seats, and 201 with 20 seats, which will be used in this script. The Dates table should contain two dates, which will be expressed as date1 and date2 in this script.This scenario assumes that is the case.

The faculty names will be a, b, c, d, etc. to simplify input and this script.
The dates will be real dates but will be represented in this script by the symbolic names date1 and date2.

Script:

-Add faculty a
Note: after adding a faculty, the faculty should appear in the drop down list on the Reserve panel.

-Add faculty b

-Add faculty c

-Add faculty d

-Add faculty e

-Reserve a, date1, 20

  • a reserves room 201

-Reserve b, date1, 50

  • b reserves room 101

-Reserve c, date1, 50

  • c gets waitlisted

-Reserve d, date1, 40

  • d reserves room 102

-Reserve e, date1, 20

  • e gets waitlisted

-Reserve c, date2, 20

  • c reserves room 201

-Status date1

  • a reserved 201
  • b reserved 101
  • d reserved 102

-Status date2

  • c reserved 201

-Status Waitlist

  • c date1 50
  • e date1 20

General conditions of testing:

  • the results of any action are displayed to the user immediately after the action is performed without the user needing to check Status.
  • All affected combo boxes are updated immediately after each action is performed.

Creating a timestamp field in Java

The following is sample code to insert a Timestamp field into a table column:

// declare a timestamp field.
java.sql.Timestamp currentTimestamp = new java.sql.Timestamp(Calendar.getInstance().getTime().getTime());

// use the timestamp in an insert to the wait list.
getWaitList = dbConnection.prepareStatement(“insert into waitlist (flight, day, customerName, timeStamp) values (?, ?, ?)”);
getWaitList.setString(1, entry.getFlightName());
getWaitList.setString(2, entry.getDay());
getWaitList.setString(3, entry.getCustomerName());
getWaitList.setTimestamp(4, currentTimestamp);
count = getWaitList.executeUpdate();

Make sure the column in the database table is specified as Timestamp and not Time.

"Is this question part of your assignment? We Can Help!"

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Get Started