Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void printFrage()
- {
- conn = getInstance();
- if(conn != null)
- {
- // Anfrage-Statement erzeugen.
- Statement query;
- try {
- query = conn.createStatement();
- // Ergebnistabelle erzeugen und abholen.
- String sql = "SELECT nr, frage, antwort1, antwort2, antwort3, antwort4, richtig FROM fragen"
- + " where nr like '1' ORDER BY nr asc";
- ResultSet result = query.executeQuery(sql);
- // Ergebnissätze durchfahren.
- while (result.next()) {
- int nr = result.getInt("nr");
- String frage = result.getString("frage"); // Alternativ: result.getString(1);
- String antwort1 = result.getString("antwort1");
- String antwort2 = result.getString("antwort2");
- String antwort3 = result.getString("antwort3");
- String antwort4 = result.getString("antwort4");
- int richtig = result.getInt("richtig"); // Alternativ: result.getString(2);
- String ausgabe = nr + frage + antwort1+ antwort2 + antwort3 + antwort4 +richtig;
- System.out.println(ausgabe);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment