Advertisement
Guest User

Untitled

a guest
Dec 12th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. System.out.println("Agents in database:");
  2. ResultSet resultSet = connection.createStatement().executeQuery("SELECT * FROM Agent");
  3. while (resultSet.next()) {
  4. String idOutput = resultSet.getString("id");
  5. String nameOutput = resultSet.getString("name");
  6. System.out.println(idOutput + "\t" + nameOutput);
  7. }
  8. resultSet.close();
  9. System.out.println("Add one:");
  10. System.out.println("What id?");
  11. Scanner IdReader = new Scanner(System.in);
  12. String id = IdReader.next();
  13. System.out.println("What name?");
  14. Scanner nameReader = new Scanner(System.in);
  15. String name = nameReader.next();
  16. String query = "INSERT INTO Agent (id, name) VALUES ('" + id + "', '" + name + "')";
  17. connection.createStatement().execute(query);
  18. System.out.println("Agents in database:");
  19. ResultSet newResultSet = connection.createStatement().executeQuery("SELECT * FROM Agent");
  20. while (newResultSet.next()) {
  21. String idOutput = newResultSet.getString("id");
  22. String nameOutput = newResultSet.getString("name");
  23. System.out.println(idOutput + "\t" + nameOutput);
  24. }
  25. newResultSet.close();
  26. connection.close();
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement