thoerup/droidradarservice/ResetLastUpdate.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 ResetLastUpdate
 */
public class ResetLastUpdate extends HttpServlet {
        private static final long serialVersionUID = 1L;

        /**
         * @see HttpServlet#HttpServlet()
         */
        public ResetLastUpdate() {
                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;
                try
                {
                        conn = DBConnection.getConnection();

                        Statement stmt = conn.createStatement();
                        stmt.execute("UPDATE droidradar SET updated=now()");


                } catch (Exception e) {
                        throw new ServletException(e);
                        
                } finally {
                        try{
                                if (conn != null && !conn.isClosed() )
                                        conn.close();
                        } catch (SQLException e) {}
                }
                
                response.sendRedirect("/DroidRadarService/ViewDroidLocations");
        }
}
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	* Servlet implementation class ResetLastUpdate
18	*/
19	public class ResetLastUpdate extends HttpServlet {
20	private static final long serialVersionUID = 1L;
21
22	/**
23	* @see HttpServlet#HttpServlet()
24	*/
25	public ResetLastUpdate() {
26	super();
27	// TODO Auto-generated constructor stub
28	}
29
30	/**
31	* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
32	*/
33	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
34	Connection conn = null;
35	try
36	{
37	conn = DBConnection.getConnection();
38
39	Statement stmt = conn.createStatement();
40	stmt.execute("UPDATE droidradar SET updated=now()");
41
42
43	} catch (Exception e) {
44	throw new ServletException(e);
45
46	} finally {
47	try{
48	if (conn != null && !conn.isClosed() )
49	conn.close();
50	} catch (SQLException e) {}
51	}
52
53	response.sendRedirect("/DroidRadarService/ViewDroidLocations");
54	}
55	}