AbstractBeliefs

Untitled

Dec 6th, 2012
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.75 KB | None | 0 0
  1.     public static void q9(ArrayList<NSS> all) throws Exception{
  2.         Connection conn = DriverManager.getConnection(
  3.                 // Napier blocks outside MySQL. Use:
  4.                 // ssh myname@myhost -L 10000:myhost:3306
  5.                 //"jdbc:mysql://myhost:3306/NSS",
  6.                 "jdbc:mysql://localhost:10000/NSS",
  7.                 "NSS", "mypass");
  8.         conn.setAutoCommit(true);
  9.         Statement stmt = conn.createStatement();
  10.        
  11.         ResultSet rs = stmt.executeQuery(
  12.                 "SELECT instituteName, numSample FROM responses "+
  13.                 "WHERE question=1 AND subject='(8) Computer Science' "+
  14.                 "ORDER BY numSample DESC LIMIT 5");
  15.         System.out.println("\n ===== Question 8 =====\n");
  16.         while (rs.next()){
  17.             System.out.println(rs.getString(1)+"\t"+rs.getInt(2));
  18.         }
  19.         rs.close();
  20.         stmt.close();
  21.         conn.close();
  22.     }
Advertisement
Add Comment
Please, Sign In to add comment