应用步骤
在J2EE应用,使用Torque的步骤如下:
1. 系统分析和设计,直至Business Object;
2. 按照Business Object模型,形成数据库脚本文件database.sql;
3. 编写$Torque_home/build.properties;
4.编写$Torque_home/schema/project-schema.xml及$Torque_home/schema/id-table-schema.xml,或者将database.sql拷贝到$Torque_home/schema/schema.sql, 在$Torque_home下运行ANT生成对应的schema.xml文件运行语句为:ant -f build-torque.xml sql2xml;
5. 编写$Torque_home/Torque.properties;
6. 调用Torque生成对象模型,创建数据库和相关表(利用ANT):
◆ ant -f build-torque.xml
◆ ant -f build-torque.xml create-db
◆ ant -f build-torque.xml id-table-init-sql
◆ ant -f build-torque.xml insert-sql
7. 修改*.java和*Peer.java,加入业务逻辑处理;
8. 开发J2EE应用。
注意问题
Torque在文档中提供了一个教程,可以帮助开发人员了解Torque的用法,也提供了一个完整的示例。但是,在使用Torque的J2EE开发中,还需要注意以下问题:
◆ Torque的初始化只能进行一次:Torque.init(“Torque.properties”)。如果是采用Central Controller,则在Servlet的init方法中进行初始化比较合适。
◆ 需要配置运行时的数据库连接,配置信息在Torque.properties中。下面是采用Torque的old pool、Jdbc2Pool、JNDI及ConnectionPoolDataSource等各种形式的配置文件:
## Using torque's old pool
#torque.dsfactory.MMCycle.factory=org.apache.
torque.dsfactory.TorqueDataSourceFactory
#torque.dsfactory.MMCycle.pool.defaultMax-Connections=10
#torque.dsfactory.MMCycle.pool.maxExpiry-Time=3600
#torque.dsfactory.MMCycle.pool.connection-WaitTimeout=10
#torque.dsfactory.MMCycle.connection.driver=
com.microsoft.jdbc.sqlserver.SQLServerDriver
#torque.dsfactory.MMCycle.connection.url=jdbc:microsoft:
sqlserver://DB1:1433;DatabaseName=MMCycle;SelectMethod=cursor
#torque.dsfactory.MMCycle.connection.user = sa
#torque.dsfactory.MMCycle.connection.password = (7MOR6pa2)
## Using Jdbc2Pool
#torque.dsfactory.bookstore.factory=
# org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory
#torque.dsfactory.bookstore.pool.defaultMaxActive
=10
#torque.dsfactory.bookstore.pool.testOnBorrow
=true
#torque.dsfactory.bookstore.pool.validationQuery
=SELECT 1
#torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.bookstore.connection.url =
jdbc:mysql://localhost:3306/torque
#torque.dsfactory.bookstore.connection.user = user
#torque.dsfactory.bookstore.connection.password = password
## Using jndi
#torque.dsfactory.bookstore.factory=org.apache.
torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.bookstore. jndi.path=jdbc/bookstore
#torque.dsfactory.bookstore.jndi.java.naming.
factory.initial = org.apache.naming.java.java-URLContextFactory
#torque.dsfactory.bookstore.jndi.java.naming.
factory.url.pkgs = org.apache.naming
#torque.dsfactory.bookstore.datasource.classname=
org.apache.torque.pool.TorqueClassicDataSource
#torque.dsfactory.bookstore.datasource.
dataSourceName=jdbc/DBbookstore
#torque.dsfactory.bookstore.datasource.jndi-Environment.java.naming.factory.initial
=org.apache.naming.java.javaURLContextFactory
#torque.dsfactory.bookstore.datasource.jndi-Environment.java.naming.factory.url.pkgs
=org.apache.naming
#torque.dsfactory.bookstore.datasource.default-MaxConnections=10
## ConnectionPoolDataSource
#torque.dsfactory.bookstore.factory=
org.apac-he.torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.bookstore.jndi.path=jdbc/DBbookstore
#torque.dsfactory.bookstore.jndi.java.naming.
factory.initial = org.apache.naming.java.
javaURLContextFactory
#torque.dsfactory.bookstore.jndi.java.naming.
factory.url.pkgs = org.apache.naming
#torque.dsfactory.bookstore.datasource.classname=
org.apache.commons.dbcp.cpdsadapter.Driver-AdapterCPDS
#torque.dsfactory.bookstore.datasource.driver =
org.gjt.mm.mysql.Driver
#torque.dsfactory.bookstore.datasource.url =
jdbc:mysql://localhost:3306/torque
#torque.dsfactory.bookstore.datasource.user = user
#torque.dsfactory.bookstore.datasource.password =
password
结论
对于大多数采用RDMS作为数据存储手段的J2EE项目来说,Torque简单、易用, 是Persistence层的优秀解决方案之一。
|
|
 |
| 快速搜索通道 |
 |
|