aardio连接数据库查询

admin2021-04-17  92

import win.ui;
import string;
import inet.whttp;
import console;
import fsys.file;
import fsys.dlg;
import thread.works
import io;
import com;
import com.excel;


import console;
import mysql.client;
//多线程管理器
import thread.manage

var csv="关键词,数量,第一评论,第二评论,第三评论"+'\r\n'
//创建线程管理器
manage = thread.manage(3)
//console.log("正在连接数据库服务器...");
thread.invoke( function()
        while(! thread.get("db4free.net:end")){
         io.stdout.write(">");sleep(100);
    }  
)

var dbMysql,err = mysql.client(
    server = "127.0.0.1"; //数据库服务器,可省略默认为localhost
    uid = "root";//用户名,可省略默认为root
    pwd = "KnBf3a9k";  
);

thread.set("db4free.net:end",true)
//console.clearScreen ();
if(!dbMysql){
    console.log("连接数据库失败",err);
    console.pause();
    return;
}

//选择数据库
dbMysql.selectDb("marking")
var result = dbMysql.query("SELECT level1 FROM `cmf_role1` where 1  group by level1 ");
	for  level1 in result.each(){
      			console.log(level1)
      			
   		}
转载请注明原文地址: https://www.aardio.net/read-171.html
最新回复(0)