📄 addnew.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="conn.jsp"%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="inc/register.css" type="text/css">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>订票—>注册</title>
</head>
<body topmargin="0" leftmargin="0">
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<tr>
<td height="33"> </td>
</tr>
<div align="center">
<table width="780" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="inc/a3.jpg" width="780" height="148"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="780">
<center>
<tr>
<td height="2" valign="top" colspan="3" bgcolor="#00006A"> </td>
</tr>
</center>
<tr>
<td width="131" height="16" bgcolor="#93BEF2" valign="bottom">
<p align="center">
<script language="javascript" src="inc/date.js"></script>
</td>
</tr>
<center>
<tr>
<td height="2" valign="top" colspan="3" bgcolor="#00006A"> </td>
</tr>
</center>
</table>
</div>
<SCRIPT language=JavaScript src="inc/validate.js"></SCRIPT>
<SCRIPT language=JavaScript>
<!--
function checkform()
{
if (checkstring("用户名", document.addnew.uname.value, false)) {
document.addnew.uname.focus();
return false;
}
var pwd = document.addnew.pwd.value;
if (addnew.pwd.value=="") {
alert("请输入登录密码！");
addnew.pwd.focus();
return (false);
}
if (pwd.length < 3) {
alert("密码不能少于三位！");
return false;
}
var pwd2 = document.addnew.pwd2.value;
if (pwd != pwd2) {
alert("两次密码输入不一致！");
document.addnew.pwd.value="";
document.addnew.pwd2.value="";
return false;
}
if (checkemail("电子邮件", document.addnew.email.value, false)) {
document.addnew.email.focus();
return false;
}
return true;
}
//-->
</SCRIPT>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="780" height="45">
<tr>
<td width="766" height="18" valign="top" colspan="5" bgcolor="#5388C1">
</td>
</tr>
<tr>
<td width="144" height="162" valign="top" bgcolor="#5388C1">
<p align="center"> </p>
<p>
</td>
<td width="29" height="309" valign="top"><img border="0" src="images/selfk.GIF"></td>
<td width="462" height="309">
<FORM name=addnew onsubmit="return checkform();" action=addnew.jsp method=post>
</center>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" width="352" height="1" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr>
<td width="350" height="13" background="images/t-bg1.gif">
<p align="center"> <center><h2>新用户注册</h2></center></td>
</tr>
<center>
<center>
<tr>
<td width="350" height="263" bgcolor="#fffff4">
<p align="center"> 用户名:<input type="text" name="uname" size="15" maxLength=15> </p>
<p align="center"> 密码:<input type="password" name="pwd" size="15" maxLength=15></p>
<p align="center">确认密码:<input type="password" name="pwd2" size="15" maxLength=15></p>
<p align="center"> E-mail:<input type="text" name="email" size="15" maxLength=30></p>
<p align="center"><input type="submit" value="注 册" name="B1" style="position: relative; height: 19"></td>
</tr>
</center>
</center>
<center>
<center>
</center>
</center>
</table>
</div>
</td>
<center>
<td width="1" height="309" valign="top" bgcolor="#00006A"></td>
<td width="119" height="309" valign="top" bgcolor="#F3F3F3"></td>
</tr>
<tr>
<td width="743" height="1" valign="top" colspan="5" bgcolor="#5388C1">
<p align="center"> </td>
</tr>
<tr>
<td width="743" height="3" valign="top" colspan="5">
<p align="center">
</td>
</tr>
<tr>
<td width="743" height="7" valign="top" colspan="5">
<p align="center"><script language="javascript" src="inc/copyright.js"></script>
</td>
</tr>
<tr>
<td width="743" height="3" valign="top" colspan="5">
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
<%request.setCharacterEncoding("GB2312");
String zhmail="欢迎您注册,请尽快完成您的注册!";
zhmail=zhmail+"完全注册之后,您便能享受到本站完善的服务,目前主要功能购票功能!";
zhmail=zhmail+"最后祝您在本站找到合适车票!";
zhmail=zhmail+"<br> P.S.(此信为系统所发,请不要回复,谢谢!)";
String usertype=request.getParameter("usertype") ;
if(usertype!=null){
String uname=request.getParameter("uname");
String email=request.getParameter("email");
String pwd=request.getParameter("pwd");
String adminvalue="person";
if(adminvalue.equals(usertype))
{
String sql="select * from scott.person where uname='"+uname+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
%>
<SCRIPT language=JavaScript>
alert('用户名重复，请重新选择一个用户名！');
javascript:history.go(-1)
</SCRIPT>
<% }else{
stmt.executeUpdate("INSERT INTO scott.person(id,uname,pwd,email) VALUES(scott.personid.nextval,'"+uname+"','"+pwd+"','"+email+"')");
stmt.executeUpdate("INSERT INTO scott.pmailbox(id,reid,senduid,title,sendname,mailtext) VALUES(scott.pmailboxid.nextval,'"+uname+"','sysop','祝贺您注册成功！','系统管理员！','"+zhmail+"')");
session.putValue("puid", uname);
}
%>
<SCRIPT language=JavaScript>
alert('新用户注册成功，正在登录中...，请稍候！');
this.location.href='person/main.jsp';
</SCRIPT>
<%
}else{
String sql="select * from scott.company where uname='"+uname+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
%>
<SCRIPT language=JavaScript>
alert('用户名重复，请重新选择一个用户名！');
javascript:history.go(-1)
</SCRIPT>
<%}else{
stmt.executeUpdate("INSERT INTO scott.company(id,uname,pwd,email) VALUES(scott.companyid.nextval,'"+uname+"','"+pwd+"','"+email+"')");
stmt.executeUpdate("INSERT INTO scott.pmailbox(id,reid,senduid,title,sendname,mailtext) VALUES(scott.pmailboxid.nextval,'"+uname+"','sysop','祝贺您注册成功！','系统管理员！','"+zhmail+"')");
session.putValue("cuid", uname);
}
%>
<SCRIPT language=JavaScript>
alert('新用户注册成功，正在登录中...，请稍候！');
this.location.href='company/main.jsp';
</SCRIPT>
<%}
}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -