thirdgatewayname.java

来自「短信网关发送接受平台。」· Java 代码 · 共 39 行

package orderapp;

/**
 * Title:
 * Description:
 * Copyright:    Copyright (c) 2002
 * Company:
 * @author
 * @version 1.0
 */
import data.*;
import java.sql.*;
public class ThirdGatewayName {
       public ConnectionPool data;
       public ResultSet rs;
       public String sql;
       public String result;
	public ThirdGatewayName() {
	       data=new ConnectionPool();
	}
	public String getGatewayName(long thirdNum){
		      System.out.println("JJ");
		       result="";
		       sql="select gateway from mobile_gateway_ref where start_number<"+thirdNum+" and end_number>"+thirdNum;
		       System.out.println(sql);
		try{
			 rs=data.executeQuery(sql);
			 rs.next();
			 result=rs.getString("gateway");
			 rs=null;
	       }
	       catch(SQLException e){
			       result=null;
			       e.printStackTrace();
	       }

	       return result;
	}
}