Why won't stick in out statement ?

Thread view:

Andrew Rich - 18 Feb 2005 11:39 GMT

My java keeps saying that the is unterminated

Why ?

It is just a string

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<jsp:directive.page import="java.sql.*" />
<HTML>
<HEAD>
<TITLE>JDBC scriptlet example</TITLE>
</HEAD>
<BODY>
<jsp:scriptlet>
Class.forName("com.mysql.jdbc.Driver");
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost:3306/smtrack", "", "");
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("select region from
sm04022005");
int numCols = rs.getMetaData().getColumnCount ();
while (rs.next())
{
out.print(" Region=" + rs.getString("region") + " ");
}
statement.close();
connection.close();
</jsp:scriptlet>
<jsp:expression>numCols</jsp:expression>
</BODY>
</HTML>

Reply to this Message

Andrew Rich - 18 Feb 2005 12:01 GMT

while (rs.next())
{
<![CDATA[
out.print(" Region=" + rs.getString("region") + " ");
]]>
}

fixed it

My java keeps saying that the is unterminated

Why ?

It is just a string

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<jsp:directive.page import="java.sql.*" />
<HTML>
<HEAD>
<TITLE>JDBC scriptlet example</TITLE>
</HEAD>
<BODY>
<jsp:scriptlet>
Class.forName("com.mysql.jdbc.Driver");
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost:3306/smtrack", "", "");
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("select region from
sm04022005");
int numCols = rs.getMetaData().getColumnCount ();
while (rs.next())
{
out.print(" Region=" + rs.getString("region") + " ");
}
statement.close();
connection.close();
</jsp:scriptlet>
<jsp:expression>numCols</jsp:expression>
</BODY>
</HTML>

Reply to this Message

Why won't <BR> stick in out statement ?

Free Magazines