一个小登陆系统

来源:互联网 发布:windows ios 编辑:程序博客网 时间:2024/04/29 01:47

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%">&nbsp&nbsp&nbsp&nbsp&nbsp用户名称(必须填写)</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input name="username" type="text" maxlength="12">不能超过12个字符(6个汉字)</td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp用户密码(必须填写)</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input name="password1" type="password" maxlength="12"></td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp确认密码(必须填写)</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input name="password2" type="password" maxlength="12"></td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp电子油箱(必须填写)</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input name="email" type="text" maxlength="30"></td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp用户性别</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input type="radio" name="sex" value="男"  >男&nbsp
   <input type="radio" name="sex" value="女">女</td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp家庭住址</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<input name="address" type="text" maxlength="12"></td>
   </tr>
   <tr height="20" valign="middle">
   <td width="40%">&nbsp&nbsp&nbsp&nbsp&nbsp用户生日</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<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%">&nbsp&nbsp&nbsp&nbsp&nbsp QQ号码</td>
   <td width="60%">&nbsp&nbsp&nbsp&nbsp&nbsp<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" onclick='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>

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

有点乱,有待进一步改进~