Torque 使用详解

Toeque=B5=C4=CA=B9=D3=C3=CF=EA=BD=E2
 Torque=CA=C7=D4=DAJ2EE=D3=A6=D3=C3=D6=D0
=B5=C4Persistence Layer=B5=C4=BD=E2=
 =BE=F6=B7=BD=B0=B8=A1=A3=D6=F7=D2=AA=D3=
C3=D3=DAObject Relation Mapping =BD=
 =E2=BE=F6=B7=BD=B0=B8=BC=F2=B3=C6ORM=A1=
A3

=BC=F2=BD=E9
Torque=CA=C7Apache Turbine Framework =CF=C2=B5=C4=D2=BB=B2=BF=B7=D6=A3=AC=
 =CF=D6=D4=DA=D2=D1=BE=AD=B6=C0=C1=A2=BF=
AA=C4=DC=D7=D4=D4=CB=D0=D0=B5=C4=B9=
 =A4=B3=CC=C1=CB=A3=AC=CB=FB=B0=FC=C0=A8=
C1=CB=CB=F9=D3=D0=B2=FA=C9=FA=B3=F6=
 =C0=B4=B5=C4OM=BA=CDPeer=C0=E0=A3=AC=BB=
B9=C4=DA=D6=C3=C1=CB=CA=FD=BE=DD=BF=
=E2=B5=C4=C1=AC=BD=D3=B3=D8=A1=A3

=CF=C2=D4=D8
=CF=C2=D4=D8=B5=D8=D6=B7
http://db.apache.org/torque
=C4=BF=C7=B0=B0=E6=B1=BE:
=093.1
=B0=B2=D7=B0
=CF=B5=CD=B3=D2=C0=BF=BF
=09JDK1.3=BB=F2=D5=DF=D2=D4=C9=CF
=09Ant 1.5=BB=F2=D5=DF=D2=D4=C9=CF
=B0=B2=D7=B0=B2=BD=D6=E8=A3=BA
1=A3=AE=09=BD=E2=BF=AATorque-gen-3.1.zip=CE=C4=BC=FE
2=A3=AE=09=D0=DE=B8=C4Torque-gen-3.1=C4=BF=C2=BC=CF=C2=B5=C4build.propertie=
s=CE=C4=BC=FE
& #61548;=09=D0=DE=B8=C4=B9=A4=B3=CC=B5=C4
=C3=FB=B3=C6
torque.project =3D bookstore
& #61548;=09=D0=DE=B8=C4=CA=FD=BE=DD=BF=E2
=B5=C4=C0=E0=D0=CD
 =A3=A8=BF=C9=D1=A1=B5=C4=CA=FD=BE=DD=BF=
E2=C0=E0=D0=CD=D3=D0
axion, cloudscape, db2, db2400, hypersonic, interbase, mssql,mysql, oracle,=
postgresql, sapdb, sybase=A3=A9
torque.database =3D oracle
& #61548;=09=D0=DE=B8=C4OM=09=C0=E0=B5=C4=
B0=FC=BD=E1=B9=B9
torque.targetPackage =3D com.sincetomes.om
& #61548;=09=D0=DE=B8=C4=CA=FD=BE=DD=BF=E2
=B5=C4=D0=C5=CF=A2
 =D2=D4=C9=CF=C3=E6=D0=DE=B8=C4=B5=C4Orac
le=CE=AA=C0=FD=D7=D3
torque.database.createUrl =3D jdbc:oracle:thin:@localhost:1521:ORCL
torque.database.buildUrl =3D jdbc:oracle:thin:@localhost:1521:ORCL
torque.database.url =3D jdbc:oracle:thin:@localhost:1521:ORCL
torque.database.driver =3D oracle.jdbc.driver.OracleDriver
torque.database.user =3D username
torque.database.password =3Dpassword
torque.database.host =3D localhost
3=A3=AE=09=CC=ED=BC=D3schema.xml=CE=C4=BC=FE

 =D2=D4=C9=CF=C3=E6=B5=C4=C0=FD=D7=D3=CE=
AA=C0=FD
project=3D bookstore
=C4=C7=C3=B4=CE=C4=BC=FE=CA=C7bookstore-schema.xml=B4=E6=B7=C5=D4=DATorque-=
gen-3.1/schema/=C4=BF=C2=BC=CF=C2
 =BC=D9=C9=E8=D3=D0=C1=BD=D5=C5=B1=ED=C8=
E7=CF=C2=B6=A8=D2=E5
=09<?xml version=3D"1.0" encoding=3D"GBK" standalone=3D"no"?>
=09=09<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3=
_1.dtd">
=09=09<database name=3D"bookstore"><!---=D7=A2=D2=E2=D5=E2=C0=EF=D0=B4=B5=
=C4=CA=C7=B9=A4=B3=CC=B5=C4=C3=FB=B3=C6-->
=09=09=09<table name=3D"User" idMethod=3D"native" description=3D"=D3=C3=BB=
=A7=B1=ED">
=09=09=09=09< !=A1=AAid=3D=A1=AFnative=A1=AF=BE=CD=CA=
C7=BF=B4=CA=FD=BE=DD=
 =BF=E2=B1=BE=CA=A1=B5=C4=BB=FA=D6=C6orac
le=B2=FA=C9=FASequence =B1=ED=C3=FB=
_seq-->
=09=09=09=09<column name=3D"userid" required=3D"true" primaryKey=3D"true" t=
ype=3D"INTEGER" autoIncrement=3D"true" description=3D"=D3=C3=BB=A7ID"/>
=09=09=09=09< !=A1=AA=D7=A2=D2=E2autoIncrement=3D=A1=A
Ftrue=A1=AF=B1=ED=CA=
=BE=D7=D4=D4=F6-->
=09=09=09=09<column name=3D"username" required=3D"true" size=3D"255" type=
=3D"VARCHAR" description=3D"=D3=C3=BB=A7=C3=FB"/>
=09=09=09=09<column name=3D"password" required=3D"true" size=3D"255" type=
=3D"VARCHAR" description=3D"=C3=DC=C2=EB"/>
=09=09=09<unique name=3D"username_uq">
=09=09=09=09<unique-column name=3D"username"/>
=09=09=09</unique>
=09=09</table>
=09=09<table name=3D"userAction" idMethod=3D"native" description=3D"=D3=C3=
=BB=A7=CF=FB=B7=D1=D0=D0=CE=AA=B1=ED">
=09=09=09<column name=3D"ActionID" required=3D"true" primaryKey=3D"true" ty=
pe=3D"INTEGER" autoIncrement=3D"true" description=3D"=D3=C3=BB=A7ID"/>
=09=09=09<column name=3D"userid" required=3D"true" type=3D"INTEGER" descrip=
tion=3D"=D3=C3=BB=A7ID"/>
=09=09=09=09<foreign-key foreignTable=3D"User" onDelete=3D"restrict" name=
=3D"user_fk">
=09=09=09< !=A1=AA=BA=CD=C9=CF=B1=ED=B5=C4=CD=E2=BC
=FC=B9=D8=CF=B5-->
=09=09=09=09<reference local=3D"userid" foreign=3D"userid"/>
=09=09=09=09</foreign-key>
=09=09</table>
</database>
 4=A3=AE=09=09=D4=CB=D0=D0Ant=B2=FA=C9=FA
=C0=E0=BA=CD=CA=FD=BE=DD=BF=E2=BD=
=C5=B1=BE=BA=CD=C6=E4=CB=FB
=09=D7=BC=B1=B8=BB=B7=BE=B3
set JAVA_HOME=3DC:\Jbuild9\JDK1.4.1
set  ANT_HOME=3DC:\JBuilder9\thirdparty\apach
e-ant-1.6.1
set PATH=3D%path%;% JAVA_HOME %\bin;% ANT_HOME %\bin
& #61550;=09=B2=FA=C9=FA=CA=FD=BE=DD=BF=E2
=BD=C5=B1=BE
=09=09ant =A8Cf build-torque.xml sql
=09=09=D4=DATorque-gen-3.1/src/sql/ =CF=C2=BB=E1=B2=FA=C9=FA=D2=BB=B8=F6book
=
store-schema.sql=CE=C4=BC=FE
=09=09=B2=FA=C9=FAOM=C0=E0
ant =A8Cf build-torque.xml om
=D4=DATorque-gen-3.1/src/java/ =B4=F8=D3=D0=B0=FC=BD=E1=B9=B9=B5=C4Java
=C0=
=E0=A3=AC=C8=E7=CF=C2=CD=BC
=09=20
 =09=09=09=D5=E2=D0=A9=CA=C7=CA=FD=BE=DD=
BF=E2=B6=D4=D3=A6=B5=C4=CA=B5=CC=E5=
=B2=D9=D7=F7=C0=E0=A1=A3
& #61550;=09=09=B2=FA=C9=FA=CA=FD=BE=DD=BF
=E2=D7=D6=B5=E4
ant =A8Cf build-torque.xml doc

=D4=DATorque-gen-3.1/src/doc/ =CE=C4=BC=FE=CF=C2=BB=E1=B2=FA=C9=FA=D2=
BB=B8=
=F6bookstore-schema.html
=CF=EA=CF=B8=D0=C5=CF=A2=A3=BA
Table Name=09OM Class=09Description
User
User=09=D3=C3=BB=A7=B1=ED
userAction
 Useraction=09=D3=C3=BB=A7=CF=FB=B7=D1=D0
=D0=CE=AA=B1=ED
User
=D3=C3=BB=A7=B1=ED=20
 Name=09Type=09Size=09Default=09JavaName=
09PK=09FK=09not null=09Description
userid=09INTEGER=09 =09 =09Userid=09X =09  =09X =09=D3=C3=BB=A7ID
username=09VARCHAR=09(255) =09 =09Username=09  =09  =09X =09=D3=C3=BB=A7=C3=
=FB
password=09VARCHAR=09(255) =09 =09Password=09  =09  =09X =09=C3=DC=C2=EB
userAction
 =D3=C3=BB=A7=CF=FB=B7=D1=D0=D0=CE=AA=B1=
ED=20
 Name=09Type=09Size=09Default=09JavaName=
09PK=09FK=09not null=09Description
ActionID=09INTEGER=09 =09 =09Actionid=09X =09  =09X =09=D3=C3=BB=A7ID
userid=09INTEGER=09 =09 =09Userid=09  =09X =09X =09=D3=C3=BB=A7ID

& #61550;=09=09=09=CA=FD=BE=DD=BF=E2=B5=C4
=B4=B4=BD=A8
ant =A8Cf build-torque.xml create-db
ant =A8Cf build-torque.xml insert-sql

 =B0=D1=B8=D5=B2=C5=CA=FD=BE=DD=BF=E2=B4=
B4=BD=A8=B3=F6=C0=B4=B5=C4=BD=C5=B1=
 =BE=B2=E5=C8=EB=B5=BD=CA=FD=BE=DD=BF=E2=
D6=D0=A3=AC=D7=A2=D2=E2=D0=E8=D2=AA=
 =B0=D1=CA=FD=BE=DD=BF=E2=B5=C4=C7=FD=B6=
AF=BC=D3=D4=D8=B5=BDTorque-gen-3.1/=
lib/=B5=C4=C4=BF=C2=BC=CF=C2
=CA=B9=D3=C3=BD=CC=B3=CC
 1=A3=AE=09=B4=B4=BD=A8=D4=CB=D0=D0=B5=C4
=C5=E4=D6=C3=CE=C4=BC=FEtorque.prop=
erties
=CC=ED=BC=D3=C4=DA=C8=DD
 #log4j=B5=C4=C5=E4=D6=C3(=BF=C9=D1=A1=A3
=AC=BF=C9=D2=D4=B2=BB=D3=C3=C5=E4=
=D6=C3)
log4j.rootCategory =3D DEBUG, default
log4j.appender.default =3D org.apache.log4j.FileAppender
log4j.appender.default.file =3D ./torque.log
log4j.appender.default.layout =3D org.apache.log4j.SimpleLayout
 #torque=B5=C4=CA=FD=BE=DD=BF=E2=D0=C5=CF
=A2
torque.database.default =3D bookstore
torque.database.bookstore.driver =3D oracle.jdbc.driver.OracleDriver
torque.database.bookstore.url =3D jdbc:oracle:thin:@localhost:1521:ORCL
torque.database.bookstore.username =3D user
torque.database.bookstore.password =3D password
## Using commons-dbcp=20
torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.SharedPool=
DataSourceFactory
#torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.PerUserPo=
olDataSourceFactory
torque.dsfactory.bookstore.pool.defaultMaxActive=3D10
torque.dsfactory.bookstore.pool.testOnBorrow=3Dtrue
#torque.dsfactory.bookstore.pool.validationQuery=3DSELECT 1
torque.dsfactory.bookstore.connection.driver =3D oracle.jdbc.driver.OracleD=
river
torque.dsfactory.bookstore.connection.url =3D jdbc:oracle:thin:@localhost:1=
521:ORCL
torque.dsfactory.bookstore.connection.user =3D user
torque.dsfactory.bookstore.connection.password =3D password
=A3=A3other infomation
torque.idbroker.cleverquantity=3Dtrue
torque.manager.useCache =3D true
2=A3=AE=09=CA=B9=D3=C3=CA=B5=C0=FD
i.=09=B3=F5=CA=BC=BB=AFTorque.ini(=A1=B0torque.properties=A1=B1)
ii.=09insert
=CA=B5=CC=E5=C0=E0=B2=D9=D7=F7
=09User user =3D new User()
=09user.setUsername(=A1=B0test=A1=B1);
=09user.setPassword(=A1=B0password=A1=B1);
=09user.isNew();
=09try{
=09=09user.save();
=09}catch(TorqueException e){}
Peer=C0=E0=B2=D9=D7=F7
=09User user =3D new User()
=09user.setUsername(=A1=B0test=A1=B1);
=09user.setPassword(=A1=B0password=A1=B1);
=09try{
=09=09UserPeer.doInsert(user);
=09}catch(TorqueException e){}
iii.=09update
=CA=B5=CC=E5=C0=E0=B2=D9=D7=F7
User user =3D =A1=AD
=09user.setUsername(=A1=B0test=A1=B1);
=09user.setPassword(=A1=B0password=A1=B1);
=09user.setModify(true);
=09try{
=09=09user.save();
=09}catch(TorqueException e){}
Peer=C0=E0=B2=D9=D7=F7
=09User user =3D new User()
=09user.setUsername(=A1=B0test=A1=B1);
=09user.setPassword(=A1=B0password=A1=B1);
=09try{
=09=09UserPeer.doUpdate(user);
}catch(TorqueException e){}
iv.=09delete
=09=09UserPeer.doDelete(user);
=09=09=BB=F2=D5=DF
=09=09UserPeer.doDelete(criteria);
v.=09select
 =D0=E8=D2=AA=CC=D8=B1=F0=B5=C4=D7=A2=D2=
E2org.apache.torque.util.Criteria=
=D5=E2=B8=F6=C0=E0=20
Criteria criteria =3D new Criteria();
criteria.add(UserPeer. USERNAME,=A1=B1test=A1=B1);
List list =3D null;
Try{
list =3D UserPeer.doSelect(criteria);
=09=09=09=09}catch(TorqueException e){}
=09=09=09for(int i=3D0l;i<list.size;i++){
=09=09=09=09User user =3D (User)list.get(i);
=09=09=09=09Log.debug(=A1=B0UserID:=A1=B1+User. getUserid());
=09=09=09=09Log.debug(=A1=B0UserName:=A1=B1+user.getUserName())
=09=09=09=09Log.debug(=A1=B0Password:=A1=B1+user.getPassword());
}
=B4=B4=BD=A8Join
criteria.addJoin(UseractionPeer.USERID,UserPeer.USERID);
=B4=B4=BD=A8Distinct
criteria. setDistinct();
=C5=C5=D0=F2
criteria.addAscendingOrderByColum(UserPeer.USERID);//=C9=FD=D0=F2
criteria.addDescendingOrderByColum(UserPeer.USERID)=A3=BB//=BD=B5=D0=F2
 Criteria=B8=BD=B4=F8=C1=CB=D0=ED=B6=E0=B
5=C4=B7=BD=B7=A8=A3=AC=D6=F7=D2=AA=
=B5=C4=C8=E7=CF=C2=A3=BA
Criteria.ALT_NOT_EQUAL
Criteria.CUSTOM
Criteria.DISTINCT
Criteria.EQUAL
Criteria.GREATER_EQUAL
Criteria.GREATER_THAN
Criteria.IN
Criteria.JOIN
Criteria.LESS_EQUAL
Criteria.LESS_THAN
Criteria.LIKE
Criteria.NOT_EQUAL
Criteria.NOT_IN
 =09=CE=AA=C1=CB=B8=FC=C1=E9=BB=EE=B5=C4=
B8=F8=D3=C3=BB=A7=BF=D8=D6=C6=CA=FD=
 =BE=DD=BF=E2=B5=C4=B2=D9=D7=F7,=CF=B5=CD
=B3=BB=B9=CC=E1=B9=A9=C1=CB=D7=D4=
=D0=B4SQL=D3=EF=BE=E4=B5=C4=BD=E1=B9=B9
=C8=E7=A3=BAcriteria.add(UserPeer.USERNAME,(Object)=A1=B1test=A1=B1, Criter=
ia.CUSTOM)
=B5=C8=CD=ACselect * from user where username=3D=A1=AFtest=A1=AF
 =09=D2=D4=C9=CF=CB=B5=B5=C4=CA=C7=CA=B5=
CC=E5=B6=D4=CF=F3=B5=C4=B2=D9=D7=F7=
=A1=A3
 =BD=D3=CF=C2=C0=B4=CE=D2=C3=C7=BD=B2=CA=
F6=D2=BB=CF=C2=B7=C7=CA=B5=CC=E5=B6=
=D4=CF=F3=B2=D9=D7=F7=B5=C4=C0=FD=D7=D3
criteria.addJoin(UseractionPeer.USERID,UserPeer.USERID);
=09criteria.addSelectColumn(UserPeer.USERNAME);
=09criteria.addSelectColumn(UserPeer.PASSWORD) //=D5=E2=C0=EF=B1=ED=CA=BEUs=
 erAction=B1=ED=D6=D0=B5=C4=C6=E4=CB=FB=D
7=D6=B6=CE
=09criteria.addSelectColumn(UseractionPeer.USERID)
=09criteria.addSelectColumn(UseractionPeer.XXX) //=D5=E2=C0=EF=B1=ED=CA=BEU=
 serAction=B1=ED=D6=D0=B5=C4=C6=E4=CB=FB=
D7=D6=B6=CE
=09=A1=AD..
=09List list =3D null;
=09Try{
=09=09list =3D org.apache.torque.util.BasePeer.doSelect(criteria);
=09}catch(TorqueException e){}
 =09=D6=F7=D2=AA=D1=A1=C8=A1=B3=F6=C0=B4=
B5=C3=B2=BB=CA=C7=CA=B5=CC=E5=B6=D4=
=CF=F3=B6=F8=CA=C7com..workingdogs.village.Record=B6=D4=CF=F3
=09for(int i=3D0;i<list.size;i++){
=09=09com..workingdogs.village.Record record =3D (com..workingdogs.village.=
Record)
=09=09list.get(i);
=09=09// =BB=F1=C8=A1=B6=D4=CF=F3=D6=D0=B5=C3=D6=
B5
=09=09Log.debug(=A1=B0userid:=A1=B1+record.getValue(=A1=B0userid=A1=B1).asI=
nt());
=09=09Log.debug(=A1=B0Username:=A1=B1+record.getValue(=A1=B0username=A1=B1)=
asString());
=09=09Log.debug(=A1=B0Password:=A1=B1+record.getValue(=A1=B0passwod=A1=B1).=
asString());
}
 =09=B6=D4=D3=DA=B8=B4=BA=CF=B2=E9=D1=AF=
D0=E8=D2=AA=D7=A2=D2=E2=B5=C4=D2=BB=
 =B5=E3=CA=C7criteria=D5=E2=B8=F6=B6=D4=C
F=F3=B1=D8=D0=EB=D6=D8=D0=C2=B9=B9=
 =D4=EC=D2=BB=B4=CE=A3=AC=CF=C2=C3=E6=BE=
D9=B8=F6=C0=FD=D7=D3
 =09=C8=E7=CE=D2=C3=C7=CF=EB=B2=E9=D1=AFu
serid>100 and userid<500 =D6=AE=BC=
=E4=B5=C4=CA=FD=BE=DD
 =09=09=CA=D7=CF=C8=C9=E8=D6=C3=B5=DA=D2=
BB=B8=F6=CA=FD=BE=DD
=09=09criteria.add(UserPeer.USERID,100, Criteria. GREATER_THAN);
 =09=BD=D3=CF=C2=C0=B4=B4=B4=BD=A8=C1=ED=
CD=E2=D2=BB=B8=F6
=09Criteria.Criterion cr =3D criteria.getCriterion(UserPeer.USERID=A3=BB
=09cr.add(criteria.getNewCriterion(cr.getTable(),cr.getColum(),new Integer(=
500), Criteria.LESS_EQUAL)
=09List list =3D UserPeer.doSelect(criteria);

=B1=E0=B3=CC=D0=C4=B5=C3=A3=BA
1. =09=D4=DA=CA=B5=CC=E5=C0=E0=D6=D0=C3=BB=
D3=D0=BF=B4=B5=BD=CA=FD=BE=DD=BF=
 =E2=B5=C4=D2=BB=CF=B5=C1=D0=D0=C5=CF=A2=
A3=AC=BD=A8=D2=E9=C8=E7=B9=FB=D2=BB=
 =B8=F6=CA=FD=BE=DD=D0=E8=D2=AA=B6=E0=B4=
CE=BA=CD=CA=FD=BE=DD=BF=E2=B5=C4=BD=
 =BB=BB=A5=A3=AC=D7=D4=BC=BA=BB=F1=C8=A1=
CA=FD=BE=DD=BF=E2=C1=AC=BD=D3=A1=A3
 =09=BB=F1=C8=A1=C1=AC=BD=D3=B5=C4=B7=BD=
B7=A8=A3=BA
=09java.sql.Connection con =3D null;
=09try{
=09=09org.apache.torque.Torque.inif(=A1=B0torque.properties=A1=B1);
=09=09con =3D org.apache.torque.getConnection();
=09}catch(TorqueException e){}
=09
 =09=BD=D3=CF=C2=C0=B4=B2=BB=B9=DC=CA=C7i
nsert,update,delete=B5=C4=B7=BD=B7=
 =A8=D6=D0=CC=ED=BC=D3=CA=FD=BE=DD=B5=C4=
B5=C4=C1=AC=BD=D3=B6=D4=CF=F3
=09
=09=C8=E7:
=09=09user.save(con);
=09=09BasePeer.doSelect(cri,con);
=09=B5=C8
=09
=09=D6=AE=BA=F3=BE=CD=CA=C7
=09Torque.closeConnection(con);
2. =09=B6=D4=D3=DA=B3=F5=D1=A7=D5=DF=A3=AC=
B2=BB=CF=B0=B9=DF=D5=E2=D6=D6=CA=
 =B5=CC=E5=B6=D4=CF=F3=B5=C4=B2=D9=D7=F7=
A3=AC=BF=C9=D2=D4=B6=E0=CA=B9=D3=C3=
BasePeer=D5=E2=B8=F6=C0=E0

 BasePeer=CC=E1=B9=A9=C1=CB=B6=E0=D6=D6=B
5=C4=B2=D9=D7=F7=A3=AC=C8=E7=D7=D4=
=BC=BA=B1=E0=D0=B4SQL
BasePeer.executeQuery(=A1=B0select * from =A1=AD.=A1=B1,con);
3. =09=B6=D4=D3=DA=CA=FD=BE=DD=C1=BF=B1=C8=
BD=CF=B4=F3=B5=C4select,Torque=CC=
 =E1=B9=A9=C1=CB=D2=BB=B8=F6=CA=B5=D3=C3=
C0=E0org.apache.torque.util.LargeSe=
lect
 =CF=EA=CF=B8=B5=C4=D3=C3=B7=A8=C7=EB=B2=
CE=BC=FBTorque-3.1=B5=C4API
=B3=A3=D3=C3=B5=C4=CA=C7=CA=B9=D3=C3org.apache.torque.util.Criteria=D5=E2=
 =B8=F6=C0=E0=D6=D0=B5=C4=C1=BD=B8=F6=CA=
F4=D0=D4
criteria.setLimit(10) // =C9=E8=D6=C3=C3=BF=B4=CE=D1=A1=C8=A1=D6=
BB=D3=D010=
=B8=F6
criteria.setOffset(5);// =C9=E8=D6=C3=CA=C7=B4=D3=B5=DA5=B8=F6=CA
=FD=BE=DD=
=BF=AA=CA=BC=C8=A1=CA=FD=BE=DD
4. =09=B1=BE=C8=CB=CF=B0=B9=DF=CA=B9=D3=C3X
ML=D7=F6=C5=E4=D6=C3=CE=C4=BC=FE
=BD=A8=D2=E9=CA=B9=D3=C3XML=CE=C4=BC=FE
 =C5=E4=D6=C3=CE=C4=BC=FE=B5=C4=CA=B5=C0=
FD
<?xml version=3D"1.0" encoding=3D"UTF-8"?>
<configuration>
=09<database>
=09=09<default>bookstore</default>
=09=09<bookstore>
=09=09=09<adapter>oracle</adapter>
=09=09</bookstore>
=09</database>
=09<dsfactory>
=09=09<bookstore>
=09=09=09<connection>
=09=09=09=09<driver>oracle.jdbc.driver.OracleDriver</driver>
=09=09=09=09<url>jdbc:oracle:thin:@localhost:1521:orcl</url>
=09=09=09=09<user>username</user>
=09=09=09=09<password>password</password>
=09=09=09</connection>
=09=09=09<factory>org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory</f=
actory>
=09=09=09<pool>
=09=09=09=09<defaultMaxActive>10</defaultMaxActive>
=09=09=09=09<testOnBorrow>true</testOnBorrow>
=09=09=09</pool>
=09=09</bookstore>
=09</dsfactory>
=09<idbroker>
=09=09<cleverquantity>true</cleverquantity>
=09</idbroker>
=09<manager>
=09=09<useCache>true</useCache>
=09</manager>
</configuration>

ConfigurationFactory factory =3D new ConfigurationFactory();
URL configURL =3D new File("config.xml").toURL();
factory.setConfigurationFileName(configURL.toString());
Configuration config =3D factory.getConfiguration();
=09=09org.apache.torque.Torque.inif(config);

 =B1=BE=C8=CB=CB=AE=C6=BD=D3=D0=CF=DE=A3=
AC=D3=D0=CA=B2=C3=B4=B2=BB=C3=F7=B0=
 =D7=B5=C4=B5=D8=B7=BD=BB=B9=CD=FB=CC=E1=
B3=F6=A3=AC=D2=D4=B1=E3=B8=C4=D5=FD=
 =A1=A3=D2=E2=BC=FB=BD=A8=D2=E9=C7=EB=B7=
A2=CB=CD=B1=BE=C8=CB=B5=C4=D3=CA=BC=
=FE=A3=AC=B5=D8=D6=B7xtshi@sincetimes.com.cn