isBeforeFirst()返回
true如果下一次调用
next()会把光标的第一行
ResultSet。换句话说,任何具有数据的成功查询一旦执行,将产生
ResultSet带有
isBeforeFirst()returning的
true。
只需从代码中删除该块,并让
rs.next()循环处理可能为空的
ResultSets:
try{ Class.forName("org.sqlite.JDBC"); c = DriverManager.getConnection("jdbc:sqlite:lineappDB.db"); c.setAutoCommit(false); System.out.println("Opened database successfully"); stmt = c.createStatement(); String query = String.format("SELECt * FROM VIDEOS"); result = new Object[6]; ResultSet rs = stmt.executeQuery(query); while (rs.next()) { result[0] = rs.getInt(1); result[1] = rs.getString(2); result[2] = rs.getString(3); result[3] = rs.getString(4); result[4] = rs.getString(5); result[5] = rs.getInt(6); }} 


