----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
I've done something like what you describe for generating complex reports for my
company.
Many complex reports can be expressed as fairly succinct SQL. The problem is getting a
report writer (we use Impromptu) to give you
what you want in terms of the query and the format without spending a couple of days
per report (or longer!)
I developed a Servlet that takes up to 5 init args. These are Query Html page, query
xml, query xsl, report xml and report xsl.
With just the report xml and report xsl the servlet will run the xml through (an
adaptation of ) Donald Ball's SQL Processor (part
of the Cocoon framework) and then pass the result to an xsl engine (Michael Kay's
SAXon).
You can add parameters for a query html page if all you params are not based on other
data or you can set up a query that returns a
parameter entry page instead of a report if you parameters are based on database
values.
For each report I use an alias to the servlet with a different set of xml/xsl pages.
It's sweet so far.
***********************************************************
Brett Knights 626-432-5767 work
[EMAIL PROTECTED] 626-355-1017 home
***********************************************************
>
> Hi all,
> I am newbie here so kindly pardon my ignorance.I am trying to
> implement a system that is very database intensive and right
> now all the
> actions/reactions of Jserv are based on the parameters
> supplied by the HTML
> pages using GET and POST .( I am avoiding using POST as much
> as possible to
> avoid any malicious parameter inputs from the clients ). But
> the problem is
> that all these parameters, the corresponding servlets and the logic is
> still exposed to whoever wishes ( and is smart enough ) to see.
>
> Is there some way i to create a black box type framework
> where only
> the user inputs go in and request codes for actions approved
> for normal
> users are submitted? The only thing the user sees is the
> input they are
> supplying and some action code and nothing else.
>
> Basically is it better to create a servlet super class
> that manages
> all the data for the session and all the possible logic paths
> that a user
> can follow ? - OR - would i be able to do something like this
> using beans ?
> Anybody done this before ?
>
> Any ideas/suggestions will be very helpful.
> Thanks to all.
>
> RVS
>
>
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
