mysms_jsp.java

做的非常好的论坛

      out.write("                    操作选项：[<a class=a03 href=delsms.jsp?id=");
      out.print(rs.getObject("id"));
      out.write(">删除</a>][<a class=a03 href=editsms.jsp?id=");
      out.print(rs.getObject("id"));
      out.write(">编辑</a>] \r\n");
      out.write("                    ");
}
      out.write("\r\n");
      out.write("                    </font></td>\r\n");
      out.write("                  <td width=\"45%\"><div align=\"right\">发信时间:");
      out.print(rs.getObject("indate").toString().substring(0,10));
      out.write("&nbsp;</div></td>\r\n");
      out.write("                </tr>\r\n");
      out.write("              </table></td>\r\n");
      out.write("          </tr>\r\n");
      out.write("        </table></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  </table>\r\n");
}
      out.write('\r');
      out.write('\n');

str="select * from sms where bbssystem=2 and accepter='"+session.getAttribute("name")+"' order by indate desc";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
if(rs1.next()&&t==null){

      out.write("\r\n");
      out.write("<table border=\"0\" width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#A4B6D7\" align=\"center\">\r\n");
      out.write("    <tr bgcolor=\"#b1d6fa\">\r\n");
      out.write("      <td height=\"23\" valign=\"middle\"> \r\n");
      out.write("        <div align=\"center\"><b>系统信息</b></div></td>\r\n");
      out.write("      <td class=\"new14\"><b>标 题：");
      out.print(rs1.getObject("title"));
      out.write("</b></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("    <tr bgcolor=\"#f3f5ff\">\r\n");
      out.write("      <td valign=\"top\" width=\"20%\" bgcolor=\"#e8f5FF\"><div align=\"center\">\r\n");
      out.write("          <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("            <tr> \r\n");
      out.write("              <td><div align=\"center\"> <IMG height=84 src=../bbs/userheadimg/cache5.gif width=84></div></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("            <tr> \r\n");
      out.write("              <td height=\"20\"><div align=\"center\">系统管理员</div></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("            <tr> \r\n");
      out.write("              <td height=\"12\">&nbsp;</td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table>\r\n");
      out.write("        </div></td>\r\n");
      out.write("      <td valign=\"top\" bgcolor=\"#f6f6f6\"><table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\r\n");
      out.write("          <tr>\r\n");
      out.write("            <td height=\"80\" valign=\"top\" class=\"new14\"> ");
      out.print(htmln(rs1.getObject("content").toString()));
      out.write("</td>\r\n");
      out.write("          </tr>\r\n");
      out.write("        </table>\r\n");
      out.write("        <table width=\"100%\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\">\r\n");
      out.write("          <tr>\r\n");
      out.write("            <td height=\"1\" background=\"../bbs/userheadimg/bg_text1.gif\"></td>\r\n");
      out.write("          </tr>\r\n");
      out.write("          <tr>\r\n");
      out.write("            <td><table width=\"100%\" border=0 cellspacing=0 cellpadding=0>\r\n");
      out.write("                <tr>\r\n");
      out.write("                  <td width=\"56%\" class=new14><font color=\"#000000\"> \r\n");
      out.write("                    ");
if(bbsadmin.equals("1")){
      out.write("\r\n");
      out.write("                    操作选项：[<a class=a03 href=delsms.jsp?id=");
      out.print(rs1.getObject("id"));
      out.write(">删除</a>][<a class=a03 href=editsms.jsp?id=");
      out.print(rs1.getObject("id"));
      out.write(">编辑</a>] \r\n");
      out.write("                    ");
}
      out.write("\r\n");
      out.write("                    ");
if(rs1.getObject("sender")!=null){
      out.write("[<a class=a03 href=\"agree.jsp?id=");
      out.print(rs1.getObject("id"));
      out.write("&postuser=");
      out.print(rs1.getObject("sender"));
      out.write("&accepter=");
      out.print(rs1.getObject("accepter"));
      out.write("&agree=Y\">同意</a>][<a class=a03 href=\"disagree.jsp?id=");
      out.print(rs1.getObject("id"));
      out.write("&postuser=");
      out.print(rs1.getObject("sender"));
      out.write("&accepter=");
      out.print(rs1.getObject("accepter"));
      out.write("&agree=N\">不同意</a>]");
}
      out.write("\r\n");
      out.write("                    </font></td>\r\n");
      out.write("                  <td width=\"44%\"><div align=\"right\">发信时间:");
      out.print(rs1.getObject("indate").toString().substring(0,10));
      out.write("&nbsp;</div></td>\r\n");
      out.write("                </tr>\r\n");
      out.write("              </table></td>\r\n");
      out.write("          </tr>\r\n");
      out.write("        </table></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  </table>\r\n");

}

      out.write('\r');
      out.write('\n');

if(t!=null){
ku="sender='"+username+"'";
}
else{
ku="accepter='"+username+"'";
}

if(smtype!=null&&searchstr!=null){
   sqlsms="select * from sms where "+ku+" and "+smtype+" like '%"+searchstr+"%' and bbssystem=0 order by indate desc";
}
else{
sqlsms="select * from sms where "+ku+" and bbssystem=0 order by indate desc";
}
//out.print(sqlsms);
//out.close();
ResultSet rs15=stmt1.executeQuery(sqlsms);
int i=1;
while(rs15.next()){ 
String replysign=rs15.getObject("replysign").toString();

if(t!=null){
str="select * from clubuser where clubuser_name='"+session.getAttribute("name")+"'";
}
else{
str="select * from clubuser where clubuser_name='"+rs15.getObject("sender").toString()+"'";
}
//str="select * from clubuser where clubuser_name='"+rs15.getString("sender")+"'";
//out.print(str);
Statement stmt5=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs5=stmt5.executeQuery(str);
rs5.next();
String clubuser_nickname=rs5.getObject("clubuser_nickname").toString();

      out.write("\r\n");
      out.write("<TABLE align=\"center\" bgColor=\"#a4b6d7\" border=0 cellPadding=0 cellSpacing=0 width=\"99%\">\r\n");
      out.write("    <TBODY>\r\n");
      out.write("      <TR bgColor=#f2f8ff> \r\n");
      out.write("        <TD width=\"20%\" height=\"23\" vAlign=middle bgColor=#b1d6fa class=font10_5><div align=\"center\">第");
      out.print(i);
      out.write("条</div></TD>\r\n");
      out.write("        <TD bgColor=#b1d6fa class=new14><B> 标 题：");
      out.print(rs15.getObject("title"));
      out.write("</B> </TD>\r\n");
      out.write("      </TR>\r\n");
      out.write("    </TBODY>\r\n");
      out.write("  </TABLE>\r\n");
      out.write("  <TABLE width=\"99%\" border=0 align=\"center\" cellPadding=0 cellSpacing=0 bgColor=\"#FFFFFF\">\r\n");
      out.write("    <TBODY>\r\n");
      out.write("      <TR bgColor=#f2f8ff>\r\n");
      out.write("        <TD bgColor=#e8f5ff class=font10_5 rowSpan=2 vAlign=top width=\"20%\"><DIV align=center>\r\n");
      out.write("            <TABLE border=0 cellPadding=0 cellSpacing=0 width=\"100%\">\r\n");
      out.write("              <TBODY>\r\n");
      out.write("                <TR>\r\n");
      out.write("                  <TD><div align=\"center\"><IMG height=84 src=\"../bbs/userheadimg/cache5.gif\" width=84></div></TD>\r\n");
      out.write("                </TR>\r\n");
      out.write("                <TR> \r\n");
      out.write("                  <TD height=20>・网名：");
      out.print(clubuser_nickname);
      out.write("</TD>\r\n");
      out.write("                </TR>\r\n");
      out.write("                <TR> \r\n");
      out.write("                  <TD height=20>・注册：");
      out.print(rs5.getObject("clubuser_reg_date").toString().substring(0,10));
      out.write("</TD>\r\n");
      out.write("                </TR>\r\n");
      out.write("              </TBODY>\r\n");
      out.write("            </TABLE>\r\n");
      out.write("          </DIV></TD>\r\n");
      out.write("      </TR>\r\n");
      out.write("      <TR bgColor=#f2f8ff>\r\n");
      out.write("        <TD bgColor=#f6f6f6 class=new14 vAlign=top><TABLE border=0 cellPadding=3 cellSpacing=3 width=\"100%\">\r\n");
      out.write("            <TBODY>\r\n");
      out.write("              <TR>\r\n");
      out.write("                <TD height=\"160\" vAlign=top class=new14>");
      out.print(htmln(rs15.getObject("content").toString()));
      out.write("</TD>\r\n");
      out.write("              </TR>\r\n");
      out.write("            </TBODY>\r\n");
      out.write("          </TABLE>\r\n");
      out.write("          <TABLE border=0 cellPadding=0 cellSpacing=5 width=\"100%\">\r\n");
      out.write("            <TBODY>\r\n");
      out.write("              <TR>\r\n");
      out.write("                <TD background=\"../bbs/images/bg_text1.gif\" height=\"1\"></TD>\r\n");
      out.write("              </TR>\r\n");
      out.write("              <TR>\r\n");
      out.write("                <TD align=left class=new14><table width=\"100%\" border=0 cellspacing=0 cellpadding=0>\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"56%\" class=new14>&nbsp;<font color=\"#000000\">操作选项：[<a class=a03 href=delsms.jsp?id=");
      out.print(rs15.getObject("id"));
      out.write(">删除</a>][<a class=a03 href=editsms.jsp?id=");
      out.print(rs15.getObject("id"));
      out.write(">编辑</a>][");
if(replysign.equals("0")){
      out.write("<a class=a03 href=replysms.jsp?id=");
      out.print(rs15.getObject("id"));
      out.write("&touser=");
      out.print(rs5.getObject("clubuser_name"));
      out.write(">回复</a>");
}else{
      out.write("<font color=\"#FF0000\">已回复</font>");
}
      out.write("]</font></td>\r\n");
      out.write("                      <td width=\"44%\"><div align=\"right\">发信时间:&nbsp;");
      out.print(rs15.getObject("indate").toString().substring(0,10));
      out.write("&nbsp;</div></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                  </table></TD>\r\n");
      out.write("              </TR>\r\n");
      out.write("            </TBODY>\r\n");
      out.write("          </TABLE></TD>\r\n");
      out.write("      </TR>\r\n");
      out.write("    </TBODY>\r\n");
      out.write("  </TABLE> \r\n");

i=i+1;
}

      out.write("\r\n");
      out.write("  <script language=\"JavaScript\" src=\"../inc/bbstail.js\"></script>\r\n");
      out.write("</div>\r\n");
      out.write("</body>\r\n");
      out.write("</html>");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}