Guest User

Untitled

a guest
Jun 9th, 2013
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.23 KB | None | 0 0
  1. public static void  printFrage()
  2.   {
  3.   conn = getInstance();
  4.  
  5.     if(conn != null)
  6.     {
  7.       // Anfrage-Statement erzeugen.
  8.       Statement query;
  9.       try {
  10.         query = conn.createStatement();
  11.  
  12.         // Ergebnistabelle erzeugen und abholen.
  13.         String sql = "SELECT nr, frage, antwort1, antwort2, antwort3, antwort4, richtig FROM fragen"
  14.             + " where nr like '1'   ORDER BY nr asc";
  15.         ResultSet result = query.executeQuery(sql);
  16.  
  17.         // Ergebnissätze durchfahren.
  18.         while (result.next()) {
  19.           int nr = result.getInt("nr");
  20.           String frage = result.getString("frage");         // Alternativ: result.getString(1);
  21.           String antwort1 = result.getString("antwort1");
  22.           String antwort2 = result.getString("antwort2");
  23.           String antwort3 = result.getString("antwort3");
  24.           String antwort4 = result.getString("antwort4");
  25.           int richtig = result.getInt("richtig");                     // Alternativ: result.getString(2);
  26.           String ausgabe = nr + frage + antwort1+ antwort2 + antwort3 + antwort4 +richtig;
  27.           System.out.println(ausgabe);
  28.         }
  29.       } catch (SQLException e) {
  30.         e.printStackTrace();
  31.       }
  32.     }
  33.   }
Advertisement
Add Comment
Please, Sign In to add comment