#眉標=Open source小說連載
#副標=開放原始碼之軟體工程(6)
#大標=面對資料庫的再變動
#作者=文／Mark Ho

=========程式========
程式1
<pathelement path="lib/dom4j-1.4.jar" />
<pathelement path="lib/c3p0-0.8.5pre4.jar" />
<pathelement path="lib/odmg-3.0.jar" />
=========程式========


=========程式========
程式2
<taskdef 
name="hbm2ddl" 
classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask" classpathref="class.path" />
=========程式========


=========程式========
程式3
<target name="ddlgen">
<hbm2ddl
config="./hibernate.cfg.xml"
delimiter=";"
drop="no" 
quiet="yes"
text="yes" 
output="export.sql">
</hbm2ddl>			
</target>
=========程式========


=========程式========
程式4
[hbm2ddl] Initializing c3p0 pool... 
com.mchange.v2.c3p0.PoolBackedDataSource…
=========程式========


=========程式========
程式5
  [hbm2ddl] drop table if exists news;
  [hbm2ddl] drop table if exists category;
  [hbm2ddl] create table news (
  [hbm2ddl]    news_id int(11),
…
=========程式========


=========程式========
程式6
<many-to-one 
name="parent_cat"
column="parent_cat"/>

<set name="sub_categories" 
inverse="true" 
cascade="delete-orphan">
<key column="parent_cat"/>
<one-to-many class="CategoryBean"/>
</set>
=========程式========


=========程式========
程式7
<set name="sub_news" inverse="true" 
cascade="delete-orphan">
	<key column="news_category"/>
	<one-to-many class="NewsBean"/>
</set>
=========程式========



=========程式========
程式8
<many-to-one 
name="news_category"
column="news_category"
outer-join="true"
class="CategoryBean"/>
=========程式========



=========程式========
SQL語法1
ALTER TABLE news 
ADD INDEX xxx (news_category), 
ADD CONSTRAINT xxx 
FOREIGN KEY (news_category) 
REFERENCES category (cat_id);
ALTER TABLE category 
ADD INDEX xxx (parent_cat), 
ADD CONSTRAINT FK XXX
  FOREIGN KEY (parent_cat) 
REFERENCES category (cat_id);
=========程式========