mysql读取数据 二维数组_从数据库读取数据存入二维数组

下面是我写的,但好像行不通,各位大虾帮忙看下是哪里出问题,要怎么改,帮帮小弟了,我先谢了~Stringsql="select*fromscene";rs=stmt.executeQuery(sql);rs.last();intsceneLength=rs.get...

下面是我写的,但好像行不通,各位大虾帮忙看下是哪里出问题,要怎么改,帮帮小弟了,我先谢了~

String sql="select * from scene";

rs=stmt.executeQuery(sql);

rs.last();

int sceneLength=rs.getRow();

rs.beforeFirst();

int i=0;

Scenery[][] sceneries=new Scenery[sceneLength][];

while(rs.next()){

String sql1="select * from scenery where scenery.scene=rs.getInt(1)";

rses[i]=stmt.executeQuery(sql1);

int j=0;

while(rses[i].next()){

sceneries[i][j]=new Scenery(rs.getString(2),rses[i].getString(3),rses[i].getString(4),rses[i].getString(5),rses[i].getString(6),rses[i].getString(7));

j++;

}

i++;

}

展开