這是一個以 XML 作為中介格式的自動完成(AutoSuggest)實作:前端輸入時非同步向後端要資料,後端吐出一段 XML,前端解析後填進下拉提示。
頁面上定義了一個 ACClient 類別,負責組請求網址、發送查詢、解析 XML 並把結果轉成陣列:
function ACClient(queryurl, width, objInput, objLable)
{
this.xmldom = getXmlhttp();
this.queryurl = queryurl;
this.prolist = new Array();
this.divwidth = width;
this.objInput = objInput;
this.getEligible = function(ac) {
var eligible = new Array();
if (ac.inputText.length < 1) {
document.getElementById(objInput.name).value = "";
document.getElementById(objLable.name).value = "";
return eligible;
}
// 加上隨機參數避免快取
var strURL = this.queryurl + escape(ac.inputText) + "&rand=" + Math.random();
this.xmldom.open("GET", strURL, false);
try { this.xmldom.send(); } catch (e) { return; }
this.prolist = this.xmldom.responseXML.documentElement.selectNodes("/duxion/object");
if (0 == this.prolist.length) { return eligible; }
for (var i = 0; i < this.prolist.length; i++) {
if (i > 15) break; // 最多顯示 16 筆
var node = this.prolist.item(i);
eligible[eligible.length] = node.getAttribute("fullcontent");
}
ac.div.style.width = this.divwidth;
return eligible;
};
this.useSuggestion = function(sel)
{
if (sel >= 0)
{
var node = this.prolist.item(sel);
if (typeof(node.getAttribute("value")) != "undefined")
document.getElementById(objInput.name).value = node.getAttribute("value");
else
document.getElementById(objInput.name).value = "";
if (typeof(node.getAttribute("content")) != "undefined")
document.getElementById(objLable.name).value = node.getAttribute("content");
else
document.getElementById(objLable.name).value = "";
}
};
return this;
}
頁面主體很精簡——一個用來顯示提示的 div,加上一組文字框與隱藏欄位:
<div id="autosuggest" style="width:160px;font-size:12px;"><ul></ul></div>
<div>
<asp:TextBox ID="txtfreq_name" CssClass="needtext" runat="server" Width="100px"></asp:TextBox>
<asp:HiddenField ID="hidfreq_code" runat="server" />
</div>
<script type="text/javascript">
new AutoSuggest(document.getElementById('txtfreq_name'),
new ACClient("testXml.aspx?tag=yp_frequency&value=", "200px",
document.getElementById('hidfreq_code'), document.getElementById('txtfreq_name')));
</script>
後端撈資料後組出 XML 文件,每筆資料一個 object 節點,屬性 fullcontent 存放已經排好寬度的 HTML 片段,讓前端可以直接塞進提示層:
public partial class testXml : BaseForm
{
protected void Page_Load(object sender, EventArgs e)
{
ListXmlData();
}
public string fieldlist = "區域Id,區域名,區域編碼,區域層次";
public string coloumwidth = "60,10,20,30";
private void ListXmlData()
{
string strwhere = "";
if (Request["value"] != null)
{
strwhere = string.Format(" and Code like '{0}%'", Request["value"].ToString());
}
arrfield = fieldlist.Split(',');
arrwidth = coloumwidth.Split(',');
DataTable dtList = new Districts().Search("1=1" + strwhere);
int list_cols = dtList.Columns.Count;
int list_rows = dtList.Rows.Count;
string listlable = "";
XmlDocument xmldoc = new XmlDocument();
XmlDeclaration dec = xmldoc.CreateXmlDeclaration("1.0", "gb2312", null);
xmldoc.InsertBefore(dec, xmldoc.FirstChild);
XmlElement root = xmldoc.CreateElement("duxion");
xmldoc.AppendChild(root);
// 表頭
if (list_rows > 0)
{
XmlElement objtitle = xmldoc.CreateElement("object");
for (int k = 0; k < list_cols; k++)
{
listlable += "<span style='width:" + arrwidth[k]
+ ";text-align:center;font-weight:bold;color:#000000;padding-top:2px;'>"
+ arrfield[k] + "</span>";
if (k == arrfield.Length - 1) break;
}
objtitle.SetAttribute("fullcontent", listlable);
root.AppendChild(objtitle);
}
// 資料列
for (int i = 0; i < list_rows; i++)
{
listlable = "";
DataRow drList = dtList.Rows[i];
XmlElement obj = xmldoc.CreateElement("object");
for (int j = 0; j < list_cols; j++)
{
obj.SetAttribute(dtList.Columns[j].ColumnName, drList[j].ToString());
if (j <= arrfield.Length - 1)
{
listlable += "<span style='width:" + arrwidth[j] + "'>"
+ formatXmlNode(dtList.Columns[j].DataType.ToString(), drList[j].ToString())
+ "</span>";
}
}
obj.SetAttribute("fullcontent", listlable);
root.AppendChild(obj);
}
Response.ContentEncoding = System.Text.Encoding.Default;
Response.ContentType = "text/xml";
Response.Clear();
Response.Write(xmldoc.OuterXml);
Response.End();
}
private string formatXmlNode(string field_type, string field_value)
{
string return_value = field_value.Trim();
switch (field_type)
{
case "System.Double":
case "System.Decimal":
return_value = string.Format("{0:0.###}", Convert.ToDouble(return_value));
break;
}
return return_value;
}
}
其餘 .js 與 .css 檔見附件。
看完這份實作,有兩點值得警惕。第一,strwhere 是直接用字串格式化把使用者輸入拼進 SQL 條件裡,這是典型的 SQL Injection 弱點,正式環境必須改用參數化查詢。第二,前端用 escape() 編碼查詢字串並不合適(escape 不是為 URI 設計的),應改用 encodeURIComponent();而 open(..., false) 選的是同步請求,會凍結整個 UI 執行緒,改成非同步並搭配 loading 提示會是更好的選擇。