zendframework2 tableGateway db连接检索

zendframework2的 Zend\Db\TableGateway的用法：

(1)tableGateway select

use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Sql\Select;
use Zend\Db\Sql\Predicate;
use Zend\Db\Sql\Where;

.........

               $select = $this->tableGateway->getSql()->select();

                $select->where(function(Where $where) use ($ids){

$where->equalTo('work_status','0');
$where->equalTo('privilege','1');
$where->in("id",array(0=>2300,1=>2301,2=>2302));
$where->like('department', '%KS%');
return $where;

})->order('id DESC')->limit(10);

              $rowset = $this->tableGateway->selectWith($select);

..........

(2)tableGateway Adapter

public function getData($code)
{
$sql = 'SELECT MAX(seq) FROM m_tmp WHERE code='.$code.';';
$adapter = $this->tableGateway->getAdapter();
$statement = $adapter->query($sql);
$results = $statement->execute();
return $results;
}