package com.biyeseng.action;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.biyeseng.db.DBManager;
/**
* 会员注册
* @author biyeseng
* @company http://www.biyeseng.cn
*
*/
public class RegHuiAction extends HttpServlet {
/**
* Constructor of the object.
*/
public RegHuiAction() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String name=request.getParameter("name");
String pass=request.getParameter("pass");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String tel=request.getParameter("tel");
String card=request.getParameter("card");
String info=request.getParameter("info");
String adate=new java.util.Date().toLocaleString();
String state="非会员";
DBManager dbm = new DBManager();
String sql = "insert into hui(name,pass,sex,age,tel,card,info,adate,state) values('"+name+"','"+pass+"','"+sex+"','"+age+"','"+tel+"','"+card+"','"+info+"','"+adate+"','"+state+"')";
Statement stat = null;
Connection conn=null;
try {
conn=dbm.getConnection();
stat = conn.createStatement();
System.out.println(sql);
stat.execute(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if(stat!=null)
stat.close();
if(conn!=null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
out.println("<script>alert('信息注册成功，您可以登陆系统查看个人信息！');window.location.href='login.jsp'</script>");
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}