No result from JDBC with Date filter in prepareStatement

[程 万胜]

大家好：

用kylin的JDBC查询，查询条件是date类型的，如果通过prepareStatement、setDate是查询不出数据的，然而直接用SQL可以查出数据

我用的是kylin版本：apache-kylin-1.6.0-cdh5.7-bin，jdbc版本：kylin-jdbc-1.6.0.jar，java版本：java
 version "1.8.0_92"


代码1

        Driver driver = (Driver) 
Class.forName("org.apache.kylin.jdbc.Driver").newInstance();

        Properties info = new Properties();
        info.put("user", "xxx");
        info.put("password", "xxx");
        Connection conn = driver.connect("jdbc:kylin://xxx/learn_kylin", info);
        PreparedStatement state = conn.prepareStatement(
                "select " + "part_dt, sum(price) as total_selled, 
count(distinct seller_id) as sellers "
                        + "from kylin_sales where part_dt <= '2013-01-01' " + 
"group by part_dt " + "order by part_dt limit 100");

        ResultSet resultSet = state.executeQuery();
        System.out.print("结果：");
        while (resultSet.next()) {
            System.out.print(resultSet.getString(1) + "\n");
        }


运行结果

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further 
details.
结果：2011-12-31
2012-01-01
2012-01-02
2012-01-03
2012-01-04
2012-01-05
2012-01-06
2012-01-07
2012-01-08
2012-01-09


代码2

        Driver driver = (Driver) 
Class.forName("org.apache.kylin.jdbc.Driver").newInstance();

        Properties info = new Properties();
        info.put("user", "xxx");
        info.put("password", "xxx");
        Connection conn = driver.connect("jdbc:kylin://xxx/learn_kylin", info);
        PreparedStatement state = conn.prepareStatement(
                "select " + "part_dt, sum(price) as total_selled, 
count(distinct seller_id) as sellers "
                        + "from kylin_sales where part_dt <= ? " + "group by 
part_dt " + "order by part_dt limit 100");
        SimpleDateFormat simpleTime = new SimpleDateFormat("yyyy-MM-dd");
        java.util.Date passUtilDate = simpleTime.parse("2013-01-01");
        java.sql.Date passSqlDate = new java.sql.Date(passUtilDate.getTime());
        System.out.print("条件是：" + passSqlDate + "\n");
        state.setDate(1, passSqlDate);

        ResultSet resultSet = state.executeQuery();
        System.out.print("结果：");
        while (resultSet.next()) {
            System.out.print(resultSet.getString(1) + "\n");
        }


运行结果

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further 
details.
条件是：2013-01-01
结果：