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

Basic HTML version of Foils prepared May 19 99

Foil 42 JDBC Servlet Example (contd.)

From Overview of JDBC: Java Database Connectivity Basic Information Track Computational Science Course CPS616 -- Spring Semester 1999. by Nancy McCracken,(Sangetta Aggarwal, Meryem Ispirli, Udayan Parvate, Tom Pulikal, Chao-Wei Ou)

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

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Mon Jul 5 1999