help me with this " numberformat exception" please

Thu, 18 Oct 2001 05:27:40 -0700

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

Reply via email to