joomla 数据库操作

1,   jTable

-----------------------------------------------------------

 $row =& JTable::getInstance('comment', 'Table');

$row->load($id);

 

$row->bind(JRequest::get('post'))

$row->store()

 

 

 

2,  jModel

-------------------------------------------

$this->_db->setQuery($query);

$this->_db->loadObject();

 

$this->_getList($query, 0, 0);    

 

 

 

 

3,   jFactory

----------------------------------------------

$db =& JFactory::getDBO();
$query = "SELECT count(*) FROM #__reviews";
$db->setQuery( $query );
$total = $db->loadResult();
$query = "SELECT * FROM #__reviews";
$db->setQuery( $query,$limitstart, $limit );
$rows = $db->loadObjectList();