📄 auditmanagement_main.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.am.*"%>
<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<jsp:useBean id="articlesaudit" scope="application" class="com.am.articlesaudit"/>
<html>
<head>
<title>刊物文章管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<div align="center">
<p>
<%
String strSql="";
Statement stmt=dbconn.getConnection().createStatement();
strSql="select * from articles where tag=0 and (";
strSql=strSql + "reviewer1='" + Long.toString(((com.am.login)session.getAttribute("userlogin")).ID) + "'";
strSql=strSql + " or reviewer2='" + Long.toString(((com.am.login)session.getAttribute("userlogin")).ID) + "')";
ResultSet rs=stmt.executeQuery(strSql);
%>
<br>
<font size="5">评审文章列表</font>
</p>
<table cellspacing="0" cellpadding="5" border="1" width="90%">
<tr bgcolor="#DFDFDF">
<td width="10%" align=center><b><font size="4">编号</font></b></td>
<td width="45%" align=center><b><font size="4">标题</font></b></td>
<td width="25%" align=center><b><font size="4">作者</font></b></td>
<td width="20%" align=center><b><font size="4">评审状态</font></b></td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getLong("ID")%></td>
<td>
<a href="../articleShow.jsp?ID=<%=rs.getLong("ID")%>" target="_blank">
<%=rs.getString("title") %>
</a>
</td>
<td><%=rs.getString("author")%></td>
<td>
<%
articlesaudit.setConnection(dbconn.getConnection());
articlesaudit.articleID = rs.getLong("ID");
articlesaudit.reviewer = ((com.am.login)session.getAttribute("userlogin")).ID;
if(articlesaudit.isAudited())
{
%>
<a href=auditModifyForm.jsp?ID=<%=articlesaudit.ID%> target=_self>
修改评审
</a>
<%
}
else
{
%>
<a href="auditAddForm.jsp?ID=<%=rs.getLong("ID")%>">评审</a>
<%
}
%>
</td>
</tr>
<%
}
%>
</table>
<p>
<%
strSql="select * from operatelog where tag=0 and operatorID='" +String.valueOf(((com.am.login)session.getAttribute("userlogin")).ID);
rs=stmt.executeQuery(strSql);
%>
<br>
<font size="5">操作日志</font>
</p>
<table cellspacing="0" cellpadding="5" border="1" width="90%">
<tr bgcolor="#DFDFDF">
<td width="25%" align=center><b><font size="4">操作类型</font></b></td>
<td width="45%" align=center><b><font size="4">操作对象</font></b></td>
<td width="30%" align=center><b><font size="4">操作时间</font></b></td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td ><%=rs.getString("operateType")%></td>
<td ><%=rs.getString("destination")%></td>
<td ><%=rs.getString("operateDatetime")%></td>
</tr>
<%
}
%>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -