select count(*) from user_tab_columns where table_name=upper('navigate') 请问操作数据库的时候用这个得到的INT类型数据,是如何打印啊! 只会一般的操作ResultSet,如果是这样的查询语句应该怎么写!JAVA代码啊!跪求高手解答!
方法1: select count(*) as countRow from user_tab_columns where table_name=upper('navigate') ResultSet rs = ... rs.getInt("countRow ");方法2: rs.getInt(1);
select count(*) from user_tab_columns where table_name=upper('navigate')这句话返回的是表中数据的条数,他不会返回结果集,是返回一个整型数字,
String sql = "select count(*) as countRow from user_tab_columns where table_name=upper('navigate')"; ResultSet rs = stml.executeQuery(sql); rs.next(); int count = rs.getInt(1);希望能帮到你
select count(*) as countRow from user_tab_columns where table_name=upper('navigate')
ResultSet rs = ...
rs.getInt("countRow ");方法2:
rs.getInt(1);
ResultSet rs = stml.executeQuery(sql);
rs.next();
int count = rs.getInt(1);希望能帮到你
rs.getInt(1);
}
其中一表示的是输出的参数的位置,下标从一开始