ci架構怎麼讀寫操作mysql資料庫

 ci架構中，怎麼和資料庫互動，下面是我寫的簡單示例函數：

function OprData(){

        $this->load->database();

        //傳回多條記錄

        $query = $this->db->query('select * from t_appinfo');

        if($query->num_rows()>0){

            foreach($query->result() as $row){

                echo "<br/>";

                echo $row->nID;

                echo $row->sAppName;

                echo $row->tTime;

            }

        }

        //插入資料

        $name='test';

        $sql = "insert into t_appinfo(sAppName,tTime) values(".$this->db->escape($name).",now())";

        $this->db->query($sql);

        echo "<br/>row:";

        echo $this->db->affected_rows();

        //傳回單條記錄

        $sql = "select * from t_appinfo order by ttime desc limit 1";

        $query = $this->db->query($sql);

        $row = $query->row();

        echo"<br/> time:".$row->tTime;

         //更新資料

        $sql = "update t_appinfo set sAppName='".$row->sAppName."11' where nid=".$row->nID;

        $query = $this->db->query($sql);

        echo "<br/>update row:";

        echo $this->db->affected_rows()."//".$query;

        //删除資料

        $sql="delete from t_appinfo limit 1 ";

         $query = $this->db->query($sql);

        echo "<br/>delete row:";

        echo $this->db->affected_rows()."//".$query;

    }