利用ajax方法 通过servlet文件 访问数据库 获取提示。汉字无法匹配?

html文件利用ajax方法 通过servlet文件 访问数据库 获取提示。汉字无法匹配?
Access数据库Goods表:
[img]http://dl.iteye.com/upload/attachment/0082/7368/85a5bb45-b636-3bbf-aa6e-1f1b7ef4a570.png[/img]

html文件suggest.html:


body { font: 11px arial; } .suggest_link { background-color: #FFFFFF; padding: 2px 6px 2px 6px; cursor:hand; } .suggest_link_over { background-color: #E8F2FE; padding: 2px 6px 2px 6px; } #search_suggest { position:relative; background-color: #FFFFFF; text-align: left; border: 1px solid #000000; left: -12px; top: 1px; height: 74px; width: 170px; display:none; }



实现搜索提示




ajax_search.js:
var searchReq = createAjaxObj();
function createAjaxObj()
{
var httprequest=false;
if (window.XMLHttpRequest) //为非IE浏览器生成XmlHttpRequest对象
{
httprequest=new XMLHttpRequest()
if (httprequest.overrideMimeType) httprequest.overrideMimeType('text/xml')
}
else if (window.ActiveXObject) //为IE浏览器生成XmlHttpRequest对象
{
try
{
httprequest=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
httprequest=new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e){}
}
}
return httprequest
}
function searchSuggest()
{
if (searchReq.readyState == 4 || searchReq.readyState == 0)
{
var str = escape(document.getElementById('txtSearch').value);
searchReq.open("GET", 'search?search=' + str, true);//向服务器端发送请求
searchReq.onreadystatechange = handleSearchSuggest; //设置回调函数
searchReq.send(null);
}
}
function handleSearchSuggest()
{ //这是回调函数,处理从服务器端返回的信息
if (searchReq.readyState == 4)
{
var ss = document.getElementById('search_suggest')
ss.innerHTML = '';
var str = searchReq.responseText.split("\n");
for(i=0; i < str.length - 1; i++)
{
var suggest = '

suggest += 'onmouseout="javascript:suggestOut(this);" ';
suggest += 'onclick="javascript:setSearch(this.innerHTML);" ';
suggest += 'class="suggest_link">' + str[i] + '
';
ss.innerHTML += suggest;
ss.style.display="block";
}
}
}
function suggestOver(div_value)
{
div_value.className = 'suggest_link_over';
}
function suggestOut(div_value)
{
div_value.className = 'suggest_link';
}
function setSearch(value)
{
document.getElementById('txtSearch').value = value;
document.getElementById('search_suggest').innerHTML = '';
document.getElementById('search_suggest').style.display="none";
}

servlet文件SearchSuggest.java:
package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class SearchSuggest extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException
{
response.setCharacterEncoding("UTF-8");
String search = request.getParameter("search"); //接受参数值

String sql = "select GoodsName from Goods where GoodsName like '"+search+"%' order by GoodsName";//设置查询语句
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList vData = new ArrayList();
java.io.PrintWriter out = response.getWriter();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //注册数据库连接驱动

String MdbPath = "F:/sneaker/Tomcat/webapps/search/database/#costume.mdb";
String url= "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + MdbPath ;
conn = DriverManager.getConnection(url);

stmt = conn.createStatement();
rs = stmt.executeQuery(sql); //执行查询
while (rs.next())
{
vData.add(rs.getString("GoodsName"));
}
StringBuilder buf = new StringBuilder();
for (int i=0;i<vData.size();i++)
{
String keyword = (String)vData.get(i);
buf.append(keyword+"\n");
}
out.print(buf.toString());//向客户端输出信息
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (SQLException sqle) {
}
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException
{
doPost(request, response);
}
}

效果当输入为空时,可以调出数据表中所有信息 汉字及数字正常显示:

[img]http://dl.iteye.com/upload/attachment/0082/7376/1de0c6c5-0934-3f36-888a-af0bae38f84a.png[/img]

当输入数字7时,可以匹配:

[img]http://dl.iteye.com/upload/attachment/0082/7378/967d1012-b3db-39e8-bd6f-7b0d5186e3c6.png[/img]

当输入汉字儿童 或 额 时,匹配信息没有显示,是因为所输入的汉字编码有误吗,没有传递或传递后编码不匹配吗?求解?

[img]http://dl.iteye.com/upload/attachment/0082/7382/413d2446-1db1-344f-b7ba-0f834a0b72b0.png[/img]

[img]http://dl.iteye.com/upload/attachment/0082/7393/4ebd495e-1501-3593-909a-3929ed218695.png[/img]

Tomcat提示:
[img]http://dl.iteye.com/upload/attachment/0082/7677/d874bf7e-8d11-3c25-866a-ad7f9c25ce19.gif[/img]

2个回答

在客户端,对即将通过Ajax传递到后台的字符串,进行两次编码。

修改前:
[code="javascript"]var str = escape(document.getElementById('txtSearch').value); [/code]

修改后:
[code="javascript"]var str = encodeURI(encodeURI(document.getElementById('txtSearch').value)); [/code]

遇到这种问题,应该首先在以下代码处打断点进行调试,看后台获得的字符串是否是乱码:
[code="java"]String search = request.getParameter("search"); //接受参数值[/code]

yunzhu666
yunzhu666 JavaScript encodeURI() 函数 [url]http://www.w3school.com.cn/js/jsref_encodeURI.asp/url] URL编码与二次encodeURI [url]http://foryougeljh.iteye.com/blog/1456706/url]
接近 7 年之前 回复
weixin_42502701
囍相逢²LIQP 关于encodeURI的使用,应该查哪里资料?谢谢。
接近 7 年之前 回复

客户端建议使用
encodeURIComponent 而不是escape
在服务器端
URLDecoder.decode(search, "UTF-8")
如果不行可使用apache common lang StringEscapeUtils 工具类

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问