TestClienti1Week10

import java.util.ArrayList;
import java.util.List;

import javax.persistence.*;

public class TestClienti1 {

    public static void main(String[] args) {
        // TODO Auto-generated method stub

        List<Client> clienti = new ArrayList<>();
        clienti.add(new Client(101, "Alfa SRL"));
        clienti.add(new Client(102, "Beta SRL"));
        clienti.add(new Client(103, "Gamma SRL"));
        clienti.add(new Client(104, "Delta SRL"));

        EntityManagerFactory emf = Persistence.createEntityManagerFactory("ProduseJPA");
        EntityManager em = emf.createEntityManager();

        em.getTransaction().begin();
        em.persist(clienti.get(0));
        em.persist(clienti.get(1));
        em.persist(clienti.get(2));
        em.persist(clienti.get(3));
        em.getTransaction().commit();

        //Read after create
        List<Client> clientiList = em.createQuery("SELECT c FROM Client c").getResultList();
        System.out.println("Lista clientilor persistenti / salvati in BD: -------------");
        for(Client c : clientiList) {
            System.out.println("Id: " + c.getId() + ", nume: " + c.getNume());
        }

        //Read - Update
        em.getTransaction().begin();

        Client c102 = em.find(Client.class, 101);
        if(c102 != null) {
            c102.setNume("Teta SRL");
            em.persist(c102);
        }

        //Read - Remove
        Client c103 = (Client) em.createQuery("SELECT c FROM Client c WHERE c.id=103").getSingleResult();
        if(c103 != null) {
            em.remove(c103);
        }

        //Realizare tranzactie  - sincronizare cu BD
        em.getTransaction().commit();

        clientiList = em.createQuery("SELECT c FROM Client c").getResultList();
        System.out.println("Lista finala clienti persistenti / salvati in BD: ---------");
        for(Client c : clientiList) {
            System.out.println("Id: " + c.getId() + ", nume: " + c.getNume());
        }
    }
}