今天java课的内容是:已知在一篇帖子中有一名水王,帖子数量超过一半以上即为水王,现写一段程序找出水王
package Week14; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import com.DBUtil.*; public class Tiezi { static DBUtil DBUtil =new DBUtil(); public static void main(String[] args) { shuiwang(); } public static void shuiwang() { String sql = "select nameid,count(*) AS num from tiezi GROUP BY nameid ORDER BY num DESC"; Connection conn = DBUtil.getConn(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String nameid=rs.getString("nameid"); String num=rs.getString("num"); System .out.println(nameid+" "+num); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } } }