I. 创建表结构和测试数据

create table rooms(id int not null auto_increment, name varchar(100), primary key(id)); 
insert into rooms values(1,'Royal Room'); 
insert into rooms values(2,'Standard Room');
II.创建controllers/RoomController.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>"; 
       } 
    } 
 }

在地址栏中输入: http://localhost/magento/index.php/hotel/room/listing, 页面将输出:

Royal Room 
Standard Room