I get the follow error when running this script:
An error occurred at line: 24 in the jsp file: /updatePhonebook.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\opdracht4\org\apache\jsp\updatePhonebook_jsp.java:84: unclosed string literal
statement.executeUpdate("INSERT INTO Adressenlijst (\"LAST\", \"FIRST\", \"PHONE\") VALUES
^
An error occurred at line: 24 in the jsp file: /updatePhonebook.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\opdracht4\org\apache\jsp\updatePhonebook_jsp.java:86: unclosed character literal
(' "+lastValue+" ',' "+firstValue+" ',' "+phoneValue+" ')")";
-->>As far as I know this code is correct. What did I do wrong with the single and double quotes????/
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" import="java.util.*" errorPage="" %>
<HTML>
<HEAD><TITLE> Content van database bekijken </TITLE></HEAD>
<BODY>
<P>Database content updaten
<FORM ACTION="updatePhonebook.jsp" METHOD="POST">
Last name : <INPUT TYPE="TEXT" NAME=lastParam><BR>
First name : <INPUT TYPE="TEXT" NAME=firstParam><BR>
Phone numer: <INPUT TYPE="TEXT" NAME=phoneParam><BR>
<INPUT TYPE=Submit VALUE="Add to datababase">
</FORM>
<HR>
<P> Content :
<TABLE BORDER=1 CELLPADDING=0 CelLSPACING = 0>
<TD><TD> Last </TD>
<TD><TD> First </TD>
<TD><TD> Phone </TD>
</TR>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbc:odbc:Henk");
Statement statement = connection.createStatement();
Enumeration parameters = request.getParameterNames();
if(parameters.hasMoreElements()) {
String lastValue = request.getParameter("lastParam");
String firstValue = request.getParameter("firstParam");
String phoneValue = request.getParameter("phoneParam");
statement.executeUpdate("INSERT INTO Adressenlijst (\"LAST\", \"FIRST\", \"PHONE\") VALUES
(' "+lastValue+" ',' "+firstValue+" ',' "+phoneValue+" ')")";
}
ResultSet columns = statement.executeQuery (
"SELECT * FROM Adressenlijst");
while(columns.next()) {
String last = columns.getString("LAST");
String first = columns.getString("FIRST");
String phone = columns.getString("PHONE"); %>
<TR> <TD> <%= last %> </TD>
<TR> <TD> <%= first %> </TD>
<TR> <TD> <%= phone %> </TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>