程序员最近都爱上了这个网站  程序员们快来瞅瞅吧!  it98k网:it98k.com

本站消息

站长简介/公众号

  出租广告位,需要合作请联系站长


+关注
已关注

分类  

暂无分类

标签  

暂无标签

日期归档  

暂无数据

连接关闭后结果集被清除。SQLite

发布于2023-02-04 22:50     阅读(914)     评论(0)     点赞(0)     收藏(3)


这是我的代码

public static void main(String[] args) throws SQLException {
    Long chatId = 432878720L;
    String what = "*";
    String from = "BtcUser";
    ResultSet rs = selectUser(what, from, chatId);
    if (rs.next()) {
        System.out.println("NEVER REACH");
    }
}

private static ResultSet selectUser(String what, String from, long chatId) throws SQLException {
    String sql = "SELECT "+what+" FROM "+from+" WHERE chatId = ?;";
    ResultSet rs;
    try (Connection con = DriverManager.getConnection(url);
         PreparedStatement pst = con.prepareStatement(sql)) {
        pst.setLong(1, chatId);
        rs = pst.executeQuery();
        return rs;
    }
}

如您所料,IF 块始终为假。但是当这段代码像这样时:

public static void main(String[] args) throws SQLException {
    Long chatId = 432878720L;
    String what = "*";
    String from = "BtcUser";
    String sql = "SELECT "+what+" FROM "+from+" WHERE chatId = ?;";
    ResultSet rs;
    try (Connection con = DriverManager.getConnection(url);
         PreparedStatement pst = con.prepareStatement(sql)) {
        pst.setLong(1, chatId);
        rs = pst.executeQuery();
        if (rs.next()) {
            System.out.println("HELLO");
        }
    }
}

一切正常。并且 IF 块可以为真。我想 ResultSet 在连接关闭时会重置。为什么会发生这种情况以及如何防止这种情况发生?


解决方案


我想通了。不得关闭准备好的语句以保存 ResultSet。所以这有效:

public static void main(String[] args) throws SQLException {
    long chatId = 432878720L;
    String what = "*";
    String from = "BtcUser";
    ResultSet rs = f(what, from, chatId);
    if (rs.next()) {
        System.out.println("HELLO");
    }
}

private static ResultSet f(String what, String from, long chatId) throws SQLException {
    String sql = "SELECT "+what+" FROM "+from+" WHERE chatId = ?;";
    try (Connection con = DriverManager.getConnection(url)) {
        PreparedStatement pst = con.prepareStatement(sql);
        pst.setLong(1, chatId);
        return pst.executeQuery();
    }
}


所属网站分类: 技术文章 > 问答

作者:黑洞官方问答小能手

链接:http://www.javaheidong.com/blog/article/641611/0d5cd3c3bcf3e09b82ef/

来源:java黑洞网

任何形式的转载都请注明出处,如有侵权 一经发现 必将追究其法律责任

0 0
收藏该文
已收藏

评论内容:(最多支持255个字符)