📄 register.jsp

📁 这个是使用JSP、JDBC技术构架一个关于JAVA语言的BBS讨论区
💻 JSP
字号:
<%--
File Name:register.jsp
Author:fancy
Date:2001.6.1
Usage:register a new user
Address:Peking University 37#215,62762526,fancyrainbow@263.net,bbs.pku.edu.cn(id:javalover)
Note:1.这是一个Open Source项目,你可以自由的获取,修改,传播本项目的代码,无需经过本人的同意。
     2.你不可以将本项目的源代码用于商业应用,除非获得本人的书面允许。
     3.本项目的核心源代码所有权归原开发者所有,如果需要获取最新的核心代码，请与本人联系
--%>
<%
//设定Session,可能用不上
session.putValue("prevlink","");
session.putValue("nextlink","");
session.putValue("firstlink","");
session.putValue("lastlink","");
session.putValue("editlink","");
session.putValue("deletelink","");
session.putValue("backlink","");
%>

<%
String username=request.getParameter("username");
String password=request.getParameter("password"); 
String nickname=request.getParameter("nickname"); 
String email=request.getParameter("email"); 
String address=request.getParameter("address"); 
String sex=request.getParameter("sex"); 
String age=request.getParameter("age"); 
String comment=request.getParameter("comment"); 
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Java论坛</title>
</head>
<%@ include file="defaultcss.jsp"%>
<%@ include file="menuaction.jsp"%>
<%@ include file="database.jsp" %>

<%
java.sql.Statement stmtlist=conn.createStatement();
String SQL="SELECT * FROM forumuser where username='"+username+"'"+" and password='"+password+"'";
//out.println(SQL);
boolean boolCanRegister=true;
ResultSet rslist=stmtlist.executeQuery(SQL);
rslist.last();
int lastrow=rslist.getRow();
if(lastrow!=0)
{
	boolCanRegister=false;
	//out.println("here");
	rslist.close();
}
stmtlist.close();
%>

<%
if (boolCanRegister==true)
{
	java.sql.Statement stmtPost=conn.createStatement();
	//out.println("here");
	String strSQL="INSERT INTO forumuser ";
	strSQL+="(username,nickname,password,sex,email,age,address,comment,register,postcount,status,usertype,expr)";
	strSQL+="values(";
	strSQL+="'"+username+"',";
	strSQL+="'"+nickname+"',";
	strSQL+="'"+password+"',";
	strSQL+="'"+sex+"',";
	strSQL+="'"+email+"',";
	strSQL+="'"+age+"',";
	strSQL+="'"+address+"',";
	strSQL+="'"+comment+"',";
	strSQL+="getdate(),";
	strSQL+="0,";
	strSQL+="'unknown',";
	strSQL+="'normal',";
	strSQL+="5";
	strSQL+=")";
	//out.println(strSQL);
	stmtPost.executeUpdate(strSQL);
	stmtPost.close();
}
%>

<body LANGUAGE=javascript onload="return window_onload()">
<table border="0" width="100%" height="139" cellspacing="0" cellpadding="0">
  <%@ include file="toptable.jsp"%>
  <tr>
    <td width="2%" height="13"></td>
    <td width="92%" height="32" colspan="5" rowspan="2">
      <div align="center">
        <center>
        <table border="0" cellpadding="0" cellspacing="0" width="80%" height="26">
          <tr bgcolor="#efefef">
            <td width="25%" height="24"></td>
            <td width="50%" height="24"  align="center"><font color="red" size="2">Java技术讨论区(注册新用户)</font></td>
            <td width="25%" height="24"></td>
          </tr>
        </table>
        </center>
      </div>
    </td>
  </tr>
  <tr><td width="2%" height="13"></td></tr>
  <tr>
    <td width="2%" height="16"></td>
    <td width="2%" height="1" rowspan="18" background="img/shu.gif"></td>
    <td width="92%" height="1" colspan="5" rowspan="18">
      <div align="center">
        <center>
        <table border="0" cellpadding="0" cellspacing="1" width="99%" height="47">
	  <tr bgcolor='#DCEDED'>
	    <td width='100%' height='1' align="center">
	    <%
	    if (boolCanRegister==true)
	    {
	    %>
	      <font color="red" size="2">祝贺您,<%=username%>:您已经成功地注册了!</font>
	    <%
	    }
	    else
	    {
	    %>
	      <font color="red" size="2">对不起,<%=username%>:您的输入可能有误,请再试一下好吗?</font>	
	    <%
	    }
	    %>
	    </td>
	    
	  </tr>
	  <tr bgcolor='#DCDDED'>
	    <td width='100%' height='1' align="center">
	    <font color="red" size="2">回到<a href="index.jsp">首页</a></font>
	    </td>
	  </tr>
        </table>
        </center>
      </div>
    </td>     
    <td width="2%" height="1" rowspan="18"></td>     
    <td width="2%" height="1" rowspan="18" background="img/shu.gif">　</td>
  </tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="16"></td></tr>
  <tr><td width="2%" height="1"></td></tr>
  <tr>
    <td width="2%" height="41" rowspan="2"></td>
    <td width="2%" height="41" background="img/shu.gif" rowspan="2"></td>
    <td width="92%" height="27" colspan="5"></td>
    <td width="2%" height="41" rowspan="2" background="img/shu.gif"></td>
    <td width="2%" height="41" background="img/shu.gif" rowspan="2"></td>
  </tr>
  <tr align="center">
    <td width="92%" height="18" colspan="5" background="img/bottom.gif">　</td>
  </tr>
</table> 
<%@ include file="menu.jsp"%>
<%
conn.close();
%>
</body>                                                     
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -