📄 11-11.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>
<font color="yellow" size="+3">留言查询结果</font>
<hr>
<%@ page import="java.sql.*" %>
<%-- 连接数据库使用的语句 --%>
<%
String url=new String();
String sql=new String();
url="jdbc:odbc:liuyan";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);

String keywords=request.getParameter("keywords");
int serial=0;
String content=new String();
String emote=new String();
String mysql=new String();
String name=new String();
String gettime=new String();
mysql="select * from db2admin.guestbook where content like '%"+keywords+"%' or name like '%"+keywords+"%' order by serial_no DESC";
%>
<center>
<table border="1" cellspacing="0" width="560" bgcolor="#F0F8FF" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF">
<tr align="center" bgcolor="#0099FF">
<td width="30">表情</td>
<td width="60">留言人</td>
<td width="60">留言时间</td>
<td width="410">留言内容</td>
</tr>

<%
//显示查询到的相应贴子信息
Statement stat=conn.createStatement();
ResultSet rs=stat.executeQuery(mysql);
while(rs.next()){
	serial=rs.getInt("serial_no");
	emote=rs.getString("emote");
	content=rs.getString("content");
	name=rs.getString("name");
	gettime=rs.getString("guest_time");
	out.print("<tr>");
	out.print("<td width=\"30\" align=\"center\"><img src=\"images/"+emote+".gif\"></td>");
	out.print("<td width=\"60\" align=\"center\">"+name+"</td>");
	out.print("<td width=\"60\" align=\"center\">"+gettime+"</td>");
	out.print("<td width=\"410\">"+content+"</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 + -