package org.wall.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.wall.jdbc.SQLiteJDBC;

public class DataServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doPost(req, resp);
	}

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/txt; charset=UTF-8");
		// 以下两句为取消在本地的缓存
		response.setHeader("Cache-Control", "no-cache");
		response.setHeader("Pragma", "no-cache");
		PrintWriter out = response.getWriter();
		int page = (null == req.getParameter("page") || req.getParameter("page").equals("")) ? 1 : Integer.parseInt(req
				.getParameter("page"));
		try {
			List<Map<String, String>> data = SQLiteJDBC.getData(page);
			List<String> map2json = map2json(data);
			out.print(map2json);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	private List<String> map2json(List<Map<String, String>> l) {
		List<String> result = new ArrayList<String>();
		for (Map<String, String> m : l) {
			String v = "";
			for (String key : m.keySet()) {
				v += key + ":'" + m.get(key) + "',";
			}
			result.add("{" + v.substring(0,v.length()-1) + "}");
		}
		return result;
	}
}