--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/02/12 14:26:36 2269
+++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DbConnectionProbe.java 2015/07/17 08:41:58 2628
@@ -3,7 +3,9 @@
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
+import java.sql.ResultSet;
import java.sql.SQLException;
+import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
@@ -21,16 +23,31 @@
// 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("DaoAdresseService");
- out.print("DaoAdresseService
");
- try {
- Connection conn = DBConnection.getConnection();
- conn.close();
- out.print("Got DB Connection");
+ //out.print("DaoAdresseService");
+ //out.print("DaoAdresseService
");
+
+ try (
+ Connection conn = DBConnection.getConnection();
+ Statement stmt = conn.createStatement()
+ ) {
+
+ out.print("Got DB Connection
");
+
+ try (ResultSet res = stmt.executeQuery("SELECT 1") ) {
+ res.next();
+ int i = res.getInt(1);
+ if (i == 1) {
+ out.print("'SELECT 1' query ok");
+ } else{
+ out.print("'SELECT 1' returned unexpected result : " + i);
+ }
+ }
+
} catch (SQLException e) {
out.print("DB Connection failed: " + e.getMessage());