📄 wz_brow.jsp
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DateText"%>
<%@page import="DBCon"%>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect(); %>
<html>
<head>
<title>文章</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p align="center">文章管理页面</p>
<table width="80%" border="1" align="center" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ffffff" bgcolor="#e1e1e1">
<tr bordercolor="#000000">
<td width="37%" bgcolor="#CCCCCC">
<div align="center"><a href="wz_ziliao.jsp"><strong>添加新文章</strong></a></div></td>
<td width="53%"> </td>
<td width="10%"><div align="center">帮助</div></td>
</tr>
</table>
<table width="80%" border="1" align="center" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ffffff" bgcolor="#e1e1e1">
<%
String wz_power=(String)session.getValue("s_user_id");
IdSelectBean.setIdName("wz_del");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("'0' and wz_qf='3' and wz_power='"+wz_power+"'");
//IdSelectBean.setStrId("'0' and wz_qf='0' and wz_power="+wz_power+"");
try {
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
ResultSet result = IdSelectBean.getResultSet();
%>
<tr>
<td width="37%" bgcolor="#CCCCCC"> <div align="center"><strong>未完成文章</strong></div></td>
<td colspan="2"> </td>
<td width="9%"> <div align="center"></div></td>
<td width="10%"><div align="center">帮助</div></td>
</tr>
<tr>
<td><div align="center"><strong>标题</strong></div></td>
<td width="35%"> </td>
<td colspan="3"><div align="center"><strong>操作</strong></div></td>
</tr>
<%//利用while循环将数据表中的记录列出
while(result.next()) {
String id= result.getString("wz_id"); %>
<tr>
<td colspan="2"><div align="left"> <%= result.getString("wz_name") %> </div></td>
<td width="9%"><div align="center"><a href="wz_up.jsp?id=<%=id%>">修改</a></div></td>
<td width="9%"> <div align="center"><a href="wz_del.jsp?id=<%=id%>" onClick="return confirm('您确定删除吗？')">删除</a></div></td>
<td width="10%"> <div align="center"><a href="wz_xiang.jsp?id=<%=id%>">浏览</a></div></td>
</tr>
<%
}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</table>
<table width="80%" border="1" align="center" border="0" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ffffff" bgcolor="#e1e1e1">
<%
IdSelectBean.setIdName("1");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("1 and wz_del='0' and wz_qf='2' and wz_power='"+wz_power+"'");
try {
ResultSet result1= IdSelectBean.getResultSet();
%>
<tr>
<td width="37%" bgcolor="#CCCCCC"> <div align="center"><strong>被退回文章</strong></div></td>
<td colspan="3"> </td>
<td width="9%"><div align="center"></div></td>
<td width="10%"><div align="center">帮助</div></td>
</tr>
<tr>
<td><div align="center"><strong>标题</strong></div></td>
<td width="17%"><div align="center"><strong>被退回原因</strong></div></td>
<td width="18%"><div align="center"><strong>预期发布日期</strong></div></td>
<td colspan="3"> <div align="center"><strong>操作</strong></div></td>
</tr>
<%//利用while循环将数据表中的记录列出
while(result1.next()) {String id= result1.getString("wz_id"); %>
<tr>
<td><div align="left"><%= result1.getString("wz_name") %></div></td>
<td><div align="left"><%= result1.getString("wz_bei") %></div></td>
<td><div align="left"><%= result1.getString("wz_data") %></div></td>
<td width="9%"><div align="center"><a href="wz_up.jsp?id=<%=id%>">修改</a></div></td>
<td><div align="center"><a href="wz_del.jsp?id=<%=id%>" onClick="return confirm('您确定删除吗？')">删除</a></div></td>
<td><div align="center"><a href="wz_xiang.jsp?id=<%=id%>">浏览</a></div></td>
</tr>
<%
}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
DBConBean.closeAll();
%>
</table>
<table width="80%" border="1" align="center" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ffffff" bgcolor="#e1e1e1">
<tr>
<td width="37%"><div align="center"><strong>其他相关的操作</strong></div></td>
<td width="44%"> </td>
<td width="9%"> </td>
<td width="10%"><div align="center">帮助</div></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
</table>
<table width="80%" border="1" align="center" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ffffff" bgcolor="#e1e1e1">
<tr>
<td width="37%"><div align="center"><strong>本页面帮助</strong></div></td>
<td width="53%"> </td>
<td width="10%"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -