Пример #1
0
 /**
  *
  * @return \ORC\DAO\Dao
  */
 public function getDao()
 {
     if (!isset($this->_dao)) {
         $server_name = $this->_table->getServerName();
         $this->_dao = DaoFactory::get($server_name);
     }
     return $this->_dao;
 }
 public function UserDemo()
 {
     //        //现在每个方法都互相影响结果 可注释后在看
     //
     //        $dbal = DBAL::select("user");
     //        $dbal->setDataRowClass('\\APP\\Module\\Test\\DataRow\\Test');
     //        //将数组排序
     //        $dbal->orderBy('username desc');
     //        //查询个别字段
     //        $dbal->setSelect('username,password');
     //        $list = $dbal->execute();
     //        $this->set('list',$list);
     //        //将$list的结果中以username作为数组键 password作为value 组成一个数组
     //        $toArray = $list->toArray("username","password");
     //        $this->set("toArray",$toArray);
     //        //将$list的结果中usernanme字段的内容组成一个数组
     //        $getByName = $list->getByName("username");
     //        $this->set('getByName',$getByName);
     //        //将$list的结果以password分组显示
     //        $groupBy = $list->groupBy("password");
     //        $this->set('groupBy',$groupBy);
     //        //将$list的结果升序排序
     //        $sort = $list->sort("id");
     //        $this->set('sort',$sort);
     //        //将$list的结果按指定数组排序
     //        $array = array('zcs',"qwe");
     //        $sortByfield = $list->sortByField("username",$array);
     //        $this->set('sortByfield',$sortByfield);
     //        //查找数组中的某个值所对定的数据
     //        $find = $list->find("username","zcs");
     //        $this->set('find',$find);
     //DAO PDO
     $sql = "SELECT * FROM user WHERE id = ?";
     $dao = DaoFactory::get();
     //得到一个default的dao,也可以使用dbal的getDao方法
     //        $dao->beginTransaction();
     $dao->prepare($sql);
     $id = 1;
     $dao->bindParam(1, $id);
     $pdo = $dao->execute();
     $a = $dao->fetchAll($pdo);
     $this->set("pdo", $a);
 }
Пример #3
0
 private function getDao($server_name)
 {
     if (!isset($this->_daos[$server_name])) {
         $this->_daos[$server_name] = DaoFactory::create($server_name);
     }
     return $this->_daos[$server_name];
 }
 /**
  * 获得新的知识点的编号
  * @param int $exam_type_id
  * @param int $subject_id
  * @return string编号
  */
 public function createNewCode($exam_type_id, $subject_id)
 {
     //         $dbal = DBAL::insert('knowledge_point_id');
     //         $dbal->set('primary_exam_type', $exam_type_id);
     //         $dbal->set('subject_id', $subject_id);
     //         $dbal->set('id', '@COUNT:=(1)');
     //         $dbal->setRawDuplicate('id = @COUNT:=(id + 1)');
     //         $dbal->execute();
     //         $dao = $dbal->getDao();
     $subjectLoader = new Subject();
     $subjects = $subjectLoader->getAllSubjects();
     if (!isset($subjects[$subject_id])) {
         return false;
     }
     $subject_code = $subjects[$subject_id]['code'];
     $examTypeLoader = new ExamType();
     $types = $examTypeLoader->getAllTypes();
     if (!isset($types[$exam_type_id])) {
         return false;
     }
     $exam_type_code = $types[$exam_type_id]['code'];
     $dao = DaoFactory::get();
     $dao->query("INSERT INTO knowledge_point_id (primary_exam_type, subject_id, id) VALUES ({$exam_type_id}, {$subject_id}, @COUNT:=(1)) ON DUPLICATE KEY UPDATE id = @COUNT:=(id + 1)");
     $dao->query('SELECT @COUNT');
     $data = $dao->fetch(Dao::FETCH_NUM);
     $id = $data[0];
     if ($id < 1) {
         throw new SystemException('生成知识点编号失败', $dao);
     }
     return sprintf('%s-%s-ZSD-%d', $exam_type_code, $subject_code, $id);
 }
 public function execute()
 {
     $request = $this->getRequest();
     //注意!为了演示dao和dbal的用法,把所有代码放在这里,但实际上要利用model
     switch ($request->get('action')) {
         case 'add':
             return $this->HTMLView('DB.Add');
             break;
         case 'save':
             $key1 = $request->get('key1');
             $key2 = $request->get('key2');
             $dbal = DBAL::insert('test');
             $dbal->set('key1', $key1);
             $dbal->set('key_2', $key2);
             //$dbal->setKey2($key2);//两种写法都可以,推荐用上面的
             $id = $dbal->execute();
             return $this->HTMLRedirect($this->generateURL('DB.Demo'), '保存成功', '页面保存成功');
             break;
         case 'view2':
             //利用key2作为主键
             $key2 = $request->get(0, 'safe', '');
             //注意request的get的用法
             $dao = DaoFactory::get('default');
             //得到一个default的dao,也可以使用dbal的getDao方法
             $dao->beginTransaction();
             //开始一个事务, 注意这里select没有加锁(select for update)
             $dbal = DBAL::select('default.test');
             //default是配置文件里的server name,不是database name
             $dbal->setDataRowClass('\\APP\\Module\\Test\\DataRow\\Test');
             //指定datarow class,否则使用ORC\DAO\Table\DataRow
             $dbal->byKey2($key2);
             //注意虽然在数据库中字段是key_2,这里不要有_
             $row = $dbal->getOne();
             //给计数器加1
             $dbal = DBAL::update('test');
             $dbal->increase('count', 1);
             $dbal->execute();
             $dao->commit();
             //提交
             $model = $this->getModel('DB.Test');
             $model->set('record', $row);
             return $this->HTMLView('DB.ViewDemo');
             break;
         case 'view':
             $id = $request->get('id', 'posint', 0);
             $dbal = DBAL::select('default.test');
             //default是配置文件里的server name,不是database name
             $dbal->setDataRowClass('\\APP\\Module\\Test\\DataRow\\Test');
             //指定datarow class,否则使用ORC\DAO\Table\DataRow
             $dbal->byId($id);
             $result = $dbal->getOne();
             //直接得到一个DataRow,这里直接得到Test对象
             $model = $this->getModel('DB.Test');
             $model->set('record', $result);
             return $this->HTMLView('DB.ViewDemo');
             break;
         case 'list':
         default:
             $dbal = DBAL::select('test');
             //获得一个dbal select对象
             $dbal->setDataRowClass('\\APP\\Module\\Test\\DataRow\\Test');
             //指定datarow class,否则使用ORC\DAO\Table\DataRow
             $list = $dbal->execute();
             $model = $this->getModel('DB.Test');
             $model->set('list', $list);
             //如果要分页的话
             $dbal = DBAL::select('test');
             //获得一个dbal select对象
             $dbal->setDataRowClass('\\APP\\Module\\Test\\DataRow\\Test');
             //指定datarow class,否则使用ORC\DAO\Table\DataRow
             $dbal->setPage(1, 20);
             //第一页,每页20条
             $list = $dbal->execute();
             $pagination = new Pagination($list, $dbal->getTotalCount(), 1, 20);
             return $this->HTMLView('DB.List');
             break;
     }
 }