📄 reviewershow.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.am.*,java.text.*"%>
<jsp:useBean id="register" scope="page" class="com.am.register"/>
<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<html>
<head>
<title>刊物文章管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<%
register.ID=Long.parseLong((String)request.getParameter("ID"));
register.setConnection(dbconn.getConnection());
SimpleDateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
if (register.init()==false)
out.println(register.getErrDesc());
int total=0;
int done=0;
%>
<body>
<p><strong>
<font size="3">评审员姓名:</font><%=register.name%>
</strong></p>
<table cellspacing="0" cellpadding="5" border="1" width="90%">
<tr bgcolor="#DFDFDF">
<td width="15%"><font size="3">文章编号</font></td>
<td width="45%"><font size="3">标题</font></td>
<td width="20%"><font size="3">作者</font></td>
<td width="15%"><font size="3">评审状态</font></td>
</tr>
<%
String strSqlarticle="";
Statement stmt=dbconn.getConnection().createStatement();
strSqlarticle="select * from articles where ( reviewer1='"+register.ID+"' or reviewer2='"+register.ID+"' ) and tag!=-1 ";
ResultSet rsarticle=stmt.executeQuery(strSqlarticle);
String strSqlaudit="";
Statement stmtaudit=dbconn.getConnection().createStatement();
strSqlaudit="select * from articlesaudit where reviewer='"+register.ID+"'";
ResultSet rsaudit=stmtaudit.executeQuery(strSqlaudit);
String isdone="未评审";
while (rsarticle.next())
{
%>
<tr>
<td>
<%=rsarticle.getString("ID")%>
</td>
<td>
<font size="2">
<a href="articleShow.jsp?ID=<%=rsarticle.getLong("ID")%>" target="_blank">
<%=rsarticle.getString("title")%>
</a>
</font>
</td>
<td>
<font size="2">
<%=rsarticle.getString("author")%></font>
</td>
<%
rsaudit.beforeFirst();
while (rsaudit.next())
{
if (rsaudit.getInt("articleID")==rsarticle.getInt("ID"))
{
isdone="已评审";
done=done+1;
break;
}
}
%>
<td>
<font size="2"><%=isdone%></font>
</td>
</tr>
<%
total=total+1;
isdone="未评审";
}
%>
</table>
<p>分配文章总数:<%=total%></p>
<p>已评审数:<%=done%></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -