<%@ page contentType="application/json; charset=big5" %>
<%@ /*業務機密, 這行page import 略 */ %>
<%@ page import="java.sql.*, java.util.*, java.lang.*" %>
<%@ page import="com.data.toolkit.SafeSql, com.data.toolkit.JsonUtil" %>
<%
String strName = request.getParameter("name");
String strQ = request.getParameter("q");
if (strQ != null)
{
//業務機密, 取得Oracle資料庫連線方式的這行略 qub=?
StringBuffer sql = new StringBuffer();
String strKeyName = "";
//需求編號, reqNoQ
if (strName == "reqNoQ")
{
strKeyName = "reqno";
}
if (strKeyName != "")
{
sql.append("select * from ( ");
sql.append("select distinct ");
sql.append(strKeyName);
sql.append(" from tb_request where ");
sql.append(strKeyName);
sql.append(" like ");
sql.append(SafeSql.QuoteLikeRight(strQ));
sql.append(" order by ");
sql.append(strKeyName);
sql.append(" ) where ROWNUM >= 0 AND ROWNUM <= 20");
ArrayList v = qub.executeQuery(sql.toString());
StringBuffer responseText = new StringBuffer();
responseText.append('[');
if (!v.isEmpty())
{
boolean IsComma = false;
for(int i=0;i<v.size();i++)
{
HashMap hm = (HashMap)v.get(i);
if (hm.containsKey(strKeyName))
{
if (IsComma == true) {
responseText.append(',');
IsComma = true;
}
responseText.append(JsonUtil.string2Json(hm.get(strKeyName)));
}
}
}
responseText.append(']');
response.getWriter().print(responseText.toString());
}
else
{
response.getWriter().print("[]");
}
}
%>
<%@ page contentType="application/json; charset=big5" %>
<%@ /*業務機密, 這行page import 略 */ %>
<%@ page import="java.sql.*, java.util.*, java.lang.*" %>
<%@ page import="com.data.toolkit.SafeSql, com.data.toolkit.JsonUtil" %>
<%
String strName = request.getParameter("name");
String strQ = request.getParameter("q");
boolean IsOutput = false;
if (strQ != null)
{
//業務機密, 取得Oracle資料庫連線方式的這行略 qub=?
StringBuffer sql = new StringBuffer();
String strKeyName = "";
//需求編號, reqNoQ
if (strName.compareToIgnoreCase("reqNoQ") == 0)
{
strKeyName = "reqno";
}
if (strKeyName != "")
{
sql.append("select * from ( ");
sql.append("select distinct ");
sql.append(strKeyName);
sql.append(" from tb_request where ");
sql.append(strKeyName);
sql.append(" like ");
sql.append(SafeSql.QuoteLikeRight(strQ));
sql.append(" order by ");
sql.append(strKeyName);
sql.append(" ) where ROWNUM >= 0 AND ROWNUM <= 20");
// ArrayList v = qub.executeQuery(sql.toString());
// 測試用
ArrayList v = new ArrayList();
HashMap hm2 = new HashMap();
hm2.put("reqno", sql.toString());
v.add(hm2);
StringBuffer responseText = new StringBuffer();
responseText.append('[');
if (!v.isEmpty())
{
boolean IsComma = false;
for(int i=0;i<v.size();i++)
{
HashMap hm = (HashMap)v.get(i);
if (hm.containsKey(strKeyName))
{
if (IsComma == true) {
responseText.append(',');
IsComma = true;
}
responseText.append(JsonUtil.toJson(hm.get(strKeyName)));
}
}
}
responseText.append(']');
IsOutput = true;
response.getWriter().print(responseText.toString());
}
}
if (IsOutput == false)
{
response.getWriter().print("[]");
}
%>