Chi Thien Phan | 2015-09-28 06:26:15.0 | |
hi,
the sql statement with group-by-clause give us incorrect data. The demo data will be sent to your mail. ------------------------------ 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:/C:/Users/pha.GTT-ALLGEMEIN/Desktop/Test123.xlsx?maxScanRows=0&caseInsentive=true&delayedClose=0"); String query = "select * from Tabelle1 group by Prozessschritt"; 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(); } } } ---------------------------------------------------------- Pls fix it! thx | ||
HXTT Support | 2015-09-28 07:51:52.0 | |
Supported. Please download the latest package. | ||
Chi Thien Phan | 2015-09-30 04:48:42.0 | |
thx, it works fine now! |