很奇怪的一个问题，请大神出手，谢谢！

[tonybao]

大家好，
我在页面里为了得到dl_al_ah_id的值，写了个结果集，如下：

sql_oracle = "SELECT dl_al_ah_id ah_id FROM sop_invoice_credit_lines WHERE dl_dh_id = " + dispatch_num;
rs_oracle = stm_oracle.executeQuery(sql_oracle);

if (rs_oracle.next())
{
dl_al_ah_id = rs_oracle.getInt("ah_id");
}
else
{
out.println("that's not ok.");
}

这个查询在ORACLE是有结果的(有18条符合条件的记录，值都是一样的)，但在页面上结果集就是空的，就是显示个 that's not ok.

oracle 11g
Tomcat 8.5.38

请大神看看，这是为什么呢？

[bcsflilong]

List ids=new Arraylist();
while(rs_oracle.next())
{
  dl_al_ah_id = rs_oracle.getInt("ah_id");
out.println(dl_al_ah_id);
}

[tonybao]

如果dispatch_num换个其它的值，页面上结果集就不是空的了，太奇怪了。求救！

[tonybao]

An error occurred at line: [102] in the jsp file: [/shipping Arraylist cannot be resolved to a type

[freekaiQaQ]

引用 3 楼 tonybao 的回复:

An error occurred at line: [102] in the jsp file: [/shipping Arraylist cannot be resolved to a type

Arraylist cannot be resolved to a type ---> ArrayList 中的 list 的 L 是大写的。 dispatch_num 换成其他的值 就不是空的了 ，dispatch_num 值是什么？