@Override
public List extractData(ResultSet rs) throws Exception {
List<Genre> genre = new ArrayList<Genre>();
while (rs.next()) {
Genre a = new Genre();
a.setGenreId(rs.getInt("genre_id"));
a.setGenreName(rs.getString("genre_name"));
genre.add(a);
}
return genre;
}
private void Addgenre() throws Exception {
boolean exit_Add = false;
String name;
Map<Integer, String> m = as.listGenre2();
do {
System.out.println("Enter the Genre Name:");
name = sc.nextLine();
if (!m.containsValue(name)) {
Genre g = new Genre();
g.setGenreName(name);
try {
as.createGenre(g);
System.out.println("Added successfully");
System.out.println("---------------------------------------------");
exit_Add = true;
} catch (Exception e) {
System.out.println(e.getMessage());
}
} else {
System.out.println("This Genre already exists.");
}
if (!exit_Add) {
System.out.println();
System.out.println();
System.out.println("Press ' q ' to return or any other key to continue");
String option = (sc.nextLine());
if (option.length() > 0) {
switch (option.charAt(0)) {
case 'q':
exit_Add = true;
break;
default:
exit_Add = false;
break;
}
}
}
} while (!exit_Add);
}
private void Updategenre2(int id) throws SQLException {
boolean exit_Add = false;
Map<Integer, String> m = as.listGenre2();
String name;
do {
System.out.println();
System.out.println("Enter the new Genre Name:");
name = sc.nextLine();
if (!m.containsKey(name)) {
Genre g = new Genre();
g.setGenreId(id);
g.setGenreName(name);
try {
as.updateGenre(g);
System.out.println("Update successful");
exit_Add = true;
} catch (Exception e) {
System.out.println(e.getMessage());
}
} else {
System.out.println("Update successful");
}
if (!exit_Add) {
System.out.println();
System.out.println();
System.out.println("Press ' q ' to return or any other key to continue");
String option = (sc.nextLine());
if (option.length() > 0) {
switch (option.charAt(0)) {
case 'q':
exit_Add = true;
break;
default:
exit_Add = false;
break;
}
}
}
} while (!exit_Add);
}
@Override
public List extractData(ResultSet rs) throws Exception {
List<Genre> genres = new ArrayList<Genre>();
BookDAO bdao = new BookDAO(getConnection());
while (rs.next()) {
Genre g = new Genre();
g.setGenreId(rs.getInt("genre_id"));
g.setGenreName(rs.getString("genre_name"));
@SuppressWarnings("unchecked")
List<Book> books =
(List<Book>)
bdao.readFirstLevel(
"select * from tbl_book where bookId In"
+ "(select bookId from tbl_book_genres where genreId=?)",
new Object[] {rs.getInt("genreId")});
genres.add(g);
}
return genres;
}
