PreparedStatement prep=connect.prepareStatement("select count(*) from table");
ResultSet result=prep.executeQuery();
if(result.next()){
count=result.getInt(1);
}
ResultSet result=prep.executeQuery();
if(result.next()){
count=result.getInt(1);
}
String str_sum="SELECT * from table";
ResultSet rs_sum=stmt_sum.executeQuery(str_sum);
if(rs_sum.next())
{
rs_sum.last();
rowcount = rs_sum.getRow();
}
PreparedStatement prep=connect.prepareStatement("select count(*) from table");
ResultSet result=prep.executeQuery();
if(result.next()){
count=result.getInt(1);
}
select count(*) from table:这一段是什么作用啊.在是result.next()这一句只是把游标移到下一个记录吧result.getInt(1);此方法又是什么作用呢?to kidman521(kid):
Statement stmt_sum=conn.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 其中的参数是什么意思?
getRow好象是获取ResultSet对象的当前记录行号吧,这不会是把指针移到最后在取其行号吧.
学着点,人家都把问题说清楚了,你再不清楚就是你自己的不对了!不好好看书,天天想着一步登天,打好基础先!
我晕。。慢慢来吧