📄 tmp29f5pgrkeg.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@page import="java.sql.*"%>
<%!
String username;
String password;
String password2;
String question;
String answer;
String email;
String name;
String phone;
String city;
String add;
String zip;
String bir;
String sex;
String web;
String qq;
%>
<%
username=request.getParameter("username");
password=request.getParameter("password");
password2=request.getParameter("password2");
question=request.getParameter("question");
answer=request.getParameter("answer");
email=request.getParameter("email");
name=request.getParameter("name");
phone=request.getParameter("phone");
city=request.getParameter("city");
add=request.getParameter("add");
zip=request.getParameter("zip");
bir=request.getParameter("bir");
sex=request.getParameter("sex");
web=request.getParameter("web");
qq=request.getParameter("qq");
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr="jdbc:odbc:index";
if(username.equals("")||password.equals("")||password2.equals("")||question.equals("")||answer.equals("")||email.equals(""))
{
out.println("对不起,您填写的内容不完整，请您重新填写,谢谢!<p>您将在3秒钟后返回注册页");
response.setHeader("Refresh","3;URL=zhuce.htm");
return;
}
else if(!password.equals(password2))
{
out.println("对不起，您填写的密码不一致,请重新填写!<p>您将在3秒钟后返回注册页");
response.setHeader("Refresh","3;URL=zhuce.htm");
return;
}
String sql="insert into zhuce(username,password,password2,email,question,answer,name,phone,city,add,zip,bir,sex,web,qq) values ('"+username+"','"+password+"','"+password2+"','"+email+"','"+question+"','"+answer+"','"+name+"','"+phone+"','"+city+"','"+add+"','"+zip+"','"+bir+"','"+sex+"','"+web+"','"+qq+"')";
try
{
Class.forName(DBDriver);//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn=DriverManager.getConnection(ConnStr," "," ");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
out.println("您已经注册成功! "+"<br>");
stmt.close();
conn.close();
}
catch(SQLException e)
{
System.err.println("executeUpdate:"+e.getMessage());
out.println("数据没有写入");
}
%>
<style type="text/css">
<!--
body {
background-color: #FFFF99;
}
-->
</style>
<body background="images/bg1.gif">
<TABLE width="55%" border=0 align="center" cellPadding=0 cellSpacing=8 bgcolor="#FFFFFF">
<TBODY>
<TR>
<TD align=middle background="images/bg_menu.gif">
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR bgColor=#ffffff> </TR>
</TBODY>
</TABLE>
<div align="left"><img src="images/arrow.gif" width="25" height="11">您注册的资料如下：</div></TD>
</TR>
<TR>
<TD> <TABLE
width="100%" border=0 cellPadding=0 cellSpacing=8 background="images/bg01.gif">
<TBODY>
<TR>
<TD align=middle width="13%"> </TD>
<TD align=middle width="8%"><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD width="25%"><font size="2" face="楷体_GB2312">用户名</font></TD>
<TD width="41%" bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(username);%></TD>
<TD width="13%" bordercolor="#000000"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD><font size="2" face="楷体_GB2312">密 码</font></TD>
<TD bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(password);%></TD>
<TD bordercolor="#000000"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD><font size="2" face="楷体_GB2312">重复密码</font></TD>
<TD bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(password2);%></TD>
<TD bordercolor="#000000"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD><font size="2" face="楷体_GB2312">电子邮箱</font></TD>
<TD bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(email);%></TD>
<TD bordercolor="#000000"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD><font size="2" face="楷体_GB2312">密码提示问题</font></TD>
<TD bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(question);%></TD>
<TD bordercolor="#000000"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7
src="images/bul_or_tri1.gif"
width=4></TD>
<TD><font size="2" face="楷体_GB2312">密码问题回答</font></TD>
<TD bordercolor="#000000" bgcolor="#FFFFFF"> <%out.println(answer);%></TD>
<TD bordercolor="#000000"> </TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR background="images/bg_menu.gif">
<TD align=middle> <TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR bgColor=#ffffff> </TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD> <TABLE
width="100%" border=0 cellPadding=0 cellSpacing=8 background="images/bg01.gif">
<TBODY>
<TR>
<TD align=middle width="13%"> </TD>
<TD align=middle width="8%"><IMG height=7 src=""
width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD width="25%"><font size="2" face="楷体_GB2312">姓名</font></TD>
<TD width="41%" bgcolor="#FFFFFF"><font size="2">
<%out.println(name);%>
</font></TD>
<TD width="13%"> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">联系电话</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(phone);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">所在城市</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(city);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">联系地址</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(add);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">邮政编码</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(zip);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">生 日</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(bir);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/icon_arrow_5.gif" width="14" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">性 别</font></TD>
<TD bgcolor="#FFFFFF"> <%out.println(sex);%></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/zy.gif" width="15" height="15"></TD>
<TD><font size="2" face="楷体_GB2312">主页地址</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(web);%>
</font></TD>
<TD> </TD>
</TR>
<TR>
<TD align=middle> </TD>
<TD align=middle><IMG height=7 src="" width=4><img src="images/Q01.gif" width="16" height="16"></TD>
<TD><font size="2" face="楷体_GB2312">QQ</font></TD>
<TD bgcolor="#FFFFFF"><font size="2">
<%out.println(qq);%>
</font></TD>
<TD> </TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR background="images/bg_menu.gif">
<TD align=middle> <TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR bgColor=#ffffff> </TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD align=middle><div align="center">
<%response.setHeader("Refresh","10;URL=index.htm");%>
<font color="#9999FF" size="2"><img src="images/attention.gif" width="16" height="15"></font>
<font color="#9999FF" size="1">确认您的个人资料，10秒后界面返回网站首页</font> </div>
<div align="center"> </div></TD>
</TR>
</TBODY>
</TABLE>
<div align="center"> </div>
<p>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -