40 lines
1.2 KiB
Markdown
40 lines
1.2 KiB
Markdown
|
# MYSQL 类函数文档
|
|||
|
|
|
|||
|
|
**类说明**：
|
|||
|
|
`MYSQL`类为服务端数据库相关操作。
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
---
|
|||
|
|
**本类为单例类逻辑相关不易描述请直接模仿示例**：
|
|||
|
|
### 示例
|
|||
|
|
|
|||
|
|
> 请在你的 sqr_main() 函数中初始化数据库连接池
|
|||
|
|
```
|
|||
|
|
local PoolObj = MysqlPool.GetInstance();
|
|||
|
|
PoolObj.SetBaseConfiguration("127.0.0.1", 3306, "game", "uu5!^%jg");
|
|||
|
|
//连接池编码 默认为latin1 如果有需求可更改为 utf8之类的
|
|||
|
|
//PoolObj.Charset = "latin1";
|
|||
|
|
//连接池大小
|
|||
|
|
PoolObj.PoolSize = 10;
|
|||
|
|
//初始化
|
|||
|
|
PoolObj.Init();
|
|||
|
|
```
|
|||
|
|
|
|||
|
|
> 然后你可以在任何地方调用连接池获取连接 进行数据库操作
|
|||
|
|
```
|
|||
|
|
//查询的sql语句
|
|||
|
|
local sql = "SELECT m_id,charac_name,lev,village,job,exp,Hp FROM charac_info WHERE charac_no = 1;";
|
|||
|
|
//查询的元素类型，按sql中的顺序
|
|||
|
|
local column_type_list = ["int", "string", "int", "int", "int", "int", "int"];
|
|||
|
|
//从连接池中获取一个空闲连接
|
|||
|
|
local SqlObj = MysqlPool.GetInstance().GetConnect();
|
|||
|
|
local result = SqlObj.Select(sql, column_type_list);
|
|||
|
|
|
|||
|
|
printT(result);
|
|||
|
|
|
|||
|
|
//使用完成后请将连接放回连接池
|
|||
|
|
MysqlPool.GetInstance().PutConnect(SqlObj);
|
|||
|
|
```
|
|||
|
|
---
|