SQLServlet

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
3. Copy SQLServlet.class to the servlet directory
4. Copy SQLServlet.properties to the servlet-property-directory (not accessible from the web)
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

5b. or specify the path to the properties in all HTML-File: (Example:)
   <INPUT TYPE="hidden" NAME="p" VALUE="/kgo/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="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/kgo,yourUsername,yourPassword

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"

Return to index

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.