OA系统

开发平台：
Java

depArticle.jsp~58~：源码内容
							<%@ 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>
<%
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")){
      if(pp.equals("com")){//普通权限
  out.print("你没有权限查看这个页面!");
  }else{
    String where = " depar = '"+udid+"' ";
    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);
    ResultSet show = sql.getStatement(select);
   // out.print(select);
    %>
    <html>
    <head>
    <title>
    天津市河东区经济贸易委员会内部办公网
    </title>
    </head>
    <body bgcolor="#ffffff"><br />
<a href="myArticle.jsp">个人日志管理</a>
<a href="depArticle.jsp">部门内日志管理</a>
<a href="allArticle.jsp">全局日志管理</a>
<a href="edepArticle.jsp">多部门编辑日志管理</a><br /><br />
    <h4>部门内日志管理</h4>
    <div align="center">
   <table cellpadding="0" cellspacing="0" border="1" width="90%">
  <tr>
    <td>用户名</td>
    <td>日志标题</td>
    <td>用户部门</td>
    <td>发布日期</td>
    <td>日志类型</td>
    <td>修改日志</td>
    <td>删除日志</td>
  </tr>
      <%
      DBConn dbc = new DBConn();
      while(show.next()){
        String bmsql = "";%>
  <tr>
    <td><%= show.getString("users")%> </td>
    <td><%=show.getString("title") %></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>
    <td><a href=changearticle.jsp?id=<%=show.getString("id")%> >修改此日志</a></td>
    <td><a href=deletearticle_do.jsp?deleteid=<%=show.getString("id")%>&page=depArticle >删除</a></td>
  </tr>
<%
      }
      %>
      </table>
      <%out.println("<div>"+fen.controlPage("depArticle.jsp","pageID",8)+"</div>");
      %>
      </div>
    </body>
    </html>
    <%
    show.close();
    sql.closeDB();
  }
    }else{
      out.print("请登录!");
      %>
      <br /><a href="userlogin.jsp" target="mainFrame">用户登录</a>
      <%
      }
}catch(Exception e){
  e.printStackTrace();
} %>

						