金融信息系统数据库访问实验指导书.doc

Transcription

1

2 Hibernate get load 3. update delete java HibernateDemo06 2. Hibernate a) Folder lib b) lib import General File System c) next Browse d) jar e) Select All Finish f) lib >Build Path >Add to Build Path, 3. a) src Genera File b) next hibernate.cfg.xml Finish c) hibernate.cfg.xml xml <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" " d) hibernate-configuration e) hibernate-configuration session-factory

3 f) session-factory property property url sql 4. a) Empl i. id id i 1. seq_empl Empl b) src com.oracle.entity entity Empl Serializable i. Empl id name age did i id Empl set get tostring Empl Add default serial version ID 5. i. xml Empl.hbm.xml i Empl.hbm.xml <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" " Empl.hbn.xml iv. hibernate-mapping 1. class name table a) name com.oracle.entity.empl b) table Empl

4 2. class id name type column a) name id b) type id java.lang.integer c) column id d) id generator class sequence e) generator param sequence seq_empl 3. class property name column type hibernate.cfg.xml <session-factory> 6. a) test Test test b) Test session get id 2 Empl Configuration con=new Configuration().configure(); SessionFactory sf=con.buildsessionfactory(); Session session=sf.opensession(); System.out.println(session.get(Empl.class, 2)); c) 002 get load 1. a) Empl / / 002 get load / empl.txt

5 i. id i id 1. seq_empl Empl b) / / 002 get load HibernateDemo07 ecplise 2. a) get load i. test Test Test Empl empl=(empl) session.get(empl.class, 2); get load b) get load i. 1. get 2 10 id get load id 10

6 1. get 10 2 (System.out.println(empl);), 2. get load, 003 update delete 1. update : 2. delete 1. a) Empl / / 003 update delete / empl.txt i. id i id 1. seq_empl Empl

7 b) \ Hibernate \ \ 003 update delete HibernateDemo08 ecplise 2. a) Update i. test Test Session session=sf.opensession(); Transaction i iv. tran=session.begintransaction(); session get id 2 Empl empl empl setage age 40 v. session update() empl update vi. v vi Transaction commit tostring session ix. age 40 b) delete i. i iv. Transaction tran=session.begintransaction(); session get id 2 Empl empl session delete empl delete v. tran commit vi. v vi ix. session get id 2 Empl newempl newempl tostring session id 2

8 Hibernate 1. session session 001 session 1. persist a) Ecplise b) 2. select_before_update a) update b) select-befor-update c) age

9 3. saveorupdate a) Ecplise save b) update 1. a) Empl hibernate \ \ \ 001 session \empl.txt i. id id i 1. seq_empl Empl 2. a) hibernate \ \ \ 001 session HibernateDemo11 ecplise 3. a) persist i. test Test i Session session=sf.opensession(); session begintransaction() Transaction tran Empl empl new Empl("DEMO",19,1);

10 iv. session persist empl v. session vi. b) select-before-update: i. Session session=sf.opensession(); i iv. session get id 2 Empl empl session empl Session sessionsec Session sessionsec=sf.opensession() v. transec vi. v vi ix. Transaction transec=sessionsec.begintransaction() sessionsec update Empl session Empl.hbm.xml class :select-before-update= true Test select sql update sql x. Transaction transec=sessionsec.begintransaction(); xi. empl.setage(35); empl age 35 update sql c) saveorupdate i. save 1. test Test2 2. Session session=sf.opensession() Transaction tran=session.begintransaction(); 3. Empl empl name TERRY,age 28 did 2 4. session saveorupdate empl 5. session 6. save insert update 1. Empl empl=new Empl("TERRY",28,2); session.saveorupdate(empl); 2. session get id 2 empl 3. session empl 4. session Session sessionsec=sf.opensession(); 5. Transaction transec=sessionsec.begintransaction(); 6. Session sessionsec saveorupdate empl ( update )

11 7. session a) Ecplise b) 2. flush a) Ecplise b) 3. evit Ecplise 4. clear

12 1. a) Empl hibernate \ \ \ \empl.txt i. id i id 1. seq_empl Empl 2. a) hibernate \ \ HibernateDemo10 ecplise 3. a) i. test Test i iv. Session session=sf.opensession(); session.get() id 1 Empl empl empl tostring session begintransaction() Transaction tran v. session delete empl vi. v vi session empl tostring empl ecplise id 1 empl b) flush i. Session session=sf.opensession() i new Empl Id 4 name MAYYR,age 18 did 2 session save empl session

13 iv. session flush v. vi. Transaction commit c) evit i. session.flush() session evit empl empl session d) i. evit i session clear 003 session 1. persist a) Ecplise b) 2. select_before_update a) update b) select-befor-update c) age

14 3. saveorupdate a) Ecplise save b) update 1. a) Empl hibernate \ \ \ 001 session \empl.txt i. id id i 1. seq_empl Empl 2. a) hibernate \ \ \ 001 session HibernateDemo11 ecplise 3. a) persist i. test Test i Session session=sf.opensession(); session begintransaction() Transaction tran Empl empl new Empl("DEMO",19,1);

15 iv. session persist empl v. session vi. b) select-before-update: i. Session session=sf.opensession(); i iv. session get id 2 Empl empl session empl Session sessionsec Session sessionsec=sf.opensession() v. transec vi. v vi ix. Transaction transec=sessionsec.begintransaction() sessionsec update Empl session Empl.hbm.xml class :select-before-update= true Test select sql update sql x. Transaction transec=sessionsec.begintransaction(); xi. empl.setage(35); empl age 35 update sql c) saveorupdate i. save 1. test Test2 2. Session session=sf.opensession() Transaction tran=session.begintransaction(); 3. Empl empl name TERRY,age 28 did 2 4. session saveorupdate empl 5. session 6. save insert update 1. Empl empl=new Empl("TERRY",28,2); session.saveorupdate(empl); 2. session get id 2 empl 3. session empl 4. session Session sessionsec=sf.opensession(); 5. Transaction transec=sessionsec.begintransaction(); 6. Session sessionsec saveorupdate empl ( update )

16 7. session

17 1. 2. Hibernate a) Empl Dept \ \ \.txt i. id id i 1. seq_empl seq_dept Empl

18 2. Dept b) i. \ 2. a) \ \ HibernateDemo16 ecplise i. entity Dept Dept Empl HashSet set get b) i. Dept.hbm.xml class set 1. set <set name="xxx( set )" table="xxx " lazy="false" inverse="true" cascade="all"> <key column="xxx( )"/> <one-to-many class="xxx( )"/> </set> 2. set c) a) name: empllist b) table: empl c) key column: deptid d) one-to-many class com.oracle.entity.empl i. dao DeptImpl Session session=sf.opensession() session get(clz, deptid) Dept dept dept getempllist() List empllist d) i. test Test1 DeptImpl queryemplbydept i iv. Dept.class 1 Empl

19 a) student course studentandcourse studentandcourse student_id student id studentandcourse course_id course id \ \ \ b) i. \ \ \ HibernateDemo17 ecplise 2. a) entity Course Course Student Set, set get b) entity course.hbm.xml Course Student course.hbm.xml set many-to-many i. set <set name="xxx( set )" table="xxx " lazy="false" cascade="all" inverse="true" > <key column="xxx( )" foreign-key="xxx( )"/> <many-to-many column= XXX( ) class="xxx( )"/> </set> Set 1. name: studentlist 2. table: studentandcourse 3. key column: course_id 4. foreign-key fk_course 5. many-to-many class student_id

20 6. class com.oracle.entity.student c) Session session=sf.opensession() get(clz, courseid) Course course d) course getstudentlist Set stulist session stulist 3. a) ManyToMany b) CourseImpl c) querystudentbycourse id 1001 Course Student Set d) for e) 003 ( ) 1. querystudentbycourse id querycoursebystudent a) student course studentandcourse studentandcourse student_id student id studentandcourse course_id course id \ \ \ 003.txt b)

21 i. \ \ \ HibernateDemo18 ecplise 2. studentandcourse a) entity Course Course SAC Set SACList, set get b) Student Student SAC Set SACList set get c) entity Course.hbm.xml Student.hbm.xml class set i. set <set name="xxx( List )" table="xxx " lazy="false" cascade="all" inverse="true" > <key column="xxx( )" foreign-key="xxx( )"/> <one-to-many class="xxx( )"/> </set> Course.hbm.xml set i 1. name: SACList 2. table: studentandcourse 3. key column: course_id 4. foreign-key fk_course 5. one-to-many class com.oracle.entity.sac Student.hbm.xml set 1. name: SACList 2. table: studentandcourse 3. key column: student_id 4. foreign-key fk_student 5. one-to-many class com.oracle.entity.sac d) SAC Student student Course course set get e) entity SAC.hbm.xml class many-to-one Course Student i. <many-to-one name="xxx( )" column="xxx( )" class="xxx( )" not-null="true"/> 1. name course student 2. column course_id student_id 3. class com.oracle.entity.course com.oracle.entity.student f)

22 i. dao CourseImpl CourseImpl 1. querystudentbycourse(class clz,serializable Id) course student a) Session session=sf.opensession() get Course b) getsaclist Set c) Set SAC SAC SAC getstudent Student stu d) stu tostring e) session 2. querycoursebystudent(class clz,serializable Id) g) student course a) Session session=sf.opensession() get(clz, Id) Student student b) student getsaclist SAC Set coulist c) SAC SAC SAC getcourse Course d) tostring e) session i. test CourseTest querystudentbycourse(class clz,serializable Id) 1. CourseImpl 2. CourseImpl querystudentbycourse(class clz,serializable Id) Course.class test StudentTest querycoursebystudent(class clz,serializable Id) 1. CourseImpl 2. CourseImpl querycoursebystudent(class clz,serializable Id) Student.class

23

24 5 fetch 1. a) student course studentandcourse studentandcourse student_id student id studentandcourse course_id course id \ Hibernate \ \ 001.txt b) i. \ Hibernate \ \ HibernateDemo19 ecplise 2. a) i. Course.hbm.xml set lazy false test Test b) i. Course.hbm.xml set lazy i iv. true test Test CourseImpl session.close System.out.println(stuList.size()); Test c) i. Course.hbm.xml set lazy extra i test Test dao CourseImpl System.out.println(studentList.size()) size iterator iv. test Test d)

25 i. Course.hbm.xml set lazy batch-size 2 batch-size="2" test Test e) fetch i. Course.hbm.xml set name fetch subselect fetch join select test Test a) Empl Dept \ Hibernate \ \ \ 002.txt i. empl dept b)

26 i. \ Hibernate \ \ HibernateDemo20 ecplise 2. a) Empl Empl Dept dept set get b) Empl.hbm.xml class many-to-one <many-to-one/> <many-to-one name="xxx( )" column="xxx( )" lazy="false" class="xxx( )" not-null="true" cascade="save-update"/> i. 1. name dept 2. column DEPTID 3. class com.oracle.entity.dept c) dao DeptImpl Session session=sf.opensession() d) session get clz, Id Empl empl get clz id querydeptbyempl(class clz, Serializable Id) e) empl getdept dept f) dept g) test Test1 i. DeptImpl i querydeptbyempl(class clz, Serializable Id) Empl.class 1 Dept, dept dept tostring h)

27 Hibernate HQL age a) player hibernate \ \ \ \ 001 sql

28 b) hibernate \ \ \ HibernateDemo21 ecplise c) PlayerImpl IplayerDao i. queryallplayer() Session session=sf.opensession() session createquery String arg Query query HQL a) HQL i. from XXX( ) 1. Player 2. query list Player players 3. null players queryplayerbyage(int age) 1. Session session=sf.opensession() session createquery String arg Query query HQL a) HQL i. from XXX( ) where age=:xxx( ) 1. Player 2. pid 2. query setinteger(arg0, arg1), pid a) i. arg0 HQL pid arg1 age query list Player players 4. null players a) PlayerDemo queryallplayer() i. PlayerImpl playimpl i iv. playimpl PlayerImpl queryallplayer() Player playersall tostring tostring b) PlayerDemo1 queryplayerbyage(int age) i. PlayerImpl playimpl

29 i iv. playimpl PlayerImpl queryplayerbyage(int age) 28 Player players tostring tostring 002 QBC QBE 1. QBC age QBC age 28 id 6 3. QBE 1. a) player hibernate \ \ \ \001 sql ( )

30 b) hibernate \ \ \ HibernateDemo22 ecplise c) PlayerImpl IplayerDao i. QBC 1. PlayerImpl queryplayerbyageqbc int age QBC 2. Session session=sf.opensession() session createcriteria arg criteria Player.class 3. Restrictions eq(propertyname, value) Criterion criterion age propertyname age value age 4. criteria add(criterion agr0) criteria criterion add Criterion agr0 5. criteria list Player List players 6. a) PlayerQBC PlayerImpl playerimpl b) playerimpl PlayerImpl queryplayerbyageqbc(int age) 28 Player players c) players tostring tostring age 28 d) QBC 1. PlayerImpl queryplayerbycondition(list<criterion> criterionlist) QBC 2. queryplayerbycondition(list<criterion> criterionlist) Session session=sf.opensession() session createcriteria arg

31 criteria Player.class 3. queryplayerbycondition(list<criterion> criterionlist) criterionlist add criteria 4. criteria list Player players 5. players 6. a) PlayerQBC1 PlayerImpl playerimpl=new PlayerImpl() List criterions Criterion b) age 28 i. Restrictions eq(propertyname, value) Criterion criterionone age propertyname age value 28 c) id 6 1. Criterion criterionsec propertyname id value 6 d) criterionone criterionsec criterions e) PlayerImpl playerimpl f) playerimpl PlayerImpl queryplayerbycondition(list<criterion> critertionlist) criterions Player players g) Player h) 7. QBE a) dao PlayerImpl queryplayerbytemple(example example) Criteria criteria=session.createcriteria(player.class); criteria add example criteria b) test PlayQBE PlayerImpl playerimpl=new PlayerImpl(); empl c) player setage int arg age 37 d) Example create Object arg empl Example example e) example playerimpl.queryplayerbytemple() List players

32 f) player tostring age a) player hibernate \ \ \ 001 sql b) hibernate \ \ \ HibernateDemo24 ecplise c) i. ( ) PlayerImpl age a) Query query=session.createquery("from Player where age=:pid"); as Player P i. from A as B where B.C=:XXX a) test PlayerDemo1 PlayerDemo1

33 004 iterator 1. HQL 2. QBC 3. QBC 4. HQL 5. HQL iterator 3. a) PL id seq_player sql / b)

34 c) hibernate \ \ HibernateDemo26 ecplise 4. a) QBC HQL i. HQL 1. PlayerImpl queryplayerbyhql(string sql) Session session = sf.opensession(); 2. session createquery query 3. query setfirstresult(arg0) 0 4. query setmaxresult(arg0) query list() List 6. test PlayHQL 7. PlayerImpl playerimpl 8. playerimpl PlayerImpl queryplayerbyhql String sql 9. Player age order by XX desc sql from Player order by age desc sql queryplayerbyhql String sql 10. Player 11. QBC 1. PlayerImpl queryplayerbyqbc(list<criterion> conditions) Session session = sf.opensession(); 2. session createcriteria Player.class criteria 3. conditions criteria 4. criteria addorder(order.desc("xx")) XX age

35 5. criteria setfirstresult(int arg) 0 6. criteria setmaxresults(int arg) 2 7. criteria list List players 8. players 9. test PlayerQBC queryplayerbyqbc(list<criterion> conditions) 10. PlayerImpl playerimpl 11. List list 12. Restrictions.ge("XXX", XXX) age>28 list 13. playerimpl queryplayerbyqbc(list<criterion> conditions) list 14. Player 15. b) HQL QBC i. HQL : 1. PlayerImpl queryuniqueplayerbyhql String sql Session session = sf.opensession(); 2. session createquery query 3. query setmaxresult(arg0) 1 4. query list() List 5. test PlayHQLUnique 6. QBC 1. dao PlayerImpl 2. queryuniqueplayerbyqbc(list<criterion> conditions) 3. Criteria criteria=session.createcriteria(player.class); criteria setmaxresults(x); 1 4. test PlayerQBCUnique c) HQL iterator i. PlayerImpl queryplayerbyhqliterate(string sql) i Session session = sf.opensession(); session createquery query query iterate() Iterator iterator

36 iv. Player List players v. iterator hasnext while iterator vi. v vi ix. iterator next() Player player new Player play play players players test PlayHQLIterator 005 HQL 1. count min max avg 2. upper lower 3. size

37 1. a) sql.txt i. dept dept_id empl id, b) hibernate \ \ HibernateDemo29 ecplise 2. a) count min max avg i. DeptImpl querybycfunction() i iv. Session session = sf.opensession(); String sql=" " sql select count(e.id),min(e.age),max(e.age),avg(e.age)from Empl e Empl age age age test test1.test1 test1. b) upper lower i. DeptImpl querybypfunction() Session session = sf.opensession(); String sql=" " sql select upper(d.deptname),lower(d.deptname)from Dept d

38 i iv. Dept deptname deptname test test1. test1 dept.querybycfunction(); test1 c) size i. DeptImpl querybysfunction() i iv. Session session = sf.opensession(); String sql=" " sql select size(d.empllist)from Dept d where deptid=1 Dept deptid 1 Empl test test1 test1 dept.querybypfunction(); test1

39 Hibernate age>25 1. a) i. oracle Empl, sql b) hibernate \ \ \ HibernateDemo30 ecplise 2. a) HQL i. dao EmplImpl EmplImpl i querybyhql(int age) HQL Session session = sf.opensession(); sql from Empl e where e.age>:age sql session createquery sql Query query

40 iv. query setinteger String arg0 Object arg1 sql 1. arg0 age sql age 2. arg1 age querybyhql(int age) age v. query list() Empl List vi. v empls empls test Test1 age>25 List<Empl>empls=dept.queryByHQL( ) age 25 b) QBC i. dao EmplImpl EmplImpl i iv. querybyqbc(int age) QBC Criteria criteria=session.createcriteria(empl.class); Restrictions gt(string arg0,object arg1) Criterion criterion 1. arg0 age 2. arg1 querybyqbc(int age) age criteria add criterion criteria criteria list Empl List empls v. test Test2 age>25 vi. List<Empl>empls=dept. querybyqbc( ) age 25) 002 id 1 2,3 1. a)

41 i. oracle Empl, sql b) hibernate \ \ \ HibernateDemo31 ecplise 2. a) HQL i. dao EmplImpl EmplImpl i iv. querybyhqlrange() Session session = sf.opensession(); sql from Empl e where e.id in(1,2,3) id 1,2,3 ( not int between and. ) not between.and. session createquery sql query query list() Empl List empls empls v. test Test1 b) QBC i. dao EmplImpl EmplImpl i iv. querybyqbcrange() Criteria criteria=session.createcriteria(empl.class); Restrictions in String arg0 Object[] arg1 Criterion criterion 1. arg0 id 2. arg1 id 1,2,3 new Integer[]{1,2,3} 3. not between not between criteria add criterion criteria criteria list Empl List empls empls v. test Test2

42 003 name e 1. a) i. oracle Empl, sql b) hibernate \ \ \ HibernateDemo32 ecplise 2. a) HQL i. dao EmplImpl EmplImpl i iv. querybyhql() Session session = sf.opensession(); sql from Empl e where e.name like '%e%' name e like session createquery sql query query list() Empl List empls empls v. test Test1 b) QBC

43 i. dao EmplImpl EmplImpl querybyqbc i iv. () QBC Criteria criteria=session.createcriteria(empl.class); Restrictions like String arg0 String arg1 Criterion criterion 1. arg0 name 2. arg1 name e %e% criteria add criterion criteria criteria list Empl List empls v. test Test2 004 name m id>1 age>25 1. a) i. oracle Empl, sql b) hibernate \ \ \ HibernateDemo33 ecplise 2. a) HQL

44 i. dao EmplImpl EmplImpl i iv. querybyhql() Session session = sf.opensession(); sql from Empl e where e.name like '%m%'and e.id>1 or e.age>25 name m id>1 age>25 like session createquery sql query query list() Empl List empls empls v. test Test1 b) QBC i. dao EmplImpl EmplImpl querybyqbc () QBC i iv. Criteria criteria=session.createcriteria(empl.class); Restrictions and(lhs, rhs) 1. lhs Restrictions.like("name", "%m%") name m 2. rhs Restrictions.gt("id", 1)) id>1 Restrictions or(lhs, rhs) Criterion criterion 1. lhs and Restrictions.and(Restrictions.like("name", "%m%"), Restrictions.gt("id", 1)) name e id>1 2. rhs Restrictions.gt("age", 25) age>25 criteria add criterion criteria v. criteria list Empl List vi. v empls empls test Test2

45 Hibernate fetch select: 2. fetch subselect: sql ) ( sql 3. fetch join lazy= true no session depts DeptImpl session no session fetch join 1. a) Dept Empl

46 i. oracle Empl, sql 1. oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo35 ecplise 2. (Dept Empl Dept Empl Set empllist a) i. fetch select i 1. entity Dept.hbm.xml 2. lazy fetch select 3. test Test1 fetch select n+1 n deptid>1, 3 sql fetch subselect 1. entity Dept.hbm.xml 2. lazy fetch subselect 3. test Test1 fetch subselect n sql fetch join 1. entity Dept.hbm.xml 2. lazy ture lazy fetch join 3. test Test1 Query list fetch join lazy= true

47 HQL 2. QBC 1. a) Dept Empl i. oracle Empl, sql 1.

48 oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo36 ecplise 2. (Dept Empl Dept Empl Set empllist a) HQL i i. test Test1 IDeptDao deptdao=new DeptImpl(); iv. sql from Dept d left join fetch d.empllist left join fetch HashSet set list 1. HashSet set=new HashSet(list); for list HashSet set v. b) QBC i. dao DeptImpl querydeptbyqbccollection() i iv. Criteria criteria=session.createcriteria(dept.class); criteria setfetchmode(string arg0,fetchmode arg1) 1. arg0 empllist dept empl 2. arg1 FetchMode.JOIN test Test2 1. HashSet set list HashSet set=new HashSet(list); for list HashSet set v.

49 HQL 3 deptid=3 2. HQL 3. QBC age>25 Mike Mike SAL

50 1. a) Dept Empl i. oracle Empl, sql 1. oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo37 ecplise 2. (Dept Empl Dept Empl Set empllist a) HQL i. test Test1 IDeptDao deptdao=new DeptImpl(); sql from Dept d left join d.empllist left join b) HQL i. test Test1 sql sql from Dept d inner join d.empllist inner join

51 c) QBC i. DeptImpl querydeptbyqbccollection(int age) Criteria criteria=session.createcriteria(dept.class) i iv. Criteria criteria=session.createcriteria(dept.class) criteria criteriaalias String arg0 String arg1 1. arg0 empllist 2. arg1 E Restrictions ge String propertyname Object value criteria add criteria 1. propertyname E.age ( EmplList age E) 2. value age querydeptbyqbccollection(int age) age test Test2 v. List list=deptdao.querydeptbyqbccollection( ); HQL 2. HQL id>1

52 1. a) Dept Empl i. oracle Empl, sql 1. oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo39 ecplise 2. (Dept Empl empl dept ) a) i. test Test1 IEmplDao deptdao = new EmplImpl(); sql from Dept d inner join fetch d.empllist inner join fetch b) i. test Test2 IEmplDao empldao = new i EmplImpl(); IEmplDao empldao = new EmplImpl(); sql from Empl e where e.dept.deptid>1 id>1

53 a) Dept Empl i. oracle Empl, sql 1.

54 oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo40 ecplise 2. (Dept Empl Dept Empl ) a) i. test Test1 IEmplDao deptdao = new i iv. EmplImpl(); sql select e.id, e.name,e.age,d.deptid from Empl e join e.dept d where e.did=e.dept.deptid Empl id name age Dept deptid deptdao queryemplanddept(sql) List list list iterator Iterator it while it hasnext it v. it next Object vi. v array id name age deptid int id=(integer) array[0]; String name=(string) array[1]; int age=(integer)array[2]; int deptid=(integer)array[3]; b) i. entity EmplAndDept i set get 1. private int id; 2. private String name; 3. private int age; 4. private int deptid; test Test2 sql sql 1. Test1 sql

55 iv. 2. sql new packagename.classname(param1 param2 param3..) 3. sql Select new com.oracle.entity.emplanddept(e.id, e.name,e.age,d.deptid)from Empl e join e.dept d where e.did=e.dept.deptid while hasnext it v. it next EmplAndDept array vi. v 1. array getid() int id 2. array getname String name 3. array getage int age 4. array getdeptid int deptid

56 Hibernate a) Restrictions b) QBE 1. a) i. oracle Empl, sql 1.

57 b) hibernate \ \ \ HibernateDemo42 ecplise 2. a) i.restrictions 1. dao emplimpl queryemplqbc() Criteria criteria=session.createcriteria(empl.class); 2. Restrictions like(string propertyname String value,matchmode matchmode) a) propertyname name b) value o c) matchmode MatchMode.ANYWHERE 3. criteria list List list 4. list 5. test Test1 Test1. QBE 1. dao emplimpl queryemplqbe(empl empl) Criteria criteria=session.createcriteria(empl.class); 2. Example create Object arg empl Example example 3. example enablelike MatchMode.ANYWHERE 4. example ignorecase 5. criteria add example 6. criteria list List list 7. list 8. test Test2 IEmplDao empldao = new EmplImpl(); empl 9. empl setname String arg O name O 10. Test2. sql 11. entity Empl

58 12. id age did Integer set get 13. Test a) Dept Empl i. oracle Empl, sql 1. oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo43 ecplise 2.

59 i. dao emplimpl Session session = i iv. sf.opensession(); session get Class arg0 Serializable arg1 Dept, dept get 1. arg0 Dept.class 2. arg1 deptid session createfilter arg0 arg1 Query query 1. arg0 dept.getempllist() 2. arg1 sql 1. query setfirstresult int arg arg 0 2. quer y setmaxresult int arg arg 2 query list List list v. list b) test Test1 String sql= id>1, sql where id>1 c) deptdao queryempllist(serializable deptid,string sql) Empl List list 1 sql d) a) exists

60 b) elements a) Dept Empl i. oracle Empl, sql 1. oracle Dept sql 1. b) hibernate \ \ \ HibernateDemo44 ecplise 2.

61 a) 1 i. test Test1 String sql= sql, sql from Dept d where (select count(e) from d.empllist e)>1 b) i. exists 1. test Test1 sql from Dept d where exists( from d.empllist e) 2. elements 1. test Test1 sql from Dept d where:empl in elements(d.empllist) (empl ) 2. EmplImpl Query query=session.createquery(sql); setentity(string arg0,object arg1); query a) arg0 sql empl b) arg1 new Empl(1,"BOB",18,2) 3. test Test1 c) size 1 i. dao EmplImpl query.setentity("empl", new i Empl(1,"BOB",18,2)); test Test1, sql from Dept d where d.empllist.size>1 Test a)

62 i. oracle Empl, sql 1. b) hibernate \ \ \ HibernateDemo47 ecplise 2. a) i. ehcache jar i ehcache-core jar hibernate-ehcache final.jar slf4j-api jar classpath hibernate \ \ \ ehcache.xml HibernateDemo47 src hibernate.cfg.xml session-factory iv. dao EmplImpl querybycache() Query query= session.createquery("from Empl e where e.age>25 ") v. query setcacheable true vi. v vi ix. query list session createquery( from Empl e where e.age>25 ) Query query query1 setcacheable true query list List list x. list xi. test Test1 sql

63 Log4j 2. Hibernate.cfg.xml hibernate.properties 1. a) i. oracle Empl, sql 1.

64 b) \ \ \ HibernateDemo50 ecplise 2. a) Log4j i. log4j jar HibernateDemo50 lib lib log4j-1.2,12.jar, >Bulid Path >Add to Build Path 1. src log4j.properties a) b) c) i iv. test Test1 public static void main(string[] args) final public static final Logger getlogger arg logger arg Test1.class IEmplDao deptdao=new EmplImpl(); logger info(string arg) dao EmplImpl List list= criteria.list(); Test1 logger debug String arg arg

65 v. test Test1 HibernateDemo50 HibernateDemo50 iotek.log b) Hibernate.cfg.xml hibernate.properties i. src hibernate.cfg.xml hibernate.properties 1. hibernate.cfg.xml show_sql true sql 2. hibernate.properties hibernate. show_sql false sql dao EmplImpl i iv. config.configure("/hibernate.cfg.xml"); config addclass Empl.class test Test1 sql show_sql true hibernate.cfg.xml hibernate.properties hibernate.cfg.xml hibernate.properties Hibernate API JDBC 1. a) i. oracle Empl, sql 1.

66 b) \ \ \ HibernateDemo51 ecplise 2. a) hibernate.cfg.xml session-factory property JDBC i. <property name="hibernate.transaction.factory_class">org.hibernate.transaction.jd BCTransactionFactory</property> b) dao emplimpl Session session = sf.opensession(); session begintransaction() Transaction tr c) session get id 1 Empl empl d) empl setdid int arg empl did 3 e) tr commit f) empl g) test Test1 sqldeveloper Empl id 1 did

67 1. a) i. oracle Account, sql 1. b) \ \ \ HibernateDemo53 ecplise 2. HibernateDemo53 dao BussinessCheckService BussinessService BussinessCheckService 100 BussinessService 100 test Test1 start a) test Test b) dao BussinessCheckService Account account=(account) session.get(account.class, 1); get(account.class,1) session.get(account.class, 1,LockMode.UPGRADE); LockMode.UPGRADE

68 c) BussinessService Account account=(account) session.get(account.class, 1); get(account.class,1) session.get(account.class, 1,LockMode.UPGRADE); d) Test1 004 hibernate 1. Hibernate a) ecplise b) 2. Hibernate a) Ecplise b) 1. a) i. oracle Account, sql 1.

69 b) \ Hibernate \ \ HibernateDemo54 ecplise 2. a) Hibernate i. test firstcache i iv. Account account1=(account) session.load(account.class, 1); session evict(object arg); account1 account1 session load id 1 Account account2 account1==account2 false session contains account1 account2 contains v. account1 setbalance(int arg); account1 balance vi. v vi no session account1 session no session account1 setbalance account2 setbalance(int arg); account1 balance id 1 balance b) Hibernate i. ehcache jar i ehcache-core jar hibernate-ehcache final.jar slf4j-api jar classpath ehcache.xml src ehcache xml hibernate.cfg.xml session-factory iv. entity Account.hbm.xml Account.hbm.xml class id v. test secondcache session.close() vi. session sf opensession session session begintransaction() Transaction tr

70 v vi ix. session get(account.class, 1); id 1 Account account2 account2 setbalance int arg balance 2000 tr commit x. session xi. x secondcache sql balnance