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

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. <html>
  5. <head>
  6. <title>
  7. 天津市河东区经济贸易委员会内部办公网
  8. </title>
  9. <link href="css/sa.css" type="text/css" rel="stylesheet">
  10. </head>
  11. <body bgcolor="#ffffff">
  12. <%
  13. String message = request.getAttribute("msg")==null?"":request.getAttribute("msg").toString();
  14. out.print(message);
  15. String uid = (String)session.getAttribute("UID");
  16. %>
  17. <br>
  18. <table width="400" border="0" align="center" background="images/right.gif">
  19.    <tr>
  20.      <td align="center"><font class="font2">公告</font></td>
  21.    </tr>
  22. </table>
  23. <br />
  24. <table width="600" height="110" border="0" align="center" class="tb">
  25.   <tr>
  26.     <td align="left">
  27.     <marquee id="affiche" align="left" behavior="scroll" direction="up" height="100" width="400" loop="-1" scrollamount="2.0"     onMouseOut="this.start()" onMouseOver="this.stop()">
  28. <%
  29. sql.getSQL2005conn("dbconfig.xml");
  30. ResultSet rs = sql.getStatement("select * from radio order by id desc;");
  31. int i=0;
  32. while(rs.next()){
  33. %>
  34. <br><font class="font3"> <%=rs.getString("date")%>
  35.        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  36.        <a href=showradio.jsp?id=<%=rs.getString("id")%> target="_blank" class="font3"><%=rs.getString("title")%>&nbsp;&nbsp;&nbsp;&nbsp;</a></font>
  37. <%
  38. i++;
  39. if(i==12){
  40.   break;
  41. }
  42.      }
  43.      %>
  44.  </marquee> <p></p>
  45. </td>
  46.   </tr>
  47. </table>
  48. <br />
  49. <table width="400" border="0" align="center" background="images/right.gif" >
  50.   <tr>
  51.     <td align="center"><font class="font2">今日提醒</font></td>
  52.   </tr>
  53. </table>
  54. <br />
  55. <%
  56. ResultSet bs = sql.getStatement("select * from perinfo where usersid='"+uid+"';");
  57. int i1=0;
  58.     out.println("<table width='600' border='0' height='130' class='tb'  align='center'>");
  59.     while(bs.next()){
  60.       String gettime = bs.getString("date");
  61.       String time = new java.sql.Date(new java.util.Date().getTime()).toString();
  62.       if(gettime.equals(time)){
  63.         if(bs.getString("isread").equals("no")){
  64.           out.println("<tr align='left'><td height='25px'><font color='#ff0000'>[待办]</font>&nbsp;&nbsp;"+bs.getString("date")+"&nbsp;&nbsp;&nbsp;&nbsp;<a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+"&nbsp;&nbsp;</a></td></tr>");
  65.         }else{
  66.           out.println("<tr align='left'><td height='25px'><font color='#00ff00'>[完结]</font>&nbsp;&nbsp;"+bs.getString("date")+"&nbsp;&nbsp;&nbsp;&nbsp;<a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+"&nbsp;&nbsp;</a></td></tr>");
  67.         }
  68.       }
  69.       i1++;
  70.     }
  71.     if(bs==null){
  72.     out.println("<tr><td>今天没有备忘信息,<a href='infolist.jsp'>-->管理备忘录</a></td></tr>");
  73.     }
  74.     out.println("</table>");
  75.     bs.close();
  76.     sql.closeDB();
  77. %>
  78. </body>
  79. </html>