thoerup/droidradarservice/ViewDroidLocations.java

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);
        }

}
1	package dk.thoerup.droidradarservice;
2
3	import java.io.IOException;
4	import java.sql.Connection;
5	import java.sql.ResultSet;
6	import java.sql.SQLException;
7	import java.sql.Statement;
8	import java.util.ArrayList;
9	import java.util.List;
10
11	import javax.servlet.ServletException;
12	import javax.servlet.http.HttpServlet;
13	import javax.servlet.http.HttpServletRequest;
14	import javax.servlet.http.HttpServletResponse;
15
16
17	/**
18	* Servlet implementation class ViewDroidLocations
19	*/
20	public class ViewDroidLocations extends HttpServlet {
21	private static final long serialVersionUID = 1L;
22
23	/**
24	* @see HttpServlet#HttpServlet()
25	*/
26	public ViewDroidLocations() {
27	super();
28	// TODO Auto-generated constructor stub
29	}
30
31	/**
32	* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
33	*/
34	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
35	Connection conn = null;
36	ResultSet rs = null;
37	try
38	{
39	conn = DBConnection.getConnection();
40
41	Statement stmt = conn.createStatement();
42	rs = stmt.executeQuery("SELECT imei,handle,groupname,latitude,longitude,updated FROM droidradar ORDER BY updated ASC");
43
44	List<DroidBean> droids = new ArrayList<DroidBean>();
45	while (rs.next()) {
46	DroidBean bean = new DroidBean();
47	bean.setImei( rs.getLong(1) );
48	bean.setHandle( rs.getString(2) );
49	bean.setGroup(rs.getString(3));
50	bean.setLatitude(rs.getDouble(4));
51	bean.setLongitude(rs.getDouble(5));
52	bean.setLastUpdate(rs.getTimestamp(6));
53
54	droids.add(bean);
55
56	}
57	request.setAttribute("droids", droids);
58
59
60	} catch (Exception e) {
61	throw new ServletException(e);
62	} finally {
63	try{
64	if (rs != null && !rs.isClosed())
65	rs.close();
66	if (conn != null && !conn.isClosed() )
67	conn.close();
68	} catch (SQLException e) {}
69	}
70	getServletContext().getRequestDispatcher("/ViewDroidLocations.jsp").forward(request,response);
71	}
72
73	}