web端显示MySQL数据库中内容

package aaa; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONObject; import aaa.ToolMySQLConnection; import aaa.UploadImage; public class LoginServlet extends HttpServlet{ private static final long serialVersionUID = 1L; @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException { response.setContentType("text/html; charset=UTF-8"); String imgEncodedStr = request.getParameter("image"); String fileName = request.getParameter("filename"); String userName = request.getParameter("userName"); String userNumber = request.getParameter("userNumber"); String errorInformation = request.getParameter("errorInformation"); String addressInformation = request.getParameter("addressInformation"); System.out.println("Filename: "+ fileName); System.out.println("userName: "+userName); System.out.println("userNumber: "+ userNumber); System.out.println("errorInformation: "+ errorInformation); System.out.println("addressInformation: "+ addressInformation); boolean type=true; PrintWriter out = response.getWriter(); if(imgEncodedStr != null){ UploadImage.convertStringtoImage(imgEncodedStr, fileName,userName, userNumber,errorInformation,addressInformation); } if(UploadImage.wheatherTure()) { JSONObject json = new JSONObject(); json.put("msg", type ); //json.put("msg", JSONArray.fromObject(type,jsonConfig)); response.getWriter().write(json.toString()); out.flush(); out.close(); } } /*String ID = request.getParameter("ID"); //用于接收android前台的输入的值，此处参数必须要与你前台的值相对应 String PW= request.getParameter("PW"); boolean type=false;//用于判断账号和密码是否与数据库中查询结果一致 response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); Connection con=null; JSONObject json = new JSONObject(); // JsonConfig jsonConfig = new JsonConfig(); // jsonConfig.registerJsonValueProcessor(java.sql.Date.class,new JsonDateValueProcessor()); try { con=ToolMySQLConnection.getConnection(); Statement stmt=con.createStatement(); String sql="select * from printing.sys_staff where Account="+ID+" and Password="+PW; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { type=true; } } catch(Exception ex) { ex.printStackTrace(); } finally { ToolMySQLConnection.Close(null, null, con); json.put("msg", type ); //json.put("msg", JSONArray.fromObject(type,jsonConfig)); response.getWriter().write(json.toString()); out.flush(); out.close(); } }*/ }