?? readtxt1.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";
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 face='times new roman'>Title:</font></strong>";
cp_zz="<strong><font color=#42738c face='times new roman'>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+" <font color=red><big>"+s1+"</big></font><br>"+cp_zz+" <a href='quickmail.asp?author="+s3+"'>"+s3+"</a>" + " "+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();
%>
<form METHOD="POST" action="post2.jsp?root_id=<%=id%>">
<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 + -