JSP PAGE
<%
String xaccode;
String xuid,xupas;
xuid=request.getParameter("uid");
xupas=request.getParameter("upass");
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:Track","","");
String s="SELECT accode FROM USERDTL WHERE
ID='"+xuid+"'AND PASS='"+xupas+"'";
Statement stm=null;
stm = conn.createStatement();
ResultSet r=stm.executeQuery(s);
if(r.next())
{
String xacode=r.getString("ACCODE");
String st="SELECT CN_NO,DEST_FROM,DEST_TO,AMOUNT
FROM cninfo WHERE ACCODE='"+xacode+"'";
Statement stmt=null;
stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(st);
out.println("<BODY BGCOLOR=\"#FDF5E6\">\n" +
"<TABLE BORDER=1 ALIGN=CENTER>\n" +
"<TR BGCOLOR=\"#FFAD00\">\n" +
" <TH> Consignment No. <TH> Dest. From <TH> Dest. To
<TH> Amount \n" +
"<TR>\n" );
while(rs.next())
{
out.println("<TR><TD>" %>+// ERROR1 :An error occurred at
line: 64 in the jsp file: /uid.jsp
Syntax error, insert ")" to complete
MethodInvocation
// ERROR 2 :An error occurred at line:
64in the jsp file: /uid.jsp
Syntax error, insert ";" to complete
BlockStatements
// ERROR 3 :An error occurred at line: 64
in the jsp file: /uid.jsp
Syntax error on token ";", assert expected
after this token
<a href="javascript:void(0);" style="text-decoration: none;"
onclick="javascript:window.open
('/test2.jsp','blank','width=900,height=650')"> + rs.getString
("CN_NO") + </a>+
<% +"<TD>" +rs.getString("DEST_FROM")+"<TD>"
+rs.getString("DEST_TO")+"<TD>" +rs.getInt("AMOUNT"));
//ERROR 4: An error occurred at line: 66 in the jsp
file: /uid.jsp
Syntax error on token ")", delete this token
}
} else {
out.println("Sorry!!!! login failed" ); }
}
catch(Exception exc)
{out.println(exc.toString()+"<br>");}
%>
