daoadresseservice/db/DbConnectionProbe.java

package dk.daoas.daoadresseservice.db;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

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


@WebServlet("/DbConnectionProbe")
public class DbConnectionProbe extends HttpServlet {
        private static final long serialVersionUID = 1L;
       
    public DbConnectionProbe() {
        super();
        // TODO Auto-generated constructor stub
    }

        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                response.setContentType("text/html");
                PrintWriter out = response.getWriter();
                
                out.print("<html><head><title>DaoAdresseService</title></head><body>");
                out.print("<h2>DaoAdresseService</h2>");
                
                try (
                        Connection conn = DBConnection.getConnection(); 
                        Statement stmt = conn.createStatement()
                        ) {
                        
                        out.print("Got DB Connection<br>");
                        
                        stmt.executeQuery("SELECT 1");
                        
                        out.print("'SELECT 1' query ok");
                        
                        
                } catch (SQLException e)  {
                        out.print("DB Connection failed: " + e.getMessage());
                }
                
                
        }

}
1	torben	2267	package dk.daoas.daoadresseservice.db;
2
3			import java.io.IOException;
4			import java.io.PrintWriter;
5			import java.sql.Connection;
6			import java.sql.SQLException;
7	torben	2356	import java.sql.Statement;
8	torben	2267
9			import javax.servlet.ServletException;
10			import javax.servlet.annotation.WebServlet;
11			import javax.servlet.http.HttpServlet;
12			import javax.servlet.http.HttpServletRequest;
13			import javax.servlet.http.HttpServletResponse;
14
15
16	torben	2269	@WebServlet("/DbConnectionProbe")
17			public class DbConnectionProbe extends HttpServlet {
18	torben	2267	private static final long serialVersionUID = 1L;
19
20	torben	2269	public DbConnectionProbe() {
21	torben	2267	super();
22			// TODO Auto-generated constructor stub
23			}
24
25			protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
26			response.setContentType("text/html");
27			PrintWriter out = response.getWriter();
28
29			out.print("<html><head><title>DaoAdresseService</title></head><body>");
30			out.print("<h2>DaoAdresseService</h2>");
31	torben	2356
32			try (
33			Connection conn = DBConnection.getConnection();
34			Statement stmt = conn.createStatement()
35			) {
36
37	torben	2357	out.print("Got DB Connection<br>");
38	torben	2356
39	torben	2357	stmt.executeQuery("SELECT 1");
40	torben	2267
41	torben	2357	out.print("'SELECT 1' query ok");
42
43
44	torben	2267	} catch (SQLException e) {
45			out.print("DB Connection failed: " + e.getMessage());
46			}
47
48
49			}
50
51			}