package dk.daoas.daoadresseservice.db;
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;
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();
}
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();
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());
}
}
}