Java-index >> Java Essentials >> Java Programming

JSP Problems

hi all

[13 byte] By [Sehama] at [2007-11-26 22:16:30]

«« JProgressBar and my thread
»» Managing a synchronous event

# 1

hello, like you, i've got lots of JSP problems.. could you please help me?

suparenoa at 2007-7-10 11:09:49 >

top of Java-index,Java Essentials,Java Programming...

# 2

well, I have posted that message because I have JSP problems myself,so can anyone help me please.

Sehama at 2007-7-10 11:09:49 >

# 3

Well I think everybody believes you posted your message by mistake and you will soon post a real question that can be answered ...

quittea at 2007-7-10 11:09:49 >

# 4

I am trying to read records from postgresql in JSP page and store the records in a vector. and store this vector in a session.

the values of this session will be dislpyed in another JSP page where session.getValue(vector) is called to display the DB records.

but every time I try to run the JSP pages I got erros.

can anyone help me please beacause its part of my final year project.

Here is the code for the two pages:

first JSP (LaptopsListings.jsp)

<%@ page import="java.sql.*" %>

<%@ page import="java.io.*" %>

<%@ page session= "true" import="java.util.*, seham.Laptops" %>

<html>

<head><title> Laptops page </tilte></html>

<body>

Connection conn = null;

Statement stmt = null;

String query;

ResultSet rs= null;

HttpSessionsession;

try{

Class.forName("org.postgresql.Driver");

conn = DriverManager.getConnection("jdbc:postgresql:shopdb","postgres","07101981");

stmt = conn.createStatement();

query = "SELECT * FROM laptops";

Vector records = new Vector();

rs = stmt.executeQuery(query);

Laptops laptop ;

while( rs.next() ){

laptop = new Laptops( rs.getString( 1 ), rs.getString( 2 ),Integer.parseInt(rs.getString( 3 )),Integer.parseInt(rs.getString( 4 ));

records.add(laptop);

session.putValue("ShopLaptops", records);

rs.close();

stmt.close();

}

}catch(ClassNotFoundException cnf){

out.println(cnf.toString());

}catch(SQLException sql){

out.println(sql);

}

</form>

</body>

</html>

the second JSP(DisplayListingLaptops.jsp)

<%@ page import="java.sql.*" %>

<%@ page import="java.io.*" %>

<%@ page session= "true" import="java.util.*, seham.Laptops" %>

Vector LaptopsList = (Vector)session.getValue("ShopLaptops");

if (LaptopsList != null && (LaptopsList.size()> 0)) {

<HTML>

<HEAD>

<TITLE>Laptops List</TITLE>

</HEAD>

<H1>Laptops For Sale</H1>

for (int index = 0; index < LaptopsList.size(); index++){

Laptops laptop ;

laptop = (Laptops)LaptopsList.elementAt(index);

<tr>

<td>

<form name="BUY"

action="http://localhost:8080/myServlets/servlet/ShoppingCartController1"

method="POST">

</form> </td>

</tr>

}// end for

</table>

</center>

} //end if

</body>

</html>

here is the errors that I got:

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp

Generated servlet error:

Syntax error, insert ")" to complete Expression

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp

Generated servlet error:

Syntax error, insert ")" to complete Expression

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)

org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)

org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)

org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)

org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Sehama at 2007-7-10 11:09:49 >

# 5

I am trying to read records from postgresql in JSP page and store the records in a vector. and store this vector in a session. the values of this session will be dislpyed in another JSP page where session.getValue(vector) is called to display the DB records. but every time I try to run the JSP pages I got erros. can anyone help me please beacause its part of my final year project. Here is the code for the two pages:

first JSP (LaptopsListings.jsp) <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page session= "true" import="java.util.*, seham.Laptops" %> <html> <head><title> Laptops page </tilte></html> <body> <% Connection conn = null; Statement stmt = null; String query ; ResultSet rs = null; HttpSession session; try{ Class.forName("org.postgresql.Driver"); conn = DriverManager.getConnection("jdbc:postgresql:shopdb","postgres","07101981"); stmt = conn.createStatement(); query = "SELECT * FROM laptops"; Vector records = new Vector(); rs = stmt.executeQuery(query); Laptops laptop ; while( rs.next() ){ laptop = new Laptops( rs.getString( 1 ), rs.getString( 2 ),Integer.parseInt(rs.getString( 3 )),Integer.parseInt(rs.getString( 4 )); records.add(laptop); session.putValue("ShopLaptops", records); rs.close(); stmt.close(); } }catch(ClassNotFoundException cnf){ out.println(cnf.toString()); }catch(SQLException sql){ out.println(sql); } %> <form action="http://localhost:8080/jsp-examples/admin/DisplayLaptopsListing.jsp" method="post"> <input type="submit" value="Show Laptops"> </form> </body> </html> the second JSP(DisplayListingLaptops.jsp) <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page session= "true" import="java.util.*, seham.Laptops" %> <% Vector LaptopsList = (Vector)session.getValue("ShopLaptops"); if (LaptopsList != null && (LaptopsList.size()> 0)) { %> <HTML> <HEAD> <TITLE>Laptops List</TITLE> </HEAD> <BODY BGCOLOR= "#FDF5E6" > <center> <H1>Laptops For Sale</H1> <table border="0" cellpadding="0" width="100%" bgcolor="#FDF5E6"> <% for (int index = 0; index < LaptopsList.size(); index++){ Laptops laptop ; laptop = (Laptops)LaptopsList.elementAt(index); <tr> <td><b><%= laptop.getLaptop_id() %></b></td> <td><b><%= laptop.getLaptopDesc() %></b></td> <td><b><%= laptop.getLaptopQuantity() %></b></td> <td><b><%= laptop.getLaptopPrice() %></b></td> <td> <form name="BUY" action="http://localhost:8080/myServlets/servlet/ShoppingCartController1" method="POST"> <input type="submit" value="BUY"> <input type="hidden" name= "index" value='<%= index %>'> <input type="hidden" name="action" value="BUY"> </form> </td> </tr> <% }// end for %> </table> </center>

<% } //end if %> </body> </html> here is the errors that I got: org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp Generated servlet error: Syntax error, insert ")" to complete Expression org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) root cause org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp Generated servlet error: Syntax error, insert ")" to complete Expression org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414) org.apache.jasper.compiler.Compiler.compile(Compiler.java:297) org.apache.jasper.compiler.Compiler.compile(Compiler.java:276) org.apache.jasper.compiler.Compiler.compile(Compiler.java:264) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

I would really appreiate your help.

Sehama at 2007-7-10 11:09:49 >

# 6

> Well I think everybody believes you posted your

> message by mistake and you will soon post a real

> question that can be answered ...

I'm losing belief actually (although he's trying hard)

Seham, please surround your code with [code] and [/code] tags, as explained in the [url=http://forum.java.sun.com/help.jspa?sec=formatting]Formatting tips[/url].

TimTheEnchantora at 2007-7-10 11:09:49 >

# 7

Please use code tags when posting code.

There are several mistakes concerning the HTML code, but this is a minor problem. Some things I found:

- In the session object, setValue() and getValue() have been deprecated and replaced by setAttribute() and getAttribute()

- There's a closing bracket ")" missing at the end of this line:

laptop = new Laptops( rs.getString( 1 ), rs.getString( 2 ),Integer.parseInt(rs.getString( 3 )),Integer.parseInt(rs.getString( 4 )));

- Afaics, you close both ResultSet and Statement inside the query loop; this should be done after the loop

<%@ page import="java.sql.*" %>

<%@ page import="java.io.*" %>

<%@ page session= "true" import="java.util.*, seham.Laptops" %>

<html>

<head><title> Laptops page </tilte>

</html>

<body>

Connection conn = null;

Statement stmt = null;

String query ;

ResultSet rs = null;

HttpSession session;

try{

Class.forName("org.postgresql.Driver");

conn = DriverManager.getConnection("jdbc:postgresql:shopdb","postgres","07101981");

stmt = conn.createStatement();

query = "SELECT * FROM laptops";

Vector records = new Vector();

rs = stmt.executeQuery(query);

Laptops laptop ;

while( rs.next() ){

laptop = new Laptops( rs.getString( 1 ), rs.getString( 2 ),Integer.parseInt(rs.getString( 3 )),Integer.parseInt(rs.getString( 4 ));

records.add(laptop);

session.putValue("ShopLaptops", records);

rs.close();

stmt.close();

}

catch(ClassNotFoundException cnf){

out.println(cnf.toString());

}

catch(SQLException sql){

out.println(sql);

} %>

</form>

</body>

</html>

the second JSP(DisplayListingLaptops.jsp)

<%@ page import="java.sql.*" %>

<%@ page import="java.io.*" %>

<%@ page session= "true" import="java.util.*, seham.Laptops" %>

Vector LaptopsList = (Vector)session.getValue("ShopLaptops");

if (LaptopsList != null && (LaptopsList.size()> 0)) {

<HTML>

<HEAD> <TITLE>Laptops List</TITLE> </HEAD>

<H1>Laptops For Sale</H1>

for (int index = 0; index < LaptopsList.size(); index++){

Laptops laptop ;

laptop = (Laptops)LaptopsList.elementAt(index);

<tr>

</form>

</td>

</tr>

}// end for

</table>

</center>

} //end if

</body>

</html>

quittea at 2007-7-10 11:09:49 >

# 8

Hi,

I have corrected the code as you have explained but I got another two errors:

I am so happy with your help

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp

Generated servlet error:

Duplicate local variable session

An error occurred at line: 12 in the jsp file: /admin/LaptopsListing.jsp

Generated servlet error:

The constructor Laptops(String, String, int, int) is undefined