SQLServlet Version 1.1
Author: Klaus Gotthardt (email: info@kgo.de)
Home:   www.kgo.de 


Features:
1. SQLServlet provides an easy way to access your database using HTML-forms.
2. Establish a persistent connections to databases
3. Dynamically generate HTML-tables from the result-set 
4. Create forms for inserts and updates 
5. Replace the values in the querystring by formvariables 

You need:
1. A Servlet capable Web server
2. ODBC Driver or a pure JDBC driver for the your database 

Install:
1. Unzip SQLServlet.zip
2. Copy all html-files to a webserver-(sub)directory (example: ..tomcat-home../webapps/examples/servlets)
3. Copy SQLServlet.class to the servlet directory  (example: ..tomcat-home../webapps/examples/web-inf/classes)
4. Copy SQLServlet.properties to the servlet-property-directory (not accessible from the web)
(example: ..tomcat-home../webapps/web-inf)
5a. Edit the servlets property file and insert init-args (path to SQLServlet.properties)
   Example 
   # servlet.properties in jrun:
   servlet.SQLServlet.args=properties=C:/Programme/Live Software/JRunIIS/properties/SQLServlet.properties
   servlet.SQLServletpro.args=properties=C:/Programme/Live Software/JRunIIS/properties/SQLServlet.properties
   
   # Servlet Init Parameters (Apache Jserv)
   servlet.SQLServlet.initArgs=properties=C:/Program Files/Apache JServ 1.1b3/servlets/SQLServlet.properties
   servlet.SQLServletpro.initArgs=properties=C:/Program Files/Apache JServ 1.1b3/servlets/SQLServlet.properties
   
   # tomcat web.xml:  ( C:\jakarta-tomcat-3.2.1\webapps\examples\WEB-INF\web.xml)
    <servlet>
        <servlet-name>
            SQLServlet
        </servlet-name>
        <servlet-class>
            SQLServlet
        </servlet-class>

        <init-param>
            <param-name>properties</param-name>
            <param-value>C:/jakarta-tomcat-3.2.1/webapps/examples/WEB-INF/SQLServlet.properties</param-value>
        </init-param>

    </servlet>




5b. or specify the path to the properties in all HTML-File: (Example:)
   <INPUT TYPE="hidden" NAME="p" VALUE="/WEB-INF/SQLServlet.properties">

6. Restart your webserver	

 



Examples:
query:
HTML:                                                     
<A HREF=/servlet/SQLServlet?p=/WEB-INF/SQLServlet.properties&c=testConnection1&q=testQuery0 TARGET=rechts >query0</A><BR>
Properties: 
testConnection1=org.gjt.mm.mysql.Driver,jdbc:mysql://10.0.0.1/kgo,yourUsername,yourPassword
testQuery0=select * from PRODUCT 

insert:
HTML:
<INPUT TYPE="text" NAME="value1" >
<INPUT TYPE="text" NAME="value2" >
...
<INPUT TYPE="hidden" NAME="c" value="testConnection1">
<INPUT TYPE=HIDDEN NAME="q" VALUE="testInsert">            
properties:
testInsert=insert into YourTable (Field1,...) values (%value1%,..)
testConnection1=org.gjt.mm.mysql.Driver,jdbc:mysql://10.0.0.1/kgo,yourUsername,yourPassword

query:
HTML:
price less 
<INPUT type="text" name="PRICE" value="999">
<INPUT TYPE="hidden" NAME="p" VALUE="/WEB-INF/SQLServlet.properties">
<INPUT TYPE="hidden" NAME="c" value="testConnection1">
<INPUT TYPE="hidden" NAME="q" VALUE="testQuery2">
properties:
testQuery2=select * from PRODUCT where price < '%PRICE%' order by productid  
testConnection1=org.gjt.mm.mysql.Driver,jdbc:mysql://10.0.0.1/test,yourUsername,yourPassword
or
testConnection1=sun.jdbc.odbc.JdbcOdbcDriver,jdbc:odbc:test,username,password
update:
HTML:                                                      Properties: 
<INPUT type="text" name="Primarykey" value="">
<INPUT type="hidden" name="q" value="testSelect">          testSelect=select Field1,... from YourTable
<INPUT type="hidden" name="w" value="testWhere">           testWhere=where YourPrimarykey = %Primarykey%
<INPUT type="hidden" name="u" value="testTable">           testTable=update YourTable %set%

insert:
HTML:
<A HREF=/servlet/SQLServlet?p=/WEB-INF/SQLServlet.properties&c=testConnection1&q=testSelect2&i=testInsert1  >insert</A><BR>
Properties: 
testInsert1=insert into PRODUCT %set%
testSelect2=select * from PRODUCT where 1 > 1
testConnection1=org.gjt.mm.mysql.Driver,jdbc:mysql://10.0.0.1/kgo,yourUsername,yourPassword

Test from browser: 

edit SQLServlet.properties (testConnection1, testQuery0) and enter:
http://..../servlet/SQLServlet?debug=on&p=/WEB-INF/SQLServlet.properties&c=testConnection1&q=testQuery0





persistant connection: (stored in a sessionobject): 

HTML:                                                      Properties: 
connect:
<INPUT TYPE="hidden" NAME="p" VALUE="/WEB-INF/SQLServlet.properties">
<INPUT TYPE=HIDDEN NAME="c" VALUE="testConnection1">       testConnection1=org.gjt.mm.mysql.Driver,jdbc:mysql://10.0.0.1/kgo,yourUsername,yourPassword
<INPUT TYPE="hidden" NAME="password" value="testPassword"> testPassword=%pass%
<INPUT TYPE="hidden" NAME="user" value="testUser" >        testuser=%user%
<INPUT TYPE="text" NAME="user" >
<INPUT TYPE="password" NAME="pass" >

query:
<A HREF=/servlet/SQLServlet?q=testQuery0>                  testQuery0=select * from PRODUCT 

disconnect: 
<input type="hidden"    name="x" value="-- good bye --">




Layout params):
HTML                                                      Properties: 
<INPUT TYPE=HIDDEN NAME="t" VALUE="testTable">            testTable=BORDER=1 BGCOLOR=#eeee77 CELLPADDING=2 CELLSPACING=0"
<INPUT TYPE=HIDDEN NAME="l" VALUE="testLabel">            testLable=bgcolor=#ee44ee"
<INPUT TYPE=HIDDEN NAME="v" VALUE="testValue">            testValue=bgcolor=#eeeeff"
<INPUT TYPE=HIDDEN NAME="v2" VALUE="testValue2">          testValue2=bgcolor=#eeffaa"
<INPUT TYPE=HIDDEN NAME="f" VALUE="testFont">             testFont=face=arial size=-1 color=#009933"




order SQLServlet
http://shareit1.element-5.de/programs.html?productid=132531&language=English

