在改别人的代码,然后有错误,请教下大家
DBConnector db=new DBConnector();
String sql="select * from MemberLove;
ArrayList<Object[]> al=null;
try{
al=db.executeQuery(sql);
}
catch(Exception e){
e.printStackTrace();
throw e;
}
condition=" and gender='"+gender+"'";
int minAge=Integer.parseInt(String.valueOf(((Object[])(al.get(0)))[0]));// 报错
int maxAge=Integer.parseInt(String.valueOf(((Object[])(al.get(0)))[1]));// 报错
// 报错代码如上,用到了DBConnector类。报错提示为:java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
提示数据越界单对数据库执行查询,结果如图
DBConnector db=new DBConnector();
String sql="select * from MemberLove;
ArrayList<Object[]> al=null;
try{
al=db.executeQuery(sql);
}
catch(Exception e){
e.printStackTrace();
throw e;
}
condition=" and gender='"+gender+"'";
int minAge=Integer.parseInt(String.valueOf(((Object[])(al.get(0)))[0]));// 报错
int maxAge=Integer.parseInt(String.valueOf(((Object[])(al.get(0)))[1]));// 报错
// 报错代码如上,用到了DBConnector类。报错提示为:java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
提示数据越界单对数据库执行查询,结果如图
al=db.executeQuery(sql);
看看al的值
for (Object[] objs : al) {
System.out.print(objs.length + ": ");
for (int i = 0; i<objs.length; i++) {
System.out.print(objs[i] + "\t");
}
System.out.println();
}