开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
depArticleView.jsp~48~
资源名称：bangong.rar　[点击查看]
上传用户：dlqqsh
上传日期：2021-11-13
资源大小：7840k
文件大小：5k
源码类别：

OA系统

开发平台：

Java

depArticleView.jsp~48~：源码内容
  1. <%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*,officeol.mc.tools.*" %>
  2. <%request.setCharacterEncoding("gbk");%>
  3. <jsp:useBean id="sql" scope="page" class="control.sqlcontrol"></jsp:useBean>
  4. <jsp:useBean id="fen" scope="page" class="control.Textcontrol.Pagecontrol"></jsp:useBean>
  5. <html>
  6. <head>
  7. <title>
  8. 天津市河东区经济贸易委员会内部办公网
  9. </title>
  11. </head>
  12. <body bgcolor="#ffffff">
  13. <br />
  14. <h4 align="center">部门内文章列表</h4>
  15. <a href="myArticleView.jsp">个人文章查看  </a>&nbsp;
  16. <a href="depArticleView.jsp">部门文章查看  </a>&nbsp;
  17. <a href="allArticleView.jsp">全局文章查看 </a>&nbsp;
  18. <br />
  19. <br />
  20. <%
  21. try{
  22.   String ud = (String)session.getAttribute("UD");
  23.   String udid = (String)session.getAttribute("UDID");
  24.   String un = (String)session.getAttribute("UN");
  25.   String uid = (String)session.getAttribute("UID");
  26.   String pp = (String)session.getAttribute("POPE");
  27.   String login = (String)session.getAttribute("LOGIN");
  29.   if(login!=null&&login.equals("OK")){
  31.   String where = "";
  32.   if(pp.equals("dep")){//部门权限
  33.     where = " depar = '"+udid+"' ";
  34. Connection conn=sql.getSQL2005conn("dbconfig.xml");
  35. if(request.getParameter("pageID")==null){
  36. }else{
  37.   fen.setpages(request.getParameter("pageID"));
  38. }
  40. String select = fen.getPageinfsql(12,"article","id","desc",where);
  41. //out.print(select);
  42. ResultSet show = sql.getStatement(select);
  43. %>
  45. <div align="center">
  46.   <table cellpadding="0" cellspacing="0" border="1" width="95%">
  47.     <tr>
  48.       <td>用户</td>
  49.       <td>文章标题</td>
  50.       <td>用户部门</td>
  51.       <td>发布时间</td>
  52.       <td>文章类型</td>
  53.     </tr>
  54.     <%
  55.     DBConn dbc = new DBConn();
  56.     String bmsql = "";
  58.     while(show.next()){
  59.       bmsql = "";
  60.       %>
  61.       <tr>
  62.         <td><%=show.getString("users") %></td>
  63.         <td><a href=showarticle.jsp?id=<%=show.getString("id")%>  ><%=show.getString("title") %></a> </td>
  64.         <td><%
  65.         bmsql ="select deparname from deparment where id = '"+show.getString("depar")+"'";
  66.           String[][] bm = dbc.getArray(bmsql);
  67.           out.print(bm[0][0]);
  68.           %></td>
  69.         <td><%=show.getString("date") %></td>
  70.         <td><%if(show.getString("type").equals("0")){
  71.           out.print("共享文章");
  72.         }else if(show.getString("type").equals("1")){
  73.           out.print("部门内文章");
  74.         }else if(show.getString("type").equals("2")){
  75.           out.print("多部门编辑文章");
  76.         } %></td>
  77.       </tr>
  79.       <%
  81.     }
  83.     out.println("</table>");
  84.     out.println("<div>"+fen.controlPage("depArticleView.jsp","pageID",8)+"</div>");
  85.     %>
  87. </div>
  88. <a href="" target="_blank"></a>
  90. <%
  91. show.close();
  92. sql.closeDB();
  94.   }else if(pp.equals("all")){//全局权限
  95.   out.print("你有全局权限,可以在全局文章查看中获得更加详细文章列表<br />");
  96. Connection conn=sql.getSQL2005conn("dbconfig.xml");
  97. if(request.getParameter("pageID")==null){
  98. }else{
  99.   fen.setpages(request.getParameter("pageID"));
  100. }
  102. String select = fen.getPageinfsql(12,"article","id","desc",where);
  103. //out.print(select);
  104. ResultSet show = sql.getStatement(select);
  105. %>
  107. <div align="center">
  108.   <table cellpadding="0" cellspacing="0" border="1" width="95%">
  109.     <tr>
  110.       <td>用户</td>
  111.       <td>文章标题</td>
  112.       <td>用户部门</td>
  113.       <td>发布时间</td>
  114.       <td>文章类型</td>
  115.     </tr>
  116.     <%
  117.     DBConn dbc = new DBConn();
  118.     String bmsql = "";
  120.     while(show.next()){ bmsql = "";
  121.       %>
  122.       <tr>
  123.         <td><%=show.getString("users") %></td>
  124.         <td><a href=showarticle.jsp?id=<%=show.getString("id")%> ><%=show.getString("title") %></a> </td>
  125.         <td><%
  126.         bmsql ="select deparname from deparment where id = '"+show.getString("depar")+"'";
  127.           String[][] bm = dbc.getArray(bmsql);
  128.           out.print(bm[0][0]);
  129.   %></td>
  130.         <td><%=show.getString("date") %></td>
  131.         <td><%if(show.getString("type").equals("0")){
  132.           out.print("共享文章");
  133.         }else if(show.getString("type").equals("1")){
  134.           out.print("部门内文章");
  135.         }else if(show.getString("type").equals("2")){
  136.           out.print("多部门编辑文章");
  137.         } %></td>
  138.       </tr>
  140.       <%
  142.     }
  143.     out.println("</table>");
  144.     out.println("<div>"+fen.controlPage("depArticleView.jsp","pageID",8)+"</div>");
  145.     %>
  147. </div>
  148. <a href="" target="_blank"></a>
  150. <%
  151. show.close();
  152. sql.closeDB();
  154.   } else if(pp.equals("com")){//普通权限
  155.     out.print("你没有权限查看这个页面!");
  156.   }
  158. }else{
  159.   response.sendRedirect("userlogin.jsp");
  160.   }
  163. }catch(Exception e){
  164.   e.printStackTrace();
  165. } %>
  166. </body>
  167. </html>