子查询结果不成功

Question

我在sqlite查询结果的子查询中遇到问题。当执行下面的查询时，成功返回Sqlite数据库中的结果，但当运行程序时，它不返回任何值。我在下面的程序中做错了什么。请给我一些建议。

查询：

select * from (SELECT count(*), col2,col9,col4 FROM tbl_data_1  WHERE col4=6  AND col3 BETWEEN '2012-11-21' AND '2013-04-19' GROUP BY col2,col9,col4) as inr_qry where col2= '20016' and col9='3'

java程序：

Vector<Vector> dataList = new Vector();
for (int i =0; i < listRows.size(); i++){
    Vector cols = new Vector();             
    cols.add(listRows.get(i));
    for (int j = 1; j < listColumns.size(); j++){
        // below query will be dynamic
        String inner_query = "select * from (SELECT count(*), col2,col9,col4 FROM tbl_data_1  WHERE col4=6  AND col3 BETWEEN '2012-11-21'               AND '2013-04-19' GROUP BY col2,col9,col4) as inr_qry where col2= '20016' and col9='3'";

        PreparedStatement data_st = database.getConnection().prepareStatement(inner_query);
        ResultSet data_rs = data_st.executeQuery();
        while (data_rs.next())  { // result not successful, result set not having records
            SLogger.printD("data_rs.getString(1): " +data_rs.getString(1));
            cols.add(data_rs.getString(1));
        }
    }
    dataList.add(cols);
}

Answer 1

听起来很奇怪，但是作为一个int是预期的，你能试着用

getInt(1)

而不是

getString(1)

Answer 2

您不需要PreparedStatement。相反，请使用以下命令：

Statement stmt = database.getConnection().createStatement();