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

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.