datacontroller.java

彩信开发一般应用好了不？彩信开发一般应用好了不？彩信开发一般应用好了不？彩信开发一般应用好了不？彩信开发一般应用好了不？

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;
  }

}