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 + -
显示快捷键?