[OJB-developers] how to use oql between clause in DATE type

[<cn_...@ya...>]

<!-- Mapping of User defined classes starts here -->
<!-- Please keep user defined mappings in this file
only,
     to avoid mixing user defined and system mappings.
-->

<!-- Mapping of User defined classes ends here -->

<ClassDescriptor id="1">

<class.name>com.tt.mall.mirage.SimpleLicense</class.name>
	<table.name>license</table.name>
	<FieldDescriptor id="1">
		<field.name>distributorId</field.name>
		<column.name>distributor_id</column.name>
		<jdbc_type>VARCHAR</jdbc_type>
		<PrimaryKey>true</PrimaryKey>
	</FieldDescriptor>
	<FieldDescriptor id="2">
		<field.name>ownerId</field.name>
		<column.name>owner_id</column.name>
		<jdbc_type>VARCHAR</jdbc_type>
		<PrimaryKey>true</PrimaryKey>
	</FieldDescriptor>
	<FieldDescriptor id="3">
		<field.name>domainId</field.name>
		<column.name>domain_Id</column.name>
		<jdbc_type>VARCHAR</jdbc_type>
		<PrimaryKey>true</PrimaryKey>
	</FieldDescriptor>
	<FieldDescriptor id="4">
		<field.name>status</field.name>
		<column.name>status</column.name>
		<jdbc_type>VARCHAR</jdbc_type>
	</FieldDescriptor>
	<FieldDescriptor id="5">
		<field.name>startTime</field.name>
		<column.name>start_time</column.name>
		<jdbc_type>DATE</jdbc_type>
	</FieldDescriptor>
	<FieldDescriptor id="6">
		<field.name>endTime</field.name>
		<column.name>end_time</column.name>
		<jdbc_type>DATE</jdbc_type>
	</FieldDescriptor>
</ClassDescriptor>
Date curDate = Calendar.getInstance().getTime();
String oql = "select license from " +
license.getClass().getName() + " where " + curDate + "
between startTime and endTime";
...

i want to express like sql:
String sql = "select * from license where
date_format('" + new
SimpleDateFormat("yyyy-mm-dd",curDate) +
"','%y-%M-%d') between startTime and endTime"; 

i don't know how to use a java.util.Date object and
between clause in oql...

anyone tell me oql manual appreciate...



   

_________________________________________________________
Do You Yahoo!? 
摊开你的掌心 让我看看你
http://sweepstakes.yahoo.com/2002cnuser