?? chkregister.jsp.htm
字號:
<html>
<head>
<title>注冊驗證</title>
</head>
<%@page import="java.util.*, java.sql.*" contentType="text/html;charset=GB2312" %>
<body>
<%
String username=new String(request.getParameter("username").getBytes("ISO8859_1"),"GBK");
String password1=new String(request.getParameter("password1").getBytes("ISO8859_1"),"GBK");
String password2=new String(request.getParameter("password2").getBytes("ISO8859_1"),"GBK");
String age=new String(request.getParameter("age").getBytes("ISO8859_1"),"GBK");
String email=new String(request.getParameter("email").getBytes("ISO8859_1"),"GBK");
String phone=new String(request.getParameter("phone").getBytes("ISO8859_1"),"GBK");
String address=new String(request.getParameter("address").getBytes("ISO8859_1"),"GBK");
String sex=new String(request.getParameter("sex").getBytes("ISO8859_1"),"GBK");
String face=new String(request.getParameter("face").getBytes("ISO8859_1"),"GBK");
int postnumber=0; //為新用戶設(shè)置文章發(fā)表的篇數(shù)為0
int rank=0; //設(shè)置新用戶為普通級別的用戶
boolean valid=true; //判斷是否注冊合法
String err=""; //注冊不合法的提示信息
//加載數(shù)據(jù)庫驅(qū)動并用連接池連結(jié)數(shù)據(jù)庫
String sql="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
sql="select ID from User where UserName='"+username+"'";
ResultSet rs=stmt.executeQuery(sql); //執(zhí)行查詢操作
if (rs.next()){
//如果相同用戶名存在
err+="<h3>該用戶名已經(jīng)存在，請更換用戶名！</h3>";
valid=false;
}else{
sql="insert into User (UserName,Password,Email,Sex,Phone,Address,Age,PostNumber,Rank,Face) values ('"+username+"','"+password1+"','"+email+"','"+sex+"','"+phone+"','"+address+"','"+age+"','"+postnumber+"','"+rank+"','"+face+"')";
stmt.executeUpdate(sql);
}
//釋放數(shù)據(jù)庫連結(jié)
//根據(jù)注冊結(jié)果判斷
if(valid) { %>
<h3>Congratulate You！<%=username%></h3>
<h3>你已經(jīng)注冊成功,請檢查你的注冊信息：</h3>
<p></p>
你現(xiàn)在已經(jīng)是我們的合法用戶了，你可以：
<a href="login1.jsp">登錄論壇 </a>
<% }
else{ %>
<%=err%>
<a href="javascript:history.back();">返回</a>
<% } %>
<%
stmt.close();
conn.close(); %>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -