Lately, I've been having problems with JSP coding. I get the error message:
Generated servlet error:
C:\Apache Tomcat 4.0\work\localhost\_\jsp\add_0005fres$jsp.java:97: String not terminated at end of line.
String Query = "INSERT INTO abook (id, uid, fname, lname, tel, fax, email,
^
An error occured between lines: 10 and 65 in the jsp file: /jsp/add_res.jsp
Generated servlet error:
C:\Apache Tomcat 4.0\work\localhost\_\jsp\add_0005fres$jsp.java:98: ';' expected.
addr, company, comment) VALUES (NULL, '" + uid + "', '" + fname + "', '" +
^
An error occured between lines: 10 and 65 in the jsp file: /jsp/add_res.jsp
Generated servlet error:
C:\Apache Tomcat 4.0\work\localhost\_\jsp\add_0005fres$jsp.java:98: Invalid character constant.
addr, company, comment) VALUES (NULL, '" + uid + "', '" + fname + "', '" +
^
An error occured between lines: 10 and 65 in the jsp file: /jsp/add_res.jsp
Generated servlet error:
C:\Apache Tomcat 4.0\work\localhost\_\jsp\add_0005fres$jsp.java:98: Invalid character constant.
addr, company, comment) VALUES (NULL, '" + uid + "', '" + fname + "', '" +
^
An error occured between lines: 10 and 65 in the jsp file: /jsp/add_res.jsp
Generated servlet error:
C:\Apache Tomcat 4.0\work\localhost\_\jsp\add_0005fres$jsp.java:98: Invalid character constant.
addr, company, comment) VALUES (NULL, '" + uid + "', '" + fname + "', '" +
^
........
add.jsp
..........
<%@ page contentType="text/html;charset=windows-1252"%>
<html>
<head>
<basefont face="Arial">
</head>
<body>
<center>
<h2>Add Address Book Entry</h2>
<table border=0 cellspacing=5 cellpadding=5>
<form action="add_res.jsp" method="POST">
<tr>
<td><b>Username</b></td>
<td>
<select name="uid">
<!-- generate list of available usernames from database -->
<%@ page language="java" import="java.sql.*" %>
<%
// database parameters
String host="localhost";
String user="root";
String pass="";
String db="abook";
String connString;
// load driver
Class.forName("org.gjt.mm.mysql.Driver");
// create connection string
connString = "jdbc:mysql://" + host + "/" + db + "?user=" + user +
"&password=" +
pass;
// pass database parameters to JDBC driver
Connection Conn = DriverManager.getConnection(connString);
// query statement
Statement SQLStatement = Conn.createStatement();
// generate query
String Query = "SELECT DISTINCT uid FROM abook";
// get result
ResultSet SQLResult = SQLStatement.executeQuery(Query);
// get and display each record
while(SQLResult.next())
{
String UId = SQLResult.getString("uid");
out.println("<option>" + UId);
}
// close connections
SQLResult.close();
SQLStatement.close();
Conn.close();
%>
</select>
</td>
</tr>
<tr>
<td>First name</td>
<td><input type="Text" name="fname" size="15"></td>
</tr>
<tr>
<td>Last name</td>
<td><input type="Text" name="lname" size="15"></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="address"></textarea></td>
</tr>
<tr>
<td>Tel</td>
<td><input type="Text" name="tel" size="10"></td>
</tr>
<tr>
<td>Fax</td>
<td><input type="Text" name="fax" size="10"></td>
</tr>
<tr>
<td>Email address</td>
<td><input type="Text" name="email" size="10"></td>
</tr>
<tr>
<td>Company</td>
<td><input type="Text" name="company" size="25"></td>
</tr>
<tr>
<td>Comment</td>
<td><input type="Text" name="comment" size="25"></td>
</tr>
<tr>
<td colspan=2><input type="submit" name="submit" value="Add"></td>
</tr>
</form>
</table>
</center>
</body>
</html>
..........
add_res.jsp
<%@ page contentType="text/html;charset=windows-1252"%>
<html>
<head>
<basefont face="Arial">
</head>
<body>
<center>
<h2>Add Address Book Entry</h2>
<table border=0 cellspacing=5 cellpadding=5>
<form action="add_res.jsp" method="POST">
<tr>
<td><b>Username</b></td>
<td>
<select name="uid">
<!-- generate list of available usernames from database -->
<%@ page language="java" import="java.sql.*" %>
<%
// database parameters
String host="localhost";
String user="root";
String pass="";
String db="abook";
String connString;
// load driver
Class.forName("org.gjt.mm.mysql.Driver");
// create connection string
connString = "jdbc:mysql://" + host + "/" + db + "?user=" + user +
"&password=" +
pass;
// pass database parameters to JDBC driver
Connection Conn = DriverManager.getConnection(connString);
// query statement
Statement SQLStatement = Conn.createStatement();
// generate query
String Query = "SELECT DISTINCT uid FROM abook";
// get result
ResultSet SQLResult = SQLStatement.executeQuery(Query);
// get and display each record
while(SQLResult.next())
{
String UId = SQLResult.getString("uid");
out.println("<option>" + UId);
}
// close connections
SQLResult.close();
SQLStatement.close();
Conn.close();
%>
</select>
</td>
</tr>
<tr>
<td>First name</td>
<td><input type="Text" name="fname" size="15"></td>
</tr>
<tr>
<td>Last name</td>
<td><input type="Text" name="lname" size="15"></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="address"></textarea></td>
</tr>
<tr>
<td>Tel</td>
<td><input type="Text" name="tel" size="10"></td>
</tr>
<tr>
<td>Fax</td>
<td><input type="Text" name="fax" size="10"></td>
</tr>
<tr>
<td>Email address</td>
<td><input type="Text" name="email" size="10"></td>
</tr>
<tr>
<td>Company</td>
<td><input type="Text" name="company" size="25"></td>
</tr>
<tr>
<td>Comment</td>
<td><input type="Text" name="comment" size="25"></td>
</tr>
<tr>
<td colspan=2><input type="submit" name="submit" value="Add"></td>
</tr>
</form>
</table>
</center>
</body>
</html>
I appreciate any help on this. Thanks .
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Problems in JSP
Linear Mode
