import java.io.PrintWriter; import java.sql.Connection; import java.sql.Statement; import javax.naming.InitialContext; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.sql.DataSource; import net.gnehzr.tnoodle.server.SafeHttpServlet; @SuppressWarnings("serial") public class HelloWorld extends SafeHttpServlet { public HelloWorld() {} protected void wrappedService(HttpServletRequest request, HttpServletResponse response, String[] path, java.util.LinkedHashMap<String,String> query) throws Exception { PrintWriter out = response.getWriter(); out.println("Hello World"); InitialContext jndiContext = new InitialContext(); DataSource ds = (DataSource) jndiContext.lookup("java:comp/env/jdbc/connPool"); Connection conn = ds.getConnection("root", "password"); Statement stmt = conn.createStatement(); boolean results = stmt.execute("SELECT NOW();"); out.println("<br>results: " + results + "<br>"); } }