<%@page contentType="text/html;charset=GB2312"%>
<%@ include file="incdb.jsp"%>
<%@ page import="java.text.*"%>
<jsp:useBean id="user" class="test.bbsuser" scope="page"/>
<%
int userid,userclass;
String username,userpassword,useremail,userhomepage,hpname,usersex,comefrom,usersign;
java.util.Date dateandtime,userbirthday;
String strSQL;
byte[] tmpbyte;
java.sql.ResultSet sqlRst;
String B1=request.getParameter("B1");
String tempSTR;
%>
<html>
<head>
<title>用户注册</title>
<link rel="stylesheet" type="text/css" href="bbs03.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<script Language="JavaScript">
<!--
function isspacestring(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=true;
strlen=istring.length;
for (i=0;i<strlen;i++)
{
if ((istring.substring(i,i+1)!=" ")&(temp))
{ temp=false; }
}
return temp;
}
function firstisspace(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=false;
if (istring.substring(0,1)==" ")
{ temp=true; }
return temp;
}
function isemail(mystring)
{
var istring=mystring;
var atpos=mystring.indexOf("@");
var temp=true;
if (atpos==-1) //email中没有@符号；不正确的EMAIL
{
temp=false;
}
return temp;
}
function check_input(theForm)
{
if ((theForm.username.value == "")|(firstisspace(theForm.username.value)))
{
alert("请输入用户名.不能以空格开头");
theForm.username.focus();
return (false);
}
if (theForm.username.value.length > 20)
{
alert("用户名长度应小于20个字符或数字.");
theForm.username.focus();
return (false);
}
if ((theForm.userpassword.value == "")|(isspacestring(theForm.userpassword.value)))
{
alert("请输入密码.");
theForm.userpassword.focus();
return (false);
}
if (theForm.userpassword.value.length > 10)
{
alert("密码长度应小于10.");
theForm.user_password.focus();
return (false);
}
if (theForm.userpassword.value != theForm.userpassword2.value)
{
alert("两次密码不相同,请重新输入密码.");
theForm.userpassword.focus();
return (false);
}
return (true);
}
//-->
</script>
<div align="center">
<table border="1" width="600" bordercolorlight="#000000" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF">
<tr>
<td width="600" align="center">
<form method="post" action="registry.jsp" onsubmit="return check_input(this)" name="registry">
<p align="center" style="margin-top: 0; margin-bottom: 0"><b><font size="4"><br>
新 用 户 注 册 </font></b>*不能为空</p>
<center>
<div align="center">
<center>
<table border="0" width="95%" height="85">
<tr>
<td width="540" height="41">
<p style="margin-top: 0; margin-bottom: 0">用 户 名:<input class="intext" type="text" name="username" size="20" > <font color="#FF0000">*</font>
密 码:<input class="intext" type="password" name="userpassword" size="10"><font color="#FF0000">*</font>
重复密码:<input class="intext" type="password" name="userpassword2" size="10"><font color="#FF0000">*</font>
</p>
<p style="margin-top: 0; margin-bottom: 0">E_MAIL <input class="intext" type="text" name="useremail" size="30">
<p style="margin-top: 0; margin-bottom: 0">HOMEPAGE: <input class="intext" type="text" name="userhomepage" size="50" value="http://">
</p>
<p style="margin-top: 0; margin-bottom: 0">主页名称:<input class="intext" type="text" name="hpname" size="20">
</p>
<p style="margin-top: 0; margin-bottom: 0">生 日:<input class="intext" type="text" name="userbirthday" size="11" value="99-05-26"> 格式:yy-mm-dd <br>
性 别:<input type="radio" value="男" name="usersex" checked>男<input type="radio" value="女" name="usersex">女
来 自:<input class="intext" type="text" name="comefrom" size="20">
</p>
<p style="margin-top: 0; margin-bottom: 0">签名:
</p>
<p style="margin-top: 0; margin-bottom: 0"><textarea class="intext" rows="4" name="usersign" cols="36"></textarea>
<input class="buttonface" type="submit" value="好啦" name="B1">
<input class="buttonface" type="reset" value="重填" name="B2">
</p>
</td>
</tr>
</table>
</center>
</div>
</form>
</center>
</td>
</tr>
</table>
</div>
<%if (B1!=null){
//**********************************************************
username=request.getParameter("username");
userpassword=request.getParameter("userpassword");
useremail=request.getParameter("useremail");
userhomepage=request.getParameter("userhomepage");
hpname=request.getParameter("hpname");
usersex=request.getParameter("usersex");
comefrom=request.getParameter("comefrom");
userclass=0;
usersign=request.getParameter("usersign");
dateandtime=new java.util.Date();
userbirthday=new java.util.Date();
username=username.trim();
useremail=useremail.trim();
userpassword=userpassword.trim();
userhomepage=userhomepage.trim();
hpname=hpname.trim();
comefrom=comefrom.trim();
tmpbyte=username.getBytes("ISO8859_1");//编码后写入数据库
username=new String(tmpbyte);
tmpbyte=usersex.getBytes("ISO8859_1");
usersex=new String(tmpbyte);
tmpbyte=hpname.getBytes("ISO8859_1");
hpname=new String(tmpbyte);
tmpbyte=comefrom.getBytes("ISO8859_1");
comefrom=new String(tmpbyte);
tmpbyte=usersign.getBytes("ISO8859_1");
usersign=new String(tmpbyte);
//**********************************************************
if (user.getUserInfo(username)) {
%>
<div align="center">
<center>
<table border="0" width="300">
<tr>
<td width="540" align="center">
<p><font size="7" color="#FF0000" face="Copperplate Gothic Bold">error</font>
</p>
<p><font size="4" face="华文新魏">重名！请重新确定用户名！</font></p>
<p>
<!--
<form method="GET" action="registry.jsp">
<p><input type="submit" value="返回" name="B1"></p>
</form>
-->
</td>
</tr>
</table>
</center>
</div>
<%
}else
//新用户注册
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Success loading JDBC-ODBC Bridge Driver...");
}
catch(Exception e){
System.out.println("Error loading JDBC-ODBC Bridge Driver...");
e.printStackTrace();
}
try{
Connection con1 = DriverManager.getConnection("jdbc:odbc:bbs01","","");
System.out.println("Success eastablishing the Connection....");
Statement stmt1 = con1.createStatement();
ResultSet rs1 = stmt1.executeQuery("select * from user");
stmt1.executeUpdate(
"insert into user values ('"+username+"','"+userpassword+"','"+useremail+"','"+userhomepage+"','"
+hpname+"','"+usersex+"','"+comefrom+"','"+userclass+"','"+usersign+"')" );
}
catch(SQLException e){
e.printStackTrace();
}
%>
<div align="center">
<center>
<table border="0" width="300">
<tr>
<td width="540" align="center"><font color="#0000FF" face="Copperplate Gothic Bold" size="6">congratulation</font>
<p>注册成功！！</p>
<div align="center">
<center>
<table border="0" width="300">
<tr>
<td width="200" align="right">用户名:</td>
<td width="300"><%=username%></td>
</tr>
<tr>
<td width="200" align="right">密码:</td>
<td width="300"><%=userpassword%></td>
</tr>
<tr>
<td width="200" align="right">EMAIL:</td>
<td width="300"><%=useremail%></td>
</tr>
<tr>
<td width="200" align="right">homepage:</td>
<td width="300"><%=userhomepage%></td>
</tr>
<tr>
<td width="200" align="right">主页名称:</td>
<td width="300"><%=hpname%></td>
</tr>
<tr>
<td width="200" align="right">birthday:</td>
<td width="300"><%=userbirthday%></td>
</tr>
<tr>
<td width="200" align="right">性别:</td>
<td width="300"><%=usersex%></td>
</tr>
<tr>
<td width="200" align="right">来自:</td>
<td width="300"><%=comefrom%></td>
</tr>
<tr>
<td width="200" align="right">jointime:</td>
<td width="300"><%=dateandtime%></td>
</tr>
<tr>
<td width="200" align="right">积分</td>
<td width="300"><%=userclass%></td>
</tr>
<tr>
<td width="200" align="right">签名:</td>
<td width="300"></td>
</tr>
<tr>
<td width="500" align="right" colspan="2"><%=usersign%></td>
</tr>
<tr>
<td width="200" align="right"></td>
<td width="300"><a href="index.htm" target="_top">进入论坛</a></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<%
} //else
//if (B1!=null)
%>
</body>
</html>
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
test.bbsuser.getUserInfo(bbsuser.java:63)
org.apache.jsp.registry_jsp._jspService(registry_jsp.java:263)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
[此贴子已经被作者于2005-10-29 16:22:16编辑过]
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
计算机技术与应用 → 『 Java/Eclipse 』 → 救命,只有高手才能解决的...
(订阅本版)
2005/10/29 1:43:00
新浪微博
救命,只有高手才能解决的...
