1. Prerequisites: A computer has an Access database that collects the door card data. To read data from the remote access must be readable to read data in real time, and considering that you cannot be read by others, you must only People have permissions and must be logged in with this user on the client. It is inconvenient. So consider using XML RMI to deliver data .2. Implement XML to implement PrePareStatement, return to ResultSet, or Update. Because of the establishment and close The connection is very wasted, and this program does not support Transaction, so only one connection is shared. 3. Description: 1. Steeven.xml.sql Defines the basic interface and simple implementation of XML SQL 2. Steeven.rmi.sql definition RMI implementation Connection and Server 3. Gate.Server is a simple server and client 4. Todo: 1. RMI poplicy should be improved 2. In fact, XML only acts as a data transfer medium, not an external interface, you should use a simpler ROWSET implementation. (Busy For a long time, it is practiced) 3. Test .5. Statement: Copyright, no
Steeven@kali.com.cnqq: 7461522jan 08,2002
Code download, please here: http://www.starmate.com.cn/bbs/read.php? Bbs = 48 & id = 1048 # SUBJECT1048
On the remote host: Run RMISERVER, then start this service java -jar -djava.rmi.server.codebase = file: d: /tmp/gate.jar -djava.security.policy = file: rmi.Policy Gate.jar ~ ~~~~~~~~~~~~~~ Note: CodeBase parameters need absolute path
The client executes steeven.gate.server.testclient.java
IF u Start TRACE IN ODBC, IT WILL BE VERY VERY SLOW. Close It to speted Up.
Type supportted & convertions (JDBC-> java.sql.Types): NULLBoolean -> bitbyte -> tinyintshort -> small intint -> integerlong -> bigintfloatdoublebigDecimal-> numericstring -> varchar / long vcharbytes -> varbinary / long varbinarydatetimetimestamp