?? board.jsp
字號:
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<jsp:include page=cksession.jsp />
<%
int intPageSize; //Number of Records each page
int intRowCount; //Total number of records
int intPageCount; //Total pages
int intPage; //the current page number
String strPage,strAreaid,strSql="";
String strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
int i,intAreaid,intAllflag=0;
strPage=(String)request.getParameter("page");
strAreaid=(String)session.getValue("area_id");
if((!strAreaid.equals("0"))&&strAreaid!=null)
{intAreaid=java.lang.Integer.parseInt(strAreaid);
strSql="SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON ";
strSql=strSql+" FROM DATA WHERE INT_ROOTID=0 AND INT_AREAID="+intAreaid+" ORDER BY INT_ID DESC";
}
else{
strSql= "SELECT AREA.STR_AREANAME,AREA.STR_AREAMASTER,";
strSql=strSql+"DATA.INT_ID,DATA.STR_TITLE,DATA.STR_AUTHOR,DATA.INT_RPLYNUMB,DATA.INT_CLICKNUMB,DATA.STR_DATE,DATA.INT_TXTLEN,DATA.INT_COOL,DATA.INT_ICON,DATA.INT_AREAID ";
strSql=strSql+ " FROM AREA,DATA WHERE AREA.INT_AREAID=DATA.INT_AREAID AND ";
strSql=strSql+" DATA.INT_ROOTID=0 ORDER BY DATA.INT_ID DESC";
intAllflag=1;
}
%>
<table border="0" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<%if( intAllflag==1 ) {%>
<td align="center" nowrap ><font color="#ffffff" ><strong>Area</strong></font></td>
<%} %>
<td align="center" nowrap ><font color="#ffffff" ><strong>Title</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Author</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Reply/Click</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Date</strong></font></td>
</tr>
<jsp:include page=draw_tb.js />
<%
intPageSize = 20;
if(strPage==null){
intPage = 1;
}
else{
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
ResultSet sqlRst=DB.executeQuery(strSql);
sqlRst.last();
intRowCount = sqlRst.getRow();
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
int intCurrent=(intPage-1) * intPageSize +1;
if (intCurrent<=1){
sqlRst.beforeFirst();
}else{
sqlRst.absolute(intCurrent-1);
}
i = 0;
String s1,s2,s3,s4,s5,s6;
String id,icon,strAreanick="",strArealink="",strAreaguru="",cool_flag;
int intAid=0,RowCount;
icon="m1.gif";
RowCount=0;
while(i<intPageSize && sqlRst.next()){
id=sqlRst.getString("INT_ID");
s1=sqlRst.getString("STR_TITLE");
s2=sqlRst.getString("STR_AUTHOR");
s3=sqlRst.getString("INT_RPLYNUMB");
s4=sqlRst.getString("INT_CLICKNUMB");
s5=sqlRst.getString("STR_DATE");
s6="("+(String)sqlRst.getString("INT_TXTLEN")+" bytes)";
cool_flag=sqlRst.getString("INT_COOL");
icon=sqlRst.getString("INT_ICON");
if(intAllflag==1){
intAid=sqlRst.getInt("INT_AREAID");
strAreaguru=sqlRst.getString("STR_AREAMASTER");
strArealink=sqlRst.getString("STR_AREANAME");
if(strArealink.length()>8){
strAreanick=strArealink.substring(0,8);
}else{
strAreanick=strArealink;
}
}
s1=s1+s6;
out.print("draw_table("+id+",'"+s1+"','"+s2+"',"+s3+","+s4+",'"+s5+"',"+cool_flag+","+icon+","+intAllflag+","+intAid+",'"+strAreanick+"','"+strArealink+"','"+strAreaguru+"');\n");
i++;
}
}
%>
</script>
</table>
<table border="0" width="100%"><tr><td align="left">[Total <%=intPageCount%> Pages]</td><td align="right">
<%if(intPage>1){%><a href="board.jsp?page=<%=intPage-1%>">Previous</a><%}%> Page<font color="red"><%=intPage%></font> <%if(intPage<intPageCount){%><a href="board.jsp?page=<%=intPage+1%>">Next</a><%}%>
</td></tr></table>
<%
sqlRst.close();
if(intAllflag!=1){
%>
<p><big><em><strong><font color=#ff0000><%=strShow %></font> wanna speak</strong></em></big></p>
<form METHOD="POST" name=PostDoc action="post1.jsp" 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 width="100%"><em><strong><font color=#42738c face="times new roman"><big>New Topic:</font></strong></em></td>
</tr>
<tr>
<td width="100%"><input TYPE="text" SIZE="60" NAME="title" maxlength="60"
style="background-color: rgb(245,252,252)"></td>
</tr>
<tr>
<td width="100%"> <img alt height="20"
src="images/m1.gif" width="20"><input type="radio"
value="1" name="R1"> <img alt height="20"
src="images/m2.gif" width="20"> <input type="radio"
value="2" name="R1"> <img alt height="20"
src="images/m3.gif" width="20"> <input type="radio"
value="3" name="R1"> <img alt height="20"
src="images/m4.gif" width="20"> <input type="radio"
value="4" name="R1"></td>
</tr>
<tr>
<td width="100%"><em><strong><font color=#42738c face="times new roman"><big>Type Here:</font></strong></em><input
type="checkbox" name="htmltag" ><small>HTML</small>
</td>
</tr>
<tr>
<td width="100%"><textarea wrap="virtual" ROWS="15" COLS="60" NAME="content"
style="background-color: rgb(245,252,252)"></textarea></td>
</tr>
<tr>
<td width="100%"><input TYPE="submit" VALUE="Send" NAME="B1"><input TYPE="reset"
VALUE="Cancel" NAME="B2"></td>
</tr>
</table>
</form>
<%} %>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -