private void fillList() {
        Statement stmt = null;
        ResultSet rs = null;
        Connection conn = null;
        conn = Database.getConnection();
        try {
            stmt = conn.createStatement();
            String q = "select * from book";
            switch (select) {
                case "genre":
                    q = "select * from book where " + fltField + " = " + fltValue;
                    break;
                case "author":
                    q = "select * from book where author_id in "
                            + "(select id from author where "
                            + "locate(\"" + fltValue + "\"," + fltField +  ") <> 0)";
                    break;
                case "name":
                    q = "select * from book where "
                             + "locate(\"" + fltValue + "\"," + fltField +  ") <> 0";
                    break;
            }
            q = q + " order by " + fltOrderBy + " asc";
            System.out.println(q);
            rs = stmt.executeQuery(q);
            while (rs.next()) {
                list.add(new Book(rs.getString("id"), rs.getString("name"), rs.getBytes("image"), rs.getString("author_id"), rs.getString("genre_id")));
            }
        } catch (SQLException ex) {
            Logger.getLogger(BooksList.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
                if (rs != null) {
                    rs.close();
                }
                Database.close();
            } catch (SQLException ex) {
                Logger.getLogger(BooksList.class.getName()).log(Level.SEVERE, null, ex);
            }
        } // finally
    } // private void fillList()