Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- System.out.println("Agents in database:");
- ResultSet resultSet = connection.createStatement().executeQuery("SELECT * FROM Agent");
- while (resultSet.next()) {
- String idOutput = resultSet.getString("id");
- String nameOutput = resultSet.getString("name");
- System.out.println(idOutput + "\t" + nameOutput);
- }
- resultSet.close();
- System.out.println("Add one:");
- System.out.println("What id?");
- Scanner IdReader = new Scanner(System.in);
- String id = IdReader.next();
- System.out.println("What name?");
- Scanner nameReader = new Scanner(System.in);
- String name = nameReader.next();
- String query = "INSERT INTO Agent (id, name) VALUES ('" + id + "', '" + name + "')";
- connection.createStatement().execute(query);
- System.out.println("Agents in database:");
- ResultSet newResultSet = connection.createStatement().executeQuery("SELECT * FROM Agent");
- while (newResultSet.next()) {
- String idOutput = newResultSet.getString("id");
- String nameOutput = newResultSet.getString("name");
- System.out.println(idOutput + "\t" + nameOutput);
- }
- newResultSet.close();
- connection.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement