OA系统

开发平台：

Java

viewinfo.jsp~15~：源码内容

							<%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*" %>
<%request.setCharacterEncoding("gbk"); %>
<jsp:useBean id="sql" scope="page" class="control.sqlcontrol" />
<html>
<head>
<title>
changeinfo
</title>
</head>
<body bgcolor="#ffffff">
<div align="center"><br />
<h4>查看今天备忘</h4>
<%try{
  sql.getSQL2005conn("dbconfig.xml");
  //部门名:
  String ud = (String)session.getAttribute("UD");
  //部门ID:
  String udid = (String)session.getAttribute("UDID");
  //用户名:
  String un = (String)session.getAttribute("UN");
  //用户ID:
  String uid = (String)session.getAttribute("UID");
  //权限:
  String pp = (String)session.getAttribute("POPE");
  //LOGIN:
  String login = (String)session.getAttribute("LOGIN");
if(login!=null&&login.equals("OK")){
    ResultSet bs = sql.getStatement("select * from perinfo where usersid='"+uid+"';");
     if(bs.next()){
      out.print("今天没有备忘！");
    }
    out.println("<table cellpadding='0' cellspacing='0' border='0'>");
    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><td height='25px'><font color='#ff0000'>[待办]</font>&nbsp;&nbsp;<a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+"&nbsp;&nbsp;"+bs.getString("date")+"...</a></td></tr>");
        }else{
          out.println("<tr><td height='25px'><font color='#00ff00'>[完结]</font>&nbsp;&nbsp;<a href=viewinfo_do.jsp?id="+bs.getString("id")+" >"+bs.getString("title")+"&nbsp;&nbsp;"+bs.getString("date")+"...</a></td></tr>");
        }
      }
    }
    out.println("</table>");
    bs.close();
    sql.closeDB();
    }else{
    response.sendRedirect("userlogin.jsp");
  }
}catch(Exception ex){
  ex.printStackTrace();
}
%>
</div>
</body>
</html>

						