FileDocCategorySizeDatePackage
RawSQLServlet.javaAPI DocExample2726Fri Oct 12 20:02:16 BST 2001jabadot

RawSQLServlet

public class RawSQLServlet extends HttpServlet
Process a raw SQL query; use ResultSetMetaData to format it.

Fields Summary
protected String
DRIVER
The name of the JDBC Driver
protected Connection
conn
The DB connection object
protected Statement
stmt
The JDBC statement object
Constructors Summary
Methods Summary
public voiddestroy()

		try {
			conn.close();	// All done with that DB connection
		} catch (SQLException ex) {
			log(getClass() + ": destroy: " + ex);
		}
public voiddoPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
Do the SQL query


		String query = request.getParameter("sql");

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();

		if (query == null) {
			out.println("<b>Error: malformed query, contact administrator</b>");
			return;
		}

		// NB MUST also check for admin privs before proceding!
		if (!query.toLowerCase().startsWith("select")) {
			throw new SecurityException("You can only select data");
		}

		try {	// SQL
			out.println("<br>Your query: <b>" + query + "</b>");
			ResultSet rs = stmt.executeQuery(query);

			out.println("<br>Your response:");

			ResultSetMetaData md = rs.getMetaData();
			int count = md.getColumnCount();
			out.println("<table border=1>");
			out.print("<tr>");
			for (int i=1; i<=count; i++) {
				out.print("<th>");
				out.print(md.getColumnName(i));
			}
			out.println("</tr>");
			while (rs.next()) {
				out.print("<tr>");
				for (int i=1; i<=count; i++) {
					out.print("<td>");
					out.print(rs.getString(i));
				}
				out.println("</tr>");
			}
			out.println("</table>");
			// rs.close();
		} catch (SQLException ex) {
			out.print("<B>" + getClass() + ": SQL Error:</B>\n" + ex);
			out.print("<pre>");
			ex.printStackTrace(out);
			out.print("</pre>");
		}
public voidinit()
Initialize the servlet.

		try {
			// Load the driver...
			Class.forName(JDConstants.getProperty("jabadot.jabadb.driver"));

			// Get the connection
			log(getClass() + ": Getting Connection");
			Connection conn = DriverManager.getConnection (
				JDConstants.getProperty("jabadot.jabadb.url"),
				JDConstants.getProperty("jabadot.jabadb.user"),
				JDConstants.getProperty("jabadot.jabadb.password"));


			log(getClass() + ": Creating Statement");
			stmt = conn.createStatement();
			log(getClass() + ": Done.");
		} catch (ClassNotFoundException ex) {
			log(getClass() + ": init: Driver Error: " + ex);
		} catch (SQLException ex) {
			log(getClass() + ": init: SQL Error: " + ex);
		}