_ID =
* :userId AND ACC_ID = :accId'.
*/
public Tx[] findByAcc(int userId, int accId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"USER_ID = ? AND ACC_ID = ?", new Object[] {
new Integer(userId), new Integer(accId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'USER_ID =
* :userId AND CAT_ID = :catId'.
*/
public Tx[] findByCat(int userId, int catId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"USER_ID = ? AND CAT_ID = ?", new Object[] {
new Integer(userId), new Integer(catId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'USER_ID =
* :userId'.
*/
public Tx[] findWhereUserIdEquals(int userId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"USER_ID = ?", new Object[] { new Integer(userId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'ACC_ID =
* :accId'.
*/
public Tx[] findWhereAccIdEquals(int accId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"ACC_ID = ?", new Object[] { new Integer(accId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'TX_ID =
* :txId'.
*/
public Tx[] findWhereTxIdEquals(int txId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"TX_ID = ?", new Object[] { new Integer(txId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'CAT_ID =
* :catId'.
*/
public Tx[] findWhereCatIdEquals(int catId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"CAT_ID = ?", new Object[] { new Integer(catId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'TX_DATE =
* :txDate'.
*/
public Tx[] findWhereTxDateEquals(Date txDate) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"TX_DATE = ?", new Object[] { txDate == null ? null
: new java.
sql.Date(txDate.getTime()) }));
}
/**
* Returns all rows from the TX table that match the criteria 'PAYEE =
* :payee'.
*/
public Tx[] findWherePayeeEquals(String payee) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"PAYEE = ?", new Object[] { payee }));
}
/**
* Returns all rows from the TX table that match the criteria 'AMT = :amt'.
*/
public Tx[] findWhereAmtEquals(BigDecimal amt) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"AMT = ?", new Object[] { amt }));
}
/**
* Returns all rows from the TX table that match the criteria 'TRANSFER_ID =
* :transferId'.
*/
public Tx[] findWhereTransferIdEquals(int transferId) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"TRANSFER_ID = ?", new Object[] { new Integer(transferId) }));
}
/**
* Returns all rows from the TX table that match the criteria 'REF = :ref'.
*/
public Tx[] findWhereRefEquals(String ref) throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"REF = ?", new Object[] { ref }));
}
/**
* Returns all rows from the TX table that match the criteria 'DESCRIPTION =
* :description'.
*/
public Tx[] findWhereDescriptionEquals(String description)
throws TxDaoException {
return convertToDTO(HibernateUtil.executeSQLQuery("TX", Tx.class,
"DESCRIPTION = ?", new Object[] { description }));
}
/**
* Returns all rows from the TX table that match the criteria 'CLR = :clr'.
*/
public Tx[] findWhereClrEquals(int clr) throws TxDaoException {
return convertToDTO(