package mmsproject.common;

import java.sql.*;
import mmsproject.*;

/**
 *
 * <p>Title: 彩信發送接收項目</p>
 *
 * <p>Description: 數據庫操作類</p>
 *
 * <p>Copyright: 肖毅文 Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author tomato
 * @version 1.0
 */
public class DataController {
  public DataController() {
  }

  /**
   * 取得傳入的手機號碼的前綴判斷手機號碼類型
   * @param strPreFix String 前綴
   * @return int
   */
  public int GetNumberType(String strPreFix) {
    int value = -1;
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

    String sql = "select NumberType from tb_number_type where PreFix='" + strPreFix + "'";

    try {
      conn = ConnectionManager.getSqlConnection();
      stmt = conn.createStatement();
      rs = stmt.executeQuery(sql);
      if (rs.next()) {
        value = rs.getInt("NumberType");
      }
    } catch (Exception ex) {
      ex.printStackTrace();
    } finally {
      ConnectionManager.closeSqlResultSet(rs);
      ConnectionManager.closeSqlStatement(stmt);
      ConnectionManager.closeSqlConnection(conn);
    }

    return value;
  }

}