没有网站可以备案吗,软件设计图片,宁波网站扔优化,wordpress 问答系统类似于百度的搜索引擎模糊查询功能#xff0c;不过百度的模糊查询功能更强大#xff0c;这里简单实现下. 要实现模糊查询#xff0c;首先要做的就是把SQL写好。话不多少#xff0c;直接贴代码了! JSP页面#xff1a; % page languagejava importjav… 类似于百度的搜索引擎模糊查询功能不过百度的模糊查询功能更强大这里简单实现下. 要实现模糊查询首先要做的就是把SQL写好。话不多少直接贴代码了! JSP页面 % page languagejava importjava.util.* pageEncodingUTF-8%
%
String path request.getContextPath();
String basePath request.getScheme()://request.getServerName():request.getServerPort()path/;
%
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
htmlheadbase href%basePath%titleMy JSP search.jsp starting page/titlemeta http-equivpragma contentno-cachemeta http-equivcache-control contentno-cachemeta http-equivexpires content0 meta http-equivkeywords contentkeyword1,keyword2,keyword3meta http-equivdescription contentThis is my page script typetext/javascript srcprototype.js/scriptstyle typetext/cssbody{font:11px arial;}#suggest{position:absolute;background-color:#FFFFFF;text-align: :left;border: 1px solid #000000;display: none;}/stylescript typetext/javascriptfunction searchSuggest(){var urlSearch;var txtSearch$F(txtSearch);var parstxtSearchtxtSearch;var searchAjaxnew Ajax.Request(url,{method:get, //get方式提交parameters:pars, //提交参数onComplete:processRequest});}function processRequest(req){var sobj$(suggest);sobj.innerHTML;var strreq.responseText.split(-);var suggest;if(str.length0str[0].length0){for(i0;istr.length;i){suggestdivstr[i]/div;}sobj.innerHTMLsuggest;$(suggest).style.displayblock;}else{$(suggest).style.displaynone;}}/script/headbodyh3Ajax自动搜索提示/h3div stylewidth:500pxform action idformSearchinput typetext idtxtSearch nametxtSearch οnkeyupsearchSuggest()autocompleteoff/input typesubmit idcmdSerach namecmdSearch value搜索/br/div idsuggest stylewidth:200px/div/form/div/body
/htmlSevlet类: package servlet.ajax;import java.io.IOException;
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Search extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String reqrequest.getParameter(txtSearch);PrintWriter out response.getWriter();SearchDao sdnew SearchDao();sd.getText(req);StringBuffer sbsd.getText(req);out.print(sb.toString());out.flush();}
} 进行连接数据库模糊查询的JAVA类: package servlet.ajax;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;public class SearchDao {public StringBuffer getText(String req){//首先定义下连接数据的URL、用户名、密码String urljdbc:oracle:thin:127.0.0.1:1521:orcl;String userscott;String passwordyulei123;String sqlselect ename from emp a where a.ename like ?;if(req.trim().length()0){sqlsql and 11;}List strListnew ArrayList();try {Class.forName(oracle.jdbc.driver.OracleDriver);Connection conDriverManager.getConnection(url,user,password);PreparedStatement precon.prepareStatement(sql);pre.setString(1,%req.toUpperCase().trim()%);ResultSet rspre.executeQuery();while(rs.next()){String enamers.getString(ename);strList.add(ename);}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}StringBuffer sbnew StringBuffer();int sizestrList.size();for(int i0;isize;i){sb.append((String)strList.get(i)-);}return sb;}
}代码写好后就可以在文本框输入字母后就可以模糊查询出数据了! 转载于:https://www.cnblogs.com/wuyida/p/6300391.html
