Yii createCommand CURD操作+个人总结

来源：互联网发布：左程云算法视频下载编辑：程序博客网时间：2024/06/06 15:51

打开跟踪log的方法，config/main.php中 log routes 中添加

[    'class' => 'CWebLogRoute',]

所以为了效率，为了 DB 服务器的性能考虑，还是使用 createCommand 的好。

insert

$row = Yii::app()->getDb()->createCommand()->insert('goods', array(            'good_name' => $goods_name,            'good_type' => $goods_type,            'price' => $price,            'buy_nums' => 0,            'commit_nums' => 0,            'create_time' => time(),        ));

select

单表查询

$goodsTypes = Yii::app()->getDb()->createCommand()        ->select('type_id, type_name')        ->from('goods_type')        ->where('status=:status', [            ':status' => 1        ])        ->queryAll();

连表查询

$goods = Yii::app()->getDb()->createCommand()->from('goods g')        ->select('g.good_id, g.good_name, gt.type_name, g.price, g.buy_nums, g.commit_nums, g.create_time')        ->join('goods_type gt', 'g.good_type=gt.type_id')        ->where('g.`status`=:status1 and gt.`status`=:status2', [            ':status1' => 1,            ':status2' => 2        ])        ->order('g.create_time desc')        ->queryAll();

delete

$row = Yii::app()->getDb()->createCommand()        ->delete('goods', "good_id=:good_id", array(            ':good_id' => $goods_id,        ));

update

$row = Yii::app()->getDb()->createCommand()->update('goods', [    'good_name' => $goods_name,    'good_type' => $goods_type,    'price' => $price,        ], "good_id=:good_id", [    ':good_id' => 1        ]);

当然这只是一部分。

个人总结：

封装类，进行sql语句的更新(增,删,改)和查询

在models文件夹中创建类

更新

public function upd($_sql){$connection = Yii::app()->db;$result = $connection->createCommand($_sql)->execute();return $result;}

查询

public function sel($_sql){$connection = Yii::app()->db;$command = $connection->createCommand($_sql);$result = $command->queryAll();return $result;}

计数

public function getCount($_sql){$result = yii::app()->db->createCommand($sql)->query()->rowCount;return $result;}

当然了，正如我们所期待的，他们都具有返回值。成功返回1，失败返回0

0 0