一个菜鸟的问题

[chunjuan]

请问以下错误是什么意思？



HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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

exception

java.lang.NumberFormatException: For input string: "student"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:426)
at java.lang.Integer.(Integer.java:567)
at Logindenglu.doPost(Logindenglu.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:536)



--------------------------------------------------------------------------------

Apache Tomcat/4.1.29

[duan123]

呢格式化字符串不对

[chunjuan]

要怎样改？

[jackcf]

你的关于student的代码？

[chunjuan]

student是我的登陆用户名

[chunjuan]

我的源程序如下：
//Logindenglu.java
//验证密码,验证是否以参加考试,传送参数

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
import examinline.DBConnectionBean;


public class Logindenglu extends HttpServlet
{
//初始化数据库类
static Connection conn;
DBConnectionBean dbcb = new DBConnectionBean();
//定义doPost方法用来接受数据
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
//定义输出流
req.setCharacterEncoding("gb2312");
res.setContentType("text/html;charset=gb2312");
PrintWriter out = res.getWriter();

//提取表单数据
String DuserID = req.getParameter("DtextID");
String Dpassword = req.getParameter("Dtextpass");
int iDuserID = new Integer(DuserID).intValue();

try
{
//桥接连接数据库

conn = dbcb.getopenConnection();

System.out.println("数据库连接成功....");
//定义sql命令,验证密码
PreparedStatement s = conn.prepareStatement
("select SID,Spassword,Score from allStuday where SID=? and Spassword=?");

s.setInt(1,iDuserID);
s.setString(2,Dpassword);
ResultSet result = s.executeQuery();
boolean rowfound = false;
rowfound = result.next();

System.out.println("发送SQL命令成功....");


if(rowfound==false)
{
System.out.println("用户 " + iDuserID + " 密码验证失败....拒绝登陆....");
out.println("<html>");
out.println("<head>");
out.println("<title>");
out.println("登陆失败");
out.println("</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
out.println("</script>");
out.println("<style type='text/css'>");
out.println("<!--");
out.println(".yangshi {font-family: 'Arial', 'Helvetica', 'sans-serif';font-size: 12px;font-weight: lighter;color:#FFFFFF;padding: 4px;border: 1px solid #6633FF;}");
out.println("-->");
out.println("</style>");
out.println("</head>");
out.println("<body>");
out.println("<table width='75%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#6699FF' class='yangshi'>");
out.println("<tr>");
out.println("<td nowrap>");
out.println("<p>");
out.println("<font color='#FF0000'>");
out.println("对不起, ");
out.println("</font>");
out.println("<font color='#FFFFFF'>");
out.println(DuserID);
out.println("</font>");
out.println("<font color='#FF0000'>");
out.println(" ,登陆失败，您的身份未经许可！");
out.println("</font>");
out.println("</p>");
out.println("<p>");
out.println("<font color='#FF0000'>");
out.println("请");
out.println("<a href='javascript:history.back()'>");
out.println("<font color='#FF7777'>");
out.println("重新登陆");
out.println("</font>");
out.println("</a>");
out.println("检查您的帐号!如果您还未注册，点这里");
out.println("</font>");
out.println("<a href='/myside/examin/zhuce.jsp'>");
out.println("<font color='#FF7777'>");
out.println("马上注册!");
out.println("</font>");
out.println("</a>");
out.println("<font color='#FF0000'>");
out.println("！");
out.println("</font>");
out.println("</p>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</body>");
out.println("</html>");
out.close();
}
//如果通过验证,则查询是否已经参加考试
else if(rowfound==true)
{
int ScoreR = result.getInt(3);
if(ScoreR==0)
{
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv=Content-Type content='text/html; charset=gb2312'>");
out.println("<title>无标题文档</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/fun.js'>");
out.println("</script>");
out.println("</head>");
out.println("<body onLoad=MM_goToURL('parent','/myside/examin/reading.jsp?userID=" + DuserID + "');return document.MM_returnValue>");
out.println("</body>");
out.println("</html>");
out.close();
}


else
{
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
out.println("<title>");
out.println("已答题完毕");
out.println("</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
out.println("</script>");
out.println("<link href='/myside/examin/img/cssexamin.css' rel='stylesheet' type='text/css'>");
out.println("</head>");
out.println("<body>");
out.println("<div align='center'>");
out.println("您的成绩已经存在，请输入您的用户名，以便查询您的成绩!");
out.println("<form name='form1' method='post' action='/myside/examin/loginC.jsp'>");
out.println("I D:");
out.println("<input name='textfield' type='text' value=" + DuserID + " size='15'>");
out.println("<input type='submit' name='Submit' value='提交'>");
out.println("<p>");
out.println("</p>");
out.println("<font color='#666666' class='banquan'>");
out.println("©Copyright  RUSCN (dot) NET China & copy 2001-2003 ™");
out.println("<a href='mailto:[e-mail]'>");
out.println("<font color='#0033FF'>");
out.println("徐春军");
out.println("</font>");
out.println("</a>");
out.println("版权所有");
out.println("</font>");
out.println("</div>");
out.println("</body>");
out.println("</html>");
out.close();
}
}


}
//三个常见异常
catch(SQLException e)
{
System.out.println(e.toString());
}
catch(Exception e)
{
System.out.println(e.toString());
}
}


}

[chunjuan]

//DBConnectionBean.java
//用在jsp网页里的数据库桥接bean
package examinline;
import java.util.*;
import java.sql.*;
import java.io.*;

public class DBConnectionBean{
Connection dbcon=null;
Statement stmt=null;
ResultSet result=null;
String driver="";
String url="";
String user="";
String password="";

public DBConnectionBean(){
try{
InputStream fis =getClass().getResourceAsStream("jdbcsql.properties");
Properties ps=new Properties();
ps.load(fis);
driver=ps.getProperty("driver");
url=ps.getProperty("url");
user=ps.getProperty("username");
password=ps.getProperty("password");
}
catch(Exception e){
System.out.println(e);
}


}
public void setdrivername()
{
try{
Class.forName(this.driver);
System.out.println("加载数据驱动成功!");
}catch(ClassNotFoundException e){
System.out.println("jdbc driver error");
}
}
public Connection getopenConnection(){

try{
this.dbcon=DriverManager.getConnection(this.url,this.user,this.password);
System.out.println("桥接数据库成功!");
}catch(SQLException e2){
System.out.println(e2);
}
return dbcon;
}
public ResultSet executeQuery(String query)throws SQLException{
this.stmt=dbcon.createStatement();
this.result=stmt.executeQuery(query);
return result;
}

public void executeUpdate(String query)throws SQLException{
this.stmt=dbcon.createStatement();
stmt.executeUpdate(query);
if(stmt!=null) stmt.close();
}
public String getData(int index) throws SQLException{
return result.getString(index);
}
public int getIntData(int index) throws SQLException{
return result.getInt(index);
}
public float getFltData(int index) throws SQLException{
return result.getFloat(index);
}
public boolean next() throws SQLException{
return result.next();
}
public void resetResult() throws SQLException{
this.result=null;
}
public void close() throws SQLException{
if(dbcon!=null) dbcon.close();
if(stmt!=null) stmt.close();
if(result!=null) result.close();
}
public void finalize() throws Throwable{
this.close();
}
public String replaceString(String str){

char tempArray[]=str.toCharArray();

int iCurr[]=new int[10];

int j=0;

for(int i=0;i!=tempArray.length;i++)
{
int temp=(int)tempArray[i];
if(temp==92){
iCurr[j]=i;
j++;

}
}

final int temp2=j+1;

String strArray[]=new String[temp2];


strArray[0]=str.substring(0,iCurr[0]);
strArray[temp2-1]=str.substring(iCurr[j-1]+1);

for(int m=1;m!=strArray.length-1;m++){
strArray[m]=str.substring(iCurr[m-1]+1,iCurr[m]);
}
str="";
for(int k=0;k!=strArray.length-1;k++){
str=str+strArray[k]+"%5C";
}
str=str+strArray[temp2-1];
return str;
}

}