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

📄 readtxt.jsp

📁 bbs设计是一个论坛方面的设计 基于jsp的系统设计
💻 JSP
字号:
🔍 
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:include page=cksession.jsp />
<%

//--------<<<<<<<<This code shows posts and their replies>>>>>>>>>>----------------------------
boolean flag;
int id=0;
String strQuery,strSQL,uptSQL;
strQuery=request.getParameter("idget"); 
String strAuthor,sign="";
String strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);

if(strQuery!=null){
  id=java.lang.Integer.parseInt(strQuery);
  uptSQL="UPDATE DATA SET INT_CLICKNUMB=INT_CLICKNUMB+1 WHERE INT_ID="+id;
  DB.executeUpdate(uptSQL);
		 


		strSQL = "SELECT INT_ROOTID,STR_TITLE,STR_DATE,STR_AUTHOR,TXT_CONTENT,STR_SIGN ";
		strSQL=strSQL+" FROM DATA WHERE INT_ID="+id+" OR INT_ROOTID="+id+" ORDER BY INT_ID ASC";
		
		//strSQL="SELECT * FROM DATA";
		ResultSet sqlRst=DB.executeQuery(strSQL);
		 %>
		<table border="0"  width='100%' cellpadding="2" cellspacing="0" >
		<%
		String ss,cp_bt,cp_zz,cp_sj,s1,s2,s3,s4="",s5,s6="";
		int intRply;
		cp_bt="<strong><font color=#42738c >Title:</font></strong>";
		cp_zz="<strong><font color=#42738c >Author:</font></strong>";
		ss="<tr ><td>";  
		
		while(sqlRst.next()){
		  
		  intRply=sqlRst.getInt("INT_ROOTID");
		  if(intRply!=0){
		    s1="Reply";
			 }
		    else{ 
		     s1=sqlRst.getString("STR_TITLE");
			 }
		  
		  s2=sqlRst.getString("STR_DATE");
		  s3=sqlRst.getString("STR_AUTHOR");
		  s4=sqlRst.getString("TXT_CONTENT");
		  s6=sqlRst.getString("STR_SIGN");
		  

		  out.print(ss+cp_bt+"&nbsp;<font color=red><big>"+s1+"</big></font><br>"+cp_zz+"&nbsp;<a href='quickmail.asp?author="+s3+"'>"+s3+"</a>" + "&nbsp;&nbsp;"+s2+"<br></td></tr><tr ><td >");
		  out.print("<br>"+s4+"<br></td></tr>");  
		  out.print("<tr><td align='right'>" +s6+"</td></tr>");
		  out.print("<tr><td ><hr></td></tr>");
			
		} 
		%>
		 
		</table>
		
		<%
		sqlRst.close(); 
		%>
		<script>
		function KillSpace(x){                  
	     while((x.length>0) && (x.charAt(0)==' '))                  
		 x = x.substring(1,x.length)                  
	     while((x.length>0) && (x.charAt(x.length-1)==' '))                  
	    	x = x.substring(0,x.length-1)                  
	        return x                  
           }                  
		 function CheckForm()                  
		{                  
			
			document.PostDoc.gt_zw.value=KillSpace(document.PostDoc.gt_zw.value);                  
			 if(document.PostDoc.gt_zw.value.length == 0)                  
			{                  
				alert('\nPlease Input content!!')                  
				return false                  
			}                        
		                  
			return true                  
		   }                        
		
		</script>
		
		 <form METHOD="POST" name="PostDoc" action="post2.jsp?root_id=<%=id%>" onsubmit="return CheckForm()">
		  <input type="hidden" name="task" value="insert">
		  <table  border="1" borderColorDark="#ffffff" borderColorLight="#333333"
		cellPadding="0" cellSpacing="0" width="60%">
		<tr><td><big><em><strong><font color=#ff0000 ><%=strShow %></font> wanna reply</strong></em></big><br>
		</td></tr>
		  <tr><td>
		  <textarea  wrap="virtual"  ROWS="15" COLS="60" NAME="gt_zw" style="background-color: rgb(245,252,252)"></textarea>
		  </td></tr>
		 <tr><td><input TYPE="submit" VALUE="Send"
		  NAME="B1"><input TYPE="reset" VALUE="Cancel" NAME="B2">
		  </td></tr>
		 </table>
		 
		</form>
<%}else{out.print("error");} %>

⌨️ 快捷键说明

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