|
1 package jimm.datavision.testdata.odbc;
2 import jimm.datavision.testdata.Office;
3 import jimm.datavision.testdata.Job;
4 import jimm.datavision.testdata.AggregateTestData;
5 import java.util.Iterator  ;
6 import java.util.Calendar ;
7
8
12 class CreateData {
13
14 public static void main(String [] args) {
15 System.out.println("delete from office;");
16 for (Iterator iter = Office.offices(); iter.hasNext(); ) {
17 Office o = (Office)iter.next();
18 System.out.println("insert into office values (" + o.id + ", '"
19 + o.name + "', '" + o.abbrev + "', '" + o.fax
20 + "', '" + o.email + "', "
21 + (o.visible ? 1 : 0) + ");");
22 }
23
24 System.out.println("delete from jobs;");
25 for (Iterator iter = Job.jobs(); iter.hasNext(); ) {
26 Job j = (Job)iter.next();
27 System.out.println("insert into jobs values (" + j.id + ", '"
28 + j.title + "', " + j.fk_office_id + ", '"
29 + j.company + "', '" + j.location + "', '"
30 + j.description + "', "
31 + (j.visible ? 1 : 0) + ", '"
32 + j.post_date.get(Calendar.YEAR) + '-'
33 + j.post_date.get(Calendar.MONTH) + '-'
34 + j.post_date.get(Calendar.DATE) + "', "
35 + (j.hourly_rate == null ? "NULL"
36 : j.hourly_rate.toString())
37 + ");");
38 }
39
40 System.out.println("delete from aggregate_test;");
41 for (Iterator iter =
42 AggregateTestData.aggregateTestData("../aggregate_test.dat");
43 iter.hasNext(); ) {
44 AggregateTestData data = (AggregateTestData)iter.next();
45 System.out.println("insert into aggregate_test values ('" + data.col1()
46 + "', '" + data.col2() + "', " + data.value()
47 + ");");
48
49 }
50 }
51
52 }
53 |
Popular Tags |
Java API By Example, From Geeks To Geeks.