Examples of Obiect

Examples of nom.Obiect

184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
  }

  public static List<CatalogBean> listareCatalog(String obiect) {
    List<Catalog> c = new ArrayList<Catalog>();
    List<CatalogBean> catalog = new ArrayList<CatalogBean>();
    Obiect ol = new Obiect();

    EntityManagerFactory emf = Persistence
        .createEntityManagerFactory("modul3L2");
    em = emf.createEntityManager();
    em.getTransaction().begin();
    Query query = em
        .createQuery("SELECT o FROM Obiect o WHERE o.nume=:v1 ")
        .setParameter("v1", obiect);

    ol = (Obiect) query.getSingleResult();

    if (!ol.equals(null)) {
      c = ol.getCatalog();

    }
    SimpleDateFormat formatDate = new SimpleDateFormat("dd/MM/YYYY");
    int i = 0;
    for (Catalog cInd : c) {
View Full Code Here

Examples of nom.Obiect

219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
    em.close();
    return catalog;
  }

  public static void aplliedAction(List<CatalogBean> modificari) {
    Obiect ol = new Obiect();
    Student st=new Student();
    List<Catalog>removals=new ArrayList<Catalog>();
    int idStudent=-1;
    int idObiect=-1;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("modul3L2");
    em = emf.createEntityManager();
    em.getTransaction().begin();
    idObiect=modificari.get(0).getC().getIdObiect();
    idStudent=modificari.get(0).getC().getIdStudent();
   
    Query query = em
        .createQuery("SELECT o FROM Obiect o WHERE o.idObiect=:v1 ")
        .setParameter("v1", idObiect);

    ol = (Obiect) query.getSingleResult();
    query = em
        .createQuery("SELECT s FROM Student s WHERE s.idStudent=:v1 ")
        .setParameter("v1", idStudent);
    st=(Student)query.getSingleResult();
   
   
    if (!ol.equals(null)) {
     ol.setCatalog(new ArrayList<Catalog>());
    }
    if(!st.equals(null)){
      st.setCatalog(new ArrayList<Catalog>());
    }
    for(CatalogBean cInd:modificari){
      if((cInd.getC().getIdObiect()==0)&&(cInd.getC().getIdStudent()==0)){
        cInd.getC().setIdObiect(idObiect);
        cInd.getC().setIdStudent(idStudent);
      }
      ol.getCatalog().add(cInd.getC());
      st.getCatalog().add(cInd.getC());
    }   
    em.merge(ol);
    em.merge(st);
     em.createNativeQuery(
View Full Code Here

Examples of nom.Obiect

86
87
88
89
90
91
92
93
94
95
96
97
98
99
      p.setNume(numeProfesor+i);
      p.setPrenume(prenumeProfesor+i);
      p.setSitePersonal("site");
     
      for(int j=0;j<2;j++){
        Obiect o=new Obiect();
        o.setNume("obiect"+j);
        o.setIdEvaluare(j);
        o.setCredite(j+1);
        p.getObiecte().add(o);
       
      }
     
      em.persist(p);
View Full Code Here

Examples of org.jpa.Obiect

61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
        int credite=5;
        int idProfesor=1;
        String nume="ObiectTest";
        List<String> prezenta=new ArrayList<String>();
        String tipEvaluare="EvaluareTest";
        Obiect o = new Obiect();
        Obiect o1 = new Obiect();
        o.setCredite(credite);
        o.setIdProfesor(idProfesor);
        o.setNume(nume);
        o.setPrezenta(prezenta);
        o1.setCredite(credite-1);
        o1.setNume(nume+"1");
        o1.setPrezenta(prezenta);
        o1.setIdProfesor(idProfesor+1);
        List<Obiect> obev=new ArrayList<Obiect>();
        obev.add(o1);
        obev.add(o);
        Evaluare ev=new Evaluare();
        ev.setTipEvaluare(tipEvaluare);
        ev.setObiect(obev);
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();
        em.persist(ev);
        em.getTransaction().commit();  
        List<Obiect> ob=(List<Obiect>)em.createQuery("select o from Obiect o").getResultList();
        assertEquals("Nu au fost persistate obiectele",ob.size(),2);
        List gt = em.createNativeQuery("SELECT *  FROM evaluare_obiect").getResultList();
         Iterator itr = gt.iterator();
         while (itr.hasNext()) {
             Object[] obj = (Object[]) itr.next();
            
             String value2 =String.valueOf(obj[1]);
             Obiect oT=new Obiect();
             oT=em.find(Obiect.class, Integer.valueOf(value2));
             assertTrue("Nu a fost gasit macar un obiect",oT.getNume().equals(nume)||oT.getNume().equals(nume+"1"));
            
         }
        em.close();
    }
View Full Code Here

Examples of org.jpa.Obiect

32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
   
    int credite=5;
        int idProfesor=1;
        String nume="ObiectTest";
        List<String> prezenta=new ArrayList<String>();
        Obiect o = new Obiect();
        EntityManager em = emf.createEntityManager();
        o.setCredite(credite);
        o.setIdProfesor(idProfesor);
        o.setNume(nume);
        o.setPrezenta(prezenta);
        em.getTransaction().begin();
        em.persist(o);
        em.getTransaction().commit();
        Obiect o1 = new Obiect();
        o1=(Obiect)em.createQuery("Select o from Obiect o").getSingleResult();
        assertEquals("Nu a fost persistat obiectul",o1.getIdObiect(),o.getIdObiect());
        em.getTransaction().begin();
        o1.setNume(nume+"Update");
       
        o=(Obiect)em.createQuery("Select o from Obiect o").getSingleResult();
        assertTrue("Nu a fost updatat obiectul",o.getNume().equals(nume+"Update"));
       
        int deletedData=em.createQuery("delete from Obiect o").executeUpdate();
View Full Code Here

Examples of org.jpa.Obiect

70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
          String numeProfesor="NumeTest";
          String prenumeProfesor="PrenumeTest";
          String email="EmailTest";
          String site="SiteTest";
          EntityManager em = emf.createEntityManager();
          Obiect o = new Obiect();
          Obiect o1 = new Obiect();
          Profesor p=new Profesor();
          Profesor p1=new Profesor();
         
          o.setCredite(credite);
          o.setIdProfesor(idProfesor);
          o.setNume(nume);
          o.setPrezenta(prezenta);
          o1.setCredite(credite-1);
          o1.setNume(nume+"1");
          o1.setPrezenta(prezenta);
         
          List<Obiect> obev=new ArrayList<Obiect>();
          obev.add(o1);
          obev.add(o);
          p.setEmail(email);
          p.setNume(numeProfesor);
          p.setPrenume(prenumeProfesor);
          p.setSitePersonal(site);
          p.setObiecte(obev);
          em.getTransaction().begin();
          em.persist(p);
          em.getTransaction().commit();
          List<Obiect> ob=em.createQuery("Select o from Orar o").getResultList();
          for(Obiect oind:ob){
            assertTrue((oind.getNume().equals(o1.getNume())||oind.getNume().equals(o.getNume()))&&ob.size()==2);
          }
          em.getTransaction().begin();
          em.createQuery("Delete from Profesor p").executeUpdate();
          em.getTransaction().commit();
          p1.setEmail(email);
          p1.setNume(numeProfesor);
          p1.setPrenume(prenumeProfesor);
          p1.setSitePersonal(site);
          o1.setProf(p1);
          o.setProf(p1);
          em.getTransaction().begin();
          em.persist(p1);
          em.persist(o1);
          em.persist(o);
          em.getTransaction().commit();
         
          List<String>  obn =(List<String>) em.createNativeQuery("SELECT obiect.nume FROM Obiect,Profesor where obiect.prof_ID_PROFESOR=profesor.ID_PROFESOR")
              .getResultList();
          for(String oind:obn){
            assertTrue((oind.equals(o1.getNume())||oind.equals(o.getNume()))&&obn.size()==2);
          }
          em.close();
         
  }
View Full Code Here

Examples of org.jpa.Obiect

102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
    int nota=8;
    int nrPrezente=7;
     EntityManager em = emf.createEntityManager();
     Catalog c=new Catalog();
   
     Obiect o=new Obiect();
    
     c.setDataNotei(data);
     c.setIdObiect(idObiectTest);
     c.setIdStudent(idStudentTest);
     c.setNota(nota);
     c.setNrPrezente(nrPrezente);
     List<Catalog> c_o=new ArrayList<Catalog>();
     c_o.add(c);
     o.setCatalog(c_o);
       em.getTransaction().begin();
       em.persist(o);
       em.getTransaction().commit();
       int dataTest=(int) em.createNativeQuery("select catalog.id_obiect from catalog, obiect where catalog.catalog_id_obiect=obiect.id_obiect").getSingleResult();
       assertEquals(dataTest,1);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.