dedecms怎么寫增刪改查

<?php       require_once (dirname(__FILE__) . "/include/common.inc.php");  //引用數據庫連接文件       if($dsql->IsTable('dede_test')){ ??????????//如果存在dede_test表 ??????????//------------------- ??????????//|????查詢一條記錄?| ??????????//|????GetOne()?????| ??????????//------------------- ??????????//????????↓ ??????????$row?=?$dsql-&gt;GetOne("SELECT?*?FROM?dede_test?WHERE?id?=?3"); ??????????print_r($row); ?????????$sql?=?"SELECT?*?FROM?dede_test"; ????????????$dsql-&gt;Execute('me',$sql); ????????????while($arr?=?$dsql-&gt;GetArray('me')) ????????????{ ????????????????echo?"id?=?{$arr['id']}?,name?=?{$arr['name']}<br>"; ????????????} ??????} ?&gt;

<?php             $id = 1 ;             if($id>0){ ????????????????$sql?=?"DELETE?FROM?dede_test?WHERE?id='$id'"; ????????????????$dsql-&gt;ExecuteNoneQuery($sql); ????????????????ShowMsg("成功刪除一條記錄內容！","true.php");??//執行成功后跳轉到true.php頁面 ????????????????exit();?? ????????????}else{ ?????????????????ShowMsg("參數不對！","text.php");??//跳轉到text.php頁面 ????????????????exit();?? ????????????} ?&gt;

<?php        $sql="INSERT INTO dede_test(name,one,two) VALUES ( &#39;$name&#39;,&#39;$one&#39;,&#39;$two&#39;)";             $dsql->ExecuteNoneQuery($sql); ????????????$lastInsertID?=?$dsql-&gt;GetLastID(); ????????????ShowMsg("成功增加一條記錄內容！","test.php"); ?&gt;

<?php             $sql="UPDATE dede_test SET name=&#39;$name&#39;,one=&#39;$one&#39;,two=&#39;$two&#39;  WHERE ID = &#39;$id&#39;";             $dsql->ExecuteNoneQuery($sql); ????????????$lastInsertID?=?$dsql-&gt;GetLastID(); ????????????ShowMsg("成功修改一條記錄內容！","true.php");??//操作成功跳轉到true.php ????????????exit();  ?&gt;