📄 zhuce.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>注册</title>
<style type="text/css">
<!--
.style2 {
color: #CC6600;
font-weight: bold;
}
-->
</style>
</head>
<p>
<%@page import="java.sql.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<%
//在使用JDBC之前必须先导入JAVA.SQL.*包，里面包含了Statement和ResultSet两个会使用的方法。
String name=new String(request.getParameter("name"));//创建对象
String password=new String(request.getParameter("mima"));
String password2=new String(request.getParameter("mima2"));
String truename=new String(request.getParameter("xingming"));
String sex=new String(request.getParameter("xingbie"));
String age=new String(request.getParameter("nianling"));
String tel=new String(request.getParameter("dianhua"));
String email=new String(request.getParameter("email"));
String wenti=new String(request.getParameter("tishi"));
String daan=new String(request.getParameter("huida"));
if(name.equals("")||password.equals("")||password2.equals("")||truename.equals("")||sex.equals("")||age.equals("")||tel.equals("")||email.equals("")||wenti.equals("")||daan.equals(""))
{
out.println("带*为必填项,请您重新填写,谢谢!<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
if(!password.equals(password2)){
out.println("您填写的两次密码不一致,请重新填写!<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
else if(email.indexOf('@')<=0){//邮件正确格式的判断条件
out.print("请输入正确的email地址。<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
else if(password.length() >10 || password.length()<6){//密码输入的限制条件
out.print("请输入６～１０个字符的密码!<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
int g;
try {//输入年龄的限制条件
g = Integer.parseInt(age);
if(g<1||g>150)
{
out.println("<P align='center'><font size='6' face='kai' color='#FF6699'>您填写的年龄错误，请重新填写!</font></P>");
out.println("<a href=zhuce.htm>返回</a>");
return;
}
}
catch (NumberFormatException e) {
out.println("<P align='center'><font size='6' face='kai' color='#FF6699'>您填写年龄应输入数字，请重新填写!</font></P>");
out.println("<a href=zhuce.htm>返回</a>");
return;
}
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:g";
Connection con=DriverManager.getConnection(url,"","");
PreparedStatement select_stm=con.prepareStatement("select name from zhuce where name=?");
select_stm.setString(1,name);//使用下面方法能够判断数据库中是否以存在用户注册的用户名，如果存在就不会让重复注册！
ResultSet result_stm=select_stm.executeQuery();
String debug_username=null;
if(result_stm.next())
debug_username=result_stm.getString(1);
result_stm.close();
if(debug_username!=null)
{out.println("用户名已经存在，请使用其它名字<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
else if(!password.equals(password2))
{out.print("密码不正确，请重新输入密码！<p><a href=zhuce.htm>返回注册页</a></p>");
return;
}
else{
PreparedStatement stm=con.prepareStatement("insert into zhuce(name,password,truename,sex,age,tel,email,wenti,daan) values(?,?,?,?,?,?,?,?,?)");//把注册信息写到库中
stm.setString(1,name);
stm.setString(2,password);
stm.setString(3,truename);
stm.setString(4,sex);
stm.setString(5,age);
stm.setString(6,tel);
stm.setString(7,email);
stm.setString(8,wenti);
stm.setString(9,daan);
try
{
stm.executeUpdate();
}
catch(Exception e){out.print(e);}
%>
</p>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"><span class="style2">注册成功 !<strong>请记住您的用户名和密码，方便以后的登录</strong></span></p>
<p align="center"><a href="denglu.jsp">登录</a></p>
<p align="center">您的信息如下：</p>
<%
con.close();
}
%>
<table width="60%" border="0" align="center" bgcolor="#E8E8FF">
<tr>
<td width="30%">
<p align="right">用户名：</td>
<td width="70%"><%=name%></td>
</tr>
<tr>
<td width="30%">
<p align="right">密码：</td>
<td width="70%"><%=password%></td>
</tr>
<tr>
<td width="30%">
<p align="right"> 真实姓名：</td>
<td width="70%"><%=truename%></td>
</tr>
<tr>
<td width="30%"><p align="right">性别：</td>
<td width="70%"><%=sex%></td>
</tr>
<tr>
<td width="30%"><p align="right">年龄：</td>
<td width="70%"><%=age%></td>
</tr>
<tr>
<td width="30%"><p align="right">电话：</td>
<td width="70%"><%=tel%></td>
</tr>
<tr>
<td width="30%"><p align="right">电子邮件：</td>
<td width="70%"><%=email%></td>
</tr>
<tr>
<td width="30%"><p align="right">提示问题：</td>
<td width="70%"><%=wenti%></td>
</tr>
<tr>
<td width="30%"><p align="right">回答问题：</td>
<td width="70%"><%=daan%></td>
</tr>
</table>
<%
}
catch(Exception e){out.print(e);}
}
%>
<%request.getSession(true);
session.putValue("name",name);
//rs.close();
//st.close();
//response.sendRedirect("denglu2.jsp");
%>
</p>
<p align="center"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -