📄 validate.jsp
字号:
<!--
功能:注册--连接数据库
设计者:金鑫
审阅人:赵鑫磊
设计时间:2007/11/29 -->
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*,java.awt.*,javax.swing.*" %>
<%!
String name=new String();
String pass="";
String pass2="";
String sex="";
String rname="";
String addr="";
String phone="";
String email="";
%>
<%
String rand = (String)session.getAttribute("rand");
String input = request.getParameter("rand");
name=request.getParameter("t1");
pass=request.getParameter("t2");
pass2=request.getParameter("t3");
rname=request.getParameter("t4");
byte r[]=rname.getBytes("ISO-8859-1");
rname=new String(r);
sex=request.getParameter("b");
byte s[]=sex.getBytes("ISO-8859-1");
sex=new String(s);
phone=request.getParameter("t5");
byte p[]=phone.getBytes("ISO-8859-1");
phone=new String(p);
addr=request.getParameter("t6");
byte a[]=addr.getBytes("ISO-8859-1");
addr=new String(a);
email=request.getParameter("t7");
byte e[]=email.getBytes("ISO-8859-1");
email=new String(e);
if(pass.equals(pass2)&&(rand.equals(input)))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:book");
Statement stmt=con.createStatement();
String sql="insert into tb_user (e_name,e_pass,e_rname,e_sex,e_phone,e_addr,e_email) values('"+name+"','"+pass+"','"+rname+"','"+sex+"','"+phone+"','"+addr+"','"+email+"')";
stmt.executeUpdate(sql);
con.close();
stmt.close();
}
catch(Exception o)
{
System.out.println(o.getMessage());
}%>
<html>
<head>
<title>
注册成功
</title>
</head>
<body>恭喜,注册成功!<p>
请<a href="login.jsp">返回</a>
</body>
</html>
<%}
else
{
JOptionPane.showMessageDialog(null,"您输入的信息有误,请查看密码和验证码后重新输入");
response.sendRedirect("login.jsp");}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -