regok.jsp

database connection, database connection, database connection, database connection,

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../conn/conn.jsp"%>
<%@ include file="../conn/time.jsp"%>
<%@ page import="java.lang.String"%>
<%
String username = request.getParameter("username");

String pass = request.getParameter("pass");
String question = request.getParameter("question");
String answer = request.getParameter("answer");
String bumen = request.getParameter("bumen");
String email = request.getParameter("email");
String sex = request.getParameter("sex");

username = new String(username.getBytes("ISO-8859-1"),"gbk");
question = new String(question.getBytes("ISO-8859-1"),"gbk");
answer = new String(answer.getBytes("ISO-8859-1"),"gbk");
bumen = new String(bumen.getBytes("ISO-8859-1"),"gbk");


%>



<%
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from member where username='"+username+"'");
if(!rs.next()){
%>



<%
String sql="insert into member(username,password,question,answer,email,bumen,regtime,lastlogintime,sex) values('"+username+"','"+pass+"','"+question+"','"+answer+"','"+email+"','"+bumen+"','"+time+"','"+time+"','"+sex+"')";
stmt.executeUpdate(sql);
%>
<script language=JavaScript>{window.alert('注册成功!请等待审核!');window.location.href='../jspNetShopping/index.jsp'}</script>

<%}else{%><script language=JavaScript>{window.alert('对不起！请帐号已被注册,请重新选择!');window.history.go(-1);}</script><%
}%>