📄 findinform.jsp
字号:
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="to.model.Login.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="to.model.Inform.*"%>
<%@ page import="to.model.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>通知浏览</title>
<style type="text/css">
table{font-size:13px}
<!--
a:link { text-decoration: none;color: black}
a:active { text-decoration:blink;}
a:hover {text-decoration: underline;position: relative; top: 3px; left: 3px; color: red}
a:visited { text-decoration:none;color: black}
-->
</style>
</head>
<body>
<form>
<table cellspacing="1" cellpadding="1" border="0" width="800" align="center">
<%
loginItem li=(loginItem)session.getAttribute("user");
if(li==null)
{
response.sendRedirect("OfficeLogin.jsp");
}
%>
<tr>
<td colspan="9" height="1"><hr/></td>
</tr>
<tr>
<th colspan="9" align="center">我收到的通知</th>
</tr>
<tr bgcolor="#006699">
<th width="80" align="center"><font color="White">序号</font></th>
<th width="130" align="center" colspan="2"><font color="White">通知标题</font></th>
<th width="90" align="center"><font color="White">发布人</font></th>
<th width="135" align="center"><font color="White">发布日期</font></th>
<th width="85" align="center" colspan="2"><font color="White">有效日期</font></th>
<th width="50" align="center"><font color="White">状态</font></th>
<th width="50" align="center"><font color="White">操作</font></th>
</tr>
<%
int id=Integer.parseInt(request.getParameter("id"));
InformBean ib=new InformBean();
Collection c=(Collection)ib.getInform(id);
Iterator it=c.iterator();
while(it.hasNext())
{
InformItem ii=(InformItem)it.next();
%>
<tr bgcolor="#ddddee">
<td width="80" align="center"><%=ii.getId()%></td>
<td width="130" align="center" colspan="2"><img src="image/arr.gif"/><a href="displayInform.jsp?id=<%=ii.getInformID()%>"><%=ii.getInformT()%></a></td>
<td width="90" align="center"><%=ii.getPromulgator()%></td>
<td width="135" align="center"><%=ii.getAddT()%></td>
<td width="85" align="center" colspan="2"><%=ii.getEndT()%></td>
<td width="50" align="center"><%=ii.getIfreand()%></td>
<td width="50" align="center"><font color="Blue"><img src="image/arr.gif"/><a href="BackAction.do?id=<%=ii.getInformID()%>">回复</a></font></td>
</tr>
<%
}
%>
<tr>
<td colspan="9" height="25" align="center"></td>
</tr>
<tr>
<td colspan="9" height="25" align="center"></td>
</tr>
<tr>
<th colspan="9" align="center">我发布的通知</th>
</tr>
<tr bgcolor="#006699">
<th width="86" align="center"><font color="White">序号</font></th>
<th width="104" align="center"><font color="White">通知标题</font></th>
<th width="60" align="center"><font color="White">发送给</font></th>
<th width="82" align="center"><font color="White">发布日期</font></th>
<th width="157" align="center" colspan="2"><font color="White">有效日期</font></th>
<th width="156" align="center"><font color="White">反馈</font></th>
<th width="156" align="center" colspan="2"><font color="White">操作</font></th>
</tr>
<%
InformBean ibs=new InformBean();
Vector v=(Vector)ibs.selectInform(li.getPeopleName().trim());
Enumeration e=v.elements();
while(e.hasMoreElements())
{
InformItem iis=(InformItem)e.nextElement();
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
DBConnection db=new DBConnection("CollegePool",500);
con=db.getConnection();
ps=con.prepareStatement("select * from kjc_People where PeopleID=?");
int Embracer=iis.getEmbracer();
ps.setInt(1,Embracer);
rs=ps.executeQuery();
while(rs.next())
{
iis.setPeopleName(rs.getString("PeopleName"));
}
Connection con1=null;
PreparedStatement ps1=null;
ResultSet rs1=null;
con1=db.getConnection();
ps1=con1.prepareStatement("select * from People where PeopleID=?");
ps1.setInt(1,Embracer);
rs1=ps1.executeQuery();
while(rs1.next())
{
iis.setPeopleName(rs1.getString("PeopleName"));
}
%>
<tr bgcolor="#ddddee">
<td width="80" align="center"><%=iis.getId()%></td>
<td width="104" align="center"><img src="image/arr.gif"/><a href="displayInformMessage.jsp?id=<%=iis.getInformID()%>"><%=iis.getInformT()%></a></td>
<td width="60" align="center"><%=iis.getPeopleName()%></td>
<td width="82" align="center"><%=iis.getAddT()%></td>
<td width="157" align="center" colspan="2"><%=iis.getEndT()%></td>
<td width="50" align="center"><font color="Blue"><img src="image/arr.gif"/><a href="displayBack.jsp?id=<%=iis.getInformID()%>">查看</a></font></td>
<td width="50" align="center"><font color="Blue"><img src="image/arr.gif"/><a href="EditInformAction.do?id=<%=iis.getInformID()%>">修改</a></font></td>
<td width="50" align="center"><font color="Blue"><img src="image/arr.gif"/><a href="DeleteInformAction.do?id=<%=iis.getInformID()%>">删除</a></font></td>
</tr>
<%
}
%>
<tr>
<td colspan="9" height="1"><hr/></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -