year_del.jsp

来自「企业员工考勤系统」· JSP 代码 · 共 26 行

<%@ page contentType="text/html;charset=GBK"%>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ page import="java.sql.*" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>

<%! 
  String id="";
  String sql="";
  int result=0;
 %>
 <% 
   request.setCharacterEncoding("GBK");
   id=request.getParameter("id");
   sql="delete from year where id='"+id+"'";
   try{
     result=conn.executeUpdate(sql);
     conn.close();
     response.sendRedirect("year_manager_m.jsp");
   }catch(Exception e){
     response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>