String callback = request.getParameter("jsoncallback");
String lineID = request.getParameter("lineID");
String select = " select USER_ID,USER_NAME,PHONE_NO from LINE_INFO,DISTRICT_INFO,FAC_INFO,USER_INFO WHERE LINE_INFO.FAC_ID = FAC_INFO.FAC_ID AND DISTRICT_INFO.DISTRICT_ID = FAC_INFO.DISTRICT_ID AND(USER_INFO.PHONE_NO = LINK_MAN1 OR USER_INFO.PHONE_NO = LINK_MAN2 OR USER_INFO.PHONE_NO = LINK_MAN3 OR USER_INFO.PHONE_NO = LINK_MAN4 OR USER_INFO.PHONE_NO = LINK_MAN5 ) AND LINE_ID = '" + lineID +"'" ;
Connection con = null;
ResultSet rs;
java.sql.Statement statement;
con = pool1.getConnection();
statement = con.createStatement();
rs = statement.executeQuery(select);
StringBuffer sb = new StringBuffer();//组装json数据格式
sb.append("({data:[");
while (rs.next()) {
sb.append("{USER_ID:\"").append(rs.getString("USER_ID")).append("\",USER_NAME:\"").append(rs.getString("USER_NAME")).append("\",PHONE_NO:\"").append(rs.getString("PHONE_NO")).append("\"},");
}
sb.delete(sb.length() - 1,sb.length());
sb.append("]})");
response.setContentType("application/json;charset=utf-8");
PrintWriter pw = response.getWriter();
if(callback != null) {
pw.write(callback + sb.toString());
} else {
pw.write(sb.toString());
}
pw.flush();
pw.close();
function getUserInfoByLineID(line_id) {
$.getJSON("login/ajaxGetAlarmUserInfo.jsp?jsoncallback=?", { lineID: line_id} , function(json) {
alert(json);
});
}