<!--二泉.net --><?class Pages{;;;;var $cn;//連接數(shù)據(jù)庫(kù)游標(biāo);;;;var $d;;;;;//連接數(shù)據(jù)表的游標(biāo);;;;var $result;;;;;//結(jié)果;;;;var $dsn;//dsn源;;;;var $user;//用戶名;;;;;;;;var $pass;//密碼;;;;;;;;var $total;//記錄總數(shù);;;;var $pages;//總頁(yè)數(shù);;;;var $onepage;;;;;//每頁(yè)條數(shù);;;;var $page;//當(dāng)前頁(yè);;;;var $fre;//上一頁(yè);;;;var $net;//下一頁(yè);;;;var $i;;;;;//控制每頁(yè)顯示;;;;function getConnect($dsn,$user,$pass){$this->cn=@odbc_connect($dsn,$user,$pass);if(!$this->cn){;;;;$error="連接數(shù)據(jù)庫(kù)出錯(cuò)";;;;;$this->getMess($error);} ;;;;};;;;;;;;function getDo($sql){//從表中查詢數(shù)據(jù)$this->d=@odbc_do($this->cn,$sql);if(!$this->d){;;;;$error="查詢時(shí)發(fā)生了小錯(cuò)誤......";;;;;$this->getMess($error);}return $this->d;;;;;};;;;function getTotal($sql){$this->sql=$sql;$dT=$this->getDo($this->sql);//求總數(shù)的游標(biāo)$this->total=odbc_result($dT,'total');//這里為何不能$this->d呢？return $this->total; ;;;;};;;;function getList($sql,$onepage,$page){$this->s=$sql;$this->onepage=$onepage;$this->page=$page;$this->dList=$this->getDo($this->s);;;;;//連接表的游標(biāo)$this->pages=ceil($this->total/$this->onepage);if($this->pages==0) ;;;;$this->pages++; //不能取到第0頁(yè)if(!isset($this->page)) ;;;;$this->page=1;$this->fre = $this->page-1;;;;;//將顯示的頁(yè)數(shù)$this->nxt = $this->page+1; $this->nums=($this->page-1)*$this->onepage; //if($this->nums!=0){//;;;;for($this->i=0;$this->i<$pg->getNums();odbc_fetch_row($this->dd),$this->i++);//同上//}//$this->i=0;//為何這部分不能封裝？return $this->dList; ;;;;};;;;function getFanye(){$str="";if($this->page!=1);;;;$str.="<a href=".$PHP_SELF."?page=1> 首頁(yè) </a><a href=".$PHP_SELF."?page=".$this->fre."> 前頁(yè) </a>";;;;;else$str.="<font color=999999>首頁(yè) 前頁(yè)</font>";if($this->page<$this->pages);;;;$str.="<a href=".$PHP_SELF."?page=".$this->nxt."> 后頁(yè) </a>";;;;;else$str.="<font color=999999> 后頁(yè) </font>";if($this->page!=$this->pages);;;;$str.="<a href=".$PHP_SELF."?page=".$this->pages."> 尾頁(yè) </a>";;;;;else$str.="<font color=999999> 尾頁(yè) </font>";$str.="共".$this->pages."頁(yè)";$str.="您正瀏覽第<font color=red>".$this->page."</font>頁(yè)";return $str;;;;;};;;;;;;;function getNums(){return $this->nums;;;;;};;;;;;;;function getOnepage(){//每頁(yè)實(shí)際條數(shù)return $this->onepage;;;;;};;;;function getI(){return $this->i;;;;;};;;;;;;;function getPage(){return $this->page;;;;;};;;;function getMess($error){//定制消息echo"<center>$error</center>";exit;;;;;}}$pg=new Pages();$pg->getConnect("lei","sa","star");$pg->getTotal("select count(*) as total from xs");;;;;//連學(xué)生表求總數(shù)$pg->getList("select xs_name from xs order by xs_id",8,$page); if($pg->getNums()!=0){;;;;for($i=0;$i<$pg->getNums();odbc_fetch_row($pg->dList),$i++);//同上}$i=0;while(odbc_fetch_row($pg->dList)){;;;;$name=odbc_result($pg->dList,"xs_name");;;;;echo $name."<br>";;;;;if($i==$pg->getOnepage()){//跳出循環(huán)break;;;;;};;;;$i++;}echo$pg->getFanye();?>