📄 articlesfindlist.jsp

📁 一个很有用的电子刊物发布系统
💻 JSP
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.am.*,java.util.*" %>
<html>
<head>

	<title>刊物文章管理系统</title>
	<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>

<body >
<jsp:useBean id="article" scope="page" class="com.am.article"/>

<jsp:useBean id="dbconn" scope="application" class="com.am.OpenDB"/>
<jsp:useBean id="groupleader" scope="page" class="com.am.register"/>
<div align=center>
      <p><br><br>

        <b><font size="5">查询结果</font></b> 
		</p>
      <table width="90%" border="1" cellpadding="2" cellspacing="0"  >
        <tr bgcolor="#DFDFDF">
		<td width="10%" align=center><b>编号</b></td>
          <td width="35%" align=center><b>标题</b></td>
          <td width="15%" align=center><b>作者 </b></td>
          
          <td width="20%" align=center><b>提交时间</b></td>
		  <td width="20%" align=center><b>所属主题</b></td>

        </tr>
<%
String date1=request.getParameter("txtyear1")+"-"+request.getParameter("txtmonth1")+"-"+request.getParameter("txtday1")+" 23:59:59";
String date2=request.getParameter("txtyear2")+"-"+request.getParameter("txtmonth2")+"-"+request.getParameter("txtday2")+" 23:59:59";

String fields="0";

String[] myfields=request.getParameterValues("txtmyfields");
	if (myfields!=null)
	{
		for(int i=0;i<myfields.length;i++)
		{
			if(myfields[i]!="")
			{
				fields =fields +","+myfields[i];
			}
		}

	}

   	String strSql="";
    int articlecount=0;
	Statement stmt=dbconn.getConnection().createStatement();

		  strSql="select a.title,a.id,a.author,a.createDatetime,a.workgroup from articles a,users u where a.workgroup in("+fields+") and u.id=a.issuer and a.createDatetime>='"+date1+"' and a.createDatetime<='"+date2+"' and a.tag!=-1 order by a.ID asc ";
      
	ResultSet rs=stmt.executeQuery(strSql);
while(rs.next())

	{	articlecount+=1;%>

         <tr >
          <td>&nbsp;<%=rs.getString("a.ID")%></td>
		  <td width="23%">&nbsp;
		  <a href=../articleShow.jsp?ID=<%=rs.getString("a.ID")%> target="_blank"><%=rs.getString("a.title")%></a>
          </td>
          <td>&nbsp;<%=rs.getString("a.author")%></td>
          
          <td> <%=rs.getString("a.createDatetime")%></td>
          
          <td > <%
        String strSqlworkgroups="";
        Statement stmtworkgroups=dbconn.getConnection().createStatement();
        strSqlworkgroups="select * from `workgroup` where tag!=-1 and ID ="+rs.getString("a.workgroup");
        ResultSet rsworkgroups=stmtworkgroups.executeQuery(strSqlworkgroups);
        if(rsworkgroups.next())
        {
          out.println(rsworkgroups.getString("note")+' '+rsworkgroups.getString("fieldName"));
        }
        stmtworkgroups.close();
        rsworkgroups.close();
        %> 
		</td>

        </tr>
        <%
	}
		%>



 </table>
 <p>
 文章总数：<font color=blue><%=articlecount%></font>
    </p>
	</div>  
</body>
</html>
⌨️ 快捷键说明

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