deleteinfo.java

本系统基于jsp+servlet+javabean三层模式开发

package deleteServlet;

import java.io.IOException;
import java.io.PrintWriter;

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

import myLogger.MideaLogger;

import com.suntek.eap.jdbc.*;
import com.suntek.eap.core.app.*;

public class deleteInfo extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public deleteInfo() {
		super();
	}


	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
this.doPost(request, response);

}



	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
//		变量声明
		javax.servlet.http.HttpSession session = request.getSession();
		String yhm = (String)session.getAttribute("yhm");   
	          if (yhm==null){   
	              //转向显示页面   会话失效
				response.sendRedirect("error.jsp?type=2");                   
	        }   
//	获取员工id
//	连接数据源
	QueryHelper queryer = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());

//	员工基本信息
	String sql1 = "select I_YGBH from USERINFO where VC_ID='"+yhm+"'";
	RowModel row1 = null;
	try{
	row1 = queryer.getFirstRow(sql1);
	}
	catch(Exception ex){
	MideaLogger.logger.error(ex.getMessage());
	}
	String i_ygbh = row1.getColumnValue("I_YGBH");
		QueryHelper deleter = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());

		String sqldeleteW = "delete from WorkExp2 where i_ygbh = "+ i_ygbh;
		String sqldeleteS = "delete from StudyExp2 where i_ygbh = "+ i_ygbh;
		try{
		deleter.execute(sqldeleteW);
		deleter.execute(sqldeleteS);
		}
		catch(Exception ex){
			MideaLogger.logger.error(ex.getMessage());
		}//转向显示页面
		String updatesql = "Update USERINFO SET I_YGBH = "+i_ygbh+",I_JL = "+0+" WHERE VC_ID='"+yhm+"'";
		try{
			QueryHelper updater = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
			updater.execute(updatesql);
		}
		catch(Exception ex)
		{
			MideaLogger.logger.error(ex.getMessage());
		}
		response.sendRedirect("../user.jsp");
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}