Versions Compared

Version Old Version 7 New Version 8
Changes made by

Christian K

Christian K

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Erstellen von eigenen Methoden im DAO welche beim Aufrufen eine Abfrage an die Datenbank schicken und das Ergebnis zurück liefern


  • Abfrage mit einem Nativen SQLaller Objekte einer Tabelle (natives SQL Statement)

    Code Block
    languagejava
    themeConfluence
    public List<Customer> getAllCustomerNativeSQL() 
{
	String SQL = "SELECT * FROM CUSTOMER";
	Query nativeQuery = em().createNativeQuery(SQL, Customer.class);
	List<Customer> resultList = nativeQuery.getResultList();
	
	return resultList;
}

  • Abfrage mit Parametern (natives SQL Statement)

    Code Block
    languagejava
    themeConfluence
    public List<Customer> getCustomersByFirstAndLastname(String lastname, String firstname) 
{
	String SQL = "SELECT * FROM CUSTOMER WHERE Lastname LIKE ? AND Firstname LIKE ?";

	Query nativeQuery = em().createNativeQuery(SQL, Customer.class);
	nativeQuery.setParameter(1, lastname);
	nativeQuery.setParameter(2, firstname);
	List<Customer> resultList = nativeQuery.getResultList();
		
	return resultList;
}

  • Abfrage eines einzelnen Objektes (natives SQL Statement)

    Code Block
    languagejava
    themeConfluence
    public Customer getCustomersByID(Integer ID) 
{
	String SQL = "SELECT * FROM CUSTOMER WHERE ID = ?";

	Query nativeQuery = em().createNativeQuery(SQL, Customer.class);
	nativeQuery.setParameter(1, ID);
	Customer singleResult = (Customer) nativeQuery.getSingleResult();

	return singleResult;
}