📄 search.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 />
<%
if(request.getParameter("search_string")!=null)
{if(request.getParameter("R1")!=null)
{
String strPage,strAreaid,strSql="";
String strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
int intAreaid,intAllflag=0;
String strSearchfield=(String)request.getParameter("R1");
String strSearchstring=(String)request.getParameter("search_string");
if(strSearchfield.equals("title")){
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 AND DATA.STR_TITLE LIKE'%"+strSearchstring+"%' ORDER BY DATA.INT_ID DESC";
}
if(strSearchfield.equals("author")){
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 AND DATA.STR_AUTHOR LIKE'%"+strSearchstring+"%' ORDER BY DATA.INT_ID DESC";
}
intAllflag=1;
%>
<center><font face="times new roman"><big><strong>Search Results</strong></big></font></center>
<table border="0" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<%if( intAllflag==1 ) {%>
<td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>Area</strong></font></td>
<%} %>
<td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>Title</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Author</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Reply/Click</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Date</strong></font></td>
</tr>
<jsp:include page=draw_tb.js />
<%
ResultSet sqlRst=DB.executeQuery(strSql);
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(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");
}
%>
</script>
</table>
<%
sqlRst.close();
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -