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 Article:
Servlets and JSP
In addition to applets, applications, servlets, and articles, we are now accepting submissions of JSP snippets! If you have a piece of JSP code that you think would be useful to others, then send it in!
... [Submissions]
New Tutorial:
Introduction to Java Part 6:
Building Your First Application
Selena Sol goes through all the Java code and HTML necessary to create a java application.
... [more Tutorials]
Year in Review:
The Best of 1999
Y2K has come and gone and now we have a chance to look back over the past year.
In 1999 we posted over 250 applets, servlets, applications, and tools.
In this list are the 24 most popular apps from 1999.
... [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
100s of free Java code files to download.
Copyright 1999-2000 internet.com Corp.
All Rights Reserved. Legal Notices.
|