OA系统

开发平台：
Java

articlelist.jsp~103~：源码内容
							<%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*,officeol.mc.tools.*" %>
<%request.setCharacterEncoding("gbk");%>
<jsp:useBean id="sql" scope="page" class="control.sqlcontrol"></jsp:useBean>
<jsp:useBean id="fen" scope="page" class="control.Textcontrol.Pagecontrol"></jsp:useBean>
<html>
<head>
<title>
天津市河东区经济贸易委员会内部办公网
</title>
</head>
<body bgcolor="#ffffff">
<h4>全局文章查看</h4>
<a href="myArticleView.jsp">个人文章查看  </a>&nbsp;
<a href="depArticleView.jsp">部门文章查看  </a>&nbsp;
<a href="allArticleView.jsp">全局文章查看 </a>&nbsp;
&nbsp;&nbsp;<br />
<br />
<%
try{
  String ud = (String)session.getAttribute("UD");
  String udid = (String)session.getAttribute("UDID");
  String un = (String)session.getAttribute("UN");
  String uid = (String)session.getAttribute("UID");
  String pp = (String)session.getAttribute("POPE");
  String login = (String)session.getAttribute("LOGIN");
  if(login!=null&&login.equals("OK")){
    String where = "";
    if(pp.equals("all")){//全局权限
    String bm = request.getParameter("bm");
    if(bm!=null){
      DBConn dbc = new DBConn();
      String dn = "select id,deparname from deparment where dnmd5 ='"+bm+"'";
      //System.out.print(dn);
      String[][] bmm = dbc.getArray(dn);
      out.print("<font size="5" color="red">"+bmm[0][1]+" 日志列表</font><vr />");
      where = " depar = '"+bmm[0][0]+"' ";
      Connection conn=sql.getSQL2005conn("dbconfig.xml");
      if(request.getParameter("pageID")==null){
      }else{
        fen.setpages(request.getParameter("pageID"));
      }
      String select = fen.getPageinfsql(12,"article","id","desc",where);
      //out.print(select);
      ResultSet show = sql.getStatement(select);
      %>
      <div align="center">
        <table cellpadding="0" cellspacing="0" border="1" width="95%">
          <tr>
            <td>用户</td>
            <td>文章标题</td>
            <td>用户部门</td>
            <td>发布时间</td>
            <td>文章类型</td>
          </tr>
          <%
          while(show.next()){
            String bmsql = "";
            %>
            <tr>
              <td><%=show.getString("users") %></td>
              <td><a href=showarticle.jsp?id=<%=show.getString("id")%>  ><%=show.getString("title") %></a> </td>
              <td><%        bmsql ="select deparname from deparment where id = '"+show.getString("depar")+"'";
          String[][] bm1 = dbc.getArray(bmsql);
          out.print(bm1[0][0]);
 %></td>
              <td><%=show.getString("date") %></td>
              <td><%if(show.getString("type").equals("0")){
          out.print("共享文章");
        }else if(show.getString("type").equals("1")){
          out.print("部门内文章");
        }else if(show.getString("type").equals("2")){
          out.print("多部门编辑文章");
        } %></td>
            </tr>
            <%
          }
          out.println("</table>");
          out.println("<div>"+fen.controlPage("articlelist.jsp","bm="+bm+"&"+"pageID",8)+"</div>");
          %>
</div>
</body>
</html>
<%
show.close();
sql.closeDB();
}
}else if(pp.equals("com")){//普通权限
out.print("你没有权限查看这个页面!");
}else if(pp.equals("dep")){//部门权限
out.print("你没有权限查看这个页面!");
}
}else{
  response.sendRedirect("userlogin.jsp");
  }
}catch(Exception e){
  e.printStackTrace();
} %>

						