📄 displayinform.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="to.model.*"%>
<%@ page import="to.model.Inform.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="to.model.Login.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>通知详细信息</title>
<style type="text/css">
table{font-size:13px}
</style>
</head>
<body>
<form action="AddInformAction.do" method="get">
<table cellspacing="2" cellpadding="2" border="2" width="500" align="center">
<%
loginItem li=(loginItem)session.getAttribute("user");
if(li==null)
{
response.sendRedirect("OfficeLogin.jsp");
}
int id=Integer.parseInt(request.getParameter("id"));
InformBean ib=new InformBean();
InformItem ii=ib.getInformMessage(id);
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=ii.getEmbracer();
ps.setInt(1,Embracer);
rs=ps.executeQuery();
while(rs.next())
{
ii.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())
{
ii.setPeopleName(rs.getString("PeopleName"));
}
%>
<tr bgcolor="#006699">
<th colspan="4" align="center"><font color="White"><%=ii.getInformT()%></font></th>
</tr>
<tr>
<td width="139">发布日期：</td>
<td width="503"><%=ii.getAddT()%></td>
</tr>
<tr>
<td width="139">有效日期：</td>
<td width="503"><%=ii.getEndT()%></td>
</tr>
<tr>
<td width="139">发 布 人：</td>
<td width="503"><%=ii.getPromulgator()%></td>
</tr>
<tr>
<td width="139">接 收 人：</td>
<td width="503"><%=ii.getPeopleName()%></td>
</tr>
<tr>
<td width="139">通知内容：</td>
<td width="503"><%=ii.getInformC()%></td>
</tr>
<tr>
<td width="139"> </td>
<td width="139"><a href="InformBack.jsp?id=<%=id%>">回复</a></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -