hi everybody,
i spent my whole afternoon with a stupid
numberformat exception.
at last i gave up,and decided to bring
here.
can someone help me with this please, or I
will get crazy.
i am using tomcat 4 on windows 2000.
this jsp file takes a request parameter no, which
is an integer.
but it seems that it can't receive or read this
parameter correctly.
i call this jsp from my from browser as
:
but i always have the same exception (
numberformat exception)
below is my code:
<%@ page language="java" contentType="text/html;
charset=BIG5" %>
<%@ page
import="java.sql.*,java.util.*,org.gjt.mm.mysql.*"
%>
<HTML><HEAD><TITLE>NEWS</TITLE>
<META
content="text/html; charset=big5"
http-equiv=Content-Type>
</HEAD>
<BODY bgColor=pink
leftMargin=0 text=#000000 topMargin=0 marginheight='0'
marginwidth='0'><BR>
<%! Connection
conn;
String
ndate,subject,news;
int
no;
Statement
stmt;
ResultSet
rs;
String sql;
%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
if
((request.getParameter("no")!=null)&&
(request.getParameter("no")!="")){
try {
conn =
DriverManager.getConnection("jdbc:mysql:///yilmaz");
no=Integer.parseInt(request.getParameter("no"));
sql="select ndate,subject,news from new"+no;
stmt
= conn.createStatement (sql);
rs = stmt.executeQuery
();
while (rs.next() ) {
ndate=rs.getString(1);
out.println(ndate);
subject=rs.getString(2);
out.println(subject);
news=rs.getString(3);
out.println(news);
}
}
catch
(SQLException e) {
out.println("SQLException caught "+
e.getMessage());
e.printStackTrace();
}
catch (NumberFormatException nfe)
{
out.println("NumberFormatException caught
"+nfe.getMessage());
}
finally
{
rs.close();
stmt.close();
conn.close();
} }
%>
****************************************************
the whole other followings are normal html
code
****************************************************
when i run my JSP it throws :
org.apache.jasper.JasperException: Unable to
compile class for JSP
...
root cause :
java.lang.NumberFormatException: mysql
at
java.lang.Integer.parseInt(Integer.java:414)
at
java.lang.Integer.parseInt(Integer.java:463)
...
********************************
I AM LOOKING FORWARD TO YOUR HELP OR
SUGGESTIONS
THANKS A LOT IN
ADVANCE
