Please Help!

Get Started
1

I get an error message:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /addtocart.jsp:74

71: statement.setString(2,request.getParameter(“itemid”));
72: statement.setString(3,request.getParameter(“quantity”));
73: statement.setString(4,request.getParameter(“price”));
74: statement.executeUpdate();
75: connection.close();
76: %>
77:

Here’s code:

<%
HttpSession ViewProtectedPage = request.getSession();

if (ViewProtectedPage.getValue("password")!="correct")
{
	response.sendRedirect("accessdenied.jsp");
}
%>

    <html>.....<body>
<h1>Added To Basket!</h1>
<P>Congratulations <span><%= request.getParameter("username") %>!</span></p>

<p>You have succesfully added Item <span>No <%= request.getParameter("itemid") %></span> to your basket!</p>
<p> Quantity: <span><%= request.getParameter("quantity") %></span></p>
<p> Price: <span>&pound;<%= request.getParameter("price") %></span></p>
<br />
<p>Thank you!</p>

<%
String connectionURL = "jdbc:mysql://localhost:3306/xxxxxx"; 
Class.forName("com.mysql.jdbc.Driver").newInstance();
java.sql.Connection connection = java.sql.DriverManager.getConnection(connectionURL, "xxxxxx", "xxxxx");


String query = "INSERT INTO orders (username, itemid, quantity, price) VALUES (?,?,?,?)";
java.sql.PreparedStatement statement = connection.prepareStatement(query);
statement.setString(1,request.getParameter("username"));
statement.setString(2,request.getParameter("itemid"));
statement.setString(3,request.getParameter("quantity"));
statement.setString(4,request.getParameter("price"));
statement.executeUpdate();
connection.close();
%>
				
</div>

<div>
<p><a href="viewcart.jsp">Click here to view your basket</a></p>
</div>


</body>
</html>