52,797
社区成员
发帖
与我相关
我的任务
分享
//obj:当前对象、固定值this; sqlFlag:对应CodeSelectBL中的sql; paramSQL:where后面拼接的查询条件
function selectCodeList(obj, sqlFlag, paramSQL) {
$.ajax({url:"../servlet/CodeSelectServlet",
datatype:"json",
async:false,
type:"post",
data:{"sqlFlag":sqlFlag, "paramSQL":paramSQL},
success:function (jsonStr) {
var jsonobj = eval("(" + jsonStr + ")");
var data = jsonobj["datas"];
var codemap = data["0"]["0"];
for (var key in codemap) {
var s = codemap[key];
obj.append("<li><i>" + key + "</i><span>" + s + "</span></li>");
//当li数量过多给Ul加滚动条
var $HselectUlHeight = obj.height();
console.log('高度'+$HselectUlHeight);
if($HselectUlHeight > 125){
$(selector).find('.HselectUl').css({
'height':'125px',
'overflow': 'scroll',
'overflow-y': 'scroll'
});
}
}
}, error:function () {
alert("error!");
}});
}
/**
* 下拉框查询
*
* @author YanJianZhe
*/
public class CodeSelectServlet extends BaseServlet {
@Override
public void setQuerySql() {
// TODO Auto-generated method stub
}
@Override
public void setSearchConditions(HttpServletRequest request,
HttpServletResponse response) {
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.addHeader("Access-Control-Allow-Origin", "*");
PrintWriter out = response.getWriter();
String sqlFlag = (String) request.getParameter("sqlFlag");
String paramSQL = (String) request.getParameter("paramSQL");
CodeSelectBL codeSelectBl = new CodeSelectBL();
// 返回json
String jsonStr = codeSelectBl.codeSelects(sqlFlag, paramSQL);
System.out.println("下拉列表前台flag=======" + sqlFlag);
System.out.println("下拉列表返回到前台的json=======" + jsonStr);
out.write(jsonStr);
out.close();
}
}
public class CodeSelectBL {
// 执行sql语句类
private ExeSQL tExeSQL = new ExeSQL();
/** 存储查询语句 */
private String mSQL = "";
private StringBuffer mSBql = new StringBuffer(256);
/** 存储全局变量 */
private GlobalInput mGlobalInput = new GlobalInput();
/** 业务处理相关变量 */
private LDCodeSchema mLDCodeSchema = new LDCodeSchema();
/** 存储查询条件 */
private String mCodeCondition = "";
private String mConditionField = "";
/** 系统日期*/
private String mCurrentDate = PubFun.getCurrentDate();
private String mCurrentTime = PubFun.getCurrentTime();
public String codeSelects(String sqlFlag,String paramSQL) {
mLDCodeSchema.setCodeType(sqlFlag);
String result = "success";
String message = "成功!";
String jsonStr = "";
String data = "";
String codeId = "";
String codeName = "";
Map codeMap = new HashMap();
List jqueryList = new ArrayList();
mCodeCondition = paramSQL;
//mConditionField = conditionField;
//System.out.println(objCondition+"---"+conditionField);
String codesql = getCodeSql();
SSRS ssrs = new SSRS();
ssrs = tExeSQL.execSQL(codesql);
if (ssrs != null && ssrs.getMaxRow() > 0) {
for (int i = 1; i <= ssrs.getMaxRow(); i++) {
codeId = ssrs.GetText(i, 1);
codeName = ssrs.GetText(i, 2);
codeMap.put(codeId, codeName);
}
} else {
result = "fail";
message = "查询下拉列表失败!";
}
String jsonStr4 = "{\"codeMap\":\"" + codeMap + "\"}";
data += jsonStr4;
jqueryList.add(codeMap); // 拼装jqyery的json
JSONArray jsonArraytemp = new JSONArray();
jsonArraytemp = JSONArray.fromObject(jqueryList);
// 返回前台页面json数据
jsonStr = "{\"result\":\"" + result + "\",\"message\":\"" + message
+ "\",\"datas\":[" + jsonArraytemp + "]}";
return jsonStr;
}
}
<servlet>
<servlet-name>CodeSelectServlet</servlet-name>
<servlet-class>com.sinosoft.servlet.selected.CodeSelectServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CodeSelectServlet</servlet-name>
<url-pattern>/servlet/CodeSelectServlet</url-pattern>
</servlet-mapping>