dozhuce.jsp

用jsp和Oracle数据库写的一个论坛系统

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

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



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(username,userpassword,useremail,userhomepage,hpname,userbirthday,usersex,comefrom,usersign)VALUES('"+username+"', '"+userpassword+"','"+useremail+"','"+userhomepage+"','"+hpname+"','"+userbirthday+"','"+usersex+"','"+comefrom+"','"+usersign+"')");
out.print("<script>alert('添加成功');</script>");
   }
%>

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