public static List<Book> searchBook(String key) {
String sql = "exec searchBook '" + key + "'";
Result result = DBHelper.execSql(sql);
SortedMap[] rows = result.getRows();
List<Book> books = new ArrayList<Book>();
for (SortedMap row : rows) {
Book book = new Book();
book.setId(Integer.parseInt(row.get("id").toString().trim()));
book.setName(row.get("name").toString().trim());
book.setISBN(row.get("ISBN").toString().trim());
book.setAuthor(row.get("author").toString().trim());
book.setDescription(row.get("description").toString().trim());
book.setPublishDate(row.get("publishDate").toString().trim());
book.setQuantity(Integer.parseInt(row.get("quantity").toString().trim()));
System.out.println(book);
books.add(book);
}
return books;
}
