📄 articlesacceptlist.jsp

📁 一个很有用的电子刊物发布系统
💻 JSP
字号:
<%@ 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"/>
<jsp:useBean id="articlesaudit" scope="application" class="com.am.articlesaudit"/>
<jsp:useBean id="workgroup" scope="page" class="com.am.workgroup"/>
<jsp:useBean id="register" scope="page" class="com.am.register"/>
  <%
	  
		String strSql11="";
		Statement stmt11=dbconn.getConnection().createStatement();
		strSql11="select count(*) as myCount from articles where tag!=-1  and accept =1";
		ResultSet rs11=stmt11.executeQuery(strSql11);
		rs11.first();	

		
		String strSql12="";
		Statement stmt12=dbconn.getConnection().createStatement();
		strSql12="select a.ID,a.title,a.author,a.reviewer1,a.reviewer2,w.note,w.fieldName from articles a,workgroup w where a.tag!=-1 and a.accept=1 and a.workgroup=w.ID order by w.note asc";

		ResultSet rs12=stmt12.executeQuery(strSql12);
		%>
<div align="center"> 
    <p><font size=5 color=blue><b>录用文章数量：<%=rs11.getInt("myCount")%></b></font></p>
  <table border="1" width="100%" cellspacing="0" cellpadding="0" >
   
  
		
			<tr bgcolor="#DFDFDF">
			<td width=6% align=center>
			编号
			</td>
			<td width=30% align=center>
			标题
			</td>
			<td width=15% align=center>
			作者
			</td>
			<td width=12% align=center>
			评审结果-1
			</td>
			<td width=12% align=center>
			评审结果-2
			</td>
			<td width=25% align=center>
			所属主题
			</td>
			</tr>
			<%
				while(rs12.next())
				{

					Statement stmt13=dbconn.getConnection().createStatement();
					ResultSet rs13=null;
					String strSql13 ="";
			%>
					<tr>
					<td>
					<%=rs12.getLong("a.ID") %>
					</td>
					<td>
					<a href=../articleShow.jsp?ID=<%=rs12.getLong("ID") %> target=_blank>
					<%=rs12.getString("a.title") %>
					</a>
					</td>
					<td>
					<%=rs12.getString("a.author") %>
					</td>
					<td>
					<%
						strSql13="select ID from articlesaudit where articleID ='"+rs12.getLong("a.ID")+"' and reviewer='"+rs12.getLong("a.reviewer1")+"'";
						rs13=stmt13.executeQuery(strSql13);
						if(rs13.next())
						{
							%>
							<a href=../auditShow.jsp?ID=<%=rs13.getLong("ID")%> target=_blank>查看</a>
							<%
						}
						else
						{
							out.println("未评审");
						}
					%>
					</td>
					<td>
					<%
						strSql13="select ID from articlesaudit where articleID ='"+rs12.getLong("a.ID")+"' and reviewer='"+rs12.getLong("a.reviewer2")+"'";
						rs13=stmt13.executeQuery(strSql13);
						if(rs13.next())
						{
							%>
							<a href=../auditShow.jsp?ID=<%=rs13.getLong("ID")%> target=_blank>查看</a>
							<%
						}
						else
						{
							out.println("未评审");
						}
					%>
					</td>
					<td>
					<%=rs12.getString("w.note") +" "+ rs12.getString("w.fieldName")%>
					</td>
					</tr>
			<%
		
				}
			
			

	%>
  </table>
 
    
</div>
</BODY></HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -