|
1 package allinone;
2
3 import com.lutris.appserver.server.sql.*;
4 import org.enhydra.dods.*;
5 import allinone.data.*;
6
7
8
9 public class MultiReference2 {
10 void showTables(DBTransaction dbTrans){
11 try{
12 TableAQuery queryA = new TableAQuery(dbTrans);
13 TableADO[] allADO = queryA.getDOArray();
14 System.err.println();
15 System.err.println("-------------TableA-----begin----------");
16 if(allADO!=null) {
17 if(allADO.length>0)System.err.println("---oid------someData------");
18 for(int i=0; i<allADO.length; i++){
19 System.err.print(" "+allADO[i].get_Handle());
20 System.err.print(" "+allADO[i].getSomedata());
21 System.err.println();
22 }
23 } else {
24 System.err.println("noData");
25 }
26 System.err.println("-------------TableA-----end------------");
27
28 TableBQuery queryB = new TableBQuery(dbTrans);
29 TableBDO[] allBDO = queryB.getDOArray();
30 System.err.println();
31 System.err.println("-------------TableB-----begin----------");
32 if(allBDO!=null) {
33 if(allBDO.length>0)System.err.println("---oid------someData------ref-----ref-----");
34 for(int i=0; i<allBDO.length; i++){
35 System.err.print(" "+allBDO[i].get_Handle());
36 System.err.print(" "+allBDO[i].getSomedata());
37 System.err.print(" "+(null != allBDO[i].getReftoa()?allBDO[i].getReftoa().getHandle():"null"));
38 System.err.print(" "+(null != allBDO[i].getReftob()?allBDO[i].getReftob().getHandle():"null"));
39 System.err.println();
40 }
41 } else {
42 System.err.println("noData");
43 }
44 System.err.println("-------------TableB-----end------------");
45
46 TableCQuery queryC = new TableCQuery(dbTrans);
47 TableCDO[] allCDO = queryC.getDOArray();
48 System.err.println();
49 System.err.println("-------------TableC-----begin----------");
50 if(allCDO!=null) {
51 if(allCDO.length>0)System.err.println("---oid------someData-------ref-----ref-----");
52 for(int i=0; i<allCDO.length; i++){
53 System.err.print(" "+allCDO[i].get_Handle());
54 System.err.print(" "+allCDO[i].getSomedata());
55 System.err.print(" "+(null != allCDO[i].getReftoa()?allCDO[i].getReftoa().getHandle():"null"));
56 System.err.print(" "+(null != allCDO[i].getReftob()?allCDO[i].getReftob().getHandle():"null"));
57 System.err.println();
58 }
59 } else {
60 System.err.println("noData");
61 }
62 System.err.println("-------------TableC-----end------------");
63
64 }catch(Exception  e){
65 e.printStackTrace();
66 }
67 }
68
69 public void runTest(DBTransaction dbTrans1) {
70 try {
71 boolean autoWrite = ((StandardDatabaseManager)DODS.getDatabaseManager()).getDatabaseManagerConfiguration().getAutoWrite();
72 System.err.println("___ - + * startin another MultRef * + - ___");
73 showTables(dbTrans1);
74
75 TableADO tableA1 = TableADO.createVirgin(dbTrans1);
76 tableA1.setSomedata("tableA1");
77 tableA1.save();
78 if(!autoWrite)
79 dbTrans1.write();
80
81 TableBDO tableB1 = TableBDO.createVirgin(dbTrans1);
82 tableB1.setSomedata("tableB1");
83 tableB1.setReftoa(tableA1);
84 tableB1.save();
85 TableBDO tableB4 = TableBDO.createVirgin(dbTrans1);
86 tableB4.setSomedata("tableB4");
87 tableB4.setReftoa(tableA1);
88 tableB4.setReftob(tableB1);
89 tableB4.save(dbTrans1);
90 if(!autoWrite)
91 dbTrans1.write();
92
93 TableCDO tableC1 = TableCDO.createVirgin(dbTrans1);
94 tableC1.setSomedata("tableC1");
95 tableC1.setReftob(tableB4);
96 tableC1.save();
97 if(!autoWrite)
98 dbTrans1.write();
99
100 System.err.println("rows inserted");
101 showTables(dbTrans1);
102
103 System.err.print("delete1 --- ");
104 tableA1.delete(dbTrans1);
105 if(!autoWrite)
106 dbTrans1.write();
107
108 if (null != dbTrans1)
109 dbTrans1.commit();
110
111 System.err.println("that's all folks, table are empty now, I hope :) ");
112 showTables(dbTrans1);
113 }catch (Exception ex){
114 System.err.println(ex.toString());
115 ex.printStackTrace();
116 }
117 }
118 }
119 |
Popular Tags |
Java API By Example, From Geeks To Geeks.