sqlite java需要按照,什么是连接SQLite数据库的合适方法,执行准备好的语句并关闭与Java的连接?...

这是我目前的密码。我有或曾经有过几个问题:

数据库正忙-错误

SQL错误或缺少数据库

结果集已关闭

如果我想防止这两个错误,应该使用哪种代码结构?

我需要在试听区连接吗?我需要在哪里关闭连接?我需要在哪里关闭已准备好的报表?

到现在为止,我无法通过连接不同页面的信息来找到解决方案。

public boolean checkForUser(String username){

try(Connection con = this.connect();

PreparedStatement pstmt = createPreparedStatementRegistrate(conn, username);

ResultSet rs= pstmt.executeQuery();)

{

if (rueck.next()){

pstmt.close();

rs.close();

con.close();

//do some stuff

}

}catch(SQLException e){

e.printStackTrace();

}

return null;

}

private PreparedStatement createPreparedStatementRegistrate(Connection conn, String username) throws SQLException {

String sql = "SELECT * FROM users WHERE username = ?";

PreparedStatement pstmt = conn.prepareStatement(sql);

pstmt.setString(1, username);

return pstmt;

}

private Connection connect() {

String url = "jdbc:sqlite:user.db";

Connection con = null;

try {

con = DriverManager.getConnection(url);

} catch (SQLException e) {

e.printStackTrace();

}

return con;

}

java.sql.SQLException: ResultSet closed

at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:69)

at org.sqlite.jdbc3.JDBC3ResultSet.findColumn(JDBC3ResultSet.java:38)

at org.sqlite.jdbc3.JDBC3ResultSet.getString(JDBC3ResultSet.java:443)

at zugriffsverwaltung.Zugriffsverwaltung.loeschen(Zugriffsverwaltung.java:215)

at zugriffsverwaltung.Zugriffsverwaltung.(Zugriffsverwaltung.java:37)

at main.Server.(Server.java:29)

at main.Server.main(Server.java:46)

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (Connection is closed)

at org.sqlite.core.DB.newSQLException(DB.java:909)

at org.sqlite.core.CoreStatement.internalClose(CoreStatement.java:115)

at org.sqlite.jdbc3.JDBC3Statement.close(JDBC3Statement.java:35)

at org.sqlite.jdbc4.JDBC4Statement.close(JDBC4Statement.java:27)

at zugriffsverwaltung.Zugriffsverwaltung.loeschen(Zugriffsverwaltung.java:238)

at zugriffsverwaltung.Zugriffsverwaltung.(Zugriffsverwaltung.java:37)

at main.Server.(Server.java:29)

at main.Server.main(Server.java:46)