有关ResultSet取值问题,大家帮看看,谢谢 第二次执行的结果应该有一条记录,但是if(rs.next()){System.out.ptintln("???????????");....}打印语句都没有打 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ResultSet你有给属性吗?比如说可滚动的,敏感的? 我刚才改了一下程序,分别声明了两个statement和resultset,结果还是不行,和不改之前是一样的,不知道怎么搞的 下面是代码,大家帮忙看看:public List[] doAreaSearch(String[] Area, String[] Product) { List[] areaList = new ArrayList[Area.length]; conn=new ConnectionDB().connectionDB(); for (int i = 0; i < Area.length; i++) { try { stmt1 = conn.createStatement(); } catch (SQLException e1) { e1.printStackTrace(); } StringBuffer sbuffer = new StringBuffer(); sbuffer.append("select shi as shi,"); for (int j = 0; j < Product.length; j++) { sbuffer .append("sum(" + Product[j] + ") as " + Product[j] + " "); if (j + 1 != Product.length) { sbuffer.append(","); } } sbuffer.append("from PCJD_QYXX where shi='" + Area[i] + "' group by shi"); System.out.println(sbuffer.toString()); try { rs1 = stmt1.executeQuery(sbuffer.toString()); } catch (SQLException e) { e.printStackTrace(); } try { if (rs1.next()) { System.out.println("rrrrrrr"); areaList[i].add(rs1.getString("shi")); System.out.println("shi:" + rs1.getString("shi")); for (int k = 0; k < Product.length; k++) { areaList[i].add(rs1.getString(Product[k])); } System.out.println("areaList[i] size" + areaList.length); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { rs1.close(); stmt1.close(); } catch (SQLException e) { e.printStackTrace(); } } } return areaList; } catch (SQLException e)改成catch (Exception e)然后等着看 异常错误信息吧!贴上来 当生成 ResultSet 对象的 Statement 对象关闭、重新执行或用来从多个结果的序列检索下一个结果时,ResultSet 对象会自动关闭。 如何用STRING给MYBATIS配置文件传值(在线等,着急) struts2日期类型转换问题 我要做一个图表,想实现图表刷新的时候是局部刷新 struts2中怎么取得js传来的值 如何用java识别验证码?? 求助!谁知道这是怎么回事 如何用代码实现每月自动备份Oracle数据库 为什么在weblogic上用GBK会出错呢? 刚看的tomcat。发生点问题,大家帮一下。初级问题,在线等! 怎么设置classpath 现在比较熟练JSP了?下一步该学什么?请高手们推荐本书 关于一个struts.properties的问题
public List[] doAreaSearch(String[] Area, String[] Product) {
List[] areaList = new ArrayList[Area.length];
conn=new ConnectionDB().connectionDB();
for (int i = 0; i < Area.length; i++) {
try {
stmt1 = conn.createStatement();
} catch (SQLException e1) {
e1.printStackTrace();
}
StringBuffer sbuffer = new StringBuffer();
sbuffer.append("select shi as shi,");
for (int j = 0; j < Product.length; j++) {
sbuffer
.append("sum(" + Product[j] + ") as " + Product[j]
+ " ");
if (j + 1 != Product.length) {
sbuffer.append(",");
}
}
sbuffer.append("from PCJD_QYXX where shi='" + Area[i]
+ "' group by shi");
System.out.println(sbuffer.toString());
try {
rs1 = stmt1.executeQuery(sbuffer.toString());
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (rs1.next()) {
System.out.println("rrrrrrr");
areaList[i].add(rs1.getString("shi"));
System.out.println("shi:" + rs1.getString("shi"));
for (int k = 0; k < Product.length; k++) {
areaList[i].add(rs1.getString(Product[k]));
}
System.out.println("areaList[i] size" + areaList.length);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
rs1.close();
stmt1.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return areaList;
}