|
I don't know how to create a connection to use HXTT . What is the process step by step please
|
For example could you tell me how to run the Excel_JDBC30demo demos. I start server.bat then I uncomment some of the commands from the sql.txt , for example
select _rowid_,* from Sheet1;
file to try to get test.bat to run but nothing happens except the resulting test1.txt file generated after i run test.bat contains only one line of code
com.hxtt.sql.excel.ExcelDriver
how can i get it to run over an excel file to get something to work. I am very new to java but I think this program will do a lot of whta i need and if i can get it to work i am very interested in getting a licence
|
You needn't start server.bat, because you can use embedded mode. You can uset test.bat to do test, for instance,
java testSQL "jdbc:Excel:/h:/Book1.xls" "select * from Sheet1;"
|