//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.dut.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.dut.dao.BatchDBConnectionUtil;
import com.dut.struts.form.SyouhinInputActionForm;

/**
 * MyEclipse Struts Creation date: 04-16-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/syouhinRegistConf" name="syouhinInputActionForm"
 *                scope="request" validate="true"
 */
public class SyouhinRegistConfAction extends Action {

	// --------------------------------------------------------- Instance
	// Variables

	// --------------------------------------------------------- Methods

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SyouhinInputActionForm syouhinInputActionForm = (SyouhinInputActionForm) form;
		BatchDBConnectionUtil BDB = new BatchDBConnectionUtil();

		String s_year = (String) request.getSession().getAttribute("s_year");
		String yeshu = (String) request.getSession().getAttribute("s_yeshu");
		String dengji = (String) request.getSession().getAttribute("s_dengji");
		String s_sp = (String) request.getSession().getAttribute("s_sp");
		String s_spname = (String) request.getSession().getAttribute("s_spname");
		String s_spnamel = (String) request.getSession().getAttribute("s_spnamel");
		String duix = (String) request.getSession().getAttribute("duix");
		String s_by = (String) request.getSession().getAttribute("s_by");
		String s_fl = (String) request.getSession().getAttribute("s_fl");
		String s_qyyz = (String) request.getSession().getAttribute("s_qyyz");
		String s_qyfh = (String) request.getSession().getAttribute("s_qyfh");
		String s_ddbs = (String) request.getSession().getAttribute("s_ddbs");
		String nowdate = (String) request.getSession().getAttribute("nowdate");

		int nissu;
		String sql;
		int nen = Integer.parseInt(s_year);
		int hagaki_id = Integer.parseInt(yeshu);
		int toukyu_id = Integer.parseInt(dengji);
		int syouhin_id = Integer.parseInt(s_sp);
		int gyousya_id = Integer.parseInt(s_qyyz);
		int tyoutatusu = Integer.parseInt(s_ddbs);
		int jitaku = Integer.parseInt(duix);
		if(!s_by.equals("0")&& !s_fl.equals("柍")){
			nissu = Integer.parseInt(s_by);
			sql = "insert into SYOUHIN (NEN,HAGAKI_ID,TOUKYU_ID,SYOUHIN_ID,SYOUHIN_MEI,SYOUHIN_RYAKU,BUNRUI,GYOUSYA_ID,KEIYAKU_CD,TYOUTATUSU,JITAKU,NISSU,INSERT_DATE,UPDATE_DATE) values("
				+ nen
				+ ","
				+ hagaki_id
				+ ","
				+ toukyu_id
				+ ","
				+ syouhin_id
				+ ",'"
				+ s_spname
				+ "','"
				+ s_spnamel
				+ "','"
				+ s_fl
				+ "',"
				+ gyousya_id
				+ ",'"
				+ s_qyfh
				+ "',"
				+ tyoutatusu
				+ ","
				+ jitaku
				+ ","
				+ nissu
				+ ",'"
				+ nowdate
				+ "','"
				+ nowdate
				+ "'"
				+ ")";
          System.out.println(sql);
		}else{
			sql = "insert into SYOUHIN (NEN,HAGAKI_ID,TOUKYU_ID,SYOUHIN_ID,SYOUHIN_MEI,SYOUHIN_RYAKU,GYOUSYA_ID,KEIYAKU_CD,TYOUTATUSU,JITAKU,INSERT_DATE,UPDATE_DATE) values("
				+ nen
				+ ","
				+ hagaki_id
				+ ","
				+ toukyu_id
				+ ","
				+ syouhin_id
				+ ",'"
				+ s_spname
				+ "','"
				+ s_spnamel
				+ "',"
				+ gyousya_id
				+ ",'"
				+ s_qyfh
				+ "',"
				+ tyoutatusu
				+ ","
				+ jitaku
				+ ",'"
				+ nowdate
				+ "','"
				+ nowdate
				+ "'"
				+ ")";
			System.out.println(sql);
		}
		

		
		BDB.executeUpdate(sql);

		ActionForward forward = mapping.findForward("s_regist");
		return forward;
	}

}