Computer Science BSc Java Programming Practice 7 Dr

Computer Science BSc: Java Programming Practice 7 Dr. Gábor Pauler, Associate Professor, PTETTK, Room F 104, 6 th Ifjusag str. Pecs, Hungary Skype: gjpauler E-mail: pauler@t-online. hu Facebook and Open FTP sites of the course: https: //www. facebook. com/groups/574936103087671/ ftp: //gamma. ttk. pte. hu/pub/pauler/Java/

Content of the Practice Checking Home Assignment 6: Create database kezilabda 1 and table jatekos PRACTICE 7 -1: Create database table/ entity class Crocodile in project Zoo PRACTICE 7 -2: Create database tables/ entity classes from classes of your earlier Pen project solution Home Assignment 7 -1: Create group project database, stored procedures, and CRUDAFs in Model, Service, Controller layers References

7. Practice Tasks PRACTICE 7 -1: Create database table/ entity class Crocodile in project Zoo: Define a database table krokodil (Crocodile) with the following fields: krokodil_id – crocodile. ID, Integer, Identity, Primary key Csipszam – chip. Number, Integer, Unique, external natural ID, non-modifiable Nev – name, String Kor – Age, years Integer Him – Male, Intgerer (1: male, 0: not male), non-modifiable Fill it up with 4 -5 sample records Create entity class from that Create CRUDSs, observing the rules we gave at field descriptions Sample solution: Crocodile. java , zoo. sql PRACTICE 7 -2: Create database tables/ entity classes from classes of your earlier Pen project solution Sample solution: Pen , pen. sql

Content of the Practice Checking Home Assignment 6: Create database kezilabda 1 and table jatekos PRACTICE 7 -1: Create database table/ entity class Crocodile in project Zoo PRACTICE 7 -2: Create database tables/ entity classes from classes of your earlier Pen project solution Home Assignment 7 -1: Create group project database, stored procedures, and CRUDAFs in Model, Service, Controller layers References

Home Assignment 7: Create group project MVC CRUDAFs 7 -1. Create group project database: in Normal format 5, based on your earlier defined Entity Relationship Diagram: at least 5 tables, 4 relations, in average 50 records by table 7 -2. Create stored procedures: all meaningful CRUDAFs by your earlier defined Business Process Diagram 7 -3. Create entity classes: in Model layer 7 -4. Create CRUDAFs: in Model, Service, Controller layers, communicating through JSONArray

References Java MVC development tutorials: http: //zetcode. com/java/mvc/ https: //www. edureka. co/blog/mvc-architecture-injava/ https: //www. guru 99. com/mvc-tutorial. html

List of Symbols General Symbols: DEF: definition, PRC: process, ALT: alternatives, CYC: cycle, : inference, : contradicts, / : dis/advantage, URL: webaddress DIR: directory, PCK: package, CLS: class, PRP: property MET: method EVN: event EXC: exception Symbols of Graphic User Interface: Aaa|Bbb|-Menu|Submenu, SCR: Screen, FRM: Frame, ID: Unique identifier, BTN: Button, TXB: Textbox, DDN: Dropdown, TAB: Multi. Tabs, CHK: Checkbox RAD: Radio button, TBL: Table COL: Table. Column, LIN: Table. Row, KEY: Keyboard, WRN: Popup warning ERR: Error message Logic Symbols: a&&b: a and b, a&b: binary and, a||b: a or b, a|b: binary or !a: not a Math Symbols: a = b passing value a == b value equals a === b value and type equals a. equals(b) class instance equals != value not equals a / b division or integer division a % b modulus of integer division a + b addition or concatenation Database Symbols: : Entity, ▬◄: 1: many relation ►▬: Many: 1 relation ---▬: independent/dependent side PK: Primary key FK: Foreign key UML Class Diagram Symbols: +PRP: public property, -PRP: private property, #PRP: protected property, ~PCK: package, /CLS: descendant class, Owner◄─Nested: nesting connection Ancestor∆┘Descendant: inheritance conn. Whole♦┘Oblig. Part: obligatory part