ValueHolder... 9 Customer.java Oracle TopLink 10g(10.1.3) È Volume3 2

Size: px

Start display at page:

Download "ValueHolder... 9 Customer.java Oracle TopLink 10g(10.1.3) È Volume3 2"

なごみやまのかみしゃ
6 years ago
Views:

1 lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume3 Creation Date: Mar 04, 2005 Last Update: Aug 23, 2005 Version 1.0

2 ValueHolder... 9 Customer.java Oracle TopLink 10g(10.1.3) È Volume3 2

3 Oracle TopLink TopLink Java - TopLink Java ~ O/R Java å JDBC š TopLink TopLink gå å Ò å p{ /URL toplink.jar java -version Ø nç < > Windows Ø Ê UNIX/Linux Oracle TopLink 10g(10.1.3) È Volume3 3

4 Oracle TopLink 10g(10.1.3) Volume2 O/R ~ TopLink Volume1 Volume2 TopLink SQL JDBC ~ JDBC m Web 3 Ê TopLink ~ XML ~ ¾ / ~ XML ~ Workbench SampleApp stage sessions.xml [ ] [ ] [JDBC ] [ Oracle TopLink 10g(10.1.3) È Volume3 4

] [ ] { 1 SampleClient.java main try nç 6 try { sampleclient.readallsample(); sampleclient.querysample(); sampleclient.cachesample(); sampleclient.createsample(); sampleclient.

5 ] [ ] { 1 SampleClient.java main try nç 6 try { sampleclient.readallsample(); sampleclient.querysample(); sampleclient.cachesample(); sampleclient.createsample(); sampleclient.updatesample(); sampleclient.deletesample(); } catch (Exception e) { SampleClient.java setupsample.sql SampleClient SQL å ---- readallsample() ---- [TopLink Finer]:--initialize identitymaps -- Customer -- [TopLink Fine]: --SELECT ID, NAME, ADDR_ID FROM CUSTOMER [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [1] Oracle TopLink 10g(10.1.3) È Volume3 5

6 [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [2] [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [3] -- Customer (Address,Phone) -- [ 1: ] [ 1: ] [TopLink Fine]: --SELECT P_NUMBER, ID, CUST_ID FROM PHONE WHERE (CUST_ID =?) bind => [1] [ 1: ] [ 2: ] À å ½ TopLink ~ ½ À å readallsample() 3 Customer Address Phone 7 å ---- readallsample() ---- [TopLink Finer]:--initialize identitymaps -- Customer -- [TopLink Fine]: --SELECT ID, NAME, ADDR_ID FROM CUSTOMER [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [1] [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [2] [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [3] -- Customer (Address,Phone) -- [ 1: ] [ 1: ] [TopLink Fine]: --SELECT P_NUMBER, ID, CUST_ID FROM PHONE WHERE (CUST_ID =?) bind => [1] [ 1: ] [ 2: ] [ 2: ] [ 2: ] [TopLink Fine]: --SELECT P_NUMBER, ID, CUST_ID FROM PHONE WHERE (CUST_ID =?) bind => [2] [ 3: ] [ 3: ] [ 3: ] [TopLink Fine]: --SELECT P_NUMBER, ID, CUST_ID FROM PHONE WHERE (CUST_ID =?) bind => [3] [ 4: ] ---- readallsample() ---- Oracle TopLink 10g(10.1.3) È Volume3 6

7 å ½ ñ «Customer CUSTOMER ADDRESS À Address ~ ~ TopLink ~ ~ ~ ~ Workbench SampleApp mw SampleProject.mwp Customer Address 1 1 ~ [ ] 2 o ~ 1 «å ~ ~ ~ ~ ~ Oracle TopLink 10g(10.1.3) È Volume3 7

8 Customer Phone 1 o ~ [ ] 3 ~ Mapping Workbench SampleProject [ ] [ XML] XML setupsamle.sql SampleClient readallsample() 7 å CUSTOMER ADDRESS PHONE readallsample() ---- [TopLink Finer]:--initialize identitymaps -- Customer -- [TopLink Fine]: --SELECT t1.id, t1.name, t1.addr_id, t0.id, t0.city, t0.street FROM ADDRESS t0, CUSTOMER t1 WHERE (t0.id = t1.addr_id) -- Customer (Address,Phone) -- [ 1: ] [ 1: ] [TopLink Fine]: --SELECT t0.p_number, t0.id, t0.cust_id FROM PHONE t0, CUSTOMER t1 WHERE (t0.cust_id = t1.id) [ 1: ] [ 2: ] [ 2: ] [ 2: ] [ 3: ] Oracle TopLink 10g(10.1.3) È Volume3 8

9 [ 3: ] [ 3: ] [ 4: ] ---- readallsample() ---- ~ ½ querysample() ---- querysample() ---- [TopLink Finer]: --initialize identitymaps -- Customer -- [TopLink Fine]: --SELECT t1.id, t1.name, t1.addr_id, t0.id, t0.city, t0.street FROM ADDRESS t0, CUSTOMER t1 WHERE ((t0.city =?) AND (t0.id = t1.addr_id)) bind => [ ] -- Customer (Address,Phone) -- [ 1: ] [ 1: ] [TopLink Fine]: --SELECT t0.p_number, t0.id, t0.cust_id FROM PHONE t0, ADDRESS t2, CUSTOMER t1 WHERE (((t0.cust_id = t1.id) AND (t2.city =?)) AND (t2.id = t1.addr_id)) bind => [ ] [ 1: ] [ 2: ] [ 2: ] [ 2: ] [ 3: ] ---- querysample() ---- TopLink Devevloper's Guide 11. Optimization - Query Optimization ValueHolder Customer Address 1 1 Customer Phone 1 o 1 1 ValueHolder Oracle TopLink 10g(10.1.3) È Volume3 9

10 nç ValueHolder Customer Address ValueHolder 1 o ValueHolder TopLink Devevloper's Guide 33. Understanding Mappings - Mapping Concepts 1. address š~ nç Customer address š ~ setter/getter nç Customer.java package sample; import java.util.collection; import java.util.vector; import oracle.toplink.indirection.valueholder; import oracle.toplink.indirection.valueholderinterface; public class Customer { /** ( ) */ private int id; /** */ private String name; /** * ValueHolder Address * 1 1 */ private ValueHolderInterface address; /** 1 */ private Collection phones; /** * */ public Customer() { this.name = ""; //ValueHolder this.address = new ValueHolder(); this.phones = new Vector(); } public void setaddress(address address) { Oracle TopLink 10g(10.1.3) È Volume3 10

11 //ValueHolder this.address.setvalue(address); } public Address getaddress() { //ValueHolder return (Address)address.getValue(); } } 2. Workbench ~ Customer.java nç Workbench SampleApp mw SampleProject.mwp Customer [ ] ~ ~ ñ 4 3. address š ~ nç Customer address š [ ] [ ] phones š ~ ~ Oracle TopLink 10g(10.1.3) È Volume3 11

12 5 address š 4. XML address š ~ nç XML SampleApp stage 5. setupsample.sql SampleClient ~ ValueHolder Customer ADDRESS Address address š À ---- readallsample() ---- [TopLink Finer]:--initialize identitymaps -- Customer -- [TopLink Fine]: --SELECT ID, NAME, ADDR_ID FROM CUSTOMER -- Customer (Address,Phone) -- [ 1: ] [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [1] [ 1: ] [TopLink Fine]: --SELECT t0.p_number, t0.id, t0.cust_id FROM PHONE t0, CUSTOMER t1 WHERE (t0.cust_id = t1.id) [ 1: ] [ 2: ] [ 2: ] Oracle TopLink 10g(10.1.3) È Volume3 12

13 [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [2] [ 2: ] [ 3: ] [ 3: ] [TopLink Fine]: --SELECT ID, CITY, STREET FROM ADDRESS WHERE (ID =?) bind => [3] [ 3: ] [ 4: ] ---- readallsample() ---- ¾ Workbench ~ ~ ~ ~ ~ / ~ TopLink Devevloper's Guide 11. Optimization - Query Optimization Oracle TopLink 10g(10.1.3) È Volume3 13

14 TopLink Volumn1 Volume3 TopLink o O/R ~ Ž j å å SQL TopLink TopLink TopLink O/R TopLink Devevloper's Guide Oracle TopLink 10g(10.1.3) È Volume3 14

TopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç..

TopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç.. lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume2 Creation Date: Mar 04, 2005 Last Update: Aug 22, 2005 Version 1.0 ...3... 3 TopLink å...4 1... 4... 4 SampleClient.java... 5 Ò... 8... 9... 10 readallsample()... 11