Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void q9(ArrayList<NSS> all) throws Exception{
- Connection conn = DriverManager.getConnection(
- // Napier blocks outside MySQL. Use:
- // ssh myname@myhost -L 10000:myhost:3306
- //"jdbc:mysql://myhost:3306/NSS",
- "jdbc:mysql://localhost:10000/NSS",
- "NSS", "mypass");
- conn.setAutoCommit(true);
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery(
- "SELECT instituteName, numSample FROM responses "+
- "WHERE question=1 AND subject='(8) Computer Science' "+
- "ORDER BY numSample DESC LIMIT 5");
- System.out.println("\n ===== Question 8 =====\n");
- while (rs.next()){
- System.out.println(rs.getString(1)+"\t"+rs.getInt(2));
- }
- rs.close();
- stmt.close();
- conn.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment