求一条sql语句 求STUDENT表中的记录数,并将结果赋值给整型变量N!请问在java中这个功能如何用SQL实现? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select count(1) from student;java里面用resultset循环取一条就可以了resultSet.getInt(1) 用JDBC,lZ去看看int n;Connection conn = DriverManager.getConnection("DBURL", "USERNAME", "PASSWORD");String sql = "select count(*) from STUDENT";Statement stmt = conn.createStatement();ResultSet rs = stmt.executeUpdate(sql);while(rs.next()) { n = rs.getInt(1);}return n;还有释放资源的部分自己看去 执行select count(*) from student;int n = resultSet.getInt(1); SELECT COUNT(*) FROM STUDENTResultSet 对象方法 int n; Connection conn = DriverManager.getConnection("DBURL", "USERNAME", "PASSWORD"); String sql = "select count(*) from STUDENT"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeUpdate(sql); while(rs.next()) { n = rs.getInt(1); } return n; select ct count(*) from student java 能截整个网页吗? 使用Java CommAPI读取不到数据【急】 小小的作业算法问题给出答案者立刻结贴给100分!---速度在线等待 请问大家 学习Java最重要的是什么 Java哪些技术在工作中比较常用? Defaut Modifier和protected modifer 是否相同? applet访问磁盘文件的问题 难道高手区里的人就是高手? 关于键盘事件 Exception in thread "main" java.lang.NoClassDefFoundError:是怎么会事? java实现域名解析遇到的问题 我莔了,关于回文字符串
resultSet.getInt(1)
Connection conn = DriverManager.getConnection("DBURL", "USERNAME", "PASSWORD");
String sql = "select count(*) from STUDENT";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeUpdate(sql);
while(rs.next()) {
n = rs.getInt(1);
}
return n;
还有释放资源的部分自己看去
ResultSet 对象方法
Connection conn = DriverManager.getConnection("DBURL", "USERNAME", "PASSWORD");
String sql = "select count(*) from STUDENT";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeUpdate(sql);
while(rs.next()) {
n = rs.getInt(1);
}
return n;