|
In the solution,the user application on the server-side is invocated by HYSQL
which has the controllable fuction. It is said that it is HYSQL(not the user
application), directly connecting with the HYSQL interface on the browser-side
and the applet on the client-side by the user-defined port. The user
application is loaded and invocated to implement the user-defined fuction by
the controllable fuction of HYSQL when it is needed, meanwhile the applet is
downloaded when it isn't needed. Certainly all or parts of the user
application are reserved to run,so that the runningl speed is increased.The
mode which the user application is invocated passively,can satisfy the
internet rule which is "run at all times / usable at all times". The
running modules is continually added to/modified the application.That takes
advantages of colorfulness of the interactive application on the client-side
in the client/server structure and the point that the code and data is on the
server-side in the Internet structure, so that the HYSQL-based solution can
not only upbuild the individual interactive internet application quickly, but
also maintain it conveniently. “一直运行/一直可用”
Such as the applet dynamic drawing,the applet program in the client-side
browser not only can implement some fuctions without the data from outside,
but also connect HYSQL
directly to get the interactive data. Both the class program in the server and the
applet program in the browser connect HYSQL,therefore,the user applications
don't need programming to orient the port.
In general,the people write the database-based internet dialogic applications
with Java,they have to write server-side and client browser-side
applications,such as the constant and simple operation of inserting a record
into the database.Moreover,so as to provide the flexible dialogic program,on the
browser-side, they
have to write the program to orient the port,which are writing the data
and command into the port and get the result ; on the server-side, recieve and
process the data and command and write the disposal result into the port,
so rapidly increases the programming complexity.
HYSQL provides upbuilding the database interface directly in the browser and
executing the SQL statements by the interface,so that you don't
need to program to orient the port. Meanwhile,except that the special server
application program is needed to write on the server-side for processing the
complicated data, In many instances,the special server application program isn't
need to develop on the server-side, so that the development complexity and cost are rapidly
lowered.
The following example is to show the above advantages.The example demostrates
the process that the user inputs his suggestion in his browser and submits to the
web-station.In order to pop out the emphasis,the program how to write the
suggestion table is omitted.
1.If the server-side has the following sentence to create a suggestion
database:suggest.dbf,its fields are 'name','email' and 'suggestion':
"CREATE TABLE suggest.dbf (name CHAR(20),email
CHAR(30),suggestion CHAR(300))";
2.The following url is'host name and port number';unitID,user and password are
'your unit ID number','user name for loginning' and 'password';adapter is the
programming connection of HYSQL:
String url = "jdbc:HYDrive:www.huayisoft.com:2000";
int unitID = 999;
String user = "admin";
String password = "111";
HYAdapter adapter=new HYAdapter(url,"",unitID,user,password);
String suggest = "Changan Ke,hy@huayisoft.com,HYSQL is easy to learn
and easy to use!";
String sql = "INSERT INTO suggest.dbf VALUES ("+suggest+")";
adapter.executeUpdate (sql);
There are only these simple operations of getting the programming interface of
HYSQL and directly executing SQL statements by the interface,you don't need
these steps ,respectively loading the database driver,upbuilding
connection,creating statements and executing statements.
HYSQL have concentrated many advantages of traditional client/server,
Internet
and Java, is done to provide a more excellent Internet solution based on the
database.
Return to Homepage
|
