Spring CSC455 / CSC516 Java Homework and Solutions 

​

Hi Dear IT Students .

We have updated some Java Home work assignments solution for Spring CSC455/CSC516(The College of Saint Rose) and all other universities from the globe.

If you did not find out the solution then contact us directly to get instant customize solution according to your requirements and guidance of your java Homework and assignment help online.

Interested People Can contact us : Get More then 95% Score in your Java Assignments.

​

Assignments --

​

Part A. A database for an On-Demand Streaming Service (such as Netflix)

1. The system will hold information about video items, customers and various subscriptions.

2. The system offers three types of subscriptions: Basic, Advanced, and Unlimited. Each subscription has a fixed monthly payment rate.

3. A customer has an ID, email, name, payment card number, payment card expiration date, and address.

4. A video item can be a movie, TV series episode, or a TV show.

5. Each video item has a title, genre, date, and duration.

6. Each video item has a number of either 0, 1 or 2. This number specifies whether that video item is associated with the Basic, Advanced or the Unlimited subscription.

7. A customer can have a subscription to one of the three types listed above. A customer subscription will have a start date and a possible end date.

Part B. 

1. Define the entities of your system, given the system requirements that you have specified in Week 2.

2. Define the attributes for each entity.

3. Define the relations between the different entities.

4. Draw an ER diagram to show your database design.

5. Put the output of steps 1 to 4 in a Word document.

Part C. 

In this lab, you will design an Enhanced Entity Relationship (EER) diagram to improve on the database design that you have worked on in the previous weeks. You will further improve your design by including any possible:

1. Inheritance Relationships

2. Constraints

3. Union Types

Part D 

1. Using your downloaded DBMS (MS SQL Server), create a new database.

2. Create the database tables based on your entities defining

   1. The attributes within each table

   2. The primary and foreign keys within each table

Create a Word document

Part E 

1. Using your downloaded DBMS (MS SQL Server), create SQL queries that inserts at least three rows in each table.

2. Create SQL queries that update one row in each table.

3. Create SQL queries that retrieve an entire table (any table that you choose).

 

Part I: Final Database Report (20 points)

In this report, you will include all the project work that you have done throughout the course:

1. System name (Pizza Ordering, Streaming Service or Book Library) & a brief description of it.

2. The list of system requirements.

3. The ER diagram for your database design.

4. The EER diagram for your database design.

5. A description of your actual database tables, attributes and relationships.

6. Snapshots of your created database and each table.

7. Snapshots of the queries that you have executed and the execution results.

8. A summary of the challenges that you have faced in all the project phases. 

Part II: Writing Assignment (30 points)

The purpose of this assignment is to read and understand the difference between front end and back end design of a database application.

Steps:

1. Search for articles describing front end and back end design of any application (example, a website). Summarize the concepts and elements for each one.

2. Does the database that holds all the data exist at the front end or the back end? Include the answer in your report.

Your document should not exceed 2 pages.

Submission:

Put the database report and the writing assignment in one Word document and submit

Please Contact For Instant Help before Dead Line. Or Call +91-9953141035

Solution Available for All Assignmnets.

​

Spring CSC455 / CSC516 PART - 1 (The College of Saint Rose Java Solutions)

Note -  All these solutions are under JDeveloper IDE Tool . You can ask for other IDE if required.

Homework 1

Have a new class called CollegeStudent. A CollegeStudent is a kind of a student with a college name and a GPA. The CollegeStudent has collegeName and GPA properties, the appropriate constructors, and a toString() method that includes the collegeName and the GPA.

Modify ex9.java from the first set of notes to include college students initially and we can also add them. The new filename should be <lastname>1.java (for example, avitabile1.java).

When you finish, make a zip file that includes your application, project, and java files. It should contain everything, not just the java files. Also, tell me what version of JDeveloper you created it with. Do this for all homework assignments.

Customized Solution Available on request.

​

Homework 2

Part 1:

Inside a project named <lastname>2a (for example, avitabile2a), do the following:

Create an abstract class called User. This class should have properties of username and password, a constructor that assigns values to username and password, a getUsername() method, a getPassword() method, and an abstract method named userInfo(). Create two classes named Reader  and Poet that contain constructors and also contain a userInfo() method. The userInfo() method should output the username, the password, and the kind of user.

Write a program named <lastname>2a.java (for example, avitabile2a.java) that creates a TreeSet; adds Readers and Poets to it, and outputs the values sorted by the usernames.

Make sure that your User class implements the Comparable interface and includes whatever methods you need to make that work..

​

Part 2:

Inside a project named <lastname>2b (for example, avitabile2b), do the following:

Create an interface called User. This interface should contain getUsername(), getPassword(), and driverInfo().

Create two classes named Poet and Reader that implement this interface.

Write a program  named <lastname>2b.java (for example, avitabile2b.java)that creates a TreeSet; adds Poets  to it, and outputs the values sorted by the usernames of the Poet.

Your User interface also contains the compareTo method.

Your Poet and Reader classes also implement the Comparable interface.

Customized Solution Available on request.

​

Homework 3

All homework for this semester that use a database will  either use the file poetry.accdb or poetry.mdb. Both files are contained in a zip file named poetry.zip. Download it and unzip the files. Register one of them using ODBC.

The ER diagram for this database is:

Your project (named <lastname>3 - for example avitabile3) should include the following:

1. A program named <lastname>3a.java that, using a Prepared Statement, executes the query of your choice from the database and outputs the results.

1. A program named <lastname>3b.java that lets the user enter data to be inserted into the READERS table, thereby adding a new reader.

Make sure that your URL for the connection is: jdbc:odbc:poetry

Customized Solution Available on request.

 

Homework 4

Create a project named <lastname>4.

In that project, create the following files:

An html file named <lastname4>.htm that contains a form and a number of form elements. Try using form elements other than text fields as well as using text fields. The submit for the form calls a servlet.  The servlet (named <lastname4>.java) does some sort of calculation and displays the result.

Customized Solution Available on request.

​

Homework 5

 Create a project named <lastname>5. Put the following within it:

Write an html file named <lastname>5.htm that lets the user enter data to be inserted into the READERS table, and write a servlet named <lastname>5a.java that checks to see if there already is a reader with that READERID. If everything’s ok, do a forward to a second servlet named <lastname>5b.java that does the insert. If there’s a problem, do a forward to a third servlet named <lastname>5c.java that prints an error message.

Customized Solution Available on request.

​

Homework 6

 Create a project named <lastname>6

1. Write an JSP file named <lastname>6a.jsp that populates the options of a select with all CATEGORY values.The SQL statement to get this without duplicates isSELECT DISTINCT CATEGORY FROM POEMSThe action of the form that contains the select is to go to another JSP named <lastname>6b.jsp that will print (in a table) the POEMID, TITLE, DESCRIPTION, CATEGORY, and POETID for each poem of that category.

Customized Solution Available on request.

​

Homework 7

 Create a project named <lastname>7.

Write an HTML file named <lastname>7.htm that contains form elements to let someone enter a person's name and the number of boxes of cookies that person has sold.. The action of the HTML file should go to a jsp file named <lastname>7.jsp.

 The jsp will calculate the gross and net income for that person.

 Gross income is calculated like this:

boxes_sold * 4

Net income is calculated like this:

boxes_sold * 2

 The jsp will output the name, boxes sold, gross income, and neet_income for that person.

 If any field of the input is empty, an appropriate error message should be printed.

Make sure you load all parameter values into a bean named <lastname>7.java. It will make it much easier to do homework 8 if you do this.

 You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Customized Solution Available on request.

 

Homework 8

 Modify Homework 7 in the following way:

Have a second jsp named <lastname>8.jsp that will display in a table the data for all people entered in this session using the first jsp. You will want to have another Bean named <lastname>8.java that includes an ArrayList. This bean should include methods that let you add a <lastname>7 object to the ArrayList (setPerson) and return the ArrayList (getAll).

You cannot use any java scriptlets in your jsp page. Use only JSTL tags

Customized Solution Available on request.

​

Homework 9

This is a repeat of homework 6. Just make sure that you use JSTL instead of Java scriptlets.

Create a project named <lastname>9

Write an JSP file named <lastname>9a.jsp that populates the options of a select with all CATEGORY values.

The SQL statement to get this without duplicates is

SELECT DISTINCT CATEGORY FROM POEMS

The action of the form that contains the select is to go to another JSP named <lastname>9b.jsp that will print (in a table) the POEMID, TITLE, DESCRIPTION, CATEGORY, and POETID for each poem of that category

Customized Solution Available on request.

 

Homework 10

Use JSTL to do the following. Both problems will use the file hw10.xml

Create a project named <lastname>10

1. Write a JSP file named <lastname>10a.jsp that will display, in a table, all information about customers.
    

2. Write an HTML file named <lastname>10b.htm that will ask the user to enter the last name of a customer into a text field. The action of the form will be to go to a JSP file named <lastname>10b.jsp that will print, in a table, all information about customers with that last name.

Customized Solution Available on request.

​​

Homework 11

Create a project named <lastname>11

 Write an AJAX application using AJAX DWR that will display all information about a CAKE when the user enters the CAKE_ID into a text field.

The html file should be named <lastname>11.htm; and the java filenames should also include your lastname.

Customized Solution Available on request.

​

Homework 12

Create a struts application in a project named <lastname>12 that will have the following features:

• an initial html file named <lastname>12.jsp that will allow a user to enter for a new ORDERS record.

• a jsp page named <lastname>success.jsp that will display a table of information about all ORDERS records in the database (including the new one) - don't worry if the.new record doesn't show up immediately.

• a series of jsp pages that will display the reason why the new ORDERS record could not have been entered. These reasons should include that the ORDERID already exists, that the CUSTOMERID does not exist in the CUSTOMERS table, or that one or more of the data fields are empty.

•  new subclass of Action named <lastname>12Action.java that will figure out what to do.

• struts-config.xml

Customized Solution Available on request.

​

Homework 13

Modify homework 12. The changes are:

• Your initial html file named <lastname>12.jsp now uses message resources property files to display all text.

• Have an English message resources files and a Spanish message resources file. Use the Google translate site (http://translate.google.com/#) to translate from English to Spanish. The filenames should beMessageResources.properties and MessageResources_es.properties.

• an ActionForm named <lastname>13ActionForm that will read the data from <lastname>12.jsp.

• a subclass of Action named <lastname>13Action.java that will get the data from the <lastname>13ActionForm instance and see whether it is possible to insert the new ORDERS record.

• a jsp page named <lastname>success.jsp that will echo the information about the new ORDERS record. The data should come from the <lastname>13ActionForm.

Customized Solution Available on request.

​

​

Spring CSC455 / CSC516 PART - 2 (The College of Saint Rose Java Solutions)

Note -  All these solutions are under JDeveloper IDE Tool . You can ask for other IDE if required..

Customized Solution Available on request for All Assignments.

Homework 1

Have a new class called HighSchoolStudent. A HighSchoolStudent is a kind of a student with a high school and a grade. The HighSchoolStudent has highschool amd grade properties, the appropriate constructors, and a toString() method that includes the high school and grade.

Modify ex9.java from the first set of notes to include high school students initially and we can also add them.

When you finish, make a zip file that includes your application, project, and java files. It should contain everything, not just the java files. Also, tell me what version of JDeveloper you created it with. Do this for all homework assignments.

Solution Available.

​

Homework 2

Part 1:

Create an abstract class called Driver. This class should have properties of age and name, a constructor that assigns values to name and age, a getName() method, a getAge() method, and an abstract method named driverInfo(). Create two classes named TaxiDriver and RideShareDriver that contain constructors and also contain a driverInfo() method. The driverInfo() method should output the name, age, and the kind of driver.

Write a program that creates a TreeSet; adds TaxiDrivers and RideShareDrivers to it, and outputs the values sorted by the names of the drivers.

Make sure that your Driver class implements the Comparable interface and includes whatever methods you need to make that work..

​

Part 2:

 

Create an interface called Driver. This interface should contain getAge(), getName(), and driverInfo().

Create two classes named TaxiDriver and RideShareDriver that implement this interface.

Write a program that creates a TreeSet; adds TaxiDrivers  to it, and outputs the values sorted by the names of the TaxiDriver.

Your Driver interface also contains the compareTo method.

Your TaxiDriver and RideShareDriver classes also implement the Comparable interface.

​

Homework 3

All homework for this semester that use a database will use the file rides.accdb The file is contained in a zip file. rides.zip. Download it and unzip the file.

The ER diagram for this database is:

Your project should include the following:

1. A program that, using a Prepared Statement, executes the query of your choice from the database and outputs the results.

2. A program that lets the user enter data to be inserted into the CLIENT table, thereby adding a new client.

Make sure that your URL for the connection is: jdbc:odbc:rides

Solution Available.

 

Homework 4

1. Create an html file with a form and a number of form elements. Try using form elements other than text fields as well as using text fields. The submit for the form calls a servlet.  The servlet does some sort of calculation and displays the result.

 

2. Write a html file that lets the user enter data for a new client, and a servlet that adds that new client into the CLIENT table.

Solution Available 

​

Homework 5

1. Write an html file that lets the user enter data to be inserted into the CLIENT table, and write a servlet that checks to see if there already is a course with that CLIENT_ID. If everything’s ok, do a forward to a second servlet that does the insert. If there’s a problem, do a forward to a third servlet that prints an error message.

 

Both the second and the third servlet should print the number of successful and unsuccessful inserts that have been done so far in this session.

Solution Available.

​

Homework 6

• Write an html file that lets the user enter data to be inserted into the CLIENT table, and write a JSP that checks to see if there already is a client with that CLIENT_ID. If everything’s ok, do a forward to a second JSP that does the insert. If there’s a problem, do a forward to a third JSP that prints an error message. 
  
  Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
   

• Write an JSP file that populates the options of a select with all DRIVER_CITY values.

   

  The SQL statement to get this without duplicates is

   

  SELECT DISTINCT DRIVER_CITY FROM DRIVER

 

The action of the form that contains the select is to go to another JSP that will print (in a table) the DRIVER_ID, DRIVER_NAME, DRIVER_NAME, and DRIVER_EMAIL for all drivers from that city.

Solution Available.

​

Homework 7

Write an HTML file that contains form elements to let someone enter a person's name, the number of hours a person has worked, and the hourly wage for a person. The action of the HTML file should go to a jsp file.

 

The jsp will calculate the salary and tax for that person.

 

Salary is calculated like this:

hours_worked * hourly_wage

Tax is calculated like this:

salary * .07

 

The jsp will output the name, hours worked, hourly wage, salary, and tax for that person.

 

If any field of the input is empty, an appropriate error message should be printed.

 

Make sure you load all parameter values into a bean. It will make it much easier to do hw8 if you do this.

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

​

Solution Available.

 

Homework 8

Modify Homework 8 in the following ways:

 

Make sure that the salary and tax are displayed using exactly 2 digits to the right of the decimal place.

 

Have a second jsp that will display in a table the data for all people entered in this session using the first jsp. You will want to have another Bean that includes an ArrayList of Persons. This bean should include methods that let you add a Person to the ArrayList (setPerson) and return the ArrayList (getAll).

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Solution Available.

​

Homework 9

This is a repeat of homework 6. Just make sure that you use JSTL instead of Java scriptlets.

1. Write an html file that lets the user enter data to be inserted into the CLIENT table, and write a JSP that checks to see if there already is a client with that CLIENT_ID. If everything’s ok, do a forward to a second JSP that does the insert. If there’s a problem, do a forward to a third JSP that prints an error message. 
   
   Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
    

2. Write an JSP file that populates the options of a select with all DRIVER_CITY values.

    

   The SQL statement to get this without duplicates is

    

   SELECT DISTINCT DRIVER_CITY FROM DRIVER

    

   The action of the form that contains the select is to go to another JSP that will print (in a table) the DRIVER_ID, DRIVER_NAME, DRIVER_NAME, and DRIVER_EMAIL for all drivers from that city.

Solution Available.

 

Homework 10

Use JSTL to do the following. Both problems will use the file hw10.xml

1. Write a JSP file that will display, in a table, all information about employees.
    

2. Write an HTML file that will ask the user to enter the first name of an employee into a text field. The action of the form will be to go to a JSP file that will print, in a table, all information about employees with that first name.

Solution Available.

​​

Homework 11

Write an AJAX application using AJAX DWR that will display all information about a RIDE when the user enters the RIDE_ID into a text field.

Solution Available.

​

Homework 12

The video lectures for Struts 1, Struts 2, and Struts 3 contain enough information to do this assignment.

Create a struts application that will have the following features:

• an initial html file named hw12.jsp that will allow a user to enter information about a new ride.

• a jsp page named success.jsp that will display a table of information about all rides in the database (including the new one).

• a series of jsp pages that will display the reason why the new ride could not have been entered. These reasons should include that the RIDE_ID already exists, that the DRIVER_ID does not exist in the DRIVER table, that the CLIENT_ID does not exist in the CLIENT table, that one or more of the data fields are empty, or that the fee is not between 0 and 100.

•  new subclass of Action named hw12Action.java that will figure out what to do.

• struts-config.xml

Solution Available.

​

Homework 13

Create a struts application that will have the following features:

• struts-config.xml

• an initial html file named hw13.jsp that will allow a user to enter information about a new ride. This file will use message resources property files to display all text.

• Have an English message resources files and an Italian message resources file. Use the Google translate site (http://translate.google.com/#) to translate from English to Italian. The filenames should beMessageResources.properties and MessageResources_it.properties.

• an ActionForm named HW13ActionForm that will read the data from hw13.jsp.

• a subclass of Action named HW13Action.java that will get the data from the HW13ActionForm instance and see whether it is possible to insert the ride.

• a jsp page named success.jsp that will echo the information about the new ride. The data should come from the HW13ActionForm.

• a series of jsp pages that will display the reason why the new ride could not have been entered. These reasons should include that the RIDE_ID already exists, that the DRIVER_ID does not exist in the DRIVER table, that the CLIENT_ID does not exist in the CLIENT table, that one or more of the data fields are empty, or that the fee is not between 0 and 100.

Solution Available.

​

​

Spring CSC455 / CSC516 PART - 3 (The College of Saint Rose Java Solutions)

Note -  All these solutions are under JDeveloper IDE Tool . You can ask for other IDE if required..

Customized Solution Available on request for All Assignments.

Homework 1

Have a new class called PartTimeStudent. A PartTimeStudent is a kind of a student with a job. The PartTimeStudent has an employer property, and the appropriate constructors, and a toString() method that includes the employer.

Modify ex9.java from the first set of notes to include part time students initially and we can also add them.

When you finish, make a zip file that includes your application, project, and java files. It should contain everything, not just the java files. Also, tell me what version of JDeveloper you created it with. Do this for all homework assignments.

Email this zip file as an attachment to avitabij@strose.edu

Solution Available.

​

Homework 2

Create a zip file that contains your entire project and email it to avitabij@strose.edu

Part 1:

Create an abstract class called Pet. This class should have at least two abstract methods in it. Create two classes named Cat and Dog that implement these abstract methods. Write a program that creates a TreeSet; adds Cats and Dogs to it, and outputs the values sorted by the names of the pets. Make sure that your Pet class implements the Comparable interface.

Part 2:

Create an interface called Pet. This class should have at least two methods in it. Create two classes named Cat and Dog that implement this interface. Write a program that creates a TreeSet; adds Cats  to it, and outputs the values sorted by the names of the pets. Make sure that your Pet interface contains the compareTo method and your Cat and Dog classes implement the Comparable interface also.

Solution Available.

​

Homework 3

Create a zip file that contains your entire project and email it to avitabij@strose.edu.

Your project should include the following:

1. A program that, using a Prepared Statement, executes the query of your choice from the database and outputs the results.

2. A program that lets the user enter data to be inserted into the COURSES table, thereby adding a new course.

Make sure that your URL for the connection is: jdbc:odbc:registrar

Solution Available.

 

Homework 4

1. Create an html file with a form and a number of form elements. Try using form elements other than text fields as well as using text fields. The submit for the form calls a servlet.  The servlet does some sort of calculation and displays the result.

 

2. Write a html file that lets the user enter data to be inserted into the COURSES table, and have a servlet that will do the insert.

Zip all your work together. Email it to me (avitabij@strose.edu) in an attachment, as usual.

Solution Available 

​

Homework 5

1. Write an html file that lets the user enter data to be inserted into the COURSES table, and write a servlet that checks to see if there already is a course with that course number. If everything’s ok, do a forward to a second servlet that does the insert. If there’s a problem, do a forward to a third servlet that prints an error message.

 

Both the second and the third servlet should print the number of successful and unsuccessful inserts that have been done so far in this session.

Solution Available.

​

Homework 6

• Write an html file that lets the user enter data to be inserted into the COURSES table, and write a JSP that checks to see if there already is a course with that course number. If everything’s ok, do a forward to a second JSP that does the insert. If there’s a problem, do a forward to a third JSP that prints an error message. 
  
  Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
   

• Write an JSP file that populates the options of a select with all rooms that have a class offered in them. The action of the form that contains the select is to go to another JSP that will print (in a table) the course, section, dates, times, and instructor for all offerings that are held in that room.

Solution Available.

​

Homework 7

Write an HTML file that contains form elements to let someone enter the name of a company, a number of shares a person bought, the purchase price, and the sale price. The action of the HTML file should go to a jsp file.

 

The jsp will calculate the profit and tax for that stock.

 

A profit is calculated like this:

(sale_price - purchase_price) * shares

Tax is calculated like this if profit is at least 0:

profit * .15

If profit is negative, tax is 0.

 

The jsp will output the company name, shares, profit, and tax for that stock.

 

And if any field of the input is empty, an appropriate error message should be printed.

 

Make sure you load all parameter values into a bean. It will make it much easier to do hw8 if you do this.

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Solution Available.

 

Homework 8

Modify Homework 7 in the following ways:

 

Make sure that the profit and tax are displayed using exactly 2 digits to the right of the decimal place.

 

Have a second jsp that will display in a table the data for all stocks entered in this session using the first jsp. You will want to have another Bean that includes an ArrayList of Stocks. This bean should include methods that let you add a Stock to the ArrayList (setStock) and return the ArrayList (getAll).

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Solution Available.

​

Homework 9

This is a repeat of homework 6. Just make sure that you use JSTL instead of Java scriptlets.

1. Write an html file that lets the user enter data to be inserted into the COURSES table, and write a JSP that checks to see if there already is a course with that course number. If everything’s ok, do a forward to a second JSP that does the insert. If there’s a problem, do a forward to a third JSP that prints an error message. 
   
   Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
    

2. Write an JSP file that populates the options of a select with all rooms that have a class offered in them. The action of the form that contains the select is to go to another JSP that will print (in a table) the course, section, dates, times, and instructor for all offerings that are held in that room.

Solution Available.

 

Homework 10

Use JSTL to do the following. Both problems will use the file hw10.xml

1. Write a JSP file that will display, in a table, all information about customers.
    

2. Write an HTML file that will ask the user to enter the name of a city into a text field. The action of the form will be to go to a JSP file that will print, in a table, all information about customers who live in that city.

    

Solution Available.

​​

Homework 11

Write an AJAX application using AJAX DWR that will display all information about an offering when the user enters a CRN in a text field.

Solution Available.

​

Homework 12

Create a struts application that will have the following features:

• an initial html file named hw12.jsp that will allow a user to enter information about a new course.

• a jsp page named success.jsp that will display a table of information about all courses in the database (including the new one).

• a series of jsp pages that will display the reason why the new class could not have been entered. These reasons should include that the course already exists, that one or more of the data fields were empty, or the number of credits was not between 0 and 6 (inclusive).

•  new subclass of Action named hw12Action.java that will figure out what to do.

• struts-config.xml

Solution Available.

​

Homework 13

Create a struts application that will have the following features:

• struts-config.xml

• an initial html file named hw13.jsp that will allow a user to enter information about a new course. This file will use message resources property files to display all text.

• Have an English message resources files and an Italian message resources file. Use the Google translate site (http://translate.google.com/#) to translate from English to Italian. The filenames should beMessageResources.properties and MessageResources_it.properties.

• an ActionForm named HW13ActionForm that will read the data from hw13.jsp.

• a bean named HW13Results.java that has success and failure properties; with the appropriate get and set methods. The default values of the properties should be 0.

• a subclass of Action named HW13Action.java that will use or create a session-scoped Results bean. hw13Action should get the data from the HW13ActionForm instance and see whether it is possible to insert the course. If it can do the insert, it should do the insert and increment success. If it can't do the insert, it should do increment failure.

• a jsp page named success.jsp that will display the number of successes, failures, and echo the information about the new course. The data should come from the HW13ActionForm and HW13Results beans.

• a series of jsp pages that will display the reason why the new class could not have been entered. These reasons should include that the course already exists, that one or more of the data fields were empty, or the number of credits was not between 0 and 6 (inclusive). Also include the values from the HW13Results bean.

Solution Available.

​

Spring CSC455 / CSC516 PART - 4 (The College of Saint Rose Java Solutions)

Note -  All these solutions are under JDeveloper IDE Tool . You can ask for other IDE if required..

Customized Solution Available on request for All Assignments.

Homework 1

Have a new class called Alumni. An Alumni is a kind of a Student with a degree and a graduation_year. For this class, include the appropriate properties, get methods, constructors, and a toString() method that includes the degree and graduation year.

Modify ex9.java from the first set of notes to include alumni initially and we can also add them.

When you finish, make a zip file that includes your application, project, and java files.

Email this zip file as an attachment to avitabij@strose.edu

Solution Available.

​

Homework 2

Create a zip file that contains your entire project and email it to avitabij@strose.edu

Part 1:

Create an abstract class called School. This class should have two abstract methods in it - getInformation() and getMinimumAge(). It should also have a name property, a getName() method, and a constructor that takes the name of the School as an argument. Make sure that your School class implements the Comparable interface.

Create two classes named College and HighSchool that implement these abstract methods - the output of the methods will be different, of course. The classes should have a constructor that takes the name of the School as an argument.

 Write a program that creates a TreeSet; adds Colleges and HighSchools to it, and outputs the name, information, and minimum age, sorted by the name of the School.

Part 2:

Create an interface called School. This interface should include the getInformation and getMinimumAge methods. Create two classes named College and HighSchool that implement this interface. Write a program that creates a TreeSet; adds Colleges  to it, and outputs the name, information, and minimum age, sorted by the name of the School, Make sure that your School interface contains the compareTo method and your College and HighSchool classes implement the Comparable interface as well as the School interface.

Solution Available.

​

Homework 3

Create a zip file that contains your entire project and email it to avitabij@strose.edu.

Your project should include the following:

1. A program that, using a Prepared Statement, executes the query of your choice from the database and outputs the results.

2. A program that lets the user enter a new record to be inserted into the STUDENTS and USERS table, thereby adding a new student. Make sure you do the insert for the USER first. Note that some information about a student (first and last name, etc.) goes into the USERS table and some information (major, address, and so on) goes into the STUDENTS table. This will be the case for many subsequent assignments.

Make sure that your URL for the connection is: jdbc:odbc:registrar

Solution Available.

 

Homework 4

1. Create an html file with a form and a number of form elements. Try using form elements other than text fields as well as using text fields. The submit for the form calls a servlet.  The servlet does some sort of calculation and displays the result.

 

2. Write a html file that lets the user enter data that will be entered into the STUDENTS and USERS table, thereby adding a new student. Then have a servlet that will do the insert (make sure you insert the USER record before you insert the STUDENT record).

 

 

Zip all your work together. Email it to me (avitabij@strose.edu) in an attachment, as usual.

Solution Available 

​

Homework 5​

1. Write an html file that lets the user enter a new student to be inserted into the STUDENTS and USERS tables, and write a servlet that checks to see if there already is a Student with that UserID. If everything’s ok, do a forward to a second servlet that does the inserts. If there’s a problem, do a forward to a third servlet that prints an error message.

 

Both the second and the third servlet should print the number of successful and unsuccessful inserts that have been done so far in this session. Use session variables to keep track of this.

Solution Available.

​

Homework 6

1. Write an html file that lets the user enter data on a new student to be inserted into the STUDENTS and USERS table, and write a JSP that checks to see if there already is a Student with that UserID. If everything’s ok, do a forward to a second JSP that does the inserts. If there’s a problem, do a forward to a third JSP that prints an error message. 
   
   Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
    

2. Write an JSP file that populates the options of a select element that shows all the majors that students have (determined at runtime; not hard-coded). The action of the form that contains the select element is to go to another JSP that will print (in a table) information about the students who have that major.

Solution Available.

​

Homework 7

Write an HTML file that contains form elements to let someone enter the name of a company, a number of shares a person bought, the purchase price, and the sale price. The action of the HTML file should go to a jsp file.

 

The jsp will calculate the profit and tax for that stock.

 

A profit is calculated like this:

(sale_price - purchase_price) * shares

Tax is calculated like this if profit is at least 0:

profit * .15

If profit is negative, tax is 0.

 

The jsp will output the company name, shares, profit, and tax for that stock.

 

And if any field of the input is empty, an appropriate error message should be printed.

 

Make sure you load all parameter values into a bean. It will make it much easier to do hw8 if you do this.

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Solution Available.

 

Homework 8

Modify Homework 7 in the following ways:

 

Make sure that the profit and tax are displayed using exactly 2 digits to the right of the decimal place.

 

Have a second jsp that will display in a table the data for all stocks entered in this session using the first jsp. You will want to have another Bean that includes an ArrayList of Stocks. This bean should include methods that let you add a Stock to the ArrayList (setStock) and return the ArrayList (getAll).

 

You cannot use any java scriptlets in your jsp page. Use only JSTL tags.

Solution Available.

​

Homework 9

This is a repeat of homework 6. Just make sure that you use JSTL instead of Java scriptlets.

1. Write an html file that lets the user enter data on a student that will be inserted into the STUDENTS and USERS table, and write a JSP that checks to see if there already is a student with that userID. If everything’s ok, do a forward to a second JSP that does the inserts. If there’s a problem, do a forward to a third JSP that prints an error message. 
   
   Both the second and the third JSP should print the number of successful and unsuccessful inserts that have been done so far in this session.
    

2. Write an JSP file that populates the options of a select element with all majors that students have. The action of the form that contains the select is to go to another JSP that will print (in a table) the information about all students with that major.

Solution Available.

 

Homework 10

Use JSTL to do the following. Both problems will use the file hw10.xml

1. Write a JSP file that will display, in a table, all information about employees.
    

2. Write an HTML file that will ask the user to enter the first name of an employee into a text field. The action of the form will be to go to a JSP file that will print, in a table, all information about employees with that name.

Solution Available.

​​

Homework 11

Write an AJAX application using AJAX DWR that will display all information about a student when the user enters a userID in a text field.

Solution Available.

​

Homework 12

The video lectures for Struts 1, Struts 2, and Struts 3 contain enough information to do this assignment.

Create a struts application that will have the following features:

• an initial html file named hw12.jsp that will allow a user to enter information about a new student.

• a jsp page named success.jsp that will display a table of information about all students in the database (including the new one).

• a series of jsp pages that will display the reason why the new student could not have been entered. These reasons should include that the userID already exists, that one or more of the data fields were empty, or the password contained fewer than 6 characters.

•  new subclass of Action named hw12Action.java that will figure out what to do.

• struts-config.xml

Solution Available.

​

Homework 13

Create a struts application that will have the following features:

• struts-config.xml

• an initial html file named hw13.jsp that will allow a user to enter information about a new student. This file will use message resources property files to display all text.

• Have an English message resources files and a Danish message resources file. Use the Google translate site (http://translate.google.com/#) to translate from English to Danish. The filenames should beMessageResources.properties and MessageResources_da.properties.

• an ActionForm named HW13ActionForm that will read the data from hw13.jsp.

• a bean named HW13Results.java that has success and failure properties; with the appropriate get and set methods. The default values of the properties should be 0.

• a subclass of Action named HW13Action.java that will use or create a session-scoped Results bean. hw13Action should get the data from the HW13ActionForm instance and see whether it is possible to insert the user and student. If it can do the inserts, it should do the inserts and increment success. If it can't do the insert, it should do increment failure.

• a jsp page named success.jsp that will display the number of successes, failures, and echo the information about the new student. The data should come from the HW13ActionForm and HW13Results beans.

• a series of jsp pages that will display the reason why the new class could not have been entered. These reasons should include that the student already exists, that one or more of the data fields were empty, or the password was less than six characters. Also include the values from the HW13Results bean.

Solution Available.

​