|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
June 20th, 2002, 08:17 AM
|
|||
|
|||
Problems in JSP
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 .
|
|
| Viewing: Dev Shed Forums > Programming Languages > Java Help > Problems in JSP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
