这个地方resultset下面怎么总没找到这行啊

[TOO_SIMPLE]

conn = DBManager.getConn();
		String sql = "select count(*) from wm_mail where classify='fa'";
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		a = rs.getInt(1);
		System.out.println(a);

得到的结果总是出现：ResultSet 没有当前行。
数据库查的时候有啊

[Spring89]

rs.getInt(1)写列名呢？不写索引

[_jerrytiger]

打印ResultSet看看是否为空。

[MounteBank]

count(*)返回的结果是记录条数，不是记录吧，你还是 String sql = "select * from wm_mail where classify='fa'"; 或者用 String sql = "select columnName from wm_mail where classify='fa'";

[淡定的峰哥]

少了一个红色的部分
conn = DBManager.getConn();
String sql = "select count(*) from wm_mail where classify='fa'";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
rs.next();
a = rs.getInt(1);
System.out.println(a);

[GIS__]

代码应该没问题，LZ你debug看看rs里面是什么

[wangjiangbo2]

4楼说的对，少个rs.next().

int a=0;
if(rs.next()){
   a = rs.getInt(1);
}