/[projects]/dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java
ViewVC logotype

Diff of /dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionTest.java revision 2267 by torben, Thu Feb 12 13:57:32 2015 UTC dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java revision 2614 by torben, Wed Jul 15 13:31:28 2015 UTC
# Line 3  package dk.daoas.daoadresseservice.db; Line 3  package dk.daoas.daoadresseservice.db;
3  import java.io.IOException;  import java.io.IOException;
4  import java.io.PrintWriter;  import java.io.PrintWriter;
5  import java.sql.Connection;  import java.sql.Connection;
6    import java.sql.ResultSet;
7  import java.sql.SQLException;  import java.sql.SQLException;
8    import java.sql.Statement;
9    
10  import javax.servlet.ServletException;  import javax.servlet.ServletException;
11  import javax.servlet.annotation.WebServlet;  import javax.servlet.annotation.WebServlet;
# Line 12  import javax.servlet.http.HttpServletReq Line 14  import javax.servlet.http.HttpServletReq
14  import javax.servlet.http.HttpServletResponse;  import javax.servlet.http.HttpServletResponse;
15    
16    
17  @WebServlet("/DbConnectionTest")  @WebServlet("/DbConnectionProbe")
18  public class DbConnectionTest extends HttpServlet {  public class DbConnectionProbe extends HttpServlet {
19          private static final long serialVersionUID = 1L;          private static final long serialVersionUID = 1L;
20                
21      public DbConnectionTest() {      public DbConnectionProbe() {
22          super();          super();
23          // TODO Auto-generated constructor stub          // TODO Auto-generated constructor stub
24      }      }
25    
26    
27          protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {          protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
28                  response.setContentType("text/html");                  response.setContentType("text/html");
29                  PrintWriter out = response.getWriter();                  PrintWriter out = response.getWriter();
30                                    
31                  out.print("<html><head><title>DaoAdresseService</title></head><body>");                  //out.print("<html><head><title>DaoAdresseService</title></head><body>");
32                  out.print("<h2>DaoAdresseService</h2>");                  //out.print("<h2>DaoAdresseService</h2>");
33                  try {                  
34                          Connection conn = DBConnection.getConnection();                  try (
35                          conn.close();                          Connection conn = DBConnection.getConnection();
36                          out.print("Got DB Connection");                          Statement stmt = conn.createStatement()
37                            ) {
38                            
39                            out.print("Got DB Connection<br>");
40                            
41                            try (ResultSet res = stmt.executeQuery("SELECT 1") ) {
42                                    out.print("'SELECT 1' query ok");      
43                            }
44                            
45                                                    
46                  } catch (SQLException e)  {                  } catch (SQLException e)  {
47                          out.print("DB Connection failed: " + e.getMessage());                          out.print("DB Connection failed: " + e.getMessage());
Legend:
Removed from v.2267  
changed lines
  Added in v.2614
  ViewVC Help
Powered by ViewVC 1.1.20