52,797
社区成员
发帖
与我相关
我的任务
分享
function load_suggest(id, key)
{
var url="suggest.jsp?key="+key;
ajax_rqt=get_request();
ajax_rqt.onreadystatechange = function ()
{
if (ajax_rqt.readyState == 4)
{
if (ajax_rqt.status == 200)
{
var result = ajax_rqt.responseText.replace(/(^\s*)|(\s*$)/g, "");
addOptionGroup(id,result);
}
else
{
alert("您所请求的页面有异常。");
}
}
}
ajax_rqt.open("GET", url, true);
ajax_rqt.send(null);
}
userDAO userDaoObj = new userDAO();
boolean firstResult;
firstResult = true;
String result = "";
String key = getString.toString(request.getParameter("key"));
try {
String sqlString = "SELECT * from suggest where key='" + key + "'";
ResultSet rs = userDaoObj.execSql(sqlString);
while(rs.next()){
if (firstResult) {
result = rs.getString("sug");
firstResult = false;
} else {
result = result + "," + rs.getString("sug");
}
}
out.print(result);
}catch(Exception ex){
ex.printStackTrace();
}
String key = getString.toString(request.getParameter("key"));
//先看看key有没有值,有值有没有乱码或出现空格什么的,导致下面的查询语句没有返回信息
key = URLDecoder.decode(key, "UTF-8");//客户端2次转码服务器端也进行解码
try {
String sqlString = "SELECT * from suggest where key='" + key + "'";
ResultSet rs = userDaoObj.execSql(sqlString);
while(rs.next()){
if (firstResult) {
result = rs.getString("sug");
firstResult = false;
} else {
result = result + "," + rs.getString("sug");
}
}
out.print(result);//打印看看是什么值,可能是空的;和上面的查询有关
js传参编码:
var url="suggest.jsp?key="+encodeURI(encodeURI(key));//客户端转码发送
alert(ajax_rqt.responseText);
var result = ajax_rqt.responseText.replace(/(^\s*)|(\s*$)/g, "");
alert(result);
addOptionGroup(id,result);