(请教)……XML与数据库的结构和数据的转换方式？

pillow

我怎么也想不通他们之间是什么样的关系……
但是公司让我尽快熟悉这个问题——
XML与数据库的结构和数据的转换方式？
不知如何下手，希望大家帮忙讲解，谢谢……
鞠躬了……      

joint

<table>;
<schema>;
  <column>;
     <name />;
     <type />;
     <null />;
     <primary />;
  </column>;
...
</schema>;
<data>;
<row>;
    <column = value />;
    <column = value />;
....
</row>;
<row>;
    <column = value />;
    <column = value />;
....
</row>;
....
</data>;
</table>;

cinc

试试 dbunit，一个数据库测试工具，好像可以做到你想要的：
download:
http://sourceforge.net/projects/dbunit


export a dataset from your database

1. 
   
2. public class DatabaseExportSample
   
3. {
   
4.     public static void main(String[] args) throws Exception
   
5.     {
   
6.         // database connection
   
7.         Class driverClass = Class.forName("org.hsqldb.jdbcDriver");
   
8.         Connection jdbcConnection = DriverManager.getConnection(
   
9.                 "jdbc:hsqldb:sample", "sa", "");
   
10.         IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
    
11. 
    
12.         // partial database export
    
13.         String[] tableNames = {"TABLE1", "TABLE2", "TABLE2"};
    
14.         IDataSet partialDataSet = connection.createDataSet(tableNames);
    
15.         FlatXmlDataSet.write(partialDataSet, new FileOutputStream("partial.xml"));
    
16. 
    
17.         // full database export
    
18.         IDataSet fullDataSet = connection.createDataSet();
    
19.         FlatXmlDataSet.write(fullDataSet, new FileOutputStream("full.xml"));
    
20.     }
    
21. }
    

复制代码

generate a DTD representing your database schema

1. 
   
2. public class DatabaseExportSample
   
3. {
   
4.     public static void main(String[] args) throws Exception
   
5.     {
   
6.         // database connection
   
7.         Class driverClass = Class.forName("org.hsqldb.jdbcDriver");
   
8.         Connection jdbcConnection = DriverManager.getConnection(
   
9.                 "jdbc:hsqldb:sample", "sa", "");
   
10.         IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
    
11. 
    
12.         // write DTD file
    
13.         FlatDtdDataSet.write(connection.createDataSet(),                new FileOutputStream("test.dtd"));    }
    
14. }
    

复制代码

pillow

谢谢楼上二位……
看来想短时间了解是很难了
我去好好学习……
谢谢……
鞠躬……