Advertisement
Guest User

Untitled

a guest
Oct 8th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.64 KB | None | 0 0
  1. try {
  2.       String myDriver = "org.gjt.mm.mysql.Driver";
  3.       String myUrl = "jdbc:mysql://localhost/test";
  4.       Class.forName(myDriver);
  5.       Connection conn = DriverManager.getConnection(myUrl, "root", "");
  6.      
  7.       String query = "SELECT * FROM highscore";
  8.       Statement st = conn.createStatement();
  9.       ResultSet rs = st.executeQuery(query);
  10.      
  11.       while (rs.next())
  12.       {
  13.         String name = rs.getString("name");
  14.         int numPoints = rs.getInt("points");
  15.        
  16.         System.out.println ("Score von Spieler " + name + " ist: " + numPoints);
  17.       }
  18.       st.close();
  19.     }
  20.     catch (Exception e)
  21.     {}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement