/* * DatabaseServlet.java * * Copyright (c) 1998 Hubert A. Klein Ikkink, aka Mr.Haki * * PLEASE DO NOT MODIFY THIS SOURCE FILE WITHOUT CHANGING * COPYRIGHT AND AUTHOR NOTICES. THANKS. * * HUBERT A. KLEIN IKKINK SHALL NOT BE LIABLE FOR ANY DAMAGES * SUFFERED AS A RESULT OF USING, MODIFYING OR DISTRIBUTING * THIS SOFTWARE OR ITS DERIVATIVES. * */ package com.drbob42.article.dbservlet; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.beans.*; import borland.jbcl.dataset.*; import borland.sql.dataset.*; import borland.jbcl.util.Diagnostic; /** * Servlet with database connection. This servlet will show * results from a table to the user in a HTML table. * * @author Hubert A. Klein Ikkink * @version 1.0, December 03, 1998 */ public class DatabaseServlet extends HttpServlet { DatabaseServletDataModule databaseServletDataModule1; /** * Initialize global variables. * Set up the database connection, by intializing the data module. */ public void init(ServletConfig config) throws ServletException { super.init(config); try { jbInit(); } catch (Exception e) { e.printStackTrace(); } } /** * Process the HTTP Post request. * Execute the query on the table, get result and put them * in a HTML table. */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = new PrintWriter (response.getOutputStream()); out.println(""); out.println("
" + columns[i].getCaption() + " | "); } out.println("
---|
" + dataSet.format(i) + " | "); } out.println("