import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class SQLCommand 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 { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println(""); out.println("
") ; out.println("

SQL query

") ; out.println("

") ; out.println("") ; out.println("

"); out.println("
") ; out.println("

SQL update

") ; out.println("

") ; out.println("") ; out.println("

"); out.println("
") ; out.println("Close Oracle Connection:") ; out.println("") ; out.println("
"); out.println(""); } } }