部分代码: try{ int j = 0; Oracledb db = new Oracledb(); String str_sql = "select * from wap_new_yw"; str_sql="select S_ID,TITLE from wap_news where boardid='133'"; //String str_sql = "select title from wap_news where boardid='133' order by s_id"; db.setSqlstr(str_sql); db.executeselect(); java.sql.ResultSet rs = db.getRS(); //rs.beforeFirst(); rs.last();//出现问题的地方 Count = rs.getRow(); rs.beforeFirst();
order by s_ids_id到底大写的还是小写的???你的rs里面到底有几条记录???我估计一条都没有,你看看吧
try{
int j = 0;
Oracledb db = new Oracledb();
String str_sql = "select * from wap_new_yw";
str_sql="select S_ID,TITLE from wap_news where boardid='133'";
//String str_sql = "select title from wap_news where boardid='133' order by s_id";
db.setSqlstr(str_sql);
db.executeselect();
java.sql.ResultSet rs = db.getRS();
//rs.beforeFirst();
rs.last();//出现问题的地方
Count = rs.getRow();
rs.beforeFirst();
你的SQL语句中S_ID和s_id应该是一回事情
不知道为什么要变换大小写
SQL语句对字段名的大小写应该是敏感的吧
448
:)