public static int editBook(Book book) throws Exception { int intStat = 0; String sql = "UPDATE Books SET ISBN10 = ?, ISBN13 = ?, " + "Title = ?, Author = ?, Edition = ?, Publisher = ?, " + "Description = ?, YearPublish = ?, Copies = ? " + "WHERE ID = ?"; PreparedStatement ps = Connector.getConnection().prepareStatement(sql); ps.setString(1, book.getIsbn10()); ps.setString(2, book.getIsbn13()); ps.setString(3, book.getTitle()); ps.setString(4, book.getAuthor()); ps.setString(5, book.getEdition()); ps.setString(6, book.getPublisher()); ps.setString(7, book.getDescription()); ps.setInt(8, book.getYearPublish()); ps.setInt(9, book.getCopies()); ps.setInt(10, book.getBookId()); intStat = ps.executeUpdate(); Connector.close(); return intStat; }
public static int addBook(Book book) throws Exception { int intStat = 0; if (null != book.getIsbn10()) { book.setIsbn13(IsbnUtil.convert(book.getIsbn10())); } else { book.setIsbn10(IsbnUtil.convert(book.getIsbn13())); } String sql = "INSERT INTO Books (ISBN10, ISBN13, Title, Author, " + "Edition, Publisher, Description, YearPublish, " + "Copies) VALUES (?,?,?,?,?,?,?,?,?)"; PreparedStatement ps = Connector.getConnection().prepareStatement(sql); ps.setString(1, book.getIsbn10()); ps.setString(2, book.getIsbn13()); ps.setString(3, book.getTitle()); ps.setString(4, book.getAuthor()); ps.setString(5, book.getEdition()); ps.setString(6, book.getPublisher()); ps.setString(7, book.getDescription()); ps.setInt(8, book.getYearPublish()); ps.setInt(9, book.getCopies()); intStat = ps.executeUpdate(); Connector.close(); return intStat; }
public OwnedBook(Book book) { super( book.getId(), book.getGoodreadsId(), book.getAuthorName(), book.getGoodreadsAuthorId(), book.getName(), book.getIsbn(), book.getIsbn13(), book.getPublishedYear(), book.getDescription(), book.getPublisher(), book.getNumberOfPages(), book.getImageUrl()); setBookType(book.getBookType()); }
private void majListBook() { ListView bookList = (ListView) findViewById(R.id.bookList); List<Map<String, String>> l_books = new ArrayList<Map<String, String>>(); for (Book book : BookCollection.getBooks()) { Map<String, String> bookMap = new HashMap<String, String>(); bookMap.put("img", String.valueOf(book.getId_img())); // use available img bookMap.put("author", book.getAuthor()); bookMap.put("title", book.getTitle()); bookMap.put("gender", book.getGender()); bookMap.put("isbn", book.getIsbn()); bookMap.put("year", book.getYear()); bookMap.put("description", book.getDescription()); l_books.add(bookMap); } SimpleAdapter listAdapter = new SimpleAdapter( this.getBaseContext(), l_books, R.layout.book_detail, /*ajout gender*/ new String[] {"img", "author", "title", "gender", "isbn", "year", "description"}, new int[] { R.id.img_cover, R.id.author, R.id.title, R.id.gender, R.id.isbn, R.id.year, R.id.description }); bookList.setAdapter(listAdapter); bookList.setOnItemClickListener( new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { ActionBar actionBar = getSupportActionBar(); HashMap<String, String> map = (HashMap<String, String>) parent.getItemAtPosition(position); actionBar.setTitle(map.get("title")); lastItemClicked = position; System.out.println(position + " " + id); } }); }