hi,
the driver Excel_JDBC30.jar 4.2.044 on March 02, 2015 gives correct data from sql statement. But the current driver on 2015-10-21 07:06 gives empty data from the same sql statement. Pls fix it! Thx
PS: the excel file Demodaten_Doku_GanttBean.xlsx will be sent to your mail.
Java-Example-Code:
--------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class HTXX_Excel {
public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/Demodaten_Doku_GanttBean.xlsx?maxScanRows=0&caseInsentive=true&delayedClose=0");
String query = "select Nachfolger, Relationstyp, Vorgänger from Relation where Nachfolger=399649806 or Vorgänger=399649806 or Nachfolger=399649805 or Vorgänger=399649805 or Nachfolger=399649807 or Vorgänger=399649807";
Statement stmt = conn.createStatement();
ResultSet resultSet = stmt.executeQuery(query);
resultSet.getMetaData();
while (resultSet.next()) {
System.out.println("-------------------------------------");
for(int i = 1; i < 2; i++){
System.out.println(resultSet.getObject(i));
}
}
resultSet.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
--------------------------------------
|
|
Supported. Please downlosd the latest package.
|
Main
webmaster@hxtt.com