📄 register.jsp
字号:
<!-- programmed by luic、zq
Date:2004/4/12
-->
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=GBK"%>
<%
String userId=new String();
String password=new String();
String userName=new String();
String userSex=new String();
String userCardNo=new String();
String userPostcode=new String();
String userPhoneNo=new String();
String userAddress=new String();
String userMail=new String();
%>
<%-- 取出用户提交的表单数据--%>
<%
userId=request.getParameter("ename"); //用户名
password=request.getParameter("mima"); //密码
userName=request.getParameter("cnname"); //用户真实姓名
userSex=request.getParameter("sex"); //性别
userCardNo=request.getParameter("code"); //证件号码
userPostcode=request.getParameter("postcode"); //邮政编码
userPhoneNo=request.getParameter("tel"); //电话号码
userAddress=request.getParameter("address"); //地址
userMail=request.getParameter("email"); //E-mail地址
%>
<%-- 判断用户名是否已经被使用过--%>
<%
String url=new String();
url="jdbc:odbc:bookStore";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String SQL=new String();
String strin=new String();
strin="select * from client where logName='"+userId+"'";
ResultSet rs=stmt.executeQuery(strin);
if(!rs.next())
{
SQL="insert into client(logName,password,realname,sex,cardID,postcode,telNumber,address,mailbox) values('"+userId+"','"+password+"','"+userName+"','"+userSex+"','"+userCardNo+"','"+userPostcode+"','"+userPhoneNo+"','"+userAddress+"','"+userMail+"')";
stmt.executeUpdate(SQL);
response.sendRedirect("regOk.htm");
}
else{
response.sendRedirect("regFailed.htm");
}
stmt.close();
rs.close();
con.close();
%>
<html>
<head>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=GBK">
<title>用户注册</title></head>
<body>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -