★ wanayoo — archive 1999 http://javaboutique.internet.com/ThinSQL/config.htmlNouvelle recherche | Portail wanayoo
internet.com logo The Java Boutique
 APPLETS
by Category
by Date
by Name
Hall of Fame
Archive
Submit
Source Code
Servlets and JSP
 ARTICLES
Tutorials
Reviews
Glossary
 FORUM
FAQ
Users Poll
Discussion Group
Contact Us
 OTHER RESOURCES
Custom Applets
Java@Work
Java News
Jini Watch
Affiliate Programs
Top Searches
chat - counter
menu - countdown

All Net Research -- in one place
internet.com
Internet News
Internet Stocks/VC
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ECommerce/Marketing
ISP Resources
ASP Resources
Wireless Internet
Downloads
Internet Resources
Internet Lists
International

Search internet.com
Advertising Info
Corporate Info

internet.commerce
Be a Commerce Partner
Internet Jobs
E-Business Exchange
Map Your Website
Database Web Tools
Small Biz Purchasing
Get e-Biz Intell.
IT Products and Svcs
Offer Online Payment
Accept Credit Cards
Software Specials

WebDeveloper Network
BrowserWatch
Developer Forums
Developer News
JavaBoutique
JavaScriptSource
ScriptSearch
SearchEngineWatch
StreamingMediaWorld
The WDVL
WebDeveloper.com
WebDevelopersJournal WebReference.com
The XML Files

Jobs.webdeveloper.com

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

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.

When you're ready to play with the big boys

Copyright 1999-2000 internet.com Corp.
All Rights Reserved. Legal Notices.