radiolist.jsp~7~
上传用户:dlqqsh
上传日期:2021-11-13
资源大小:7840k
文件大小:2k
源码类别:

OA系统

开发平台:

Java

  1. <%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*" %>
  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. articlelist
  9. </title>
  10. </head>
  11. <body bgcolor="#ffffff">
  12. <%try{
  13.   Connection conn=sql.getSQL2005conn("dbconfig.xml");
  14.   if(request.getParameter("pageID")==null){
  15.   }else{
  16.   fen.setpages(request.getParameter("pageID"));
  17.   }
  18.   String ud = (String)session.getAttribute("UD");
  19. String udid = (String)session.getAttribute("UDID");
  20. String un = (String)session.getAttribute("UN");
  21. String uid = (String)session.getAttribute("UID");
  22. String pp = (String)session.getAttribute("POPE");
  23. String login = (String)session.getAttribute("LOGIN");
  24. String where = "type='1'";
  25. if(login.equals("OK")){
  26.   where ="type='1' or depar = "+udid;
  27. }
  28.   String select = fen.getPageinfsql(12,"radio","id","desc",where);
  29.   ResultSet show = sql.getStatement(select);
  30.   %>
  31. <div align="center">
  32. <table cellpadding="0" cellspacing="0" border="1" width="80%">
  33. <%
  34.  while(show.next()){
  35.   out.println("<tr><td><font color='#ff00ff'>[公告消息]</font>&nbsp;&nbsp;<a href=showradio.jsp?id="+show.getString("id")+" target="_blank" >"+show.getString("title")+"&nbsp;&nbsp;"+show.getString("date")+"</a></td></tr>");
  36.  }
  37.  out.println("</table>");
  38.  out.println("<div>"+fen.controlPage("radiolist.jsp","pageID",8)+"</div>");
  39. %>
  40. </div>
  41. </body>
  42. </html>
  43. <%
  44. show.close();
  45. sql.closeDB();
  46. }catch(Exception e){
  47.   e.printStackTrace();
  48. } %>