请问：怎样取得sql语句的操作行数？

[auron01]

import java.sql.*;
/**
*
* @author Administrator
*/
public class Data {
private final String url="jdbc:odbc:xiaohuoguanli";
private final String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Connection conn;
Statement stmt;
ResultSet rs;
Object data[][];
/** Creates a new instance of Data */
public Data() {
}

protected Object[][] sqlSelect(){
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,"sa","");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from htxxb order by id");
while (rs.next()){
for (int i=0;i<操作行数;i++){
data[i][0]=rs.getString("id");
data[i][1]=rs.getString("ywy");
}
//System.out.println(rs.getString(1));
}
return data;
}catch(Exception ex){
System.out.println(ex.getMessage());
return null;
}
}
}
请问，应该怎么写？

[zhouying1573]

shiyong rownum lai kongzhi

[auron01]

我知道怎么做了。
import java.sql.*;
/**
*
* @author Administrator
*/
public class Data {
private final String url="jdbc:odbc:xiaohuoguanli";
private final String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Connection conn;
Statement stmt;
ResultSet rs;
Object data[][];
/** Creates a new instance of Data */
public Data() {
}

protected Object[][] sqlSelect(String sql){
try{
int x=0;
Class.forName(driver);
conn=DriverManager.getConnection(url,"sa","");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
rs.last();
x=rs.getRow();
//System.out.println(x);
data=new Object[x][2];
rs.first();
//System.out.println(rs.getRow());
for (int i=0;i<x;i++){
data[i][0]=rs.getString("id");
data[i][1]=rs.getString("ywy");
rs.next();
}
//System.out.println(rs.getString(1));
rs.close();
stmt.close();
conn.close();
return data;
}catch(Exception ex){
System.out.println(ex.getMessage());
return null;
}
}
}
这样就可以了.贴上来大家分享

[superryu]

rs=stmt.executeQuery("select count(*) as 行数 from htxxb");
rs.next();
int i = rs.getInt("行数");

understand?

[tomcatjava]

rs=stmt.executeQuery("select * from htxxb order by id");
while (rs.next()){
//for (int i=0;i<操作行数;i++){
data[i][0]=rs.getString("id");
data[i][1]=rs.getString("ywy");
//}
}
这样便可以遍历整个结果集了，rs.next()调用后会自动指向下一个结果的。

[lovelx]

楼上说的清楚。
如果想要得到结果集中的行数，可以这样做：

rs=stmt.executeQuery("select * from htxxb order by id");
rs.last();
rs.getRow();
while( rs.previous() )
{
// do something
}

[Alexxxxxx]

while(rs.next())本身已经是个条件循环，干吗还要for啊？
建议楼主去看看JAVA资源网：www.yultao.tk

[pipigo_wzj]

楼主是不是想在结果集中指定的要操作行数。
这样可以在FOR中给一个数值

[shareanway]

不清楚意图。

[langxiaofeng]

FOR中给一个数值???/
??