ThinSQL
ThinSQL Version 1.0 (c) Klaus Gotthardt
email: info@kgo.de
home: http://www.kgo.de
Grid by:
http://www.lynx.ch/contacts/~/thomasm/default.html
ThomasM@n-s.oron.ch
(thanks!)
Sourcecode of ThinSQL on demand.
Advantages:
- access to any database on the web
- queries,updates,inserts and deletes
- freeware
- thin client (<20k)
- no plugin, no client installation
Netscape Commucator 4.06 or later, or Internet Explorer 4.0 or later
and a servlet enabled web-server is required.
Installation:
1.copy ThinSQL.html , ThinSQL.class ,ThinSQLpro.class ,OkDialog.class; LoginDialog.class and Grid.class to a web-directory
2.copy ThinSQLservlet.class , ThinSQLservletpro.class to the servlet-directory
3.edit ThinSQL.html
Params
Name: q0 - q99
Values: (separated by semicolons)
1: name of the query
2: driver
3: url
4: query-string
5: tablename or null
6: number of fields of the primary key . the fields must be at the beginning of the query
1= the primary key is the first field of the query
2= the primary key is the first and the second field of the query
0= no updates allowed
7: null or 'GroupBy'-field of the table for selections (only ThinSQLpro)
Examples:
<param name=q2 value="informixQuery;com.informix.jdbc.IfxDriver;jdbc:informix-sqli://yourhostname:1525/yourdatabasename:informixserver=yourserver;select * from yourTable;yourTable;1;null">
<param name=q3 value="oracleQuery;oracle.jdbc.driver.OracleDriver;jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:xxxx;select * from yourTable;yourTable;1;null">
<param name=q4 value="mysqlQuery;org.gjt.mm.mysql.Driver;jdbc:mysql://www.xxx.de:3306/xxxx;select ... from yourTable group by ... order by ....;null;0;null">
<param name=q99 value="RmiJdbcQuery;RmiJdbc.RJDriver;jdbc:rmi://xxx.xxx.xxx.xxx:1099/...;select * from yourTable where ...;yourTable;1;null">
ThinSQLpro (not Freeware)
Benefits:
1: groupfield for selections
2: login-dialog
3: yes/no-dialog for deletes
4: keep-alive connection (new)
Order (295$):
http://shareit1.element-5.de/programs.html?productid=105108&language=English
Back to the ThinSQL page
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.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.
| 
