package family.yin.senqi;

import javax.servlet.http.*;
import javax.servlet.ServletException;
import java.io.IOException;
import family.yin.senqi.dao.MyDAO;
import java.sql.*;
import family.yin.senqi.model.ModelOne;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class MyServlet extends HttpServlet {

  public void doPost(HttpServletRequest req, HttpServletResponse resp)
  throws ServletException, IOException
  {
    req.setCharacterEncoding("GBK");
    HttpSession session = req.getSession();
    MyDAO dao = new MyDAO();
    String recId = req.getParameter("recId");
    String indexid = req.getParameter("indexid");
    String type_str = req.getParameter("type");
    String person_str = req.getParameter("person");
    String money_str = req.getParameter("money");
    String name = req.getParameter("name");
    if(name==null)name="";
    String table_str = req.getParameter("table");

    if(recId==null || "".equals(recId)){
      ModelOne model = new ModelOne();
      model.setIndexid(indexid);
      model.setName(name);
      model.setType(0);
      model.setPerson(0);
      model.setMoney(0);
      model.setTables(0);
      if (type_str != null && !"".equals(type_str)) {
        model.setType(new Integer(type_str).intValue());
      }
      if (person_str != null && !"".equals(person_str)) {
        model.setPerson(new Integer(person_str).intValue());
      }
      if (money_str != null && !"".equals(money_str)) {
        model.setMoney(new Float(money_str).floatValue());
      }
      if (table_str != null && !"".equals(table_str)) {
        model.setTables(new Integer(table_str).intValue());
      }
      try {
        String rId = dao.getSid(0);
        model.setId(rId);
        dao.insertToMytable(model);
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
    }else{
      try {
        dao.deleteFromMytable(recId);
      }
      catch (SQLException ex1) {
        ex1.printStackTrace();
      }
    }
    String recTime = req.getParameter("recTime");
    String toPage = req.getParameter("toPage");
    resp.sendRedirect(toPage+"?cTime="+recTime);


  }

}