Question

想从sql中读取多行数据，然后存储到java中的数组或是list上面

可是只会读取一行数据，多行数据不知道怎么读
我写的代码是这样的：
LinkToSql() { String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String url = "jdbc:sqlserver://localhost\\MSSQLSERVER:1433;databaseName=InforDB"; String username = "sa"; String password = "123456";
try { Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); stmt = conn.createStatement(); //rs = stmt.executeQuery("update Table1 set Sno =" + 7733380); rs = stmt.executeQuery("select * from Data_ticket where flight_number='BH001' and flight_time = '2015-04-29 8:00:00'"); while (rs.next()) { for (int i = 0; i < note.length; i++) { note[i] = rs.getObject(i + 1); } } balance = Double.parseDouble(note[money_].toString()); } catch (Exception ex) { } }

Answer 1

你的note在哪里定义的，还有你确定
select * from Data_ticket where flight_number='BH001' and flight_time = '2015-04-29 8:00:00出来的结果有很多行吗

追问

确定那条语句会返回多个结果。