package dk.thoerup.droidradarservice;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

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


/**
 * Servlet implementation class ViewDroidLocations
 */
public class ViewDroidLocations extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ViewDroidLocations() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Connection conn = null;
		ResultSet rs = null;
		try
		{
			conn = DBConnection.getConnection();
			
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery("SELECT imei,handle,groupname,latitude,longitude,updated FROM droidradar ORDER BY updated ASC");
			
			List<DroidBean> droids = new ArrayList<DroidBean>();
			while (rs.next()) {
				DroidBean bean = new DroidBean();
				bean.setImei( rs.getLong(1) );
				bean.setHandle( rs.getString(2) );
				bean.setGroup(rs.getString(3));
				bean.setLatitude(rs.getDouble(4));
				bean.setLongitude(rs.getDouble(5));
				bean.setLastUpdate(rs.getTimestamp(6));
				
				droids.add(bean);
				
			}
			request.setAttribute("droids", droids);
			
			
		} catch (Exception e) {
			throw new ServletException(e);
		} finally {
			try{
				if (rs != null && !rs.isClosed())
					rs.close();				
				if (conn != null && !conn.isClosed() )
					conn.close();
			} catch (SQLException e) {}
		}
		getServletContext().getRequestDispatcher("/ViewDroidLocations.jsp").forward(request,response);
	}

}