packagecom.expai.servlet;importjava.io.IOException;importjava.io.PrintWriter;importjava.util.ArrayList;importjava.util.HashMap;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importnet.sf.json.JSONArray;importcom.expai.util.JDBCUtil;public class PhotoDataServlet extendsHttpServlet{private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException{
doPost(request, response);
}public void doPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException{
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
JDBCUtil dbUtil= newJDBCUtil();
Integer number= 0;
Integer pageNum= 0;//String size = null;
if(request.getParameter("number")!=null){
number= Integer.parseInt(request.getParameter("number"));
}if(request.getParameter("pageNum")!=null){
pageNum= Integer.parseInt(request.getParameter("pageNum"));
}//if(request.getParameter("size")!=null){//size = new String(request.getParameter("size").getBytes("ISO-8859-1"), "UTF-8");//}
if(number!=null&&pageNum!=null){//String sql = "select id,photoUrl from tb_photo_data where userId = "+userId +" limit "+Integer.parseInt(pageNum)*Integer.parseInt(number)+","+number;
String sql = "select id,photoUrl,width,height from tb_photo_data limit "+pageNum*number+","+number;
ArrayList> listData =dbUtil.getDataListMapNew(sql);
PrintWriter pWriter=response.getWriter();
JSONArray json=JSONArray.fromObject(listData);
pWriter.flush();
pWriter.print(json);
}
}
}