1:index.jsp
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"errorPage=""%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2321">
<title>我的首页</title>
</head>
<body>
<table width="80%" align="center">
<tr>
<form method="post" name="form1" action="login.jsp">
<td width="79%">
用户名:<input type="text" name="username" size="7">
密码:<input type="password" name="pword" size="7">
<input name="button1" type="submit" value="登录">
<a href="reg.jsp">注册</a>
</td>
</form>
<td width="21%"><div align="right"><a href="exit.jsp">退出
</a></div></td>
</tr>
</table>
</body>
</html>
2:login.jsp
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2321">
<title>登陆页面</title>
</head>
<body>
<%!String User_Name,User_Password,sql;%>
<%!Connection conn;%>
<%!ResultSet rs;%>
<%!Statement stmt;%>
<%
User_Name=request.getParameter("username");
User_Name=new String(User_Name.getBytes("ISO-8859-1"));
User_Password=request.getParameter("pword");
if((User_Name.equals(""))||(User_Password.equals("")))
{
response.sendRedirect("err.jsp?id=2");
}
else
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:abbs","",""); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select * from user where name='"+User_Name+"'and password='"+User_Password+"'";
rs=stmt.executeQuery(sql);
rs.first();
if(rs.getRow()<=0)
{
response.sendRedirect("err.jsp?id=3");
}
else
{
session.putValue("username",User_Name);
response.sendRedirect("ok.jsp");
}
}
stmt.close();
conn.close();
%>
</body>
</html>
3:reg.jsp
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"errorPage=""%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2321">
<title>注册页面</title>
<link href="css/bbs.css" _fcksavedurl=""css/bbs.css"" _fcksavedurl=""css/bbs.css"" rel="stylesheet" type="text/css">
</head>
<body>
<table width="80%" align="center">
<tr><td><a href="index.jsp">返回首页</a>:注册用户</td></tr>
</table>
<table width="80%" align="center" border="1" bordercolor="#000000">
<form method="post" name="form1" action="query.jsp">
<tr height="20" align="center" valign="middle">
<td colspan="2" align="center"><div align="center">
<span class="stylel">请用户输入详细信息</span></div></td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     用户名称(必须填写)</td>
<td width="60%">     <input name="username" type="text" maxlength="12">不能超过12个字符(6个汉字)</td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     用户密码(必须填写)</td>
<td width="60%">     <input name="password1" type="password" maxlength="12"></td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     确认密码(必须填写)</td>
<td width="60%">     <input name="password2" type="password" maxlength="12"></td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     电子油箱(必须填写)</td>
<td width="60%">     <input name="email" type="text" maxlength="30"></td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     用户性别</td>
<td width="60%">     <input type="radio" name="sex" value="男" >男 
<input type="radio" name="sex" value="女">女</td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     家庭住址</td>
<td width="60%">     <input name="address" type="text" maxlength="12"></td>
</tr>
<tr height="20" valign="middle">
<td width="40%">     用户生日</td>
<td width="60%">     <input name="year" type="text" maxlength="4" size="4">年
<input name="month" type="text" maxlength="2" size="2">月
<input name="day" type="text" maxlength="2" size="2">日
</td>
</tr>
<tr height="20" valign="middle">
<td width="40%">      QQ号码</td>
<td width="60%">     <input name="qq" type="text" maxlength="12"></td>
</tr>
<tr height="20" valign="middle">
<td colspan="2" align="center">
<div>
<input type="submit" name="regsubmit" οnclick='return CheckValue()'; value="注册"/>
</div>
</td>
</tr>
</form>
</table>
</body>
</html>
4:query.jsp
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2321">
<title>合法检测</title>
</head>
<body>
<%!String User_Name,User_Password1,User_Password2,User_Email,User_Sex,User_Address,User_Year,User_Month,User_Day,User_Birthday,User_QQ,sql;%>
<%!Connection conn;%>
<%! ResultSet rs;%>
<%
User_Name=request.getParameter("username");
User_Name=new String(User_Name.getBytes("ISO-8859-1"));
User_Password1=request.getParameter("password1");
User_Password2=request.getParameter("password2");
User_Sex=request.getParameter("sex");
User_Sex=new String(User_Sex.getBytes("ISO-8859-1"));
User_Email=request.getParameter("email");
User_Address=request.getParameter("address");
User_Address=new String(User_Address.getBytes("ISO-8859-1"));
User_Year=request.getParameter("year");
User_Month=request.getParameter("month");
User_Day=request.getParameter("day");
User_QQ=request.getParameter("qq");
if((User_Name.indexOf("'")>0)||(User_Name.indexOf(" ")>0)||(User_Name.indexOf("@")>0)||(User_Name.indexOf("=")>0)||(User_Name.indexOf("%")>0))
{//检查是否含有非法字符
response.sendRedirect("err.jsp");
return;
}
if((User_Password1.length()<6)||(User_Password1.length()>12))
{//检验密码长度
response.sendRedirect("err.jsp");
return;
}
if(!User_Password1.equals(User_Password2))
{//检验密码是否相等
response.sendRedirect("err.jsp");
return;
}
if(User_Email.equals(""))
{//检验油箱是否为空
response.sendRedirect("err.jsp");
return;
}
if(!User_Year.equals(""))
{//获取生日
if((User_Month.equals(""))&&(User_Day.equals("")))
User_Birthday="秘密";
else
User_Birthday=User_Year+"年"+User_Month+"月"+User_Day+"日";
}
else
{
if((User_Month.equals(""))&&(User_Day.equals("")))
User_Birthday="秘密";
else
User_Birthday=User_Month+"月"+User_Day+"日";
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:abbs","","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select * from user where name='"+User_Name+"'";
//检查用户名是否已经存在
rs=stmt.executeQuery(sql);
rs.last();
if(rs.getRow()>0)
{
response.sendRedirect("err.jsp");
}
else
{//在user表中插入用户注册信息
sql="insert into user(name,password,sex,email,address,birthday,qq)";
sql=sql+"values('"+User_Name+"','"+User_Password1+"','"+User_Sex+"','"+User_Email+"','"+User_Address+"','"+User_Birthday+"','"+User_QQ+"')";
stmt.executeUpdate(sql);
session.putValue("username",User_Name);
out.println("<font size=3 color=red>正在处理信息,请稍后......</font><meta http-equiv='refresh' content='2;url=zcok.jsp'>");
}
stmt.close();
%>
</body>
</html>
5: zcok.jsp
<%@page contentType="text/html;charset=gb2312" %>
<table width="80%" height=300 align="center">
<tr align="center">
<td>感谢你的支持,你已经注册成功!可以返回登陆:)</td>
</tr>
</table>
<table width="80%" align="center">
<tr align="center"><td><a href="index.jsp">返回登陆</a></td></tr>
</table>
6: ok.jsp
<%@page contentType="text/html;charset=gb2312" %>
<table width="80%" height=300 align="center">
<tr align="center">
<td>你已经登陆成功!</td>
</tr>
</table>
<table width="80%" align="center">
<tr align="center"><td><a href="index.jsp">返回登陆</a></td></tr>
</table>
7: exit.jsp
<%@page contentType="text/html;charset=gb2312" %>
<table width="80%" height=300 align="center">
<tr align="center">
<td>非常感谢你的光临!!!</td>
</tr>
</table>
<table width="80%" align="center">
<tr><td><a href="index.jsp">返回登陆</a></td></tr>
</table>
8:err.jsp
<%@page contentType="text/html;charset=gb2312"%>
<table width="80%" height=300 align="center">
<tr align="center">
<td>您输入的信息有错误!!!</td>
</tr>
</table>
<table width="80%" align="center">
<tr align="center"><td><a href="reg.jsp">返回注册</a></td></tr>
</table>
---------------------------------
有点乱,有待进一步改进~