这有问题吧
boolean hasMore = rs.next(); while ( hasMore ){
if (rs.getInt("Points") > max_point) {
max_point = rs.getInt("Points");
win = rs.getInt("GamesWon");
loss = rs.getInt("GamesLost");
total = rs.getInt("GamesPlayed");
playid = rs.getString("PlayerID");
firstname = rs.getString("FirstName");
surname = rs.getString("Surname");
}
hasMore = rs.next();
}
boolean hasMore = rs.next(); while ( hasMore ){
if (rs.getInt("Points") > max_point) {
max_point = rs.getInt("Points");
win = rs.getInt("GamesWon");
loss = rs.getInt("GamesLost");
total = rs.getInt("GamesPlayed");
playid = rs.getString("PlayerID");
firstname = rs.getString("FirstName");
surname = rs.getString("Surname");
}
hasMore = rs.next();
}
if (rs.getInt("Points") > max_point) {
max_point = rs.getInt("Points");
win = rs.getInt("GamesWon");
loss = rs.getInt("GamesLost");
total = rs.getInt("GamesPlayed");
playid = rs.getString("PlayerID");
firstname = rs.getString("FirstName");
surname = rs.getString("Surname");
}
hasMore = rs.next();
}
但我改了好多次,都是同一个错误,,>> java.sql.SQLException: No data found不会改了。。有谁能帮我改改!!谢了。。
看看你的数据源,和用户名密码写的都对么????????
while (rs.next())
如果那段CODE有问题何不删掉试试?或改简单点试试
while(rs.next())
System.out.println(rs.getString(1)+rs.getString(2));
int temp;
boolean hasMore = rs.next(); while ( hasMore ){
temp = rs.getInt("Points");
if ( temp > max_point) {
max_point = temp;
win = rs.getInt("GamesWon");
loss = rs.getInt("GamesLost");
total = rs.getInt("GamesPlayed");
playid = rs.getString("PlayerID");
firstname = rs.getString("FirstName");
surname = rs.getString("Surname");
}
hasMore = rs.next();
}
另外就是你取列值的时候,是有顺序的,只能先rs.getString(1)后rs.getString(2)。先调试一下程序,试试吧
JDBC????
你用的不是JDBC-ODBC桥吗?
你看看数据库里的字段和类型都和你读取的一样吗?