public class DBCurrencies
extends java.lang.Object
Constructor and Description |
---|
DBCurrencies() |
Modifier and Type | Method and Description |
---|---|
static CurrencyCode |
currencyCodeFor(int iNumCode) |
static CurrencyCode |
currencyCodeFor(java.lang.String sAlphaCode) |
static java.util.ArrayList<CurrencyCode> |
currencyCodes(java.sql.Connection oConn) |
static void |
main(java.lang.String[] args) |
static void |
updateConversionRates(java.sql.Connection oConn,
java.lang.String sBaseCurrency)
Update nu_conversion column of k_lu_currencies for a given base currency
Conversion rates are computed by calling a free web service.
|
public static java.util.ArrayList<CurrencyCode> currencyCodes(java.sql.Connection oConn) throws java.sql.SQLException
java.sql.SQLException
public static CurrencyCode currencyCodeFor(int iNumCode) throws java.lang.NullPointerException
java.lang.NullPointerException
public static CurrencyCode currencyCodeFor(java.lang.String sAlphaCode) throws java.lang.NullPointerException
java.lang.NullPointerException
public static void updateConversionRates(java.sql.Connection oConn, java.lang.String sBaseCurrency) throws java.sql.SQLException, java.lang.NullPointerException, java.lang.NumberFormatException
Update nu_conversion column of k_lu_currencies for a given base currency
Conversion rates are computed by calling a free web service. Each time a conversion is get a new row is inserted at k_lu_currencies_history with the conversion rate found at current timestampoConn
- JDBC database connectionsBaseCurrency
- Base Currency alphanumeric 3 letter uppercase ISO codejava.sql.SQLException
java.lang.NullPointerException
java.lang.NumberFormatException
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception