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 javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


@WebServlet("/DbConnectionTest")
public class DbConnectionTest extends HttpServlet {
        private static final long serialVersionUID = 1L;
       
    public DbConnectionTest() {
        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();
                        conn.close();
                        out.print("Got DB Connection");
                        
                } 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
8			import javax.servlet.ServletException;
9			import javax.servlet.annotation.WebServlet;
10			import javax.servlet.http.HttpServlet;
11			import javax.servlet.http.HttpServletRequest;
12			import javax.servlet.http.HttpServletResponse;
13
14
15			@WebServlet("/DbConnectionTest")
16			public class DbConnectionTest extends HttpServlet {
17			private static final long serialVersionUID = 1L;
18
19			public DbConnectionTest() {
20			super();
21			// TODO Auto-generated constructor stub
22			}
23
24			protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
25			response.setContentType("text/html");
26			PrintWriter out = response.getWriter();
27
28			out.print("<html><head><title>DaoAdresseService</title></head><body>");
29			out.print("<h2>DaoAdresseService</h2>");
30			try {
31			Connection conn = DBConnection.getConnection();
32			conn.close();
33			out.print("Got DB Connection");
34
35			} catch (SQLException e) {
36			out.print("DB Connection failed: " + e.getMessage());
37			}
38
39
40			}
41
42			}