How to call SQL statements in Magento

I. Creating table structures and test data CREATE table rooms (ID int not NULL auto_increment, name varchar (+), primary key (ID)); INSERT into rooms VALUES (1, ' Royal '); INSERT into rooms VALUES (2, "standard"); II. Create controllers/roomcontroller.php: SOURCE print? <?php class Cartz_hotel_roomcontroller extends mage_core_controller_front_action{ Public function listingaction () { $handle = Mage::getsingleton ('core/resource ')->getconnection (' core_write '); $query = $handle->query (' select name from rooms '); While ($row = $query->fetch ()) { $row = new Varien_object ($row); echo "<strong>". $row->getname ().  "</strong><br/>"; } } }?> In the Address bar, enter: http://localhost/magento/index.php/hotel/room/listing, the page will output: Royal Standard

How to call SQL statements in Magento