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

How to Add Java Applets to Your Site

New on the Java Boutique:

New Article:
J2EE Deployment Specification
Why is it that J2EE applications written in the same language, Java, may not coexist on different servers? While the answer isn't simple Sun has set out to alleviate these problems with the "J2EE Deployment Specification".
... [more articles]

New Tutorial:
Designing Packages for Stability
Are your designs stable? This month Samudra will focus on the change impact relationship involved in designing classes showing us how to take them into account when designing the package relationship.
... [more Tutorials]

Year in Review:
The Best of 2002
The year 2002 saw 201 new applets posted to JavaBoutique. Check out the 2 most popular apps from each month of 2002!
... [popular applets]

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.