📄 articlesassignreviewerform.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 bgcolor="#FFFFFF" text="#000000">
<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<jsp:useBean id="no1" scope="page" class="com.am.register"/>
<jsp:useBean id="no2" scope="page" class="com.am.register"/>
<jsp:useBean id="theauthor" scope="page" class="com.am.register"/>
<%
String fieldID=(String)request.getParameter("ID");
String strArticleSql="";
String strReviewer="";
ResultSet rsAudit1;
ResultSet rsAudit2;
String strAuditSql1;
String strAuditSql2;
int intNum1;
int intNum2;
Statement stmt=dbconn.getConnection().createStatement();

strArticleSql="select * from articles where tag!=-1 and workgroup ='"+fieldID+"'";
strReviewer="select * from `users` where tag!=-1 and systemRole='2' and myfields like '%," + fieldID + ",%' ";


ResultSet rsArticle=stmt.executeQuery(strArticleSql);

Statement stmt2=dbconn.getConnection().createStatement();
Statement stmt3=dbconn.getConnection().createStatement();
Statement stmt4=dbconn.getConnection().createStatement();
ResultSet rsReviewer=stmt2.executeQuery(strReviewer);


%>
<div align=center>
<form name="form1" method="post" action="articlesAssignReviewerSave.jsp">
<input type=hidden name=fieldID value=<%=fieldID%> >
  <table width="100%" border="1" cellpadding="3" cellspacing="0">
    <tr bgcolor="#DFDFDF">
      <td width="10%" align=center><b><font size="3">序号</font></b></td>
	  <td width="10%" align=center><b><font size="3">文章编号</font></b></td>
      <td width="40%" align=center><b><font size="3">标题</font></b></td>
      <td width="20%" align=center><b><font size="3">评审员-1</font></b></td>
      <td width="20%" align=center><b><font size="3">评审员-2</font></b></td>
      
    </tr>
    <tr>
      <%
	int rowno=0;
	while(rsArticle.next())
    {
		rowno=rowno+1;
        strAuditSql1="select * from articlesaudit where tag!=-1 and articleID=" + rsArticle.getLong("ID") + " and reviewer='" + rsArticle.getLong("reviewer1") + "'";
		strAuditSql2="select * from articlesaudit where tag!=-1 and articleID=" + rsArticle.getLong("ID") + " and reviewer='" + rsArticle.getLong("reviewer2") + "'";
		intNum1=0;
		intNum2=0;
		rsAudit1=stmt3.executeQuery(strAuditSql1);
		rsAudit2=stmt4.executeQuery(strAuditSql2);
	if (rsAudit1.next())
	{
		intNum1=rsAudit1.getInt("point");
	}


	if (rsAudit2.next())
	{
		intNum2=rsAudit2.getInt("point");

    }
   %>
    <tr>
      <td width="10%"><b><%=rowno%></b></td>
	  <td width="10%"><%=rsArticle.getLong("ID")%></td>
      <td width="40%"><a href="../articleShow.jsp?ID=<%=rsArticle.getLong("ID")%>" target="_blank"><%=rsArticle.getString("title") %></a>
        <input type="hidden" name="txtID" value=<%=rsArticle.getLong("ID")%>>
      </td>
      <td width="20%">
        <p>
          <select name="txtReviewer1">
            <option value="0"></option>
            <%
        rsReviewer.beforeFirst();
        while(rsReviewer.next())
        {

            if(rsArticle.getLong("reviewer1")==rsReviewer.getLong("ID"))
            {%>
            <option selected value="<%=rsReviewer.getLong("ID")%>"><%=rsReviewer.getString("name")%>
            </option>
            <%
            }
            else
            {
            %>
            <option value="<%=rsReviewer.getLong("ID")%>"><%=rsReviewer.getString("name")%>
            </option>
            <%
            }
        }
        %>
          </select>
   

      <td width="20%">
        <select name="txtReviewer2">
          <option value="0"></option>
          <%
        rsReviewer.beforeFirst();
        while(rsReviewer.next())
        {
            if(rsArticle.getLong("reviewer2")==rsReviewer.getLong("ID"))
            {%>
          <option selected value="<%=rsReviewer.getLong("ID")%>"><%=rsReviewer.getString("name")%>
          </option>
          <%
            }
            else
            {
            %>
          <option value="<%=rsReviewer.getLong("ID")%>"><%=rsReviewer.getString("name")%>
          </option>
          <%
            }
        }
        %>
        </select>
       
      
    </tr>
    <%
    }
  %>
  </table>
  <p>
    <input type="submit" name="btnSumbit" value="保存">
    <input type="reset" name="btnReset" value="重设">
  </p>
</form>
</div>
</body>
</html>
⌨️ 快捷键说明

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