areabean.java

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

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

public class AreaBean extends AreaDao{
  public static boolean isExists(String areaName) throws SysException {
    return getRowCountBySql("SELECT COUNT(*) FROM " + tableName + " WHERE AREA_NAME = '" + areaName +"'")>=1;
  }
  public static boolean isExists(int id, String areaName) throws SysException {
    return getRowCountBySql("SELECT COUNT(*) FROM " + tableName + " WHERE AREA_NAME = '" + areaName +"'" + " AND ID <> '" + id + "'")>=1;
  }
  public static boolean isInArea(String userMdn) throws SysException
  {
    String temp = userMdn.substring(0, 6);
    String sql = "SELECT COUNT(*) FROM  " + AreaDao.tableName + " WHERE AREA_NUMBER LIKE '" + temp + "%'";
    return AreaBean.getRowCountBySql(sql) > 0;
  }
}