API tools faq
paste
Advertisement
Zizalik

Untitled

Zizalik
May 20th, 2018
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.06 KB | None | 0 0
raw download clone embed print report
  1. package jpa;
  2.  
  3. import java.util.ArrayList;
  4. import java.util.Calendar;
  5. import java.util.GregorianCalendar;
  6. import java.util.List;
  7. import java.util.Scanner;
  8. import javax.persistence.EntityManager;
  9. import javax.persistence.EntityManagerFactory;
  10. import javax.persistence.Persistence;
  11. import javax.persistence.Query;
  12. import javax.persistence.TypedQuery;
  13. import static jpa.MainApp.sc1;
  14. import jpa.entity.Group;
  15. import jpa.entity.Language;
  16. import jpa.entity.Student;
  17.  
  18. public class MainApp {
  19.  
  20. private static final String PERSISTENCE_UNIT_NAME = "JavaExampleDBPU";
  21. private static EntityManagerFactory factory;
  22. public static Group gr = new Group();
  23. public static Group gr2 = new Group();
  24. public static EntityManager em;
  25. public static Student student1 = new Student("Ivanov", "Ivan", gr, Language.RUSSIAN,1);
  26. public static Student student2 = new Student("Petrova", "Anna", gr, Language.ESTONIAN,2);
  27. public static Student student3 = new Student("Larissa", "Joonas", gr2, Language.RUSSIAN,3);
  28. public static Student student4 = new Student("Winston", "Charles", gr2, Language.ENGLISH,4);
  29. // public static List<Student> students = new ArrayList();
  30. // public static List<Student> students2 = new ArrayList();
  31. public static List<Group> list = new ArrayList();
  32. public static List<Group> list2 = new ArrayList();
  33. public static Scanner sc=new Scanner(System.in);
  34. public static Scanner sc1=new Scanner(System.in);
  35.  
  36.  
  37. public static void main(String[] args) {
  38. factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
  39. EntityManager em = factory.createEntityManager();
  40.  
  41. System.out.println("Meie menuu");
  42. System.out.println("Valige menuust vastav soov mida tahate teha");
  43. System.out.println("1.Kogu listi printimine ekraanile");
  44. System.out.println("2.Info otsimine ID j2rgi");
  45. System.out.println("3.Uute andmete lisamine");
  46. System.out.println("4.Andmete muutmine");
  47. System.out.println("5.Andmete kustutamine");
  48. int menuu=0;
  49. menuu=sc.nextInt();
  50. switch(menuu){
  51. case 1:
  52.  
  53. em.getTransaction().begin();
  54. gr = new Group();
  55. gr.setCode("RDIR");
  56. gr.setName("Applied Information Technology");
  57. em.persist(gr);
  58. student1 = new Student("Ivanov", "Ivan", gr, Language.RUSSIAN,1);
  59. em.persist(student1);
  60. student2 = new Student("Petrova", "Anna", gr, Language.ESTONIAN,2);
  61. em.persist(student2);
  62. //em.getTransaction().commit();
  63.  
  64. // TypedQuery<Student> query2
  65. // = em.createQuery("SELECT st FROM Student st where st.id=1L", Student.class);
  66. // Student student=query2.getSingleResult();
  67. // System.out.printf("Student(#%d): %s %s\n",student.getId(),student.getLastname(),student.getFirstname());
  68.  
  69. gr2.setCode("RDDR");
  70. gr2.setName("Masinaehitus");
  71. em.persist(gr2);
  72. student3 = new Student("Larissa", "Joonas", gr2, Language.RUSSIAN,3);
  73. em.persist(student3);
  74. student4 = new Student("Winston", "Charles", gr2, Language.ENGLISH,4);
  75. em.persist(student4);
  76. em.getTransaction().commit();
  77.  
  78. Query query2 = em.createNativeQuery("SELECT * FROM GroupVK", Group.class);
  79. List<Group> list2 = query2.getResultList();
  80. for (Group a : list2) {
  81. System.out.println(a.getCode() + ": " + a.getName());
  82.  
  83. Query query3 = em.createQuery("select st from Student st ");
  84. List<Student> students2 = query3.getResultList();
  85. for(Student student: students2)
  86. {
  87. if(a.getId()==student.getGroup().getId())
  88. System.out.println(student.getLastname() + " " + student.getFirstname()+ " " + student.getId()+ " " + student.getLang());
  89. }
  90. }
  91.  
  92. // Query query3 = em.createQuery("select st from Student st ");
  93. // List<Student> students2 = query3.getResultList();
  94. // for (Student student : students2) {
  95. // System.out.println(student.getLastname() + " " + student.getFirstname());
  96. // }
  97.  
  98.  
  99. break;
  100.  
  101. case 2:
  102. em.getTransaction().begin();
  103. em.getTransaction().commit();
  104. Query query3 = em.createNativeQuery("SELECT * FROM GroupVK", Group.class);
  105. List<Group> list3 = query3.getResultList();
  106. for (Group a : list3) {
  107. System.out.println(a.getCode() + ": " + a.getName());
  108.  
  109. Query query4 = em.createQuery("select st from Student st ");
  110. List<Student> students2 = query4.getResultList();
  111. for(Student student: students2)
  112. {
  113. if(a.getId()==student.getGroup().getId())
  114. System.out.println(student.getLastname() + " " + student.getFirstname()+ " " + student.getId()+ " " + student.getLang());
  115. }
  116. }
  117.  
  118. break;
  119. case 3: Lisamine(); break;
  120. case 4: Muutmine(); break;
  121. case 5: Kustutamine(); break;
  122.  
  123.  
  124.  
  125. }
  126.  
  127.  
  128.  
  129. em.close();
  130.  
  131. }
  132.  
  133. public static void Kustutamine(){
  134. System.out.println("Info kustutamine");
  135. //kustutamine
  136. Scanner sc3 = new Scanner(System.in);
  137. int id1 = sc3.nextInt();
  138. for (Student studenta : students)
  139. {
  140. if(studenta.getId()==id1)
  141. {
  142. students.remove(studenta);
  143. em.remove(student2);
  144. //em.getTransaction().commit();
  145.  
  146. //System.out.println(studenta.getFirstname()+ " " + studenta.getLastname());
  147. }
  148. System.out.println(studenta.getFirstname()+ " " + studenta.getLastname());
  149. }
  150.  
  151. for(Student stud : students)
  152. {
  153. System.out.println(stud.getFirstname() + " " +stud.getLastname()+" "+ stud.getLang() + " " + stud.getId());
  154.  
  155. }
  156. }
  157.  
  158.  
  159. public static void Muutmine(){
  160.  
  161. System.out.println("Objektide muutmine");
  162. System.out.println("Sisestage opilase ID, kelle andmeid soovite vahetada");
  163. int teinearv=sc1.nextInt();
  164. System.out.println("Sisestage Uue opilase eesnimi");
  165. String firstname=sc.nextLine();
  166. System.out.println("Sisestage Uue opilase perekonnanimi");
  167. String lastname=sc.nextLine();
  168. System.out.println("Sisestage uue opilase keel(");
  169. int keeled=sc1.nextInt();
  170. System.out.println("Kui opilane vahetas gruppi, siis sisestage ka uus Grupp(1.RDIR, 2.RDDR)");
  171. int grupp=sc1.nextInt();
  172. for(Student opilane : students)
  173. {
  174. if(opilane.getId()==teinearv)
  175. {
  176. opilane.setFirstname(firstname);
  177. opilane.setLastname(lastname);
  178. if(grupp==1){
  179. switch (keeled) {
  180. case 1:
  181. opilane.setLang(Language.RUSSIAN);
  182. break;
  183. case 2:
  184. opilane.setLang(Language.ENGLISH);
  185. break;
  186. case 3:
  187. opilane.setLang(Language.ESTONIAN);
  188. break;
  189. }
  190. }
  191. if(grupp==2){
  192. switch (keeled) {
  193. case 1:
  194. opilane.setLang(Language.RUSSIAN);
  195. break;
  196. case 2:
  197. opilane.setLang(Language.ENGLISH);
  198. break;
  199. case 3:
  200. opilane.setLang(Language.ESTONIAN);
  201. break;
  202. }
  203. }
  204. }
  205. }
  206. }
  207.  
  208. public static void Otsimine(){
  209. factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
  210. em = factory.createEntityManager();
  211. em.getTransaction().begin();
  212. System.out.println("Isiku otsimine");
  213. int arv=sc1.nextInt();
  214.  
  215. Query query = em.createNativeQuery("select * from Student");
  216. List<Student> students10 = query.getResultList();
  217. for(Student student: students10)
  218. {
  219. // if(arv==student.getId())
  220. // {
  221. System.out.println(student.toString()+" on Grupis"+ student.getGroup().getName());
  222. // }
  223. }
  224.  
  225. em.close();
  226. }
  227.  
  228. //public static void Otsimine(){
  229. // factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
  230. // em = factory.createEntityManager();
  231. // em.getTransaction().begin();
  232. // System.out.println("Isiku otsimine");
  233. // int arv=sc1.nextInt();
  234. //
  235. // Query query2 = em.createNativeQuery("SELECT * FROM GroupVK", Group.class);
  236. // List<Group> list2 = query2.getResultList();
  237. // for (Group a : list2) {
  238. // System.out.println(a.getCode() + ": " + a.getName());
  239. //
  240. // Query query3 = em.createQuery("select st from Student st ");
  241. // List<Student> students2 = query3.getResultList();
  242. // for(Student student: students2)
  243. // {
  244. // if(a.getId()==student.getId())
  245. // {
  246. // if(arv==student.getId())
  247. // {
  248. // System.out.println(student.getLastname().toString() + " " + student.getFirstname().toString()+ " " + student.getId()+ " " + student.getLang().toString());
  249. // }
  250. // }
  251. // }
  252. //
  253. // }
  254. // em.close();
  255. //}
  256.  
  257.  
  258.  
  259. // for(Student sunta : students2)
  260. // {
  261. //
  262. // if(sunta.getId()==sunta.getGroup().getId())
  263. // {
  264. //
  265. // }
  266. // }
  267.  
  268.  
  269.  
  270.  
  271. public static void Lisamine(){
  272. System.out.println("Info lisamine");
  273. System.out.println("Sisestage eesnimi");
  274. String firstname=sc.nextLine();
  275. System.out.println("Sisestage perenimi");
  276. String lname=sc.nextLine();
  277. System.out.println("Sisestage mis keel(1.Vene keel, 2.Inglise keel, 3.Eesti keel");
  278. int keeled=sc1.nextInt();
  279. System.out.println("Valige grupp, 1. RDIR, 2.RDDR");
  280. int group=sc1.nextInt();
  281. if(group==1){
  282. switch (keeled) {
  283. case 1:
  284.  
  285. //students.add(new Student(lname,firstname,gr,Language.RUSSIAN,students.size()+1));
  286. em.persist(new Student(lname,firstname,gr,Language.RUSSIAN,students.size()+1));
  287. break;
  288. case 2:
  289. //students.add(new Student(lname,firstname,gr,Language.ENGLISH,students.size()+1));
  290. em.persist(new Student(lname,firstname,gr,Language.ENGLISH,students.size()+1));
  291. break;
  292. case 3:
  293. //students.add(new Student(lname,firstname,gr,Language.ESTONIAN,students.size()+1));
  294. em.persist(new Student(lname,firstname,gr,Language.ESTONIAN,students.size()+1));
  295. break;
  296. }
  297. }
  298. if(group==2){
  299. switch (keeled) {
  300. case 1:
  301. //students.add(new Student(lname,firstname,gr2,Language.RUSSIAN,students.size()+1));
  302. em.persist(new Student(lname,firstname,gr2,Language.RUSSIAN,students.size()+1));
  303. break;
  304. case 2:
  305. //students.add(new Student(lname,firstname,gr2,Language.ENGLISH,students.size()+1));
  306. em.persist(new Student(lname,firstname,gr2,Language.ENGLISH,students.size()+1));
  307. break;
  308. case 3:
  309. //students.add(new Student(lname,firstname,gr2,Language.ESTONIAN,students.size()+1));
  310. em.persist(new Student(lname,firstname,gr2,Language.ESTONIAN,students.size()+1));
  311. break;
  312. }
  313. }
  314.  
  315. }
  316. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!