OA系统

开发平台：

Java

infolist.jsp~2~：源码内容

							<%@ 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">
<%
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")){
}else{
   response.sendRedirect("userlogin.jsp");
 }
ResultSet bs = sql.getStatement("select * from perinfo where usersid='"+uid+"' order by date desc;");
out.println("<table cellpadding='0' cellspacing='0' border='1' width='80%'>");
while(bs.next()){
    if(bs.getString("isread").equals("no")){
         out.println("<tr><td height='25px'><font color='#ff0000'>[待办]</font></td><td>"+bs.getString("title")+"</td><td>"+bs.getString("date")+"</td><td><a href=changeinfo.jsp?id="+bs.getString("id")+" >修改备忘信息</td><td><a href=deleteinfo.jsp?id="+bs.getString("id")+" >删除记录</td></tr>");
    }else{
         out.println("<tr><td height='25px'><font color='#00ff00'>[完结]</font></td><td>"+bs.getString("title")+"</td><td>"+bs.getString("date")+"</td><td><a href=changeinfo.jsp?id="+bs.getString("id")+" >修改备忘信息</td><td><a href=deleteinfo.jsp?id="+bs.getString("id")+" >删除记录</td></tr>");
    }
}
out.println("</table>");
bs.close();
sql.closeDB();
%>
</div>
</body>
</html>

						