WebRoot/duanxin/duanxinlistmy.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
request.setCharacterEncoding("gb2312");
DBO db=new DBO();
String sql="select * from duanxin where 1=1 ";
if(session.getAttribute("yhm")!=null){
sql+=" and jsr='"+(String)session.getAttribute("yhm")+"'";
}
db.open();
ResultSet rs=db.query(sql);
//短信信息查询
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>短信列表</title>
</head>
<LINK href="../images/Admin_Style.css" type=text/css rel=stylesheet>
<LINK href="../images/style.css" type=text/css rel=stylesheet>


<body><br>
<br>
<br>

<form name="form" method="post" action="">

			    <table width="100%" border="1" cellspacing="0" cellpadding="0"  class="tablewidth">
                  <TR align="center" class=head ><TD height=23 colspan="15">我的信息列表</TD></TR>
				 		<tr class="listheadtr">
 <td width="9%" height="25" >短信编号</td>
 <td width="9%" height="25" >标题</td>
 <td width="9%" height="25" >内容</td>
 <td width="9%" height="25" >发送人</td>
 <td width="9%" height="25" >接受人</td>
 <td width="9%" height="25" >状态</td>
 <td width="9%" height="25" >时间</td>
 <td width="9%" height="25" >操作</td>
</tr>

			
					<%
					if(rs!=null){
					while(rs.next()){
					%>
                  	  <tr>
 <td height="24" ><%=rs.getString("dxid")%></td>
 <td height="24" ><%=rs.getString("bt")%></td>
 <td height="24" ><%=rs.getString("nr")%></td>
 <td height="24" ><%=rs.getString("fsr")%></td>
 <td height="24" ><%=rs.getString("jsr")%></td>
 <td height="24" ><%=rs.getString("zt")%></td>
 <td height="24" ><%=rs.getString("sj")%></td>
<td><a href="duanxindetail.jsp?keyid=<%=rs.getString("dxid")%>">查看</a></td>
</tr>

                 <%
				 }
				 }