PLEASE HELP Re: Capture of Web Form Input

PLEASE Richard J Kucera wrote:

> Web/database programmers,
>
> Is there anyone in the world out there really focused on this problem?
>
> I don't need another $10,000 load balancing server...or another quiz
> server
> not serious about capture. I don't want to write it if I don't have
> to.
>
> I don't care what language it's in mod_perl or Perl CGI or servlet...has
> anyone written
> anything to do it? See OBJECTIVE in declaration below. TIA -R
>
> import java.io.*;
> import java.sql.*;
> import java.util.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> /**
> * OBJECTIVE: Incremental capture unconstrained input data from web
> form
> * or other, put into typed & constrained RDBMS table(s)
> *
> * PARAMETERS:
> * ROW_ID
> * COLUMN
> * VALUE
> * COLUMN
> * VALUE
> * .
> * .
> * .
> *
> * This type is the base to properties of certain
> * generalizable RDBMS patterns.
> *
> * Subclasses may include master-detail, two-table join,
> * multi-table join, stored procedure interface, etc.
> *
> * These subclasses handle the individual update requests, e.g.
> * unpacking the parameters and deciding what to do with them.
> *
> * The reading of the data dictionary is essential for getting
> * type information to use in dynamically encoding the JDBC
> * to build SQL statements. At a minimum, for SQL the program
> * has to know whether or not to enclose values in 'single quotes'.
> * For more advanced prepared statements, different parameter
> * loading code needs to be executed depending on the value type.
> *
> * The key concept here is to be able to author (J)HTML with
> * form parameters/input and have this class check the names
> * and types that the form uses to upload data. This is a
> * "small interpreter pattern."
> *
> * SQL ISSUES HANDLED:
> * 1) data type
> * 2) data width
> * 3) column naming
> * 4) check constraints
> * 5) primary key constraints
> * 6) foreign key constraints
> */
> public class SimpleTableCapture {
> Hashtable nameType;
> Hashtable nameConstraint;
> Connection conn;
> String tableName;
> }
Received on Fri Nov 13 1998 - 00:00:00 CST