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()调用后会自动指向下一个结果的。
while (rs.next()){
//for (int i=0;i<操作行数;i++){
data[i][0]=rs.getString("id");
data[i][1]=rs.getString("ywy");
//}
}
这样便可以遍历整个结果集了,rs.next()调用后会自动指向下一个结果的。
如果想要得到结果集中的行数,可以这样做:rs=stmt.executeQuery("select * from htxxb order by id");
rs.last();
rs.getRow();
while( rs.previous() )
{
// do something
}
建议楼主去看看JAVA资源网:www.yultao.tk
这样可以在FOR中给一个数值
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;
}
}
}
这样就可以了.贴上来大家分享
rs.next();
int i = rs.getInt("行数");understand?