1. etc/config.xml有如下配置
-
<global>
<models>
<hotel>
<class>Cartz_Hotel_Model</class>
<resourceModel>hotel_mysql4</resourceModel>
</hotel>
<hotel_mysql4>
<class>Cartz_Hotel_Model_Mysql4</class>
<entities>
<room>
<table>rooms</table>
</room>
</entities>
</hotel_mysql4>
</models>
<resources>
<hotel_setup>
<setup>
<module>Cartz_Hotel</module>
</setup>
<connection>
<use>core_setup</use>
</connection>
</hotel_setup>
<hotel_write>
<connection>
<use>core_write</use>
</connection>
</hotel_write>
<hotel_read>
<connection>
<use>core_read</use>
</connection>
</hotel_read>
</resources>
</global>
2. 模型類為model/Room.php
-
<?php
class Cartz_Hotel_Model_Room extends Mage_Core_Model_Abstract{
protected function _construct() {
$this->_init('hotel/room');
}
public function listing(){
$this->_getResource()->findAll();
}
}
?>
-
3. 相應的資源模型類是model/Mysql4
-
<?php
class Cartz_Hotel_Model_Mysql4_Room extends Mage_Core_Model_Mysql4_Abstract{
protected function _construct(){
$this->_init('hotel/room', 'id');
}
public function findAll() {
$handle = $this->_getWriteAdapter();
$query = $handle->query('select name from rooms');
while ($row = $query->fetch()) {
$row = new Varien_Object($row);
echo $row->getName() . "<br/>";
}
}
}
?>
-
這段代碼昭示了兩個知識點:
1. model類的方法_getResource()獲得相應資源模型類的執行個體。
2. 在資源模型類中, 方法 _getWriteAdapter()用來獲得資料庫的串連控制代碼
為了您的安全,請只開啟來源可靠的網址
開啟網站
取消
來自: http://hi.baidu.com/pw425/blog/item/9a2a6a1d401ecd8286d6b64d.html