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 .