koa-mysql-connector v0.1.1

使用之前

该组件依赖@mysql/xdevapi 使用之前，请导入该依赖包

安装

$ npm install --save koa-mysql-connector

In config.js :

var mysqlx = require('@mysql/xdevapi');

var koaMysqlConnector = require("koa-mysql-connector")

const mysql = new koaMysqlConnector();

const options = {
    host: 'localhost',
    port: 33060,
    password: '12345678',
    user: 'root',
    schema: 'pro_server',
};

mysql.connect(options, options.schema);

export default mysql;

In app.js:

import mysql from './config';

Methods

connect(options, schema) 

连接MySQL数据库

Parameters:

selectDatabase(tablename, select) -> {row.]}

检索数据库

Parameters:

insertDatas(tablename, value) 

插入数据

Parameters:

deleteDatas(tablename, expr)

删除数据

Parameters:

updateDatas(tablename, expr, field, value)

修改数据

Parameters: