staffmore.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 23 行

package com.sxit.wap.staff;
import java.sql.*;
import java.util.*;
import com.sxit.wap.common.*;
import com.sxit.wap.exception.*;

public class StaffMore extends StaffDao{
  public static int getRowCountByGroupIdAndMobile(int groupId, String mobile) throws SysException {
    String sql = "SELECT COUNT(*) FROM " + tableName + " WHERE GROUP_ID = " + groupId +
        (StringUtil.isNotEmpty(mobile)?" AND TEL LIKE '%" + mobile + "%'":"" + " ORDER BY USER_NAME");
    return getRowCountBySql(sql);
  }

  public static Collection queryByGroupIdAndMobile(int groupId, String mobile, int beginRow, int endRow) throws SysException {
    String sql = "SELECT * FROM " + tableName + " WHERE GROUP_ID = " + groupId +
        (StringUtil.isNotEmpty(mobile)?" AND TEL LIKE '%" + mobile + "%'":"" + " ORDER BY USER_NAME");
    return queryBySql(sql, beginRow, endRow);
  }

  public static void main(String[] args) {
  }
}