📄 register_deal.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<html>
<head>
<title>用户注册</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
</head>
<body>
<%request.setCharacterEncoding("gb2312");
String username=request.getParameter("username");
String password=request.getParameter("password");
String truename=request.getParameter("truename");
String card=request.getParameter("card");
String tel=request.getParameter("tel");
String city=request.getParameter("city");
String email=request.getParameter("email");
String address=request.getParameter("address");
String postcode=request.getParameter("postcode");
ResultSet rs=conndb.executeQuery("select * from userdata where username='"+username+"'");
ResultSet rs_card=conndb.executeQuery("select * from userdata where card='"+card+"'");
%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<% if(rs.next()){%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("用户名已存在,请重新注册");%></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="确定" onClick="history.back(1);">
</div></td>
</tr>
<%}else{if(rs_card.next()){%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("该用户已注册");%></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="确定" onClick="history.back(1);">
</div></td>
</tr>
<%}else{ String sql="Insert into userdata(username,password,truename,tel,city,email,address,postcode) values('"+username+"','"+password+"','"+truename+"','"+tel+"','"+city+"','"+email+"','"+address+"','"+postcode+"')";
int ret=0;
ret=conndb.executeUpdate(sql);
if(ret!=0){
%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("恭喜您，注册成功");%></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="下一步" onClick="window.location.href='interest.jsp';">
</div></td>
</tr>
<%}
else{%>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("用户注册失败");%></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="确定" onClick="history.back(1);">
</div></td>
</tr>
<%}}}%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -