shouye.jsp~21~
资源名称:bangong.rar [点击查看]
上传用户:dlqqsh
上传日期:2021-11-13
资源大小:7840k
文件大小:3k
源码类别:
OA系统
开发平台:
Java
- <%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*"%>
- <%request.setCharacterEncoding("GBK"); %>
- <jsp:useBean id="sql" scope="page" class="control.sqlcontrol"></jsp:useBean>
- <html>
- <head>
- <title>
- 天津市河东区经济贸易委员会内部办公网
- </title>
- <link href="css/sa.css" type="text/css" rel="stylesheet">
- </head>
- <body bgcolor="#ffffff">
- <%
- String message = request.getAttribute("msg")==null?"":request.getAttribute("msg").toString();
- out.print(message);
- String uid = (String)session.getAttribute("UID");
- %>
- <br>
- <table width="400" border="0" align="center" background="images/right.gif">
- <tr>
- <td align="center"><font class="font2">公告</font></td>
- </tr>
- </table>
- <br />
- <table width="600" height="110" border="0" align="center" class="tb">
- <tr>
- <td align="left">
- <marquee id="affiche" align="left" behavior="scroll" direction="up" height="100" width="400" loop="-1" scrollamount="2.0" onMouseOut="this.start()" onMouseOver="this.stop()">
- <%
- sql.getSQL2005conn("dbconfig.xml");
- ResultSet rs = sql.getStatement("select * from radio order by id desc;");
- int i=0;
- while(rs.next()){
- %>
- <br><font class="font3"> <%=rs.getString("date")%>
-
- <a href=showradio.jsp?id=<%=rs.getString("id")%> target="_blank" class="font3"><%=rs.getString("title")%> </a></font>
- <%
- i++;
- if(i==12){
- break;
- }
- }
- %>
- </marquee> <p></p>
- </td>
- </tr>
- </table>
- <br />
- <table width="400" border="0" align="center" background="images/right.gif" >
- <tr>
- <td align="center"><font class="font2">今日提醒</font></td>
- </tr>
- </table>
- <br />
- <%
- ResultSet bs = sql.getStatement("select * from perinfo where usersid='"+uid+"';");
- int i1=0;
- out.println("<table width='600' border='0' height='130' class='tb' align='center'>");
- while(bs.next()){
- String gettime = bs.getString("date");
- String time = new java.sql.Date(new java.util.Date().getTime()).toString();
- if(gettime.equals(time)){
- if(bs.getString("isread").equals("no")){
- out.println("<tr align='center'><td height='25px'><font color='#ff0000'>[待办]</font> "+bs.getString("date")+" <a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+" </a></td></tr>");
- }else{
- out.println("<tr align='center'><td height='25px'><font color='#00ff00'>[完结]</font> "+bs.getString("date")+" <a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+" </a></td></tr>");
- }
- }
- i1++;
- }
- if(bs==null){
- out.println("<tr><td>今天没有备忘信息,<a href='infolist.jsp'>-->管理备忘录</a></td></tr>");
- }
- out.println("</table>");
- bs.close();
- sql.closeDB();
- %>
- </body>
- </html>