java resultset 为空_java resultset 为什么总是返回空值，导致集合长度始终位0，急求答案，谢谢！...

publicString[][]QueryAllScoreInformation(){String[][]allScore=null;Connectionconn=super.getConnection();PreparedStatementpst=null;ResultSetrs=null;intstate=0;Stringsql="s...

public String[][] QueryAllScoreInformation(){

String[][] allScore = null;

Connection conn = super.getConnection();

PreparedStatement pst = null;

ResultSet rs = null;

int state = 0;

String sql = "select t_grade.*,t_user.USERNAME,t_user.userid from t_grade join t_user on t_grade.userId = t_user.userid where t_user.state = ?";

try {

pst = conn.prepareStatement(sql);

pst.setInt(1, state);

rs = pst.executeQuery();

int cols = 0;

while(rs.next()){

cols++;

}

allScore = new String[cols][9];

List grades = new ArrayList();

while(rs.next()){

Grade_User grade = new Grade_User();

grade.setId(rs.getLong("id"));

grade.setJava(rs.getInt("javaCourse"));

grade.setDb(rs.getInt("db"));

grade.setHtml(rs.getInt("html"));

grade.setjJavaPractice(rs.getInt("javaTrain"));

grade.setSumScore(rs.getInt("total"));

grade.setAvgScore(rs.getDouble("avgGrade"));

grade.setUsername(rs.getString("username"));

grade.setStudentId(rs.getLong("id"));

grades.add(grade);

}

if(grades.size() <= 0){

System.out.println(grades.size());

}

/*int k = 0;

for(int i = 0; i < allScore.length; i++){

for(int j = 0; j < allScore[i].length;j++){

//allScore[i][j] = grades.get(k).toString();

System.out.println(grades.get(k));

k++;

}

}*/

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

rs.close();

pst.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return allScore;

}

展开