📄 articleslist.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">
<script language=javascript>
<!-- 

function show_detail_rows(n)
{
	if (document.all.Show_Detail == null) return;
	if (document.all.Show_Detail.length != null)
	{
		if(document.all.Show_Detail[n].style.display == "block")
		{
			document.all.Show_Detail[n].style.display = "none"
		}
		else
		{
			document.all.Show_Detail[n].style.display = "block"
		}
		
	}
	else	
	{
		if(document.all.Show_Detailstyle.display == "block")
		{
			document.all.Show_Detail.style.display = "none"
		}
		else
		{
			document.all.Show_Detail.style.display = "block"
		}
	}
	
}
//  -->
</script>
</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"/>



<div align="center">
  
    <%
	String strSqlworkgroups="";
	Statement stmtworkgroups=dbconn.getConnection().createStatement();
	strSqlworkgroups="select * from workgroup where tag=0 order by note asc";

	ResultSet rsworkgroups=stmtworkgroups.executeQuery(strSqlworkgroups);
%>
    
  <table border="1"style="BORDER-COLLAPSE: separate" bordercolor=#000000 cellSpacing=1 cellpadding=3 width="100%">
    <tr >
	  <td width="70%" align=center><b><font size="4">主题</font></b></td>
      <td width="70%" align=center><b><font size="4">文章数量</font></b></td>
     </tr>
    <%
	  int i=0;
	  while(rsworkgroups.next())
	{
		String strSql11="";
		Statement stmt11=dbconn.getConnection().createStatement();
		strSql11="select count(*) as myCount from articles where tag!=-1  and workgroup="+rsworkgroups.getLong("ID");
		ResultSet rs11=stmt11.executeQuery(strSql11);

		
		int myCount = 0;
		if(rs11.next())
		{
			myCount = rs11.getInt("myCount");
		}
	%>
		
		<tr>
		<td bgcolor="#DFDFDF">
		<a href='javascript:show_detail_rows(<%= i %>);' target = _self >
		<%=rsworkgroups.getString("note")+" "+rsworkgroups.getString("fieldName")%>
		</a>
		</td>
		<td bgcolor="#DFDFDF">
		<%=myCount%>
		</td>
		</tr>

	
	<tr id="Show_Detail" style="display:none;" >
			<td colspan=2 style="padding:5px">
			<form name=form_<%=i%> method=post action=articlesDelete.jsp>
			<table border=0 cellspacing=1 cellpadding=5 width=100%>
			<tr >
			<td width=5%>
			编号
			</td>
			<td width=20%>
			标题
			</td>
			<td width=12%>
			作者
			</td>
			<td width=15%>
			评审员-1
			</td>
			<td width=15%>
			评审员-2
			</td>
			<td width=12%>
			状态
			</td>
			<td width=10%>
			修改
			</td>
			<td width=10%>
			删除
			</td>
			</tr>
			<%
				
			if(myCount > 0)
		{

			String strSql12="";
			Statement stmt12=dbconn.getConnection().createStatement();
			strSql12="select * from articles where tag!=-1 and workgroup="+rsworkgroups.getLong("ID");

			ResultSet rs12=stmt12.executeQuery(strSql12);
				while(rs12.next())
				{
				
					
			%>
					<tr>
					<td>
					<%=rs12.getLong("ID") %>
					</td>
					<td>
					<a href=../articleShow.jsp?ID=<%=rs12.getLong("ID") %> target=_blank>
					<%=rs12.getString("title") %>
					</a>
					</td>
					<td>
					<%=rs12.getString("author") %>
					</td>
					<td>
					<%
						if (rs12.getLong("reviewer1")==0) 
						{
							out.println("<b>未分配</b>");
						}
						else
						{	
								register.setConnection(dbconn.getConnection());
								register.ID=rs12.getLong("reviewer1");
								register.init();
								
									%>
									<b>
									<a href=../reviewerShow.jsp?ID=<%=register.ID%> target="_blank">
									<%=register.name%>
									</a>
									</b>
					<%
						}
					%>
					</td>
					<td>
					<%
						if (rs12.getLong("reviewer2")==0) 
						{
							out.println("<b>未分配</b>");
						}
						else
						{	
								register.setConnection(dbconn.getConnection());
								register.ID=rs12.getLong("reviewer2");
								register.init();
								
									%>
									<b>
									<a href=../reviewerShow.jsp?ID=<%=register.ID%> target="_blank">
									<%=register.name%>
									</a>
									</b>
					<%
						}
					%>
					</td>
					<td>
					<%	
				   if (rs12.getInt("accept")==1)
				 {

					out.println("被录用");
				 }
					else if (rs12.getInt("accept")==-1)
					{
					out.println("被拒录");
					}				   
				 else if (rs12.getInt("accept")==0)
				{
					out.println("等待");
				 }
					%>
					</td>
					<td>
					<a href=articlesModifyForm.jsp?ID=<%=rs12.getLong("ID") %> target=_self>
					修改
					</a>
					</td>
					<td>
					<input type=checkbox name=articleID value=<%=rs12.getLong("ID") %> >
					
					</td>
					</tr>
			<%
		
			}
		
			
			%>
				<tr>
					<td colspan=8 align=center>
						<input type=submit name=submit1 value=删除>&nbsp;&nbsp;&nbsp;&nbsp;
						<input type=reset name=reset1 value=重选>
					</td>
				</tr>
				<%}%>
			</table>
			</form>
			</td>
		</tr>
		
		
		<%

	i++;}
	%>
  </table>
 
    
</div>
</BODY></HTML>
⌨️ 快捷键说明

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