📄 11-22.txt

📁 jsp常用实例讲解
💻 TXT
字号:
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>查询结果</title>
<script language =JavaScript">
function newwin(url){
var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yew,width=600,height=450");
newwin.focus();
return false;
}
</script>
</head>

<body bgcolor="#FF66FF">
<div align="center">
<center>
<%@ page import="java.sql.*" %>
<%-- 连接数据库使用的语句 --%>
<%
String url=new String();
String sql=new String();
url="jdbc:odbc:luntan";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);

String keywords=request.getParameter("keywords");
int serial=0;
String title=new String();
String mysql=new String();
String speaker=new String();
String providedate=new String();
int reply=0;
int click=0;
mysql="select * from board where title like '%"+keywords+"%' or speaker like '%"+keywords+"%' or content like '%"+keywords+"%' order by serial_no DESC";
%>
<center>
<table border="1" cellspacing="0" width="500" bgcolor="#F0F8FF">
<tr bgcolor="#9dbffd" align="middle">
<td width="300" align="center">标题</td>
<td width="60" align="center">发贴人</td>
<td width="80" align="center">发贴时间</td>
<td width="40" align="center">点击数</td>
<td width="40" align="center">回复数</td>
</tr>

<%
//显示查询到的相应贴子信息
Statement stat=conn.createStatement();
ResultSet rs=stat.executeQuery(mysql);
while(rs.next()){
	serial=rs.getInt("serial_no");
	title=rs.getString("title");
	speaker=rs.getString("speaker");
	providedate=rs.getString("provide_time");
	reply=rs.getInt("reply_num");
	click=rs.getInt("click_num");
	out.print("<tr align=\"middle\">");
	out.print("<td width=\"300\" align=\"left\">");
	out.print("<a href=\"bbscontent.jsp?serial="+serial+"\" onClick=\"return newwin(this.href);\">"+title);
	out.print("</a>");
	out.print("</td>");
	out.print("<td width=\"60\" align=\"center\">"+speaker+"</td>");
	out.print("<td width=\"80\" align=\"center\">"+providedate+"</td>");
	out.print("<td width=\"40\" align=\"center\">"+reply+"</td>");
	out.print("<td width=\"40\" align=\"center\">"+click+"</td>");
	out.print("</tr>");
}
%>	
<%
rs.close();
stat.close();
conn.close();
%>
</table>
</center>
<p align="cener">
<a href="javascript:window.close();">关闭</a>
</p>
</body>
</html>
⌨️ 快捷键说明

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