tblack.java

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

package com.sxit.pim.black;

import java.util.*;
import java.sql.*;

/**
 * <p>类名: Tblack</p>
 * <p>功能: black</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2006-01-09
 * @修改纪录
 */
public class Tblack
    extends TblackImpl {
    public Tblack() {
        super();
    }

    /*
    判断mdn是否在黑名单中
     */
    public static boolean isExist(Connection con, String mdn) throws
        SQLException {
        PreparedStatement stmt = null;
        ResultSet rs = null;
        int cnt = 0;
        String sql = "";
        try {
            sql = "select count(*) as cnt from tblack where mdn='" +
                mdn + "' and statusid=2";
            stmt = con.prepareStatement(sql);
            rs = stmt.executeQuery();
            if (rs.next()) {
                cnt = rs.getInt("cnt");
            }
            stmt.close();
        }
        finally {
            if (stmt != null)
                stmt.close();
        }
        if (cnt==0){
        return false;
    }else{
    return true;
    }
    }

}