void
注册会员
UID 93558
精华
0
积分 70
帖子 78
金钱 70 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-5-24
状态 离线
|
[推荐阅读] 北京彬蓝科技 高薪诚聘php开发人员 （北京 ）
<?
class EBookDAO implements IDAO
{
private $db = null; //数据访问对象
private $dt = null; //数据表集合
public $userId = 0; //用户ID
public $para = array(); //参数数组
public $input = null; //用户输入
private $factory = null; //类厂对象
//+------------------------------------------------------------------------------------------------------------
//Desc:类的构造子(对象初始化)
public function __construct($factory)
{
$this->factory = $factory;
$this->db = $factory->getObject("mysql");
$this->dt = $factory->getObject('config')->getTable();
}
//+----------------------------------------------------------------------------------------------------------
//Desc:类的析构方法(负责资源的清理工作)
public function __destruct()
{
$this->db = null;
$this->dt = null;
$this->input = null;
$this->para = null;
$this->userId = null;
$this->factory = null;
}
//+---------------------------------------------------------------------------------------------------------
//Desc:添加一个电子楼书
public function save()
{
$ebook = $this->dt['ebook'];
extract($this->input,EXTR_OVERWRITE);
$sql = "insert into $ebook(UserID,Name,ImgUrl,Created) values ";
$sql .= "('$this->userId','$name','$imgUrl','".time()."')";
return $this->db->execute($sql);
}
//+---------------------------------------------------------------------------------------------------------
//Desc:更新指定ID的电子楼书
public function update()
{
$ebook = $this->dt['ebook'];
extract($this->input,EXTR_OVERWRITE);
$sql = "update $ebook set Name='$name',ImgUrl='$imgUrl' where ID='$id' and UserID='$this->userId'";
return $this->db->execute($sql);
}
//+---------------------------------------------------------------------------------------------------------
//Desc:删除指定ID的电子楼书
public function remove()
{
$ebook = $this->dt['ebook'];
extract($this->input,EXTR_OVERWRITE);
$dataId = is_array($id) ? implode(",",$id) : $id;
$sql = "delete from $ebook where ID in ($dataId)";
return $this->db->execute($sql);
}
//+---------------------------------------------------------------------------------------------------------
//Desc:得到指定ID的电子楼书信息
public function get()
{
$ebook = $this->dt['ebook'];
extract($this->input,EXTR_OVERWRITE);
$sql = "select * from $ebook where ID='$id' and UserID='$this->userId'";
$result = $this->db->execute($sql);
return $this->db->fetchRow($result);
}
//+--------------------------------------------------------------------------------------------------------
//Desc:得到电子楼书列表
public function getList()
{
$ebook = $this->dt['ebook'];
extract($this->para,EXTR_OVERWRITE);
$pageId = isset($_REQUEST['pageId'])?$_REQUEST['pageId']:1;
$offset = ($pageId-1)* $pageRows;
$offset = ($offset < 0) ? 0 : $offset;
$sqlCount = "select ID from $ebook where UserID='$this->userId'";
$sqlQuery = "select * from $ebook where UserID='$this->userId' order by ID desc limit $offset,$pageRows";
$rowCount = $this->db->getRows($sqlCount);
$pageNav = $this->factory->getObject('pageNav');
$pageNav->pageStyle = 1;
$navTxt = $pageNav->page($rowCount,$pageRows,$url);
$result = $this->db->execute($sqlQuery);
$ds = array();
$arrTemp = array();
while($row = $this->db->fetchRow($result))
{
$ds[] = $row;
}
$arrTemp[] = $ds;
$arrTemp[] = $navTxt;
unset($ds);
return $arrTemp;
}
//+-----------------------------------------------------------------------------------------------------------
//Desc:通过关键字搜索电子楼书
public function search()
{
$ebook = $this->dt['ebook'];
extract($this->para,EXTR_OVERWRITE);
extract($this->input,EXTR_OVERWRITE);
$pageId = isset($_REQUEST['pageId'])?$_REQUEST['pageId']:1;
$offset = ($pageId-1)* $pageRows;
$offset = ($offset < 0) ? 0 : $offset;
$sqlCount = "select ID from $ebook where UserID='$this->userId' and Name like '%$keyWord%'";
$sqlQuery = "select * from $ebook where UserID='$this->userId' and Name like '%$keyWord%' order by ID desc limit $offset,$pageRows";
$rowCount = $this->db->getRows($sqlCount);
$pageNav = $this->factory->getObject('pageNav');
$pageNav->pageStyle = 1;
$navTxt = $pageNav->page($rowCount,$pageRows,$url);
$result = $this->db->execute($sqlQuery);
$ds = array();
$arrTemp = array();
while($row = $this->db->fetchRow($result))
{
$ds[] = $row;
}
$arrTemp[] = $ds;
$arrTemp[] = $navTxt;
unset($ds);
return $arrTemp;
}
}
?>
|
|
