Question

大家帮看一下.js读取数据库的时候怎么往SQL语句里面加变量

var SqlStr = "select SiteID, ID, username from MenberSite order by SiteID"//这是SQL语句
我想查询id大于5的所有会员
var uid=5;
这SQL语句怎么写啊/?

Answer 1

var SqlStr = "select SiteID, ID, username from MenberSite where ID>"+uid+" order by SiteID" ;

Answer 2

var uid=5;

var SqlStr = "select SiteID, ID, username from MenberSite where ID>'"+uid+"' order by SiteID"