Please follow the setup instructions located in the assign/setup directory.
The sample code for these examples is code/304_lab7_example_java.zip.
Edit the sample code in the folder WebContent.
Here is the code to show "Hello World!" using JSP:
<html>
<head>
<title>Hello World in JSP</title>
</head>
<body>
<% out.println("Hello World!"); %>
</body>
</html>
Click for a demonstration of the Hello World code
The URL of the JSP file is: http://localhost/shop/HelloWorld.jsp
Modify the code using a text editor. Try and change the code so that the output looks like this:
1 2 3 4 5
Click here for a demonstration of the Hello World Again code
Example code to query the workson database and return some answers in a table. Make sure that the url is jdbc:mysql://cosc304_mysql/workson and put in your user id and password. Note the URL is not localhost as the JSP file is running in a container that does not contain the MySQL database server.
Modify the sample JSP code for querying WorksOn such that for each department you list its projects and then its employees. The output should look like this (click here).
You can pass and receive parameters between JSP pages. An example is to create an HTML form that collects user input and then passes this information to a JSP file to perform the query and return the answers.
Create your own query form for the WorksOn database. Your form should have boxes for the Employee name and Project name that accept partial matches (using LIKE '%queryString%'). The JSP file should receive the parameters and create a query that lists all WorksOn records where the employee name and project name are as specified. Show the count of the # of records at the bottom of the page. An example query form and system is available.