系统、网站、API站点,简单高效开发

平台介绍 >> js/jsfun/fnDb_multidb.js 多数据库模式数据库操作类

js/jsfun/fnDb_multidb.js 多数据库模式数据库操作类

    //查询
    let list = IndexBllDoctype.indexDoctypeQuery();
    console.log("查询列表:", list);

    let list2 = IndexBllDoctype.indexDoctypeQuery("pkid,ctitle", {"cstatus": 1, "ctitle|like": "%开%"}, "order by pkid desc")
    console.log("查询列表2:", list2);
    let list3 = IndexBllDoctype.indexDoctypeQuery("cstatus", {"ctitle|like": "%开%"}, "group by cstatus")
    console.log("查询列表3:", list3);
    console.log("查询行数据:", IndexBllDoctype.indexDoctypeInfo(14))
    let row = IndexBllDoctype.indexDoctypeQueryRow("pkid,ctitle", {"ctitle|like": "%开%"}, "order by pkid desc")
    let _info = new IndexDoctype(row);
    console.log("info==>", _info);

    let tInfo = {"ctitle": "AAAA", "pkid": 0};
    console.log("===>", new IndexDoctype(tInfo))
    tInfo["ctitle"] = undefined;
    console.log("===>", new IndexDoctype(tInfo))
    console.log("查询行:", row);
    console.log("总条数:", IndexBllDoctype.indexDoctypeCount({"cstatus": 1}))

    //分页
    //无统计数据
    let page= IndexBllDoctype.indexDoctypePage("*",{"cstatus":1},"order by pkid desc")
    console.log("分页:", page)
    //有统计数据
    let page2= IndexBllDoctype.indexDoctypePageCount("pkid,ctitle",{"cstatus":1},"order by pkid desc",3,1)
    console.log("分页2:", page2)

    //新增数据
    let newID= IndexBllDoctype.indexDoctypeInsert({"ctitle":"AAAAAAAAA"})
    console.log("新增数据:", newID);
    console.log("新增数据1:",IndexBllDoctype.indexDoctypeInfo(newID))
    //更新数据
    IndexBllDoctype.indexDoctypeUpdateByID(newID,{"ctitle":null})
    console.log("新增数据2:",IndexBllDoctype.indexDoctypeInfo(newID))

    //删除数据
    console.log("删除条数:", IndexBllDoctype.indexDoctypeDelete({"cstatus": -2}));
    console.log("删除指定ID的条数:", IndexBllDoctype.indexDoctypeDeleteByID(200))

备案号:闽ICP备20003806号     厦门市湖里区陈朝能网络技术工作室