7,714
社区成员
发帖
与我相关
我的任务
分享
Connection con = null;
PreparedStatement pt = null;
ResultSet rs = null;
int logFlag = 0;
String strAlert = "";
try{
con = com.core.db.DBUtils.getConnection();
pt = con.prepareStatement(" SELECT userid, "
+ " sum(IIF(WEBNUM is NULL or WEBNUM = '',1,0))as NOTWEBNUM, "
+ " sum(IIF(WEBNUM is not NULL and REPLACE(WEBNUM,' ','') <> '',1,0))as HASWEBNUM, "
+ " sum(IIF(user_delete = '1',1,0))as USER_DEL, "
+ " sum(IIF(deleteflage = '1',1,0))as MNG_DEL, "
+ " sum(1) as C "
+ " FROM tblinfo "
+ " group by userid ");
rs = pt.executeQuery();