Monday, May 25, 2009

Java- Searching a matching countrycode column from database, exception code

String myNumber = destNumber.substring(1);
if(myNumber.startsWith("00")){
myNumber = myNumber.substring(2);
} else if(myNumber.startsWith("0")) {
myNumber = myNumber.substring(1);
} else if(myNumber.startsWith("+")){
myNumber = myNumber.substring(1);
}
try
{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection (dbUrl);
s = conn.createStatement();
s.executeQuery("SELECT CountryCode, CountryName, CallRate FROM ratestable");
rs = s.getResultSet();
boolean myMatch = false;
while(rs.next())
{
String myLocalNumber = "";
String myCountryCode = rs.getString(1);
if(myNumber.startsWith(myCountryCode)){
myMatch = true;
myLocalNumber = myNumber.substring(myCountryCode.length());
System.out.println("Country Code:"+myCountryCode+"Local no="+myLocalNumber);
myArrayList.add(myCountryCode);
myArrayList.add(rs.getString(2));
myArrayList.add(rs.getString(3));
myArrayList.add(myConnectionType);
myArrayList.add(myLocalNumber);
return myArrayList;
}
}