OA系统

开发平台：
Java

shouye.jsp~17~：源码内容
							<%@ 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")%>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
       <a href=showradio.jsp?id=<%=rs.getString("id")%> target="_blank" class="font3"><%=rs.getString("title")%>&nbsp;&nbsp;&nbsp;&nbsp;</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='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>");
        }else{
          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>");
        }
      }
      i1++;
    }
    if(bs==null){
    out.println("<tr><td>今天没有备忘信息,<a href='infolist.jsp'>-->管理备忘录</a></td></tr>");
    }
    out.println("</table>");
    bs.close();
    sql.closeDB();
%>
</body>
</html>

						