import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class SQLQuery extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { HttpSession session = request.getSession(true) ; Connection conn = (Connection) session.getAttribute("connection") ; if(conn == null) { response.sendError(HttpServletResponse.SC_OK, "Session timed out.") ; } else { String query = request.getParameter("query") ; try { Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery(query) ; response.setContentType("text/html"); ResultSetMetaData rsmd = rs.getMetaData() ; int cols = rsmd.getColumnCount() ; PrintWriter out = response.getWriter(); out.println(""); out.println("") ; out.println("") ; for(int i = 1 ; i <= cols ; i++) out.println("") ; out.println("") ; while(rs.next()) { out.println("") ; for(int i = 1 ; i <= cols ; i++) out.println("") ; out.println("") ; } out.println("

" + rsmd.getColumnLabel(i) + "

" + rs.getString(i) + "

") ; out.println(""); out.println(""); out.println(""); } catch (SQLException e) { response.sendError(HttpServletResponse.SC_OK, "Query failed: " + e.getMessage()) ; } } } }