deljob.jsp

基于B/S的商贸管理系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="checksession.jsp"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ include file="../conn/conn.jsp"%>
<%
int id = Integer.parseInt((String)request.getParameter("id"));
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from job where id="+id);
rs.next();
int  userid=Integer.parseInt((String) session.getAttribute("userid"));
if (userid==Integer.parseInt((String) rs.getString("fbmemid"))){


String sql="delete from job where id="+id;
stmt.executeUpdate(sql);



response.sendRedirect("gljob.jsp");}else{%>
<script language=JavaScript>{window.alert('无权操作!');window.location.href='gljob.jsp'}</script>
<%
}
%>