ICANUI-DIV操作数据库

    select(){ //函数触发就给服务器端发送请求

        this.http.post(["test",1],r=>{   

        //test为http.json定义的方法
        //该数组后可接多个参数，后端接收为v1...

            console.log(r);  //请求成功后返回的数据

        });
    }

can.system.debug=true;

<?php
define("HOST","localhost"); //服务器地址
define("DB_USER","root"); //用户名
define("DB_PASSWORD","root"); //数据库密码
define("DB_NAME","tt"); //数据库名

?>

<?php $protocols=‘{
    "test": {
        "require": "mysql",
        "func": "query",
        "args": [
            "SELECT * from test WHERE id=\‘{v1}\‘",
            "json"
        ]
    }
}‘ ?>

    "user_insert": {
        "require": "mysql",
        "func": "query",
        "args": [
            "INSERT INTO test (name,chinese,maths,english) VALUES (\‘{v1}\‘,\‘{v2}\‘,\‘{v3}\‘,\‘{v4}\‘)",
            "json"
        ]
    }

    "user_update": {
        "require": "mysql",
        "func": "query",
        "args": [
            "UPDATE test SET chinese=\‘{v2}\‘,maths=\‘{v3}\‘,english=\‘{v4}\‘ WHERE name=\‘{v1}\‘",
            "json"
        ]
    },

    "user_delete": {
        "require": "mysql",
        "func": "query",
        "args": [
            "delete from test WHERE Id={v1}",
            "json"
        ]
    },