through.jsp

来自「用JSP写的一个在线购物网站的代码」· JSP 代码 · 共 31 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"' and system='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，您不是系统管理员不能进行相应操作");
history.back();
</script>
<%}else{
String small=request.getParameter("small");
int intsmall=Integer.parseInt(small);
String big=request.getParameter("big");
int intbig=Integer.parseInt(big);
String id=request.getParameter("id");
int intid=Integer.parseInt(id);

sql="update ware set censor_yes='"+"1"+"' where id='"+intid+"' and class_small='"+intsmall+"' and class_big='"+intbig+"'";
rs=data.executeQuery(sql);
response.sendRedirect("through_ware.jsp");
}}%>