Пример #1
0
 @Override
 public void delete(Author author) throws SQLException {
   String[] tmp = author.parseAuthor();
   String query =
       "DELETE FROM LIBRARY.AUTHORS WHERE NAME='" + tmp[0] + "' AND COUNTRY='" + tmp[1] + "';";
   PreparedStatement ps = con.prepareStatement(query);
   ps.executeUpdate();
 }
Пример #2
0
 @Override
 public void insert(Author author) throws SQLException {
   String query = "INSERT INTO LIBRARY.AUTHORS (NAME, COUNTRY) VALUES (?,?);";
   PreparedStatement ps = con.prepareStatement(query);
   ps.setString(1, author.parseAuthor()[0]);
   ps.setString(2, author.parseAuthor()[1]);
   ps.executeUpdate();
 }
Пример #3
0
  @Override
  public List<Author> get(String field) throws SQLException {
    String query =
        "SELECT * FROM LIBRARY.AUTHORS WHERE ID='%"
            + field
            + "%' OR NAME LIKE '%"
            + field
            + "%' OR COUNTRY LIKE '%"
            + field
            + "%';";
    PreparedStatement ps = con.prepareStatement(query);
    ResultSet resSet = ps.executeQuery();
    List<Author> authors = new LinkedList<>();

    while (resSet.next()) {
      Author author = new Author();
      authors.add(author.parseAuthor(resSet));
    }

    return authors;
  }