📄 register.jsp
字号:
<html>
<head>
<title>登录检查</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn = OPDB.getConn();
String username = OPDB.AsciiToChineseString(request.getParameter("username").trim());
String password = request.getParameter("password").trim();
String email = request.getParameter("email");
if (email != null) email = email.trim();
String homepage = request.getParameter("homepage");
if (homepage != null) homepage = homepage.trim();
String userlevel = OPDB.AsciiToChineseString(request.getParameter("userlevel"));
String sql="select username from t_bbs_user where username='"+ username +"' and usertype = 'N'";
ResultSet rs =OPDB.select(conn,sql);
if(rs.next()) {
rs.close();
out.print("<script>alert(\"对不起,用户名已存在,请重新注册!\");");
out.print("window.location = \"register.htm\"</script>");
}
else {
String sql1 = "insert into t_bbs_user(userid,username,password,email,homepage,userlevel) values(seq_bbs_user.NEXTVAL,'"+username+"','"+password+"','"+email+"','"+homepage+"','"+userlevel+"')";
OPDB.insert(conn,sql1);
session.putValue("username",username);
out.print("<script>window.location = \"reg_success.htm\"</script>");
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -