/**
* Import books
*
* @param nodes
* @return
*/
private Boolean processBooks(NodeList nodes) {
NodeList books = nodes.item(0).getChildNodes();
for (int i = 0; i < books.getLength(); i++) {
if (books.item(i).getNodeType() == Node.ELEMENT_NODE) {
Element bookNode = (Element) books.item(i);
Book book = new Book();
book.setIdbook(Integer.parseInt(getTagValue("idbook", bookNode)));
book.setCode(getTagValue("code", bookNode));
book.setEdition(Integer.parseInt(getTagValue("edition", bookNode)));
book.setPages(Integer.parseInt(getTagValue("pages", bookNode)));
book.setPlace(getTagValue("place", bookNode));
book.setYear(DatatypeConverter.parseDateTime(getTagValue("year", bookNode)).getTime());
book.setType(getTagValue("type", bookNode));
book.setName(getTagValue("name", bookNode));
// find and set publisher
Publisher publisher =
publisherMgr.findByIdpublisher(Integer.parseInt(getTagValue("publisher", bookNode)));
if (publisher == null) {
continue;
}
book.setPublisher(publisher);
// find and set genre
Genre genre = genreMgr.findByIdgenre(Integer.parseInt(getTagValue("genre", bookNode)));
if (genre == null) {
continue;
}
book.setGenre(genre);
// setup book authors
List<String> authors = getTagsValues("authorCollection", bookNode);
if (book.getAuthorCollection() == null) {
book.setAuthorCollection(new ArrayList<Author>());
}
for (String authorId : authors) {
Author author = authorMgr.findByIdauthor(Integer.parseInt(authorId));
if (author != null) {
// book.getAuthorCollection().add(author);
author.getBooksCollection().add(book);
authorMgr.save(author);
}
}
try {
bookMgr.save(book);
} catch (EJBException ex) {
ex.printStackTrace(System.out);
}
}
}
return true;
}
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment; filename=export.xml");
PrintWriter out = response.getWriter();
try {
DatabaseWrapper db = new DatabaseWrapper();
// fill database wrapper with data
db.setUsers(userMgr.findAll());
db.setBooks(bookMgr.findAll());
db.setAuthors(authorMgr.findAll());
db.setBookings(bookingMgr.findAll());
db.setBorrows(borrowMgr.findAll());
db.setExemplars(exemplarMgr.findAll());
db.setGenres(genreMgr.findAll());
db.setPublishers(publisherMgr.findAll());
// Step 2 - convert to xml
JAXBContext jaxbContext = JAXBContext.newInstance(DatabaseWrapper.class);
Marshaller marshaller = jaxbContext.createMarshaller();
marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
marshaller.marshal(db, out);
} catch (Exception ex) {
ex.printStackTrace(out);
} finally {
out.close();
}
}
/**
* File upload listener
*
* @param event
* @throws Exception
*/
public void listener(FileUploadEvent event) throws Exception {
UploadedFile file = event.getUploadedFile();
try {
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
Document doc = dBuilder.parse(file.getInputStream());
doc.getDocumentElement().normalize();
processUsers(doc.getElementsByTagName("users"));
processAuthors(doc.getElementsByTagName("authors"));
processPublishers(doc.getElementsByTagName("publishers"));
processGenres(doc.getElementsByTagName("genres"));
processBooks(doc.getElementsByTagName("books"));
processExemplars(doc.getElementsByTagName("exemplars"));
processBookings(doc.getElementsByTagName("bookings"));
processBorrows(doc.getElementsByTagName("borrows"));
userMgr.flush();
bookMgr.flush();
authorMgr.flush();
bookingMgr.flush();
exemplarMgr.flush();
genreMgr.flush();
publisherMgr.flush();
borrowMgr.flush();
userMgr.clear();
bookMgr.clear();
authorMgr.clear();
bookingMgr.clear();
exemplarMgr.clear();
genreMgr.clear();
publisherMgr.clear();
borrowMgr.clear();
} catch (Exception e) {
FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Import se nezdařil."));
e.printStackTrace(System.out);
return;
}
FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Import proběhl úspěšně."));
}
/**
* Import authors
*
* @param nodes
* @return
*/
private Boolean processAuthors(NodeList nodes) {
NodeList authors = nodes.item(0).getChildNodes();
for (int i = 0; i < authors.getLength(); i++) {
if (authors.item(i).getNodeType() == Node.ELEMENT_NODE) {
Element authorNode = (Element) authors.item(i);
Author author = new Author();
author.setIdauthor(Integer.parseInt(getTagValue("idauthor", authorNode)));
author.setName(getTagValue("name", authorNode));
try {
authorMgr.save(author);
} catch (EJBException ex) {
ex.printStackTrace(System.out);
}
}
}
return true;
}