dozhuce.jsp

这个源码是一个论坛的源码,包括登陆,搜索和发表等.不过还有些功能不是很完善.

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");

int iid=1;
String du="select max(userid) from scott.bbsuser";
ResultSet rt=stmt.executeQuery(du); 
if(rt.next())
{  String id=rt.getString("userid");
   iid=Integer.parseInt(id);
   iid++;
}


String username=request.getParameter("username");
String userpassword=request.getParameter("userpassword");
String useremail=request.getParameter("useremail");
String userhomepage=request.getParameter("userhomepage");
String userbirthday=request.getParameter("userbirthday");
String usersex=request.getParameter("usersex");
String comefrom=request.getParameter("comefrom");



String sql="select * from scott.bbsuser where username='"+username+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
   if(rs.next()){
	  out.print("<script>alert('该登录名已经有人使用了');history.go(-1);</script>");
   }else{
stmt.executeUpdate("INSERT INTO scott.bbsuser(userid,username,userpassword,useremail,userhomepage,userbirthday,usersex,comefrom)VALUES('"+iid+"','"+username+"', '"+userpassword+"','"+useremail+"','"+userhomepage+"','"+userbirthday+"','"+usersex+"','"+comefrom+"')");
out.print("<script>alert('添加成功');</script>");
   }
rs.close();
rt.close();
%>

<br>
<center>
<font color=red>用户名为<%=username%>的用户注册成功！</font>
<a href="index.jsp">返回</a>
</center>