📄 regok.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<html>
<%@ include file="inc/format.jsp"%>
<%@ include file="inc/bytes.jsp"%>
<%@ include file="inc/conn1.jsp"%>
<%@ include file="top.jsp"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>计算机图书--管理系统</title>
</head>
<body >
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="39" rowspan="9" align="right" valign="top"><img src="image/y1.jpg" width="39" height="1007"></td>
<td width="206" height="13"></td>
<td width="7"></td>
<td width="605"></td>
<td width="7"> </td>
<td width="36" rowspan="9" valign="top"><img src="image/z1.jpg" width="36" height="1006"></td>
</tr>
<tr>
<td height="108" valign="top"><table width="206" height="110" border="0" cellpadding="0" cellspacing="0" background="image/dongkuaif.gif">
<!--DWLayoutTable-->
<tr>
<td width="15" height="9"></td>
<td width="181"></td>
<td width="10"></td>
</tr>
<tr>
<td height="86"></td>
<td align="center" valign="middle"><span class="stylex">
<script language="JavaScript">var when=new Date();
document.write("<h4>");
document.write(when.getYear()+"年");
document.write((when.getMonth()+1)+"月");
document.write(when.getDate()+"日<br>");
document.write(when.getHours()+"时");
document.write(when.getMinutes()+"分");
document.write("</h4>");
</script></span></td>
<td></td>
</tr>
<tr>
<td height="15"></td>
<td> </td>
<td></td>
</tr>
</table></td>
<td> </td>
<td rowspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="605" height="167" valign="top"><img src="image/tupic.gif" width="605" height="167"></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td height="7"><a name="reg"></a></td>
<td></td>
<td></td>
</tr>
<tr>
<td colspan="2" rowspan="5" valign="top">
<table width="208" height="123" border="0" cellpadding="0" cellspacing="0" background="image/logn.jpg">
<!--DWLayoutTable-->
<tr>
<td width="8" height="24"> </td>
<td width="200"> </td>
</tr>
<tr>
<td height="99"> </td>
<td><%@ include file="denglu.jsp"%></td>
</tr>
</table> <table width="208" border="0" cellpadding="0" cellspacing="0" background="image/dongkuaid.gif">
<!--DWLayoutTable-->
<tr>
<td width="215" height="42"> </td>
</tr>
<tr>
<td height="277" align="center" valign="top"><%@include file="changxiao.jsp"%></td>
</tr>
</table> <br> <table width="208" height="356" border="0" cellpadding="0" cellspacing="0" background="image/chuxiao.gif">
<!--DWLayoutTable-->
<tr>
<td width="24" height="37"> </td>
<td width="184"> </td>
<td width="7"></td>
</tr>
<tr>
<td height="293"> </td>
<td valign="top"><%@ include file="chuxiao.jsp"%></td>
<td></td>
</tr>
<tr>
<td height="24"> </td>
<td> </td>
<td></td>
</tr>
</table></td>
<td height="67"></td>
</tr>
<tr>
<td height="187" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="image/link.gif">
<!--DWLayoutTable-->
<tr>
<td width="20" height="5"></td>
<td width="495"></td>
<td width="69"></td>
<td width="21"></td>
</tr>
<tr>
<td height="21"></td>
<td valign="top"><%@ include file="scroll.htm"%></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="38"></td>
<td> </td>
<td></td>
<td></td>
</tr>
<tr>
<td height="105"> </td>
<td colspan="2" valign="top"><%@ include file="toplist.jsp"%></td>
<td> </td>
</tr>
<tr>
<td height="18"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
<td></td>
</tr>
<tr>
<td height="11"></td>
<td></td>
</tr>
<tr>
<td height="172" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#E6E6E6">
<!--DWLayoutTable-->
<tr>
<td width="591" height="33" valign="middle" bgcolor="#F7F7F7"><span style="font-size: medium">注意事项</span></td>
</tr>
<tr>
<td height="113" valign="top" bgcolor="#efefef"> <span style="font-size: 14px"><br>
1<span style="font-size: 14px">. </span>个人信息带*号的项目必填 <br>
2<span style="font-size: 14px">. </span> 客户名由您自己填写(小于6位的字母)，密码由您自己设定（3-6位字母或数字），以后定书时只需在老客户登录处登录客户名和密码即可，请务必牢记您的客户名和密码； <br>
3<span style="font-size: 14px">. </span> 老客户只须填写客户名和密码,无须提交测试； <br>
4<span style="font-size: 14px">. </span> 订单中"数量"一栏只能填写数字，如填"0"等同于您取消订购这本书，更改数量后请点击重新计算金额钮，系统将自动计算出您的购物总金额； <br>
5. 订单中的联系电话请填写正常工作日(9:00-17:00)可联系的电话； <br>
6. 本书城目前只在北京四环路以内提供送书上门服务，外地客户请予理解和注意。</span> <br></td>
</tr>
</table></td>
<td></td>
</tr>
<tr>
<td height="338" colspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="605" height="353" valign="top">
<%String u_name,u_pass,u_adds,u_tel,u_namec,u_postcode,u_email,u_faq,u_an,u_card,u_chkfaq;
u_name=Bytes(request.getParameter("user_name"));
u_pass=request.getParameter("user_pass");
u_adds=Bytes(request.getParameter("user_adds"));
u_tel=request.getParameter("user_tel");
u_namec=Bytes(request.getParameter("user_namec"));
u_card=request.getParameter("user_card");
u_postcode=request.getParameter("user_postcode");
u_email=request.getParameter("user_email");
u_faq=Bytes(request.getParameter("user_faq"));
u_an=request.getParameter("user_an");
u_chkfaq=request.getParameter("user_chkfaq");
//Statement regstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//sql="insert into eshow_content (eshow_content,eshow_name,eshow_image,eshow_index,eshow_email,eshow_oicq,eshow_sex) values ('"+eshow_text+"','"+eshow_name+"','"+eshow_face+"','"+eshow_homepage+"','"+eshow_email+"','"+eshow_oicq+"','"+eshow_sex+"')";
//sql="insert into member(user_name,user_pass,user_adds,user_tel,user_namec,user_card,user_postcode,user_mail,user_faq,user_an) values ('"+u_name+"','"+u_pass+"','"+u_adds+"','"+u_tel+"','"+u_namec+"','"+u_card+"','"+u_postcode+"','"+u_email+"','"+u_faq+"','"+u_an+"')";
//sql=Bytes(sql);
//sql=format(sql);
//regstmt.executeUpdate(sql);
//regstmt.close();
//out.print("<script>alert('用户注册成功，现在就可返回主页或登录查询更多内容。');</script>");
%>
<table width="599" border="0" cellspacing="0">
<tr>
<td height="20" colspan="2" align="center">
<div align="center"><font color="#3366CC" size="3">
用户注册</font><font color="#FF3300" size="3"> </font><font color="#FF3300">（有*标识的选项为必须填写）</font><font color="#FF3300" size="3"> </font>
<hr size="1" color="#6699cc">
<font color="#FF3300" size="3"> </font></div>
</td>
</tr>
<tr>
<td width="13%" height="20">
<div align="right"><font size="-1">用 户 名:</font></div>
</td>
<td width="85%" height="20"> <font size="-1">
<input name="user_name" type="text" class="field" id="user_name" value="<%=u_name%>" maxlength="31">
<font color="#FF3300">*</font> （注：用户注册名为32个以内的英文、数字、下划线组合）</font></td>
</tr>
<tr>
<td width="13%" height="19">
<div align="right"><font size="-1">密 码:</font></div>
</td>
<td width="85%" height="19"> <font size="-1">
<input name="user_pass" type="text" class="field" id="user_pass" value="<%=u_pass%>" maxlength="16">
<font color="#FF3300">*</font> （注：密码少于16位必须是英文、数字、下划线）</font></td>
</tr>
<tr>
<td width="13%">
<div align="right"><font size="-1">联系地址:</font></div>
</td>
<td width="85%"> <font size="-1">
<input name="user_adds" type="text" class="field" id="user_adds" value="<%=u_adds%>" size=40 maxlength="50">
</font></td>
</tr>
<tr>
<td width="13%">
<div align="right"><font size="-1">联系电话</font></div>
</td>
<td width="85%"> <font size="-1">
<input name="user_tel" type="text" class="field" id="user_tel" value="<%=u_tel%>" maxlength="30">
</font></td>
</tr>
<tr>
<td width="13%" height="31">
<div align="right"><font size="-1">真实姓名:</font></div>
</td>
<td width="85%" height="31"> <font size="-1">
<input name="user_namec" type="text" class="field" id="user_namec" value="<%=u_namec%>" maxlength="50">
<font color="#FF3300">*</font> （姓名少于31个字符）</font></td>
</tr>
<tr>
<td width="13%">
<div align="right"><font size="-1">身份证号:</font></div>
</td>
<td width="85%"> <font size="-1">
<input name="user_card" type="text" class="field" id="user_card" value="<%=u_card%>" maxlength="18">
</font></td>
</tr>
<tr>
<td width="13%">
<div align="right"><font size="-1">邮 编:</font></div>
</td>
<td width="85%"> <font size="-1">
<input name="user_postcode" type="text" class="field" id="user_postcode" value="<%=u_postcode%>" maxlength="8">
（请输入正确的邮编，以便我们为您快速送货）</font></td>
</tr>
<tr>
<td width="13%">
<div align="right"><font size="-1">Email:</font></div>
</td>
<td width="85%"> <font size="-1">
<input name="user_mail" type="text" class="field" id="user_mail" value="<%=u_email%>" maxlength="254">
（注：用于收取订单跟踪邮件及密码邮件）</font></td>
</tr>
<tr>
<td>
<div align="right"></div>
<div align="right"><font size="-1">密码提问:</font></div></td>
<td width="85%"> <font size="-1">
<input name="user_faq" type="text" class="field" id="user_faq" value="<%=u_faq%>" maxlength="254">
（注：设置密码提问，可帮助您在遗忘密码时取回密码。）</font></td>
</tr>
<tr>
<td>
<div align="right"></div>
<div align="right"><font size="-1">密码回答:</font></div></td>
<td width="85%"> <font size="-1">
<input name="user_chkfaq" type="text" class="field" id="user_chkfaq" value="<%=u_chkfaq%>" maxlength="254">
</font></td>
</tr>
<tr>
<td>
<div align="right"></div>
<div align="right"><font size="-1">确认回答:</font></div></td>
<td width="85%"> <font size="-1">
<input name="user_an" type="text" class="field" id="user_an" value="<%=u_an%>" maxlength="254">
</font></td>
</tr>
<tr bgcolor="#F0F0F0">
<td colspan="2">
<div align="center">
<input name="s-home" type="button" class="botton1" id="s-home" value="回到首页" onClick="javascript:window.location.href='index.jsp'">
<input name="r-login" type="button" class="botton1" id="r-login" value="登录" onClick="javascript:window.location.href='index.jsp#reg'">
</div>
</td>
</tr>
</table><%
Statement rgstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//sql="insert into eshow_content (eshow_content,eshow_name,eshow_image,eshow_index,eshow_email,eshow_oicq,eshow_sex) values ('"+eshow_text+"','"+eshow_name+"','"+eshow_face+"','"+eshow_homepage+"','"+eshow_email+"','"+eshow_oicq+"','"+eshow_sex+"')";
sql="insert into member (user_name,user_pass,user_adds,user_tel,user_namec,user_card,user_postcode,user_email,user_faq,user_an) values ('"+u_name+"','"+u_pass+"','"+u_adds+"','"+u_tel+"','"+u_namec+"','"+u_card+"','"+u_postcode+"','"+u_email+"','"+u_faq+"','"+u_an+"')";
sql=Bytes(sql);
sql=format(sql);
rgstmt.executeUpdate(sql);
rgstmt.close();
out.print("<script>alert('用户注册成功，现在就可返回主页或登录查询更多内容。');</script>");
%>
</td>
</tr>
<!--DWLayoutTable-->
</table></td>
</tr>
</table>
<%@ include file="end.jsp"%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -