⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 showindividual.jsp

📁 JSP+SQL2005 MVC模式 下载后改DB.java类的SQL密码就可用。
💻 JSP
字号:
<%@ page language="java" import="com.model.javabean.SubSingle,java.util.ArrayList,java.sql.ResultSet,java.io.UnsupportedEncodingException" contentType="text/html;charset=gb2312"%>



<html>
  <head>
    
    <style type="text/css">
<!--
.STYLE1 {
	color: #660000;
	font-weight: bold;
}
.STYLE2 {
	color: #FFFFFF;
	font-weight: bold;
}
.STYLE3 {font-size: 16px}
-->
    </style>
</head>
  
  <body><br>
    <table width="1059" border="0" cellpadding="0" cellspacing="0" background="images/7.gif">
      <!--DWLayoutTable-->
      <tr>
        <td width="88" height="59">&nbsp;</td>
        <td width="853">&nbsp;</td>
        <td width="118">&nbsp;</td>
      </tr>
      <tr>
        <td height="884">&nbsp;</td>
        <td valign="top"><table width="100%" height="650" border="0" cellpadding="0" cellspacing="0">
          <!--DWLayoutTable-->
          <tr>
            <td width="853" height="441" valign="top"><table width="815" height="600" border="1" cellpadding="0" cellspacing="0">
              <!--DWLayoutTable-->
              <tr>
                <td colspan="2" align="center" bgcolor="#FFFFCC"> =============== @ 帖子内容 @ =============== </td>
              </tr>
              
              <%
   int num=-1;
   int id=-1;
   String title1 = "";
   String title2 = "";
   
   String strid=request.getParameter("id");
      
   System.out.print(strid);
   String strnum=request.getParameter("num");
   try{
	   id=Integer.parseInt(strid);
	   num=Integer.parseInt(strnum);
	 
   }catch(Exception e){
	   id=-1;
	   num=-1;
   }	   
   ArrayList sublist=(ArrayList)session.getAttribute("sublist");
   if(sublist==null||sublist.size()==0){
	   out.println("<tr><td align='center' colspan='2' height='25' bgcolor='#76B0C8'>查看帖子内容出错!</td></tr>");
   }
   else{
     int i=0;
	 for(;i<sublist.size();i++){
	   SubSingle subsingle=(SubSingle)(sublist.get(i));
	   if(id==subsingle.getId()&&num==subsingle.getTypenum()){
	   title1 = subsingle.getSubtitle();
	   //title2 = new String(subsingle.getSubtitle().getBytes("ISO-8859-1"),"gb2312");
	   System.out.print("ooooo====ooo");
	   System.out.print(title1);
%>
              <tr>
                <td width="127" bgcolor="#66FF99"><span class="STYLE1">主题:</span></td>
                <td width="682"><%=subsingle.getSubtitle()%></td>
              </tr>
              <tr>
                <td bgcolor="#66FF99"><span class="STYLE1">发帖人:</span></td>
                <td><%=subsingle.getIssuer()%></td>
              </tr>
              <tr>
                <td bgcolor="#66FF99"><span class="STYLE1">发帖时间:</span></td>
                <td><%=subsingle.getTime()%></td>
              </tr>
              <tr>
                <td bgcolor="#66FF99"><span class="STYLE1">详细内容:</span></td>
                <td height="90"><textarea name="textarea" cols="95" rows="13" readonly="readonly"><%=subsingle.getContent()%></textarea></td>
              </tr>
              <tr>
                <td  align="right" colspan="2"><a href="reversion.jsp?id=<%=id%>&num=<%=num%>&title1=<%=title1%>">[回复]</a>
              <a href="showsubject.jsp?num=<%=num%>">[返回]</a></td>
              </tr>
              <tr>
                <td height="40" colspan="2" align="center" valign="top" bgcolor="#FF99FF"> ********回复的帖子*******</td>
              </tr>
              
            <%
         String sql="select * from tb_revert where rev_card_type="+num+" and rev_card_id="+id+" order by rev_time desc"; 
         com.model.javabean.DB mydb=new com.model.javabean.DB();
         ResultSet rs=mydb.Read(sql);
         if(rs.next()){
	       rs.previous();
	       int k=1;
	       while(rs.next()){
           %>     <table width="813" height="142" border="1" cellpadding="0" cellspacing="0">
          <tr>
            <td height="31" colspan="8" background="images/top1.gif">&nbsp; <span class="STYLE3"><%=k++%>楼&nbsp;&nbsp; 
            <img src="images/face3.gif" alt="2" width="20" height="20" /> 回复人:<%=rs.getString("rev_author")%>&nbsp;&nbsp; 
            <img src="images/email.gif" alt="1" width="16" height="16" />Email&nbsp;&nbsp; <img src="images/ip.gif" width="16" height="15">IP&nbsp;&nbsp; 
            <img src="images/time.gif" alt="4" width="16" height="16"/>留言时间:<%=rs.getTimestamp("rev_time").toLocaleString()%>&nbsp;&nbsp;
                  <a href="delect.jsp?title=<%=subsingle.getSubtitle()%>&author=<%=rs.getString("rev_author")%>&id=<%=id%>&num=<%=num%>">删除该楼</a></span></td>
            </tr>
          <tr>
            <td width="127" height="109"><span class="STYLE3">回复内容:</span></td>
            <td width="712" colspan="7"><textarea name="textarea" cols="100" rows="8" readonly="readonly"><%=rs.getString("rev_content")%></textarea></td>
          </tr>
</table>
			  <%	    	   
	       }
         }
         else
    	   out.println("<tr><td align='center' colspan='2' height='25' bgcolor='#76B0C8'>没有回复的帖子!</td></tr>");
         mydb.closed();
         break;	   
	   }
     }
	 if(i>=sublist.size())
		 out.println("<tr><td align='center' colspan='2' height='25' bgcolor='#76B0C8'>要查看的帖子不存在!</td></tr>");
   }     
%>
            </table></td>
          </tr>
          
        </table></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="176"></td>
        <td></td>
        <td></td>
      </tr>
  </table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -