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; |
import java.sql.Statement; |
9 |
|
|
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(); |
38 |
|
|
39 |
out.print("Got DB Connection<br>"); |
out.print("Got DB Connection<br>"); |
40 |
|
|
41 |
stmt.executeQuery("SELECT 1"); |
try (ResultSet res = stmt.executeQuery("SELECT 1") ) { |
42 |
|
out.print("'SELECT 1' query ok"); |
43 |
out.print("'SELECT 1' query ok"); |
} |
44 |
|
|
45 |
|
|
46 |
} catch (SQLException e) { |
} catch (SQLException e) { |