huiyishi_anpai_deletservlet.java

jsp考勤

package test;

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

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

public class Huiyishi_Anpai_DeletServlet extends HttpServlet
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public void service(HttpServletRequest req,HttpServletResponse res)
	throws ServletException,IOException
	{
		int errf = 0;
		Connection con = null;
		Status st = new Status();
		res.setContentType("text/html;charset=Shift_JIS");
		req.setCharacterEncoding("Shift_JIS");

		HttpSession session = req.getSession(true);
		//僄儔乕儊僢僙乕僕惗惉梡儊僜僢僪傪掕媊
		ErrorMessage em = new ErrorMessage();
		//僄儔乕僼僅儚乕僪梡儊僜僢僪傪掕媊
		ErrorForward efw = new ErrorForward();

		try
		{
			//DB僆乕僾儞
			con=DatabaseConn.getConnection();
			int i =Integer.parseInt(req.getParameter("j"));	
			Kaigi_Jouhou_004Entity[] kje =(Kaigi_Jouhou_004Entity[]) session.getAttribute(SISnet.SESSION_ID_STR+".KAIGI_JOUHOU");
			Kaigi_Jouhou_004Entity ee = kje[i];
			Kaigi_Jouhou kj = new Kaigi_Jouhou();

		    // Kaigi_Jouhou僆僽僕僃僋僩偺 delet()儊僜僢僪傪幚峴偟傑偡丅
			kj.delet(con,ee);
			String chaxunqufen =(String) session.getAttribute(SISnet.SESSION_ID_STR+".chaxunqufen");
			
			String datefrom =(String) session.getAttribute(SISnet.SESSION_ID_STR+".DATE");

			// Kaigi_Jouhou僆僽僕僃僋僩偺 find()儊僜僢僪傪幚峴偟傑偡丅			
			Kaigi_Jouhou_004Entity[] kjeagain = kj.find(con,datefrom,chaxunqufen);
			
			//session偺曐懚
			session.setAttribute(SISnet.SESSION_ID_STR+".KAIGI_JOUHOU",kjeagain);			
			session.setAttribute(SISnet.SESSION_ID_STR+".lenhuiyi",kjeagain.length+"");
			


			WinParam win[] = new WinParam[1];
			

			win[0] = new WinParam();
			win[0].param = "";
			win[0].url = "/kaoqin/kqglstm104.jsp";
			win[0].tar = "httm";
			//師偵屇傇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());
			}
		} 
		
	}
}