Cookbook sample
Executing Update (insert, update, delete)
$product = new Product();
$product->setId(1);
$product->setDescription('Shih Tzui');
$key = $sqlMap->insert('insertProduct', $product);
Executing Query for Object (select)
$key = 1;
$product = $sqlMap->queryForObject ('getProduct', $key);
Executing Query for Object (select) With Preallocated Result Object
$customer = new Customer();
$sqlMap->beginTransaction();
$sqlMap->queryForObject('getCust', $parameter, $customer);
$sqlMap->queryForObject('getAddr', $parameter, $customer);
$sqlMap->commitTransaction();
Executing Query for List (select)
$list = $sqlMap->queryForList ('getProductList');
Executing Query for List (select) With Result Boundaries
$list = $sqlMap->queryForList ('getProductList', $key, null, 0, 40);
Executing Query for Paginated List (select)
$list = $sqlMap->queryForPagedList ('getProductList', null, 10);
$list->nextPage();
$list->previousPage();
Executing Query for Map
$map = $sqlMap->QueryForMap('getProductList', null, 'productCode');
$product = $map['EST-93'];