 |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
订阅该问题
悬赏分：20 - 2007年08月14日
请高手帮忙修改以下文件，改为连接Oracle数据库（最好不要更改自定义函数名称，每个自定义函数实现原来同样的功能即可），在此先行谢过！！！
Oracle数据库的相关信息修改为以下内容：
DATABASE=$SID
USER=$USERNAME
PASSWORD=$PASSWORD
原来连接mysql数据库文件如下：
<?
class DB
{
var $Host = "192.168.1.158"; // Hostname of our MySQL server
var $Database = "livechat"; // Logical database name on that server
var $User = "root"; // Database user
var $Password = 'root'; // Database user's password
var $Link_ID = 0; // Result of mysql_connect()
var $Query_ID = 0; // Result of most recent mysql_query()
var $Record = array(); // Current mysql_fetch_array()-result
var $Row; // Current row number
var $error = 0; // Error state of query
var $Error = "";
function halt($msg)
{
echo("Database error: $msg
\n");
echo("MySQL error: $this->error ($this->Error)
\n");
die("Session halted.");
}
function connect()
{
if($this->Link_ID == 0)
{
$this->Link_ID = mysql_connect($this->Host, $this->User, $this->Password);
if (!$this->Link_ID)
{
$this->halt("Link_ID == false, connect failed");
}
$SelectResult = mysql_select_db($this->Database, $this->Link_ID);
if(!$SelectResult)
{
$this->errno = mysql_errno($this->Link_ID);
$this->error = mysql_error($this->Link_ID);
$this->halt("cannot select database ".$this->Database."");
}
return $this->Link_ID;
}
}
function num_rows()
{
return mysql_num_rows($this->Query_ID);
}
function close()
{
if($this->Link_ID != 0)
{
mysql_close($this->Link_ID);
}
}
}
class RS
{
var $db_link;
var $rs;
var $record;
var $row;
var $errno;
var $error;
function open($db)
{
$this->db_link = $db;
}
function query($sql)
{
$this->rs = mysql_query($sql,$this->db_link);
$this->row = 0;
$this->errno = mysql_errno();
$this->error = mysql_error();
if (!$this->rs)
{
$this->halt("Invalid SQL: ".$sql);
}
return $this->rs;
}
function f($field)
{
return $this->record[$field];
}
function movenext()
{
$this->record = mysql_fetch_array($this->rs);
$this->row += 1;
$this->errno = mysql_errno();
$this->error = mysql_error();
$stat = is_array($this->record);
if (!$stat)
{
mysql_free_result($this->rs);
$this->rs = 0;
}
return $this->record;
}
function free()
{
if ($this->rs<>"")
{
mysql_free_result($this->rs);
}
}
function halt($msg)
{
echo("Database error: $msg
\n");
echo("MySQL error: $this->error ($this->Error)
\n");
die("Session halted.");
}
}
?>
sea-green[/COLOR]