＋设为首页 ＋添加到收藏夹
必须用这种方法
ResultSet rs=db.executeQuery("select count(*) as num from e_member");
在jsp中如何得到这个num值呢,我试了好几种方法都没有成功？
向大家求教
我用这种方法是不行的
Object i=rs.getObject("num");
String i=rs.getString("num");
int i=rs.getInt("num");
public static int getCount(String tablename) throws SQLException {
java.sql.Connection conn = null;
OpenDbBean db = new OpenDbBean();
java.sql.ResultSet rs = null;
java.sql.Statement ps = null;
int count = 0;
try {
conn = db.getConnection();
ps = conn.createStatement();
rs = ps.executeQuery(
"select count(*) num from "+tablename);
if (rs.next()) {
count = rs.getInt(1);
}
}
catch (java.sql.SQLException e) {
System.out.println(e.getMessage());
}
finally {
db.CleanConnection(conn, ps, rs);
}
return count;
}
