?? area_1.jsp
字號:
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<%
ResultSet rs=DB.executeQuery("SELECT INT_ID,STR_TITLE,STR_AUTHOR FROM DATA WHERE INT_COOL=1 ORDER BY STR_DATE DESC");
//(------取數(shù)據(jù)，畫表格------------
int intRowcount =0;
String strId,strS1,strS2,cool_sign;
String strAll;
cool_sign="<strong><small><font face='Comic Sans MS'></font><font color=#ff0000>C</font><font color=#e68000>o</font><font color=#00c000>o</font><font color=#0099ff>l</font><font color=#9900ff>!</font></font></small></strong> ";
strAll="<table cellspacing='0' cellpadding='0' width='100%' bgcolor='#ebebeb'>";
while(rs.next()&&intRowcount<10){
strId=rs.getString("INT_ID");
strS1=rs.getString("STR_TITLE");
strS2=rs.getString("STR_AUTHOR");
strAll=strAll+"<tr ><td colspan='2' class='p9'>"+cool_sign+"<a href='readtxt.jsp?idget="+strId+"'>"+strS1+"</a></td><td align='left' nowrap><a href='intramail.jsp?receiver="+strS2+"'>"+strS2+"</a></td></tr>";
intRowcount++;
}
strAll=strAll+"</table>";
out.print(strAll);
rs.close();
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -