adminbean.java

WAP PUSH后台源码,WAP PUSH后台源码

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

public class AdminBean extends AdminDao{
  public static boolean isExists(String adminName) throws SysException {
    try {
      findByPK(adminName);
      return true;
    } catch (FinderException e) {
      return false;
    }
  }
  public static Collection queryAdmin(int beginRow, int endRow) throws SysException {
    String sql = "SELECT * FROM " + tableName + " WHERE ADMIN_FLAG != 1";
    return queryBySql(sql, beginRow, endRow);
  }
  public static int getRowCountOfAdmin() throws SysException {
    String sql = "SELECT COUNT(*) FROM " + tableName + " WHERE ADMIN_FLAG != 1";
    return getRowCountBySql(sql);
  }
  public static void changeAdminPwd(String adminName, String adminPwd) throws SysException {
    String sql = "UPDATE " + tableName + " SET ADMIN_PWD = '" + adminPwd + "'  WHERE ADMIN_NAME = '" + adminName + "'";
    updateBySql(sql);
  }
}