php-与数据库对应实体类的命名

数据库建表时，我们有时会这样命名"resource_id" 来表示这是个resource表里面的"id"字段。当表名比较长时我们可能会这样"resource_ref"表示资源影射表。这样的表通常有外键，很可能就是我们在开头命名的"resource_id"。这时候字段名可能就变成"resource_ref_resource_id"。OK，这样稍微比一长串字符串的命名好认一些。但做实体的时候，你应该不要做一模一样的命名。

<?php
 class Zwb_Models_Entity_ResourceRef {
    private $_id;
    private $_roleId;
    private $_resourceId;
    
    public function get($key){
        return $this->{'_'.$key};
    }
    
    public function set($key,$val){
        $this->{'_'.$key} = $val;
    }
    /**
     * @return the $id
     */
    public function getId() {
        return $this->_id;
    }

    /**
     * @return the $roleid
     */
    public function getRoleid() {
        return $this->_roleId;
    }

    /**
     * @return the $resourceid
     */
    public function getResourceid() {
        return $this->_resourceId;
    }

    /**
     * @param $id the $id to set
     */
    public function setId($id) {
        $this->_id = $id;
    }

    /**
     * @param $roleid the $roleid to set
     */
    public function setRoleid($roleid) {
        $this->_roleId = $roleid;
    }

    /**
     * @param $resourceid the $resourceid to set
     */
    public function setResourceid($resourceid) {
        $this->_resourceId = $resourceid;
    }

    
}

对应起来可以这样

<?php
class Zwb_Functions_CapitalToUnderline {
    public static function capitalToUnderline($str) {
        $temp = preg_split("/(?=[A-Z])/", $str);
        if(count($temp)>1)
        {
            $arr = implode('_', $temp);
            return strtolower($arr);
        }
        return $str;
    }
}

public function fetchAll($options) {
        $table = Zwb_Functions_CapitalToUnderline::capitalToUnderline($options['table']);
        $db = Zwb_Models_DbEntry::getInstance()->getdb();
        $objects = array();
        
        $result = $db->fetchAll("SELECT * FROM ".$table);
        $objectName = 'Zwb_Models_Entity_'.ucfirst($table);
        foreach($result as $row)
        {
            $object = new $objectName();
            $objectArray = (array) $object;
            foreach($objectArray as $key => $val)
            {
                $key = trim(substr($key, strlen($objectName)+3));//类成员为私有，转换时要去除类名
                $tablekey = Zwb_Functions_CapitalToUnderline::capitalToUnderline($key);
                $object->set($key, $row[$table.'_'.$tablekey]);
            }
            $objects[] = $object;
        }
        return $objects;
    }