Advertisement
Guest User

Untitled

a guest
Apr 5th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.68 KB | None | 0 0
  1. Create table CatalogRequirements (
  2. semester varchar(20) NOT NULL,
  3. year int NOT NULL,
  4. program varchar(20) not null,
  5. GPA decimal(5 , 2 ) NOT NULL,
  6. ILETS decimal(5 , 2 ),
  7. TOFEL int,
  8. Backlogs int,
  9. Pre_requisite1 varchar(20),
  10. Pre_requisite2 varchar(20),
  11. compsmingpa decimal(5,2) not null,
  12. compsminHours int not null,
  13. Primary key (semester , year,program)
  14. );
  15. Create table Catalog_Course (
  16. courseNum int NOT NULL,
  17. semester varchar(20) not null,
  18. year int not null,
  19. program varchar(20) not null,
  20. Hours int NOT NULL,
  21. MIN_GPA decimal(3 , 2 ) NOT NULL,primary key(coursenum,semester,year,program),
  22. FOREIGN KEY (coursenum)
  23. references nwcourse (coursenum),
  24. FOREIGN KEY (semester,year,program)
  25. references CatalogRequirements (semester,year,program)
  26. );
  27.  
  28. /* This is CatalogRequirement Class */
  29.  
  30. @ManagedBean
  31. @SessionScoped
  32. @Entity
  33. @IdClass(CatalogRequirementsId.class)
  34. public class CatalogRequirements implements Serializable{
  35.  
  36.  
  37. @Id
  38. private String semester;
  39. @Id
  40. private int year;
  41. @Id
  42. private String program;
  43. @Id
  44. CatalogRequirementsId crPK = new CatalogRequirementsId();
  45. private double GRE;
  46. private double IELTS;
  47. private int TOEFL;
  48. private int Backlogs;
  49. private String PreRequisites1;
  50. private String PreRequisites2;
  51. private double compsMinGpa;
  52. private int CompsMinHours;
  53. private CatalogCourse cc;
  54.  
  55.  
  56. @OneToMany(mappedBy = "catalogrequirements")
  57. private Set<CatalogCourse> catalogCourses;
  58.  
  59. public CatalogRequirements() {
  60. }
  61.  
  62. public CatalogRequirements(double GRE,double IELTS, int TOEFL, int Backlogs, String PreRequisites1, String PreRequisites2, double compsMinGpa, int CompsMinHours) {
  63. this.GRE = GRE;
  64. this.IELTS = IELTS;
  65. this.TOEFL = TOEFL;
  66. this.Backlogs = Backlogs;
  67. this.PreRequisites1 = PreRequisites1;
  68. this.PreRequisites2 = PreRequisites2;
  69. this.compsMinGpa = compsMinGpa;
  70. this.CompsMinHours = CompsMinHours;
  71. }
  72.  
  73. public CatalogRequirementsId getCrPK() {
  74. return crPK;
  75. }
  76.  
  77. public void setCrPK(CatalogRequirementsId crPK) {
  78. this.crPK = crPK;
  79. }
  80.  
  81. public Set<CatalogCourse> getCatalogCourses() {
  82. return catalogCourses;
  83. }
  84.  
  85. public void setCatalogCourses(Set<CatalogCourse> catalogCourses) {
  86. this.catalogCourses = catalogCourses;
  87. }
  88.  
  89. public double getGRE() {
  90. return GRE;
  91. }
  92.  
  93. public void setGRE(double GRE) {
  94. this.GRE = GRE;
  95. }
  96.  
  97. public double getIELTS() {
  98. return IELTS;
  99. }
  100.  
  101. public void setIELTS(double IELTS) {
  102. this.IELTS = IELTS;
  103. }
  104.  
  105. public int getTOEFL() {
  106. return TOEFL;
  107. }
  108.  
  109. public void setTOEFL(int TOEFL) {
  110. this.TOEFL = TOEFL;
  111. }
  112.  
  113. public int getBacklogs() {
  114. return Backlogs;
  115. }
  116.  
  117. public void setBacklogs(int Backlogs) {
  118. this.Backlogs = Backlogs;
  119. }
  120.  
  121. public String getPreRequisites1() {
  122. return PreRequisites1;
  123. }
  124.  
  125. public void setPreRequisites1(String PreRequisites1) {
  126. this.PreRequisites1 = PreRequisites1;
  127. }
  128.  
  129. public String getPreRequisites2() {
  130. return PreRequisites2;
  131. }
  132.  
  133. public void setPreRequisites2(String PreRequisites2) {
  134. this.PreRequisites2 = PreRequisites2;
  135. }
  136.  
  137. public double getCompsMinGpa() {
  138. return compsMinGpa;
  139. }
  140.  
  141. public void setCompsMinGpa(double compsMinGpa) {
  142. this.compsMinGpa = compsMinGpa;
  143. }
  144.  
  145. public int getCompsMinHours() {
  146. return CompsMinHours;
  147. }
  148.  
  149. public void setCompsMinHours(int CompsMinHours) {
  150. this.CompsMinHours = CompsMinHours;
  151. }
  152.  
  153. public String getSemester() {
  154. return semester;
  155. }
  156.  
  157. public void setSemester(String semester) {
  158. this.semester = semester;
  159. }
  160.  
  161. public int getYear() {
  162. return year;
  163. }
  164.  
  165. public void setYear(int year) {
  166. this.year = year;
  167. }
  168.  
  169. public String getProgram() {
  170. return program;
  171. }
  172.  
  173. public void setProgram(String program) {
  174. this.program = program;
  175. }
  176.  
  177. public void saveCatalog() {
  178. CreateCatalogDao dao = new CreateCatalogDao();
  179. dao.createCatalog(this);
  180.  
  181. }
  182. }
  183.  
  184. public class CatalogRequirementsId implements Serializable{
  185.  
  186. private String semester;
  187. private int year;
  188. private String program;
  189.  
  190. public CatalogRequirementsId() {
  191. }
  192.  
  193. public CatalogRequirementsId(String semester, int year, String program) {
  194. this.semester = semester;
  195. this.year = year;
  196. this.program = program;
  197. }
  198.  
  199. public String getSemester() {
  200. return semester;
  201. }
  202.  
  203. public void setSemester(String semester) {
  204. this.semester = semester;
  205. }
  206.  
  207. public int getYear() {
  208. return year;
  209. }
  210.  
  211. public void setYear(int year) {
  212. this.year = year;
  213. }
  214.  
  215. public String getProgram() {
  216. return program;
  217. }
  218.  
  219. public void setProgram(String program) {
  220. this.program = program;
  221. }
  222.  
  223. @Override
  224. public int hashCode() {
  225. int hash = 7;
  226. hash = 17 * hash + Objects.hashCode(this.semester);
  227. hash = 17 * hash + Objects.hashCode(this.year);
  228. hash = 17 * hash + Objects.hashCode(this.program);
  229. return hash;
  230. }
  231.  
  232. @Override
  233. public boolean equals(Object obj) {
  234. if (obj == null) {
  235. return false;
  236. }
  237. if (getClass() != obj.getClass()) {
  238. return false;
  239. }
  240. final CatalogRequirementsId other = (CatalogRequirementsId) obj;
  241. if (!Objects.equals(this.semester, other.semester)) {
  242. return false;
  243. }
  244. if (!Objects.equals(this.year, other.year)) {
  245. return false;
  246. }
  247. if (!Objects.equals(this.program, other.program)) {
  248. return false;
  249. }
  250. return true;
  251. }
  252. }
  253.  
  254. @ManagedBean
  255. @SessionScoped
  256. @Entity
  257. @IdClass(CatalogCourseId.class)
  258. public class CatalogCourse implements Serializable{
  259.  
  260. @Id
  261. CatalogCourseId ccid = new CatalogCourseId();
  262. @Id
  263. private String CourseNo;
  264. private int CreditHours;
  265. private double MinGrade;
  266.  
  267. @ManyToOne
  268. private CatalogRequirements catalogrequirements;
  269. //private CatalogCourse cc;
  270.  
  271. public CatalogCourse() {
  272. }
  273.  
  274. public CatalogCourse(String CourseNo, int CreditHours, double MinGrade, CatalogRequirements catalogrequirements) {
  275. this.CourseNo = CourseNo;
  276. this.CreditHours = CreditHours;
  277. this.MinGrade = MinGrade;
  278. this.catalogrequirements = catalogrequirements;
  279. }
  280.  
  281. public CatalogRequirements getCatalogrequirements() {
  282. return catalogrequirements;
  283. }
  284.  
  285. public void setCatalogrequirements(CatalogRequirements catalogrequirements) {
  286. this.catalogrequirements = catalogrequirements;
  287. }
  288.  
  289. public CatalogCourseId getCcid() {
  290. return ccid;
  291. }
  292.  
  293. public void setCcid(CatalogCourseId ccid) {
  294. this.ccid = ccid;
  295. }
  296.  
  297. public int getCreditHours() {
  298. return CreditHours;
  299. }
  300.  
  301. public void setCreditHours(int CreditHours) {
  302. this.CreditHours = CreditHours;
  303. }
  304.  
  305. public double getMinGrade() {
  306. return MinGrade;
  307. }
  308.  
  309. public void setMinGrade(double MinGrade) {
  310. this.MinGrade = MinGrade;
  311. }
  312.  
  313. public String getCourseNo(){
  314. return getCcid().getCourseNo();
  315. }
  316.  
  317. public void setCourseNo(String CourseNo){
  318. getCcid().setCourseNo(CourseNo);
  319. }
  320.  
  321. public CatalogRequirements getCrFK(){
  322. return getCcid().getCrFK();
  323. }
  324.  
  325. public void setCrFK(CatalogRequirements fk){
  326. getCcid().setCrFK(fk);
  327. }
  328. }
  329.  
  330. public class CatalogCourseId implements Serializable {
  331.  
  332. private String CourseNo;
  333.  
  334. @ManyToOne
  335. CatalogRequirements crFK;
  336.  
  337. public String getCourseNo() {
  338. return CourseNo;
  339. }
  340.  
  341. public void setCourseNo(String CourseNo) {
  342. this.CourseNo = CourseNo;
  343. }
  344.  
  345. public CatalogRequirements getCrFK() {
  346. return crFK;
  347. }
  348.  
  349. public void setCrFK(CatalogRequirements crFK) {
  350. this.crFK = crFK;
  351. }
  352.  
  353. @Override
  354. public int hashCode() {
  355. int hash = 7;
  356. hash = 37 * hash + Objects.hashCode(this.CourseNo);
  357. hash = 37 * hash + Objects.hashCode(this.crFK);
  358. return hash;
  359. }
  360.  
  361. @Override
  362. public boolean equals(Object obj) {
  363. if (obj == null) {
  364. return false;
  365. }
  366. if (getClass() != obj.getClass()) {
  367. return false;
  368. }
  369. final CatalogCourseId other = (CatalogCourseId) obj;
  370. if (!Objects.equals(this.CourseNo, other.CourseNo)) {
  371. return false;
  372. }
  373. if (!Objects.equals(this.crFK, other.crFK)) {
  374. return false;
  375. }
  376. return true;
  377. }
  378. }
  379.  
  380. <?xml version="1.0" encoding="UTF-8"?>
  381. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  382. <hibernate-mapping package="com.javaknowledge.entity">
  383. <class name="com.javaknowledge.entity.CatalogRequirements" table="CatalogRequirements">
  384. <composite-id class="com.javaknowledge.entity.CatalogRequirementsId" mapped="true">
  385. <key-property name="semester" column="semester" ></key-property>
  386. <key-property name="year" column="year" ></key-property>
  387. <key-property name="program" column="program" ></key-property>
  388. </composite-id>
  389. <property name="GRE" column="GPA" />
  390. <property name="IELTS" column="ILETS" />
  391. <property name="TOEFL" column="TOFEL" />
  392. <property name="Backlogs" column="Backlogs" />
  393. <property name="PreRequisites1" column="Pre_requisite1" />
  394. <property name="PreRequisites2" column="Pre_requisite2" />
  395. <property name="compsMinGpa" column="compsmingpa" />
  396. <property name="compsMinHours" column="compsminHours" />
  397. <set name="catalogCourses" inverse="true" cascade="all">
  398. <key not-null="true">
  399. <column name="semester" ></column>
  400. <column name="year" ></column>
  401. <column name="program" ></column>
  402. </key>
  403. <one-to-many class="com.javaknowledge.entity.CatalogCourse"></one-to-many>
  404. </set>
  405.  
  406. </class>
  407. </hibernate-mapping>
  408.  
  409. <?xml version="1.0" encoding="UTF-8"?>
  410. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  411. <hibernate-mapping>
  412. <class name="com.javaknowledge.entity.CatalogCourse" table="Catalog_Course">
  413. <id name="CourseNo" column="courseNum" type="string" ></id>
  414. <property name="CreditHours" column="Hours" />
  415. <property name="MinGrade" column="MIN_GPA" />
  416. <many-to-one name="catalogrequirements" class="com.javaknowledge.entity.CatalogRequirements" not-null="true">
  417. <column name="semester" />
  418. <column name="year" />
  419. <column name="program" />
  420. </many-to-one>
  421. </class>
  422. </hibernate-mapping>
  423.  
  424. <?xml version="1.0" encoding="UTF-8"?>
  425. <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate- configuration-3.0.dtd">
  426. <hibernate-configuration>
  427. <session-factory>
  428. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  429. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  430. <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/gdp</property>
  431. <property name="hibernate.connection.username">root</property>
  432. <property name="hbm2ddl.auto">update</property>
  433. <property name="show_sql">true</property>
  434. <mapping resource="com/javaknowledge/entity/CatalogRequirements.hbm.xml" />
  435. <mapping resource="com/javaknowledge/entity/CatalogCourse.hbm.xml"/>
  436. </session-factory>
  437. </hibernate-configuration>
  438.  
  439. public class CreateCatalogDao {
  440.  
  441. private CatalogCourse cc;
  442. public void createCatalog(CatalogRequirements cust) {
  443. Transaction trns = null;
  444. Session session = HibernateUtil.createSessionFactory().openSession();
  445. try {
  446. trns = session.beginTransaction();
  447. session.save(cust);
  448. trns.commit();
  449.  
  450. } catch (RuntimeException e) {
  451. if (trns != null) {
  452. trns.rollback();
  453. }
  454. } finally {
  455. session.flush();
  456. session.close();
  457. }
  458. }
  459. }
  460.  
  461. public class CatalogCourseId implements Serializable {
  462. private CatalogRequirementsId catalogRequirements;
  463. private String CourseNo;
  464. ...
  465. }
  466.  
  467. @Entity
  468. @IdClass(CatalogCourseId.class)
  469. @Table(name="Catalog_Course")
  470. public class CatalogCourse {
  471. @Id
  472. @ManyToOne
  473. @JoinColumns({
  474. @JoinColumn(name="semester", referencedColumnName="semester"),
  475. @JoinColumn(name="year", referencedColumnName="year"),
  476. @JoinColumn(name="program", referencedColumnName="program")
  477. })
  478. private CatalogRequirements catalogRequirements;
  479.  
  480. @Id
  481. @Column(name="courseNum")
  482. private String courseNo;
  483.  
  484. ...
  485. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement