articlesdeletelist.jsp
来自「一个很有用的电子刊物发布系统」· JSP 代码 · 共 51 行
JSP
51 行
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.am.*"%>
<jsp:useBean id="article" scope="page" class="com.am.article"/>
<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<html>
<head>
<title>刊物文章管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language=javascript>
<!--
function checkDel(delID)
{
if(confirm("确定要删除该文章吗?"))
{
window.location="articlesDelete.jsp?ID="+delID;
}
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF">
<%
String strSql="";
Statement stmt=dbconn.getConnection().createStatement();
strSql="select * from articles where tag=0 and issuer='" +((com.am.login)session.getAttribute("userlogin")).ID + "'";
ResultSet rs=stmt.executeQuery(strSql);
%>
<table cellspacing="0" cellpadding="5" border="1" width="90%">
<tr bgcolor="#DFDFDF">
<td width="10%"><b><font size="4">编号</font></b></td>
<td width="60%"><b><font size="4">文章标题</font></b></td>
<td width="30%"><b><font size="4">操作</font></b></td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getLong("ID")%></td>
<td><%=rs.getString("title") %></td>
<td>
<input type=button name=modifybtn value=删除 onclick='checkDel(<%=rs.getLong("ID")%>)'>
</td>
</tr>
<%
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?