reg.java

来自「一些基本jsp」· Java 代码 · 共 37 行

package my.servlet;
import my.data.MyOdbc;
import my.data.MyParameter;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Reg extends HttpServlet{
	public void doPost(HttpServletRequest request,
	   HttpServletResponse reponse)
	   throws IOException{
	   	MyParameter cn=new MyParameter(request);
	   	HttpSession session=request.getSession(true);
	   String sql,userId,password,sex,Email,quest,ponse,date;
	   userId=cn.getParameter("userId");
	   password=cn.getParameter("password");
	   sex=cn.getParameter("sex");
	   Email=cn.getParameter("Email");
	   quest=cn.getParameter("quest");
	   ponse=cn.getParameter("ponse");
	   MyOdbc myodbc=new MyOdbc();
	   date=myodbc.getTime();
	   sql="insert into 用户表(用户名,用户密码,性别,用户邮箱,密码问题,密码答案,注册日期)values('"+userId+"','"+password+"','"+sex+"','"+Email+"','"+quest+"','"+ponse+"','"+date+"')";
	   if(myodbc.regUpdate(userId)){
	   	myodbc.executeUpdate(sql);
	   	session.setAttribute("userId",userId);
	   	session.setAttribute("Type","user");
	   	System.out.println ("注册成功");
	 	   	reponse.sendRedirect("index.jsp");
	  }else{
	   	reponse.sendRedirect("err.jsp?id=1");
	   	
	       }        	
	   }
	
}