一、后台模糊查询
代码如下(示例):
<!-- 实现admin.jsp页面中模糊查询的搜索功能(根据标题进行模糊查询) -->
<div style = "width:100%;height:40px;text-align: center;line-height:40px; ">
<form action = "admin.jsp" method = "post">
<label>新闻标题</label>
<!-- autocomplete 关闭自动提示 -->
<input type = "text" name = "strName" autocomplete="off"/>
<input type = "submit" value = "搜索"/>
</form>
</div>
<%
//编码设置
request.setCharacterEncoding("utf-8");
String strName = request.getParameter("strName");
//搜索的关键词为中文 获取时会出现乱码 通过String类进行编码和解码
System.out.println("模糊查询的关键词为:[解决前] "+strName);
//sql语句
String sql = "select * from tb_news";
//第一次运行admin.jsp strName为null 不能调用任何方法
if(null!=strName){
strName = new String(strName.getBytes("ISO-8859-1"),"utf-8");
sql+=" where ntitle like '%"+strName+"%'";
}
%>
二、include指令
代码如下(示例):
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>后台-尾部封装页面</title>
</head>
<body>
<div id="site_link"> <a href="#">关于我们</a><span>|</span> <a href="#">Aboue Us</a><span>|</span> <a href="#">联系我们</a><span>|</span>
<a href="#">广告服务</a><span>|</span> <a href="#">供稿服务</a><span>|</span> <a href="#">法律声明</a><span>|</span> <a href="#">招聘信息</a><span>|</span>
<a href="#">网站地图</a><span>|</span> <a href="#">留言反馈</a> </div>
<div id="footer">
<p class="">24小时客户服务热线:010-68988888      <a href="#">常见问题解答</a>     
新闻热线:010-627488888<br />
文明办网文明上网举报电话:010-627488888      举报邮箱:<a href="#">[email protected]</a></p>
<p class="copyright">Copyright © 1999-2009 News China gov, All Right Reserver<br />
新闻中国 版权所有</p>
</div>
</body>
</html>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>新闻发布系统-后台主页</title>
<link rel="stylesheet" type="text/css" href="css/admin.css" />
</head>
<body>
<div id="header">
<div id="welcom">欢迎使用新闻管理系统!</div>
<ul class="classlist">
<%
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","123");
//将sql语句传入方法返回执行对象
PreparedStatement ps = conn.prepareStatement(sql);
//根据执行对象调用方法返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历结果集
while(rs.next()){
out.println("<li> <a href='admin_newsDetail.jsp?nid="+rs.getInt(1)+"'>"+rs.getString(3)+"</a> <span> 作者:"+rs.getString(4)+"      <a href='admin_editNews.jsp?nid="+rs.getInt(1)+"'>修改</a>      <a href='javascript:void(0)' onclick='clickdel(\""+rs.getInt(1)+"\")'>删除</a></span> </li>");
}
%>
<li class='space'