有没有方法是统计ResultSet结果集内记录个数的? int i=0;while(rs.next()){i++;}...<%=i%> 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 rs.last();int count=rs.getRow(); 没有直接的方法?类似rs.getrow() ResultSet rs=.........rs.last();int sum=rs.getRow(); select count(*) from tb where ....or int sum=rs.getRow(); public int getsqlnum(String sql) { int i = 0; //Vector v = new Vector(); ResultSet rs1 = null; try { sql = sql.trim(); if (myconn !=null) myconn.close(); myconn = DriverManager.getConnection(sConnStr, UseName, PassWord); Statement statement = myconn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs1 = statement.executeQuery(sql); rs1.last(); i = rs1.getRow(); //while(rs1.next()) //{ i++; } rs1.close(); rs1 = null; myconn.close(); myconn = null; } catch(Exception e) { System.out.print("getsqlnum error" +e.getMessage()); //rs1 = null; //return 0; } return i; } select count(*) from tablename 我是这样写的!就一二句搞定的!不知前头有人这样写了没!??呵呵~rs2=sqlStmt.executeQuery(sql2); if(rs2.next()) { int n=rs2.getRow(); don就是记录个数了! 除非數據庫提供特別優化,否則,一般使用:select count(1) from tablename where .... int i=0;while(rs.next()){i++;}...<%=i%> 同意Leemaasn(呆鸟一号)的方法! 用select count(*) from tablename方法得到的只是一个值吗? 用select count(*) as count from tablename加上 as count可以用getString("count")得到不然得用getString(1)获取 to:batt这样写对不对?String sql="select count(*) as count from table";......ps = con.prepareStatement(sql);rs = ps.executeQuery();String sum=rs.getString("count"); 这样写才对!!String sql="select count(*) as count from table";ps = con.prepareStatement();rs = ps.executeQuery(sql);String sum=rs.getString("count"); TO Leemaasn(呆鸟一号) :还是老哥厉害呵呵~~ String sum=rs.getString("count");int sum=rs.getInt("count");道理一样吧,只是类型不一样罢了 为什么我的jsp每次用tomcat运行后都不能加到webapps里面 jsp3级联动,后2个下拉框无法从数据库获得值,第一个下拉框可以从数据库读出 中文乱码问题? 如何通过jsessionid找到session 怎么样自定义log4j信息格式和内容? [急啊!100分!][up有分!]tomcat在局域网无法访问的问题 大家好,我是新手学web tomcat配置问题 请帮忙看看 谢谢拉 帮我看一下,这是什么错误? 急~~~~~~~无法及时显示修改后的servlet A question 请教!!!!!!! tomcat下 inputStream 问题
int count=rs.getRow();
类似rs.getrow()
rs.last();
int sum=rs.getRow();
or
int sum=rs.getRow();
{
int i = 0;
//Vector v = new Vector();
ResultSet rs1 = null;
try
{
sql = sql.trim();
if (myconn !=null)
myconn.close();
myconn = DriverManager.getConnection(sConnStr, UseName, PassWord);
Statement statement = myconn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs1 = statement.executeQuery(sql);
rs1.last();
i = rs1.getRow();
//while(rs1.next())
//{ i++; }
rs1.close();
rs1 = null;
myconn.close();
myconn = null;
}
catch(Exception e)
{
System.out.print("getsqlnum error" +e.getMessage());
//rs1 = null;
//return 0;
}
return i;
}
if(rs2.next())
{
int n=rs2.getRow();
do
n就是记录个数了!
否則,一般使用:
select count(1) from tablename where ....
while(rs.next())
{
i++;
}
...
<%=i%>
方法得到的只是一个值吗?
加上 as count可以用getString("count")得到不然得用getString(1)获取
这样写对不对?
String sql="select count(*) as count from table";
......
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
String sum=rs.getString("count");
ps = con.prepareStatement();
rs = ps.executeQuery(sql);
String sum=rs.getString("count");