****太奇怪的问题!****我的最后30分奉上!虽有点少!但我有诚意!
这个程序昨天用还好使
为什么今天就有这样的错误!
表单提交的代码如下<%@ page language="java" import="java.sql.*"%>
<%@ page import ="java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>user register</title>
</head>
<body>
<%
String userid=request.getParameter("userid");
String password=request.getParameter("password");
String confirm_password=request.getParameter("confirm_password");
String question=request.getParameter("question");
String answer=request.getParameter("answer");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String literacy=request.getParameter("literacy");
String mail=request.getParameter("mail");
String aihao=request.getParameter("aihao");
byte[] tmpbyte=userid.getBytes("ISO8859_1");
userid=new String(tmpbyte);
tmpbyte=password.getBytes("ISO8859_1");
password=new String(tmpbyte);
tmpbyte=confirm_password.getBytes("ISO8859_1");
confirm_password=new String(tmpbyte);
tmpbyte=question.getBytes("ISO8859_1");
question=new String(tmpbyte);
tmpbyte=answer.getBytes("ISO8859_1");
answer=new String(tmpbyte);
tmpbyte=name.getBytes("ISO8859_1");
name=new String(tmpbyte);
tmpbyte=literacy.getBytes("ISO8859_1");
literacy=new String(tmpbyte);
tmpbyte=aihao.getBytes("ISO8859_1");
aihao=new String(tmpbyte);
%>
<%
if((userid.length()==0)||(password.length()==0)||(confirm_password.length()==0))
out.println("登录名,密码,及密码校验不能为空!");
else if ((question.length()==0)||(answer.length()==0))
out.println("密码遗失提示问题及答案不能为空!");
else if (!password.equals(confirm_password))
out.println("密码与确认密码不一致!");
else if( mail.length()==0)
out.println("E-MAIL不能为空!");
else if(mail.indexOf('@')<=0)
out.println("EMAIL 地址有错误!");
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:nn";
Connection con=DriverManager.getConnection(url);
PreparedStatement select_stm=con.prepareStatement("select password from nn where userid=?");
select_stm.setString(1,userid);
ResultSet result=select_stm.executeQuery();
String temp_password=null;
if(result.next())
temp_password=result.getString(1);
result.close();
if (temp_password!=null)
out.println("这个用户名已存在,请再换一个名字注册!");
else
{ String sqlstr="select *from nn";
Statement stmt=con.createStatement();
sqlstr="insert into nn(userid,password,confirm_password,question,answer,name,sex,mail,literacy,aihao) values('"+userid+"','"+password+"','"+confirm_password+"', '"+question+"','"+answer+"','"+name+"','"+sex+"','"+mail+"','"+literacy+"','"+aihao+"')";
stmt.executeUpdate(sqlstr);
stmt.close();
}
%>
<%@ include file="succeed.jsp" %>
<%
}catch (Exception e){out.println(e);}
}
%>
</body>
</html>
****************************************************************************
错误是
500 Internal Server Error
/kk/register_action.jsp:
null
java.lang.NullPointerException
at jrun__kk__register_action2ejsp17._jspService(jrun__kk__register_action2ejsp17.java:69)
at allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:40)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at allaire.jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:34)
at allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:174)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:925)
at allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:88)
at allaire.jrun.servlet.JRunSE.service(JRunSE.java:1131)
at allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:330)
at allaire.jrun.http.WebEndpoint.run(WebEndpoint.java:107)
at allaire.jrun.ThreadPool.run(ThreadPool.java:267)
at allaire.jrun.WorkerThread.run(WorkerThread.java:74)
***********************************************************************
哪位高手帮帮忙!
感激万分!