Kontakt

Fakturační údaje

IČ: 87189224, BÚ: 1958653063/0800

Contact info in QR code

Musico

Informace

  • Webová aplikace vytvořená pomocí technologií EJB a JSF, s úmyslem nasazení na Glassfish serveru.
  • Psaná jako semestrální práce pro předmět X33EJA.
  • Účelem bylo osvojit si:
    • Návrh doménového modelu a jeho implementaci (alespoň jedna vazba M:N)
    • Použití JPA pro persistenci
    • Transakce
    • Použití EJB (stateless i statefull)
    • Lokalizaci do více jazyků
    • Autorizaci uživatelů, rozdělení do rolí a zabezpečení přístupu k business vrstvě
    • Webové rozhrání (servlety, jsp, nebo web framework)

Zdrojové kódy

 1: -- UserAccount
 2: INSERT INTO MUSICO.USERACCOUNT (USERACCOUNTID, USERNAME, PASSWORD, EMAIL, DATECREATED, DISPLAYNAME) VALUES (1, 'peruginni', 'heslo', 'ondra@macoszek.cz', '2010-01-13', 'OndÅej Macoszek');
 3: 
 4: -- UserRole
 5: INSERT INTO MUSICO.USERROLE (USERROLEID, USERNAME, ROLENAME) VALUES (1, 'peruginni', 'member');
 6: 
 7: -- Genres
 8: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (2, 'Pop');
 9: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (3, 'Rock');
10: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (4, 'Folk');
11: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (5, 'Ska');
12: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (6, 'Acoustic Disco');
13: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (7, 'Skate Folk');
14: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (8, 'Indie Klezmer');
15: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (9, 'Garage Opera');
16: INSERT INTO MUSICO.GENRE (GENREID, "NAME") VALUES (10, 'Instrumental Hip Hop');
17: 
18: -- Band
19: INSERT INTO MUSICO.BAND (BANDID, DATEFOUNDATION, DATECREATED, WEBSITE, "NAME", COUNTRY, PREFERREDGENRE) VALUES (15, '1973-04-01', '2010-01-13 23:07:03.074', 'www.acdc.com', 'AC/DC', 'Australia', 3);
20: INSERT INTO MUSICO.BAND (BANDID, DATEFOUNDATION, DATECREATED, WEBSITE, "NAME", COUNTRY, PREFERREDGENRE) VALUES (16, '1981-08-03', '2010-01-13 23:16:40.428', 'www.altan.ie', 'Altan', 'Ireland', 4);
21: INSERT INTO MUSICO.BAND (BANDID, DATEFOUNDATION, DATECREATED, WEBSITE, "NAME", COUNTRY, PREFERREDGENRE) VALUES (17, '1988-02-02', '2010-01-13 23:17:46.296', 'www.persianajones.com', 'Persiana Jones', 'Italy', 5);
22: INSERT INTO MUSICO.BAND (BANDID, DATEFOUNDATION, DATECREATED, WEBSITE, "NAME", COUNTRY, PREFERREDGENRE) VALUES (18, '1996-04-14', '2010-01-13 23:19:44.23', 'www.subways.com', 'The Subways', 'Great Britain', 3);
23: 
24: -- Musician
25: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (3, '', '', 'Young', 'Angus');
26: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (4, '', '', 'Williams', 'Cliff');
27: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (5, '', '', 'Johnson', 'Brian');
28: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (6, '', '', 'Rudd', 'Phill');
29: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (9, '', '', 'Lunn', 'Billy');
30: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (10, '', '', 'Cooper', 'Charlotte');
31: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (11, '', '', 'Morgan', 'Josh');
32: INSERT INTO MUSICO.MUSICIAN (MUSICIANID, ARTNAME, BIOGRAPHY, SECONDNAME, FIRSTNAME) VALUES (12, '', '', 'Ní Mhaonaigh', 'Mairéad');
33: 
34: 
35: -- BandMusician
36: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (3, 15);
37: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (4, 15);
38: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (5, 15);
39: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (6, 15);
40: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (9, 18);
41: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (10, 18);
42: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (11, 18);
43: INSERT INTO MUSICO.BANDMUSICIAN (MUSICIANID, BANDID) VALUES (12, 16);
44: 
45: -- Event
46: INSERT INTO MUSICO.EVENT (EVENTID, DATEEND, PLACE, DATESTART, "NAME", BAND) VALUES (7, '2010-01-13 23:00:00.0', 'Praha', '2010-01-13 19:00:00.0', 'AC/DC v Praze', 15);
47: INSERT INTO MUSICO.EVENT (EVENTID, DATEEND, PLACE, DATESTART, "NAME", BAND) VALUES (8, '2010-02-13 23:00:00.0', 'Dublin', '2010-02-13 19:00:00.0', 'Altan v Dublinu', 16);
48: 
49: 
50: 
51: