articlesdelete.jsp
来自「一个很有用的电子刊物发布系统」· JSP 代码 · 共 40 行
JSP
40 行
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.am.*" %>
<HTML>
<HEAD>
<title>刊物文章管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<BODY>
<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<%
String[] articleID = request.getParameterValues("articleID");
String strID = "0";
for(int i=0; i<articleID.length;i++)
{
strID=strID +","+articleID[i];
}
String strSql = "delete from articles where ID in ("+strID+")";
try
{
Statement stmt=dbconn.getConnection().createStatement();
stmt.execute(strSql);
strSql ="delete from articlesaudit where articleID in ("+strID+")";
stmt.execute(strSql);
out.println("<center><font color=blue size=5>文章删除成功!</font></center><br><br>");
out.println("<center><input type=button name=gofirst value=确定 onclick=javascript:window.location='articlesList.jsp' ></center>");
}
catch(Exception e)
{
out.println("<center><font color=red size=5>删除文章失败,请稍后重试!</font></center><br><br>");
out.println("<center><input type=button name=goback value=返回 onclick=javascript:window.history.go(-1) ></center>");
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?