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

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

OA系统

开发平台：

Java

depArticleView.jsp~45~：源码内容
  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>
  10. <h4>部门内文章列表</h4>
  11. </head>
  12. <body bgcolor="#ffffff">
  13. <a href="myArticleView.jsp">个人文章查看  </a>&nbsp;
  14. <a href="depArticleView.jsp">部门文章查看  </a>&nbsp;
  15. <a href="allArticleView.jsp">全局文章查看 </a>&nbsp;
  16. <br />
  17. <br />
  18. <%
  19. try{
  20.   String ud = (String)session.getAttribute("UD");
  21.   String udid = (String)session.getAttribute("UDID");
  22.   String un = (String)session.getAttribute("UN");
  23.   String uid = (String)session.getAttribute("UID");
  24.   String pp = (String)session.getAttribute("POPE");
  25.   String login = (String)session.getAttribute("LOGIN");
  27.   if(login!=null&&login.equals("OK")){
  29.   String where = "";
  30.   if(pp.equals("dep")){//部门权限
  31.     where = " depar = '"+udid+"' ";
  32. Connection conn=sql.getSQL2005conn("dbconfig.xml");
  33. if(request.getParameter("pageID")==null){
  34. }else{
  35.   fen.setpages(request.getParameter("pageID"));
  36. }
  38. String select = fen.getPageinfsql(12,"article","id","desc",where);
  39. //out.print(select);
  40. ResultSet show = sql.getStatement(select);
  41. %>
  43. <div align="center">
  44.   <table cellpadding="0" cellspacing="0" border="1" width="95%">
  45.     <tr>
  46.       <td>用户</td>
  47.       <td>文章标题</td>
  48.       <td>用户部门</td>
  49.       <td>发布时间</td>
  50.       <td>文章类型</td>
  51.     </tr>
  52.     <%
  53.     DBConn dbc = new DBConn();
  54.     String bmsql = "";
  56.     while(show.next()){
  57.       bmsql = "";
  58.       %>
  59.       <tr>
  60.         <td><%=show.getString("users") %></td>
  61.         <td><a href=showarticle.jsp?id=<%=show.getString("id")%>  ><%=show.getString("title") %></a> </td>
  62.         <td><%
  63.         bmsql ="select deparname from deparment where id = '"+show.getString("depar")+"'";
  64.           String[][] bm = dbc.getArray(bmsql);
  65.           out.print(bm[0][0]);
  66.           %></td>
  67.         <td><%=show.getString("date") %></td>
  68.         <td><%if(show.getString("type").equals("0")){
  69.           out.print("共享文章");
  70.         }else if(show.getString("type").equals("1")){
  71.           out.print("部门内文章");
  72.         }else if(show.getString("type").equals("2")){
  73.           out.print("多部门编辑文章");
  74.         } %></td>
  75.       </tr>
  77.       <%
  79.     }
  81.     out.println("</table>");
  82.     out.println("<div>"+fen.controlPage("depArticleView.jsp","pageID",8)+"</div>");
  83.     %>
  85. </div>
  86. <a href="" target="_blank"></a>
  88. <%
  89. show.close();
  90. sql.closeDB();
  92.   }else if(pp.equals("all")){//全局权限
  93.   out.print("你有全局权限,可以在全局文章查看中获得更加详细文章列表<br />");
  94. Connection conn=sql.getSQL2005conn("dbconfig.xml");
  95. if(request.getParameter("pageID")==null){
  96. }else{
  97.   fen.setpages(request.getParameter("pageID"));
  98. }
  100. String select = fen.getPageinfsql(12,"article","id","desc",where);
  101. //out.print(select);
  102. ResultSet show = sql.getStatement(select);
  103. %>
  105. <div align="center">
  106.   <table cellpadding="0" cellspacing="0" border="1" width="80%">
  107.     <tr>
  108.       <td>用户</td>
  109.       <td>文章标题</td>
  110.       <td>用户部门</td>
  111.       <td>发布时间</td>
  112.       <td>文章类型</td>
  113.     </tr>
  114.     <%
  115.     DBConn dbc = new DBConn();
  116.     String bmsql = "";
  118.     while(show.next()){ bmsql = "";
  119.       %>
  120.       <tr>
  121.         <td><%=show.getString("users") %></td>
  122.         <td><a href=showarticle.jsp?id=<%=show.getString("id")%> ><%=show.getString("title") %></a> </td>
  123.         <td><%
  124.         bmsql ="select deparname from deparment where id = '"+show.getString("depar")+"'";
  125.           String[][] bm = dbc.getArray(bmsql);
  126.           out.print(bm[0][0]);
  127.   %></td>
  128.         <td><%=show.getString("date") %></td>
  129.         <td><%if(show.getString("type").equals("0")){
  130.           out.print("共享文章");
  131.         }else if(show.getString("type").equals("1")){
  132.           out.print("部门内文章");
  133.         }else if(show.getString("type").equals("2")){
  134.           out.print("多部门编辑文章");
  135.         } %></td>
  136.       </tr>
  138.       <%
  140.     }
  141.     out.println("</table>");
  142.     out.println("<div>"+fen.controlPage("depArticleView.jsp","pageID",8)+"</div>");
  143.     %>
  145. </div>
  146. <a href="" target="_blank"></a>
  148. <%
  149. show.close();
  150. sql.closeDB();
  152.   } else if(pp.equals("com")){//普通权限
  153.     out.print("你没有权限查看这个页面!");
  154.   }
  156. }else{
  157.   response.sendRedirect("userlogin.jsp");
  158.   }
  161. }catch(Exception e){
  162.   e.printStackTrace();
  163. } %>
  164. </body>
  165. </html>