我最近添加了一个名为“ GetAveGoogleChart.Java”的servlet,它将通过休眠从MySQLDB中获取值。
公共类GetAveGoogleChart扩展了HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code>
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("application/json");
response.setContentType("text/html;charset=UTF-8");
String applicationName = request.getParameter("appName");
String transactionName = request.getParameter("tranName");
TransactionAO myAO = new TransactionAO();
Iterator<Transactionentry> transactionEntries= myDAO.getTransactions(applicationName, transactionName).listIterator();
//System.out.println("Entries size = " + transactionEntries.size());
SimpleDateFormat sdf = new SimpleDateFormat("YYYY-MM-dd'T'HH:mm:ss");
SimpleDateFormat sdf1 = new SimpleDateFormat("YYYY,MM,dd,HH,mm,ss");
JSONObject rootNode = new JSONObject();
JSONArray colsArray = new JSONArray();
JSONObject col1Object = new JSONObject();
col1Object.put("id", "TestDate");
col1Object.put("label", "TestDate");
col1Object.put("type", "datetime");
col1Object.put("p", new JSONArray());
JSONObject col2Object = new JSONObject();
col2Object.put("id", "Utils");
col2Object.put("label", "CPU Average (in %)");
col2Object.put("type", "number");
col2Object.put("p", new JSONArray());
colsArray.put(col1Object);
colsArray.put(col2Object);
JSONArray rowsArray = new JSONArray();
while(transactionEntries.hasNext()){
Transactionentry te=transactionEntries.next();
Date entryDate = te.getTranendtime();
double value = te.getAvecpu().doubleValue();
JSONObject rowObject = new JSONObject();
JSONArray cArray = new JSONArray();
JSONObject myDateObject = new JSONObject();
myDateObject.put("v", "Date("+sdf1.format(entryDate)+")");
JSONObject valueObject = new JSONObject();
valueObject.put("v", value);
cArray.put(myDateObject);
cArray.put(valueObject);
rowObject.put("c", cArray);
rowsArray.put(rowObject);
}
//JSONObject colsObject = new JSONObject();
//colsObject.put("cols", colsArray);
//JSONObject rowsObject = new JSONObject();
//rowsObject.put("rows", rowsArray);
rootNode.put("cols", colsArray);
rootNode.put("rows", rowsArray);
PrintWriter out = response.getWriter();
// Assuming your json object is **jsonObject**, perform the following, it will return your json object
out.print(rootNode);
out.flush();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
当我点击带有网址的网页时
http://localhost:8080/sample/GetAveGoogleChart?tranName=Login&appName=SVA%20-%20And
我得到的回应
Servlet GetAveGoogleChart位于/ sample
我没有收到任何其他有效的JSON响应。
请帮助我解决问题。
提前致谢。
最佳答案
在上面的代码中,您具有:
response.setContentType("application/json");
response.setContentType("text/html;charset=UTF-8");
如果删除第二个response.setContentType(),则可能会有所帮助:)