reg_save.jsp

基于jsp的网络百宝箱

<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GB18030" import="java.sql.*,java.util.Date,java.io.*"%>
<%@ include file="config.ini"%>
<%@ include file="conn.jsp"%>
<%@ include file="md5.jsp"%>
<%
//接收用户提交的注册信息
String username=codeToString(request.getParameter("username"));
String password=md5(codeToString(request.getParameter("password")));
String email=codeToString(request.getParameter("email"));
String qq=codeToString(request.getParameter("qq"));
java.text.SimpleDateFormat now=new java.text.SimpleDateFormat("yyyy-MM-dd");   
String date=now.format(new java.util.Date());
if(username==null||password==null)
{
  response.sendRedirect("login.jsp");
}
else
{
	//判断用户注册的用户名是否已经存在
  try
  {
    sqlstr="select username from users where username='"+username+"'";
    rs=iCanDb.doSelect(sqlstr);
	//如果存在将返回错误信息
    if(rs.next())
    {
      out.print("<script>");
      out.print("alert('该用户名已被注册，请返回');");
      out.print("history.back();");
      out.print("</script>");
    }
	//如果不存在，则将用户输入的注册信息存储到数据库中
    else
    {
      if(email==null) {email="";}
      if(qq==null) {qq="";}
      try
      {
         sqlstr="insert into users([username],[password],[email],[qq],[date]) values('"+username+"','"+password+"','"+email+"','"+qq+"','"+date+"')";
         iCanDb.doAdd(sqlstr);
         sqlstr="select id from users where username='"+username+"'";
         rs=iCanDb.doSelect(sqlstr);
         rs.next();
         String id=rs.getString("id");
         String iCanroot=dirPath.replace('\\','/');
         File boxPath=new File(iCanroot+"box",id);
         boxPath.mkdir();
         out.print("<script>");
         out.print("alert('注册成功，请返回登陆！');");
         out.print("location.href='login.jsp';");
         out.print("</script>");
      }
      catch(Exception e)
      {
        out.print("<script>");
        out.print("alert('"+e+"');");
        out.print("location.href='login.jsp';");
        out.print("</script>");
      }
    }
  }
  catch(Exception e)
  {
    out.print("<script>");
    out.print("alert('数据库出错！');");
    out.print("location.href='login.jsp';");
    out.print("</script>");
  }    
}
%>