Castor:基于XML的Java开源数据绑定框架(支援JDO)

官方网站：http://www.castor.org/index.html

所需Jar包一览：

castor-1.2.jar
castor-1.2-anttasks.jar
castor-1.2-codegen.jar
castor-1.2-ddlgen.jar
castor-1.2-jdo.jar
castor-1.2-xml.jar
castor-1.2-xml-schema.jar
jdbc-se2.0.jar
jta1.0.1.jar
xerces-J_1.4.0.jar
commons-logging-1.1.jar
mysql-connector-java-5.1.6-bin.jar
log4j-1.2.13.jar

 

castor.properties

1. # Example properties indent the output, require validation
2. # on input and turn debugging on.
3. #
4. org.exolab.castor.validation=false
5. org.exolab.castor.indent=true
6. org.exolab.castor.debug=true
8. # True if database configuration should be initalization
9. # when loading it (default: true).
10. #
11. #org.exolab.castor.jdo.DatabaseInitializeAtLoad=true
13. # 
14. # TransactionManagerFactory implementations
15. # 
16. org.castor.transactionmanager.Factories=/
17.   org.castor.transactionmanager.WebSphereTransactionManagerFactory,/
18.   org.castor.transactionmanager.WebSphere5TransactionManagerFactory,/
19.   org.castor.transactionmanager.WebSphere51TransactionManagerFactory,/
20.   org.castor.transactionmanager.LocalTransactionManagerFactory,/
21.   org.castor.transactionmanager.JNDIENCTransactionManagerFactory,/
22.   org.castor.transactionmanager.JOTMTransactionManagerFactory
24. #
25. # Shell the TransactionManager be initialized at registration or lazily when
26. # requested for the first time? Defaults to false.
27. #
28. org.castor.transactionmanager.InitializeAtRegistration=false

工程布局：

 

jdo-conf.xml

1. <?xml version="1.0" ?>
2. <!DOCTYPE jdo-conf PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version 1.0//EN"
3.  "http://castor.org/jdo-conf.dtd">
5. <jdo-conf>
7.     <database name="castordb" engine="mysql" >
8.     
9.         <driver url="jdbc:mysql://localhost:3306/castordb" 
10.             class-name="com.mysql.jdbc.Driver">
11.             <param name="user" value="root" />
12.             <param name="password" value="root" />
13.         </driver>
14.         
15.         <mapping href="jdo/mapping.xml" />
16.         
17.     </database>
18.     
19.     <transaction-demarcation mode="local">
20.         <transaction-manager name="local" />
21.     </transaction-demarcation>
23. </jdo-conf>

mapping.xml

1. <?xml version="1.0" ?>
2. <!DOCTYPE mapping PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
3.                            "http://castor.org/mapping.dtd">
4. <mapping>
5.     <class name="myapp.ProductGroup" identity="id">
6.         <description>Product group</description>
7.         <map-to table="prod_group" xml="group" />
8.         <field name="id" type="integer">
9.             <sql name="id" type="integer" />
10.             <bind-xml node="attribute" />
11.         </field>
12.         <field name="name" type="string">
13.             <sql name="name" type="char" dirty="check" />
14.             <bind-xml node="text" />
15.         </field>
16.     </class>
18.     <class name="myapp.Product" identity="id">
19.         <description>Product definition</description>
20.         <map-to table="prod" xml="product" />
21.         <field name="id" type="integer">
22.             <sql name="id" type="integer" />
23.             <bind-xml name="id" node="attribute" />
24.         </field>
25.         <field name="name" type="string">
26.             <sql name="name" type="char" />
27.             <bind-xml name="name" node="element" />
28.         </field>
29.         <field name="price" type="float">
30.             <sql name="price" type="numeric" />
31.             <bind-xml name="price" node="element" />
32.         </field>
33.         <field name="group" type="myapp.ProductGroup">
34.             <sql name="group_id" />
35.             <bind-xml name="group" node="element" />
36.         </field>
37.         <field name="details" type="myapp.ProductDetail" required="true"
38.             collection="vector">
39.             <sql many-key="prod_id" />
40.             <bind-xml name="detail" node="element" />
41.         </field>
42.         <field name="categories" type="myapp.Category" required="true" collection="vector">
43.             <sql name="category_id" many-table="category_prod"
44.                 many-key="prod_id" />
45.             <bind-xml name="category" node="element" />
46.         </field>
47.     </class>
49.     <class name="myapp.ProductDetail" identity="id" depends="myapp.Product">
50.         <description>Product detail</description>
51.         <map-to table="prod_detail" xml="detail" />
52.         <field name="id" type="integer">
53.             <sql name="id" type="integer" />
54.             <bind-xml node="attribute" />
55.         </field>
56.         <field name="product" type="myapp.Product">
57.             <sql name="prod_id" />
58.             <bind-xml name="product" node="element" reference="true" />
59.         </field>
60.         <field name="name" type="string">
61.             <sql name="name" type="char" />
62.             <bind-xml node="text" />
63.         </field>
64.     </class>
66.     <class name="myapp.Computer" extends="myapp.Product" identity="id">
67.         <description>
68.             Computer definition, extends generic product
69.         </description>
70.         <map-to table="computer" xml="computer" />
71.         <field name="id" type="integer">
72.             <sql name="id" type="integer" />
73.             <bind-xml name="id" node="attribute" />
74.         </field>
75.         <field name="cpu" type="string">
76.             <sql name="cpu" type="char" />
77.             <bind-xml node="element" />
78.         </field>
79.     </class>
81.     <class name="myapp.Category" identity="id">
82.         <description>
83.             A product category, any number of products can belong to the
84.             same category, a product can belong to any number of
85.             categories
86.         </description>
87.         <map-to table="category" xml="category" />
88.         <field name="id" type="integer">
89.             <sql name="id" type="integer" />
90.             <bind-xml />
91.         </field>
92.         <field name="name" type="string">
93.             <sql name="name" type="char" />
94.             <bind-xml node="element" />
95.         </field>
96.         <field name="products" type="myapp.Product" required="true"
97.             collection="vector">
98.             <sql name="prod_id" many-table="category_prod"
99.                 many-key="category_id" />
100.             <bind-xml name="product" node="element" />
101.         </field>
102.     </class>
103. </mapping>

Category.java

1. package myapp;
3. import java.util.Vector;
6. public class Category {
7.     
8.     private int _id;
9.     private Vector<Product> _products = new Vector<Product>();
10.     private String _name;
12.     public int getId(){
13.         return _id;
14.     }
16.     public void setId( int id ) {
17.         _id = id;
18.     }
20.     
21.     public String getName() {
22.         return _name;
23.     }
26.     public void setName( String name ){
27.         _name = name;
28.     }
30.     public Vector<Product> getProducts() {
31.         return _products;
32.     }
35.     public void addProduct( Product product ) {
36.         
37.         if ( ! _products.contains( product ) ) {
38.             System.out.println( "Adding product " + product + " to category " + this );
39.             _products.addElement( product );
40.             product.addCategories( this );
41.         }
42.     }
44.     public String toString() {
45.         return "<id: " + _id + " name: " + _name + ">";
46.     }
47. }

Computer.java

1. package myapp;
3. import org.exolab.castor.jdo.TimeStampable;
5. public class Computer extends Product implements TimeStampable {
6.     
7.     private String _cpu;
8.     private long _timeStamp;
9.     
10.     public String getCpu() {
11.         return _cpu;
12.     }
14.     public void setCpu(String cpu) {
15.         _cpu = cpu;
16.     }
18.     public void jdoSetTimeStamp(long timeStamp) {
19.         _timeStamp = timeStamp;
20.     }
22.     public long jdoGetTimeStamp() {
23.         return _timeStamp;
24.     }
26.     public String toString() {
27.         return "<id: " + getId() + " name: " + getName() + " price: "
28.                 + getPrice() + " cpu: " + _cpu + ">";
29.     }
30. }

Product.java

1. package myapp;
3. import java.util.Vector;
4. import org.exolab.castor.jdo.Database;
5. import org.exolab.castor.jdo.Persistent;
6. import org.exolab.castor.jdo.TimeStampable;
7. import org.exolab.castor.mapping.AccessMode;
9. public class Product implements Persistent, TimeStampable {
10.     
11.     private int _id;
12.     private String _name;
13.     private float _price;
14.     private ProductGroup _group;
15.     private long _timeStamp;
16.     private Vector<ProductDetail> _details = new Vector<ProductDetail>();
17.     private Vector<Category> _categories = new Vector<Category>();
19.     public int getId() {
20.         return _id;
21.     }
23.     public void setId(final int id) {
24.         _id = id;
25.     }
27.     public String getName() {
28.         return _name;
29.     }
31.     public void setName(final String name) {
32.         _name = name;
33.     }
35.     public float getPrice() {
36.         return _price;
37.     }
39.     public void setPrice(final float price) {
40.         _price = price;
41.     }
43.     public ProductGroup getGroup() {
44.         return _group;
45.     }
47.     public void setGroup(final ProductGroup group) {
48.         _group = group;
49.     }
51.     public ProductDetail createDetail() {
52.         return new ProductDetail();
53.     }
55.     public Vector<ProductDetail> getDetails() {
56.         return _details;
57.     }
59.     public void addDetail(final ProductDetail detail) {
60.         _details.add(detail);
61.         detail.setProduct(this);
62.     }
64.     public Vector<Category> getCategories() {
65.         return _categories;
66.     }
68.     public void addCategories(final Category category) {
69.         if (!_categories.contains(category)) {
70.             _categories.addElement(category);
71.             category.addProduct(this);
72.         }
73.     }
75.     public void jdoPersistent(final Database db) {
76.     }
78.     public void jdoTransient() {
79.     }
81.     public Class<Computer> jdoLoad(final AccessMode accessMode) {
82.         
83.         if (_name.indexOf("PC") >= 0) {
84.             return Computer.class;
85.         }
86.         return null;
87.     }
89.     public void jdoBeforeCreate(final Database db) {
90.     }
92.     public void jdoAfterCreate() {
93.     }
95.     public void jdoStore(final boolean modified) {
96.     }
98.     public void jdoBeforeRemove() {
99.     }
101.     public void jdoAfterRemove() {
102.     }
104.     public void jdoUpdate() {
105.     }
107.     public void jdoSetTimeStamp(final long timeStamp) {
108.         _timeStamp = timeStamp;
109.     }
111.     public long jdoGetTimeStamp() {
112.         return _timeStamp;
113.     }
115.     public String toString() {
116.         return "<id: " + _id + " name: " + _name + " price: " + _price + ">";
117.     }
118. }

ProductDetail.java

1. package myapp;
3. public class ProductDetail {
5.     private int _id;
6.     private Product _product;
7.     private String _name;
9.     public int getId() {
10.         return _id;
11.     }
13.     public void setId(int id) {
14.         _id = id;
15.     }
17.     public String getName() {
18.         return _name;
19.     }
21.     public void setName(String name) {
22.         _name = name;
23.     }
25.     public Product getProduct() {
26.         return _product;
27.     }
29.     public void setProduct(Product product) {
30.         _product = product;
31.     }
33.     public String toString() {
34.         return "<id: " + _id + " name: " + _name + ">";
35.     }
36. }

ProductGroup.java

 

1. package myapp;
3. public class ProductGroup {
5.     private int _id;
6.     private String _name;
8.     public int getId() {
9.         return _id;
10.     }
12.     public void setId(int id) {
13.         _id = id;
14.     }
16.     public String getName() {
17.         return _name;
18.     }
20.     public void setName(String name) {
21.         _name = name;
22.     }
24.     public String toString() {
25.         return "<id: " + _id + " name: " + _name + ">";
26.     }
27. }

测试代码：

CastorDemo.java

1. package jdo;
3. import java.sql.Connection;
4. import java.sql.Statement;
6. import myapp.Category;
7. import myapp.Computer;
8. import myapp.Product;
9. import myapp.ProductDetail;
10. import myapp.ProductGroup;
12. import org.exolab.castor.jdo.Database;
13. import org.exolab.castor.jdo.JDOManager;
14. import org.exolab.castor.jdo.OQLQuery;
15. import org.exolab.castor.jdo.QueryResults;
16. import org.exolab.castor.mapping.Mapping;
18. public class CastorDemo {
20.     private static final String DATABASE_NAME = "castordb";
21.     public static final String JDO_CONFIG_FILE = "jdo-conf.xml";
22.     public static final String MAPPING_FILE = "mapping.xml";
23.     
24.     public static void main(String[] args) throws Exception {
25.         
26.         Mapping mapping = new Mapping(CastorDemo.class.getClassLoader());
27.         mapping.loadMapping(CastorDemo.class.getResource(MAPPING_FILE));
28.         
29.         String jdoConf = CastorDemo.class.getResource(JDO_CONFIG_FILE).toString();
30.         JDOManager.loadConfiguration(jdoConf);
31.         JDOManager manager = JDOManager.createInstance(DATABASE_NAME);
32.         Database db = manager.getDatabase();
33.         
34.         createTable(manager);
35.         
36.         db.begin();
37.         ProductGroup group = new ProductGroup();
38.         group.setId( 3 );
39.         group.setName( "a group" );
40.         db.create( group );
41.         Product product = new Product();
42.         product.setId( 4 );
43.         product.setName( "product4" );
44.         product.setPrice( 200 );
45.         product.setGroup( group );
46.         ProductDetail detail = new ProductDetail();
47.         detail.setId( 1 );
48.         detail.setName( "keyboard" );
49.         product.addDetail( detail );
50.         detail = new ProductDetail();
51.         detail.setId( 2 );
52.         detail.setName( "mouse" );
53.         product.addDetail( detail );
54.         detail = new ProductDetail();
55.         detail.setId( 3 );
56.         detail.setName( "monitor" );
57.         product.addDetail( detail );
58.         db.create( product );
59.         
60.         Category category = new Category();
61.         category.setId( 1 );
62.         category.setName( "category" + category.getId() );
63.         category.addProduct( product );
64.         db.create( category );
65.         
66.         Computer computer = new Computer();
67.         computer.setId( 7 );
68.         computer.setCpu( "Pentium" );
69.         computer.setName( "MyPC" );
70.         computer.setPrice( 400 );
71.         computer.setGroup( group );
72.         detail = new ProductDetail();
73.         detail.setId( 4 );
74.         detail.setName( "network card" );
75.         computer.addDetail( detail );
76.         detail = new ProductDetail();
77.         detail.setId( 5 );
78.         detail.setName( "scsi card" );
79.         computer.addDetail( detail );
80.         db.create(computer);
81.      
82.         db.commit();
84.         //======================================================
85.         
86.         db.begin();
87.         OQLQuery productOql = db.getOQLQuery( "SELECT p FROM myapp.Product p WHERE p.id > $1" );
88.         productOql.bind( 1 );
89.         QueryResults results = productOql.execute();
90.         while(results.hasMore()) {
91.             product = ( Product ) results.next();
92.             System.out.println(product.getName());
93.             //db.remove( product );
94.         }
95.         db.commit();
96.         
97.         //======================================================
98.         
99.         db.begin();
100.         product = ( Product ) db.load( Product.class, 7 );
101.         System.out.println(product.getName() + " " + product.getPrice());
102.         db.commit();
103.         
104.         db.begin();
105.         product.setPrice(700);
106.         db.update(product);
107.         db.commit();
108.         
109.         //======================================================
110. //      Marshaller marshaller = new Marshaller( new PrintWriter(System.out));
111. //      marshaller.setMapping( mapping );
112. //      marshaller.marshal(product);
113. //              
114. //      db.begin();
115. //      OQLQuery computerOql = db.getOQLQuery( "SELECT c FROM myapp.Computer c WHERE c.id >= $1" );
116. //      computerOql.bind( 7 );
117. //      results = computerOql.execute();
118. //      
119. //      while( results.hasMore() )
120. //           marshaller.marshal( results.next() );
121. //      db.commit();
122.         
123.         db.close();
124.       
125. //        MappingRoot mappingRoot = mapping.getRoot();
126. //        ClassMapping classMap;
127. //        FieldMapping fieldMap;
128. //        FieldMapping[] fieldMaps;
129. //        int mappingCount = mappingRoot.getClassMappingCount();
130. //        for ( int i = 0; i < mappingCount; ++i ){
131. //            classMap = mappingRoot.getClassMapping( i );
132. //            fieldMaps = classMap.getClassChoice().getFieldMapping();
133. //            for ( int j = 0; j < fieldMaps.length; ++j ){
134. //                fieldMap = fieldMaps[j];
135. //                System.out.println("        Field name: " + fieldMap.getName());
136. //                System.out.println("        Field type: " + fieldMap.getType());
137. //            }
138. //        }
139.     }
140.     
141.     public static void createTable(JDOManager manager) throws Exception {
142.         
143.         Database db = manager.getDatabase();
144.         db.begin();
145.         Connection connection = db.getJdbcConnection();
146.         Statement statement = connection.createStatement();
147.         statement.executeUpdate("create table prod (id int not null, name varchar(200) not null, price numeric(18,2) not null,  group_id int not null)");
148.         statement.executeUpdate("create table prod_group (id int not null, name varchar(200) not null)");
149.         statement.executeUpdate("create table prod_detail (id int not null, prod_id int not null, name varchar(200) not null)");
150.         statement.executeUpdate("create table computer (id int not null, cpu varchar(200) not null)");
151.         statement.executeUpdate("create table category (id int not null, name varchar(200) not null)");
152.         statement.executeUpdate("create table category_prod (prod_id int not null, category_id int not null)");
153.         db.commit();
154.         db.close();
155.     }
156. }

Castor和Spring集成： http://www.castor.org/spring-orm-integration.html

Castor介绍资料：

http://www.ibm.com/developerworks/cn/xml/x-xjavacastor1/

http://www.ibm.com/developerworks/cn/xml/x-xjavacastor2/

http://www.ibm.com/developerworks/cn/xml/x-xjavacastor3/

http://www.ibm.com/developerworks/cn/xml/x-xjavacastor4/