getsql __eLYy7WnbOfHBEUfGrg4 __eLYy7WnbOfHBEUfGrg4 : " + sql ); return sql; }, read:function(){ var sql = " " + " SELECT " + " a.APPLICATIONID, " + " a.DOMAINID, " + " a.ID, " + " b.ITEM_USERNAME, " +//用户昵称 " b.ITEM_USERID, " +//微博id " b.ITEM_EQUIPMENT, " +//发文设备 " b.ITEM_USERTYPE, " +//用户验证类型 " b.ITEM_RELEASETIME, " +//发文时间 " b.ITEM_TEXT, " +//HTML正文 " b.ITEM_SHARE, " +//转发数 " b.ITEM_COMMENT, " +//评论数 " b.ITEM_PRAISE, " +//点赞数 //" b.ITEM_ADDRESS AS ITEM_AD, " +//文章地址 " b.ITEM_ADDRESS, " +//文章地址 " b.ITEM_CREATETIME, " +//抓取时间 " b.ITEM_NOTYPETEXT, " +//无类型文本 " b.ITEM_PROJECT, " +//所属项目 " b.ITEM_PROJECTID, " +//所属项目id " b.ITEM_SAVEUSERID " +//保存用户id " FROM " + " tlk_collection a " + " LEFT JOIN tlk_collection_1 b ON a.ITEM_PROJECTID = b.ITEM_PROJECTID " ; println("read sql ----->: " + sql ); return sql; } }]]> 4