## 創建數據表
```
CREATE TABLE `admin_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL COMMENT '用戶名',
`password` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
在App目錄下創建 Model/Admin/UserModel.php
```
<?php
namespace App\Model\Admin;
use EasySwoole\ORM\AbstractModel;
class AdminModel extends AbstractModel
{
protected $tableName = 'admin_user';
protected $primaryKey = 'id';
public function getAll(int $page = 1, string $keyword = null, int $pageSize = 10): array
{
$where = [];
if (!empty($keyword)) {
$where['username'] = ['%' . $keyword . '%', 'like'];
}
$list = $this->limit($pageSize * ($page - 1), $pageSize)->order($this->primaryKey, 'DESC')->withTotalCount()->all($where);
$total = $this->lastQueryResult()->getTotalCount();
return ['total' => $total, 'list' => $list];
}
/*
* 登錄成功后請返回更新后的bean
*/
public function login():?AdminModel
{
$info = $this->get(['username' => $this->username, 'password' => $this->password]);
return $info;
}
}
```
控制器中調用模型 /App/HttpController/Api/User.php
```
<?php
namespace App\HttpController\Api;
use App\Model\Admin\UserModel;
use EasySwoole\Http\AbstractInterface\Controller;
class User extends Controller
{
public function index()
{
$param = $this->request()->getRequestParam();
$model = new UserModel();
$model->username = $param['username'];
$model->password = md5($param['password']);
if ($model->login()) {
echo '成功';
} else {
echo '失敗';
}
}
}
```
