netstatbean.java

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

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

public class NetstatBean extends NetstatDao{
 public static boolean isExists(String netstatMachIp)
        throws SysException
    {
        return NetstatDao.getRowCountBySql("SELECT COUNT(*) FROM " + NetstatDao.tableName + " WHERE mach_Name = '" + netstatMachIp + "'") >= 1;
    }

    public static boolean isExists(int id, String netstatMachIp)
        throws SysException
    {
        return NetstatDao.getRowCountBySql("SELECT COUNT(*) FROM " + NetstatDao.tableName + " WHERE mach_Name = '" + netstatMachIp + "'" + " AND ID <> '" + id + "'") >= 1;
    }
}