...
Code Block |
---|
<queryset name="BIRT" dateFormat="yyyy-MM-dd" xmlDateFormat="yyyy-MM-dd" xmlTimeStampFormat="MM/dd/yyyy">
<resource-def>
<url>jdbc:mysql://localhost/ClassicModels</url>
<driver>com.mysql.jdbc.Driver</driver>
<user>root</user>
<password/>
</resource-def>
<query name="allCustomers">
<retrieve>
<!-- maps to HTTP GET -->
<statement> SELECT customerNumber,customerName from Customers order by customerName </statement>
</retrieve>
</query>
<query name="customerByNumber" autocreate="true">
<retrieve>
<!-- maps to HTTP GET -->
<statement> SELECT * from Customers where customerNumber={cnum} </statement>
</retrieve>
</query>
</queryset> |
...
<query name="customerByNumber“>
<retrieve>
<!-- maps to HTTP GET -->
<statement>
SELECT * from Customers where customerNumber={cnum}
</statement>
</retrieve>
</query>