dedecms 执行sql语句

<?php
// 连接数据库
$dsql = new DedeSql(false);
$dsql->SetServer('localhost', 'username', 'password');
$dsql->SetDatabase('dedecmsdb');

// 执行查询语句
$sql = "SELECT * FROM `dede_archives` WHERE `typeid` = 1";
$dsql->ExecuteNoneQuery($sql);

// 获取查询结果
while ($row = $dsql->GetArray()) {
    echo "ID: " . $row['id'] . ", Title: " . $row['title'] . "<br>";
}

// 执行插入语句
$insertSql = "INSERT INTO `dede_archives` (`typeid`, `title`, `sortrank`) VALUES (1, 'New Article', 10)";
$dsql->ExecuteNoneQuery($insertSql);

// 执行更新语句
$updateSql = "UPDATE `dede_archives` SET `title` = 'Updated Article' WHERE `id` = 1";
$dsql->ExecuteNoneQuery($updateSql);

// 执行删除语句
$deleteSql = "DELETE FROM `dede_archives` WHERE `id` = 1";
$dsql->ExecuteNoneQuery($deleteSql);

// 关闭数据库连接
$dsql->Close();
?>