updata_syainservlet.java

jsp考勤

/*
 *	Copyright (C) 2000, Toa System, Ltd.  All rights reserved.
 */

 package test;

import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
import util.*;
import def.*;
import exce.*;
import entity.*;



/**
 *	偙偺僒乕僽儗僢僩偼丄儘僌僀儞僠僃僢僋偺偨傔偺Servlet偱偡丅<br>
 *	@version	2.00
 *	@author		TOA
 *
 *	峏怴棜楌
 *	<ul>
 *		<li>
 *	</ul>
 */
public class Updata_SyainServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;



	public void init(ServletConfig config)
	throws ServletException {

		super.init(config);

		try {
		    Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (Exception e) {
		    System.out.println("Class.forName()failed");
			e.printStackTrace();
		}
    }
	
	

	public void service(HttpServletRequest req, HttpServletResponse res)
	throws ServletException, IOException {
		int errf = 0;

		ChangeField cf = new ChangeField();

		Connection con = null;
		Status st = new Status();
		res.setContentType("text/html;charset=Shift_JIS");
	    req.setCharacterEncoding("Shift_JIS");		

		HttpSession session	= req.getSession(true);
		Syutuketu_Jouhou_003Entity[] ees = (Syutuketu_Jouhou_003Entity[]) session.getAttribute(SISnet.SESSION_ID_STR + ".SYUTUKETU_JOUHOU");

		//僄儔乕儊僢僙乕僕惗惉梡儊僜僢僪傪掕媊
		ErrorMessage em = new ErrorMessage();
		//僄儔乕僼僅儚乕僪梡儊僜僢僪傪掕媊
		ErrorForward efw = new ErrorForward();
		String	Kengen_Kubun	= req.getParameter("Kengen_Kubun");

		String	bumenNo	= (String) session.getAttribute(SISnet.SESSION_ID_STR + ".bumenNo");
		String	useidfrom	= (String) session.getAttribute(SISnet.SESSION_ID_STR + ".useidfrom");
		String	useidto	= (String) session.getAttribute(SISnet.SESSION_ID_STR + ".useidto");
		String	datefrom	= (String) session.getAttribute(SISnet.SESSION_ID_STR + ".datefrom");
		String	dateto	= (String) session.getAttribute(SISnet.SESSION_ID_STR + ".dateto");

		String	userid	= req.getParameter("userid");
		String	starttime	= req.getParameter("starttime").replace(":","");
		String	endtime	= req.getParameter("endtime").replace(":","");
		String	tikoku	= req.getParameter("tikoku");
		String	soutai	= req.getParameter("soutai");
		String	zangyou	= req.getParameter("zangyou");
		String	xiujia	= req.getParameter("xiujia");
		String	cout	= req.getParameter("i");
		int count = cf.strToInt(cout);

		Syutuketu_Jouhou_003Entity sjee =new Syutuketu_Jouhou_003Entity ();

		    sjee._user_cd  = ees[count]._user_cd;
			sjee._user_nm  = ees[count]._user_nm;
			sjee._bumon_cd  = ees[count]._bumon_cd;
			sjee._bumon_nm  = ees[count]._bumon_nm;
			sjee._date_time = ees[count]._date_time;            // 擔晅
			sjee._tikoku = cf.strToDouble(tikoku);               // 抶崗
			sjee._soutai = cf.strToDouble(soutai);     
			sjee._zangyou = cf.strToDouble(zangyou);     
			sjee._ketukin = 0.0;     
			sjee._xiujia = cf.strToDouble(xiujia); 
			sjee._syutyou = 0.0;
			sjee._start_end_kubun = "1";
			sjee._start_time = cf.strToInt(starttime);           // 弌嬑帪揰
			sjee._end_time = cf.strToInt(endtime);                  // 戅嬑帪揰
			sjee._update_user= ees[count]._user_cd;
			sjee._olupdate_user= ees[count]._user_cd;
				    

		try {
        	//DB僆乕僾儞
			con = DatabaseConn.getConnection();

			Syain_Kyutuketu sk = new Syain_Kyutuketu();

			// Syain_Kyutuketu僆僽僕僃僋僩偺 updata()儊僜僢僪傪幚峴偟傑偡丅
			sk.updata(con, sjee);

			// Syain_Kyutuketu僆僽僕僃僋僩偺 search()儊僜僢僪傪幚峴偟傑偡丅
			Syutuketu_Jouhou_003Entity[] sjet = sk.search(con, bumenNo,useidfrom,useidto,datefrom,dateto);

		
			//僙僢僔儑儞奿擺
			session.setAttribute(SISnet.SESSION_ID_STR + ".SYUTUKETU_JOUHOU", sjet);
			session.setAttribute(SISnet.SESSION_ID_STR + ".Kubun_kaoqin", "1");
			session.setAttribute(SISnet.SESSION_ID_STR + ".Kengen_Kubun", Kengen_Kubun);
			session.setAttribute(SISnet.SESSION_ID_STR + ".userid", userid);
			session.setAttribute(SISnet.SESSION_ID_STR + ".len_kaoqin", cf.intToStr(sjet.length));
			
		
            String parm = "";

                    WinParam win[] 	= new WinParam[1];						//僷儔儊乕僞攝楍愰尵
					win[0]			= new WinParam();					
					win[0].param	= parm;
					win[0].url        ="/kaoqin/kqglstm102.jsp";
					win[0].tar		= "_self";

						//師偵屇傇URL
					
			//僐儈僢僩張棟傪峴偆
			con.commit();

			//捈愙JSP傪屇傃弌偡丅乮偨偩屇傇偩偗乯
	
			
			req.setAttribute("JspParam",win);

			RequestDispatcher requestDispatcher=req.getRequestDispatcher("hb/util/Success.jsp"); 
            requestDispatcher.forward( req, res ); 
			


		} catch(OriginalException e) {
			
			errf = 1;
			st = e.getStatus();
			st.status	= -5;								// Application僄儔乕偵偡傞
			if ( st.errno != 71 ) {
				st.errno	= 110;								// Login,Password偑晄惓偱偡
			}
			String msg = em.getErrorMsg(st,"<BR>");
			efw.errForward(1,
							msg,
							req,
							res,
							this.getServletContext());
		} catch(Exception ee) {
			
			errf = 1;
			st.status	= -99;
			st.errno	= 999;
			String msg = em.getErrorMsg(st,"<BR>");
			efw.errForward(1,
							msg,
							req,
							res,
							this.getServletContext());
		} finally {
			try	{
				if ( errf == 1 ) {
					con.rollback();
				}
				if ( con != null ) {
					con.close();
				}
			} catch(Exception ee) {
				
				st.status	= -99;
				st.errno	= 999;
				String msg = em.getErrorMsg(st,"<BR>");
				efw.errForward(1,
								msg,
								req,
								res,
								this.getServletContext());
			}
		} 
	}
}