Separate HTML for Basic Foil 41 JDBC Servlet Example (contd.)

Basic HTML version of Foils prepared 7 October 97

Foil 41 JDBC Servlet Example (contd.)

From Overview of JDBC and its use with Microsoft Access ARL Database Tutorial -- February 98. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)

Implementation :

public class DBServlet extends HttpServlet {

//overriding service method

public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {

//fetch the parameters from the form input

String username = req.getParameter("username");

String password = req.getParameter("password");

String query = req.getParameter("query");

PrintStream out = new PrintStream (res.getOutputStream() );

String url = "jdbc:weblogic:oracle"; // JDBC driver url