Yii AR模式增，删，改，查实践代码

<?php

//class IndexController extends CController{
class IndexController extends Controller{

      //public $defaultAction='index'; //默认方法
      
	  public function actionindex(){
	  	  $this->pageTitle =  CHtml::encode(Yii::app()->name);
	  	  $parm = array();
		  $this->render('index',$parm);
	  }
	  
	  public  function  actionTest(){
	  	   $result = null;
	  	   //$model = new User();
	  	   echo "<pre>";
	  	  //查询
	  	  
	  	  //$result = User::model()->find("account=:name",array('name'=>'admin'));
	  	  //$result = User::model()->findAllByPk(1);
	  	  //$result = User::model()->findAll();
	  	  //echo User::model()->tableName();
	  	  //$result = User::model()->findByAttributes(array('account'=>'admin'));
	  	  //$result = User::model()->findBySql("select * from {{user}} where account=:name",array('name'=>'admin'));
	  	  /*foreach($result as $k =>$v){
             echo '姓名：'.$v['nickname'];
          }*/
          
          //查询个数，判断查询是否有结果
          //echo User::model()->count();
          //echo User::model()->countBySql("select * from {{user}} where account=:name",array('name'=>'admin'));
          
          //分页
          $count=User::model()->count(); //获取总页数
          $pagesize=1;   //每一页显示的记录条数
          $page=new Page($count,$pagesize);
          $sql="select * from {{user}} $page->limit";
          $info=User::model()->findAllBySql($sql);
          $show_page=$page->fpage();
          echo  $show_page;
          //$this->renderPartial("index",array("info"=>$info,'show_page'=>$show_page));
          
          //添加
          /*$user = new User;
          $user->account = "addyii";
          $user->password = md5("yii");
          $user->email =  "yii@yii.com";
          echo $user->save();*/
         
          //修改
          //echo User::model()->updateByPk(4,array('nickname'=>'yii'));
         // echo User::model()->updateAll(array('status'=>1),'nickname=:name',array(':name'=>'yii'));
         //自增或自减
          //echo User::model()->updateCounters(array('status'=>1),'nickname=:name',array(':name'=>'yii'));
          
          //删除
          //echo User::model()->deleteByPk(5);
          //echo User::model()->deleteAll("nickname=:name",array('name'=>"addyii"));
	  	  //print_r(User::model()->findAll());
	  	  
	  	  print_r($result);
	  }
}

?>