How can I print out an entire table from my database and its contents using Java and Hibernate?
My code thus far only prints one line of information that I need. It only prints the author:
package models;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import dao.HibernateDataDAO;
import hibernate.Books;
public class TestModel {
HibernateDataDAO data;
private SessionFactory sessionFactory;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public void test() {
System.out.println("Testing hibernate");
//This Books is just a test, in the real implementation it will be added by the user.
Books books = new Books();
books.setTitle("A Game of Thrones");
books.setAuthor("George RR Martin");
data.insertBooks(books);
Session session = sessionFactory.openSession();
session.beginTransaction();
books = (Books) session.get(hibernate.Books.class, 1);
System.out.println(books.getAuthor());
//int id = 3;
//We set this as 'increment' so that keys are set by database and not by users.
//data.deleteBooks(books, id);
}
public HibernateDataDAO getData() {
return data;
}
public void setData(HibernateDataDAO data) {
this.data = data;
}
}
My table is called books. and there are 3 columns in it: booksKey, title, and author. booksKey is an integer, title/author are strings. How can I print the entire table so that it prints out all the rows of information?
I tried modifying the above code and doing this, however, nothing printed:
Query query = session.createSQLQuery("select *from books");
List<Books> list = query.list();
for(Books test: list) {
System.out.println(test.getAuthor());
}
If someone can please help-preferably show me what code to add/fix, that would be awesome. I can't figure this out at all!
HibernateDataDAO:
package dao;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import hibernate.Books;
import hibernate.Music;
import hibernate.Contacts;
import hibernate.Movies;
//DAO = data access object.
public class HibernateDataDAO {
private SessionFactory sessionFactory;
private Transaction transaction;
public void insertBooks(Books books) {
Session session = sessionFactory.openSession();
try {
transaction = session.beginTransaction();
session.save(books);
transaction.commit();
}
catch (Exception e) {
if (transaction != null) transaction.rollback();
throw e;
}
finally {
session.close();
}
}
public void deleteBooks(Books books, int booksKey){
Session session = sessionFactory.openSession();
try{
transaction = session.beginTransaction();
Object persistentInstance = session.load(hibernate.Books.class, booksKey);
if (persistentInstance != null) {
session.delete(persistentInstance);
}
transaction.commit();
}catch(HibernateException e){
if(transaction!= null) transaction.rollback();
e.printStackTrace();
}
finally{
session.close();
}
}
public void insertMusic(Music music) {
Session session = sessionFactory.openSession();
try {
transaction = session.beginTransaction();
session.save(music);
transaction.commit();
}
catch (Exception e) {
if (transaction != null) transaction.rollback();
throw e;
}
finally {
session.close();
}
}
public void deleteMusic(Music music, int musicKey){
Session session = sessionFactory.openSession();
try{
transaction = session.beginTransaction();
Object persistentInstance = session.load(hibernate.Music.class, musicKey);
if (persistentInstance != null) {
session.delete(persistentInstance);
}
transaction.commit();
}catch(HibernateException e){
if(transaction!= null) transaction.rollback();
e.printStackTrace();
}
finally{
session.close();
}
}
public void insertMovies(Movies movies) {
Session session = sessionFactory.openSession();
try {
transaction = session.beginTransaction();
session.save(movies);
transaction.commit();
}
catch (Exception e) {
if (transaction != null) transaction.rollback();
throw e;
}
finally {
session.close();
}
}
public void deleteMovies(Movies movies, int movieKey){
Session session = sessionFactory.openSession();
try{
transaction = session.beginTransaction();
Object persistentInstance = session.load(hibernate.Movies.class, movieKey);
if (persistentInstance != null) {
session.delete(persistentInstance);
}
transaction.commit();
}catch(HibernateException e){
if(transaction!= null) transaction.rollback();
e.printStackTrace();
}
finally{
session.close();
}
}
public void insertContacts(Contacts contacts) {
Session session = sessionFactory.openSession();
try {
transaction = session.beginTransaction();
session.save(contacts);
transaction.commit();
}
catch (Exception e) {
if (transaction != null) transaction.rollback();
throw e;
}
finally {
session.close();
}
}
public void deleteContacts(Contacts contacts, int contactKey){
Session session = sessionFactory.openSession();
try{
transaction = session.beginTransaction();
Object persistentInstance = session.load(hibernate.Contacts.class, contactKey);
if (persistentInstance != null) {
session.delete(persistentInstance);
}
transaction.commit();
}catch(HibernateException e){
if(transaction!= null) transaction.rollback();
e.printStackTrace();
}
finally{
session.close();
}
}
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
}
