?? 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 + -