Code Samples

Tuesday, July 1, 2014

Strict Standards: Non-static method Configure::getInstance() should not be called

I Got this error as follows:

Strict Standards: Redefining already defined constructor for class Object in C:\Xampp\htdocs\webapp\cake\libs\object.php on line 54

Strict Standards: Non-static method Configure::getInstance() should not be called statically in C:\Xampp\htdocs\webapp\cake\bootstrap.php on line 38

I solved this problem by changing in /cake/bootstrap.php.

FIND:
error_reporting(E_ALL & ~E_DEPRECATED);

REPLACE:
error_reporting(E_ALL & ~E_STRICT & ~E_DEPRECATED);

Monday, June 30, 2014

Grails get bean/service from service or other class

import org.codehaus.groovy.grails.plugins.web.taglib.ApplicationTagLib
import grails.util.Holders
import org.codehaus.groovy.grails.commons.GrailsApplication

public static GrailsApplication grailsApplication = Holders.grailsApplication;
public static ServletContext servletContext = Holders.servletContext;
public static ApplicationTagLib g = Holders.applicationContext.getBean("org.codehaus.groovy.grails.plugins.web.taglib.ApplicationTagLib")

def bean = Holders.applicationContext.getBean(beanIdentifier);
// beanIdentifier = userService, groupService etc...

Saturday, June 28, 2014

Encrypt & Decrypt String Using AES Algorithm & jQuery

<!doctype html>
<html>
<head>
<meta charset="utf-8"/>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="crypto-js/core-min.js"></script>
<script src="crypto-js/enc-utf16-min.js"></script>
<script src="crypto-js/enc-base64-min.js"></script>
<script src="crypto-js/aes.js"></script>
<script>
 $(function() {
  $('#test').on('submit', function() {
   var plaintext = $('#text').val();
   var secret = $('#secret').val();
   var encrypted = '' + CryptoJS.AES.encrypt(plaintext, secret);
   $("#output").prepend("<br/>Encrypted: " + encrypted);
   var decrypted = CryptoJS.AES.decrypt(encrypted, secret);
   $("#output").prepend("<br/><br/> Original From Encrypted: " + decrypted.toString(CryptoJS.enc.Utf8));

   return false;
  });  
 });   
</script>
</head> 
<body lang="en">  
    <form id="test">
        <p>
            <label>Secret</label><br>
            <input id="secret" value="Secret Passphrase">
        </p>
        <p>
            <label>Text</label><br>
            <textarea id="text">This is the secret message</textarea>
        </p>
        <input type="submit" id="submit">
    </form>
    <div id="output"></div>  
</body>
</html>

Required jQuery Files

Github Location

Friday, June 6, 2014

Java Formatting Price/Number According To Country/Currency

CurrencyFormat.java

import java.util.*;
import java.lang.*;
import java.text.*;


class CurrencyFormat {
 public static void main (String[] args) throws java.lang.Exception {
 Map<String, String> languagesMap = new TreeMap<String, String>();
        Locale[] locales = Locale.getAvailableLocales();
        for (Locale obj : locales) {
            if ((obj.getDisplayCountry() != null) && (!"".equals(obj.getDisplayCountry()))) {
                languagesMap.put(obj.getCountry(), obj.getLanguage());
            }
        }

        String[] countries = Locale.getISOCountries();
        int supportedLocale = 0, nonSupportedLocale = 0;
        for (String countryCode : countries) {
            Locale obj = null;
            if (languagesMap.get(countryCode) == null) {
                obj = new Locale("", countryCode);
                nonSupportedLocale++;
            }
            else {
                //create a Locale with own country's languages
                obj = new Locale(languagesMap.get(countryCode), countryCode);
                supportedLocale++;

            }
            NumberFormat currency = NumberFormat.getCurrencyInstance(obj);
            DecimalFormatSymbols decimalFormatSymbols = ((DecimalFormat) currency).getDecimalFormatSymbols();
            String currencySymbol = decimalFormatSymbols.getCurrencySymbol();
            decimalFormatSymbols.setCurrencySymbol("");
            ((DecimalFormat) currency).setDecimalFormatSymbols(decimalFormatSymbols);

            System.out.println("Country Code = " + obj.getISO3Country()
                    + ", Price = " + currency.format(35147869.3518).trim()
                    + ", Symbol: " + currencySymbol
                    + ", Name: " + decimalFormatSymbols.getCurrency().getDisplayName()
                    + ", Code: " + decimalFormatSymbols.getCurrency().getCurrencyCode()
                    + ", Country Name = " + obj.getDisplayCountry(obj)
                    + ", Country Name = " + obj.getDisplayCountry()
                    + ", Languages = " + obj.getDisplayLanguage());
        }
        System.out.println("nonSupportedLocale : " + nonSupportedLocale);
        System.out.println("supportedLocale : " + supportedLocale);
    }
}

Output

Country Code = AND, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = ARE, Price = 35,147,869.35, Symbol: د.إ.‏, Code: AED
Country Code = AFG, Price = 35,147,869.35, Symbol: AFN, Code: AFN
Country Code = ATG, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = AIA, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = ALB, Price = 35.147.869,35, Symbol: Lek, Code: ALL
Country Code = ARM, Price = 35,147,869.35, Symbol: AMD, Code: AMD
Country Code = ANT, Price = 35,147,869.35, Symbol: ANG, Code: ANG
Country Code = AGO, Price = 35,147,869.35, Symbol: AOA, Code: AOA
Country Code = ATA, Price = 35,147,869.35, Symbol: ¤, Code: XXX
Country Code = ARG, Price = 35.147.869,35, Symbol: $, Code: ARS
Country Code = ASM, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = AUT, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = AUS, Price = 35,147,869.35, Symbol: $, Code: AUD
Country Code = ABW, Price = 35,147,869.35, Symbol: AWG, Code: AWG
Country Code = ALA, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = AZE, Price = 35,147,869.35, Symbol: AZN, Code: AZN
Country Code = BIH, Price = 35.147.869,35, Symbol: КМ., Code: BAM
Country Code = BRB, Price = 35,147,869.35, Symbol: BBD, Code: BBD
Country Code = BGD, Price = 35,147,869.35, Symbol: BDT, Code: BDT
Country Code = BEL, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = BFA, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = BGR, Price = 35 147 869,35, Symbol: лв., Code: BGN
Country Code = BHR, Price = 35,147,869.352, Symbol: د.ب.‏, Code: BHD
Country Code = BDI, Price = 35,147,869, Symbol: BIF, Code: BIF
Country Code = BEN, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = BLM, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = BMU, Price = 35,147,869.35, Symbol: BMD, Code: BMD
Country Code = BRN, Price = 35,147,869.35, Symbol: BND, Code: BND
Country Code = BOL, Price = 35.147.869,35, Symbol: B$, Code: BOB
Country Code = BES, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = BRA, Price = 35.147.869,35, Symbol: R$, Code: BRL
Country Code = BHS, Price = 35,147,869.35, Symbol: BSD, Code: BSD
Country Code = BTN, Price = 35,147,869.35, Symbol: BTN, Code: BTN
Country Code = BVT, Price = 35,147,869.35, Symbol: NOK, Code: NOK
Country Code = BWA, Price = 35,147,869.35, Symbol: BWP, Code: BWP
Country Code = BLR, Price = 35 147 869, Symbol: Руб, Code: BYR
Country Code = BLZ, Price = 35,147,869.35, Symbol: BZD, Code: BZD
Country Code = CAN, Price = 35 147 869,35, Symbol: $, Code: CAD
Country Code = CCK, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = COD, Price = 35,147,869.35, Symbol: CDF, Code: CDF
Country Code = CAF, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = COG, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = CHE, Price = 35'147'869.35, Symbol: SFr., Code: CHF
Country Code = CIV, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = COK, Price = 35,147,869.35, Symbol: NZD, Code: NZD
Country Code = CHL, Price = 35.147.869, Symbol: Ch$, Code: CLP
Country Code = CMR, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = CHN, Price = 35,147,869.35, Symbol: ￥, Code: CNY
Country Code = COL, Price = 35.147.869,35, Symbol: $, Code: COP
Country Code = CRI, Price = 35,147,869.35, Symbol: C, Code: CRC
Country Code = CUB, Price = 35,147,869.35, Symbol: CUP, Code: CUP
Country Code = CPV, Price = 35,147,869.35, Symbol: CVE, Code: CVE
Country Code = CUW, Price = 35,147,869.35, Symbol: ANG, Code: ANG
Country Code = CXR, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = CYP, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = CZE, Price = 35 147 869,35, Symbol: Kč, Code: CZK
Country Code = DEU, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = DJI, Price = 35,147,869, Symbol: DJF, Code: DJF
Country Code = DNK, Price = 35.147.869,35, Symbol: kr, Code: DKK
Country Code = DMA, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = DOM, Price = 35,147,869.35, Symbol: RD$, Code: DOP
Country Code = DZA, Price = 35,147,869.35, Symbol: د.ج.‏, Code: DZD
Country Code = ECU, Price = 35.147.869,35, Symbol: $, Code: USD
Country Code = EST, Price = 35 147 869,35, Symbol: €, Code: EUR
Country Code = EGY, Price = 35,147,869.35, Symbol: ج.م.‏, Code: EGP
Country Code = ESH, Price = 35,147,869.35, Symbol: MAD, Code: MAD
Country Code = ERI, Price = 35,147,869.35, Symbol: ERN, Code: ERN
Country Code = ESP, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = ETH, Price = 35,147,869.35, Symbol: ETB, Code: ETB
Country Code = FIN, Price = 35 147 869,35, Symbol: €, Code: EUR
Country Code = FJI, Price = 35,147,869.35, Symbol: FJD, Code: FJD
Country Code = FLK, Price = 35,147,869.35, Symbol: FKP, Code: FKP
Country Code = FSM, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = FRO, Price = 35,147,869.35, Symbol: DKK, Code: DKK
Country Code = FRA, Price = 35 147 869,35, Symbol: €, Code: EUR
Country Code = GAB, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = GBR, Price = 35,147,869.35, Symbol: £, Code: GBP
Country Code = GRD, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = GEO, Price = 35,147,869.35, Symbol: GEL, Code: GEL
Country Code = GUF, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = GGY, Price = 35,147,869.35, Symbol: GBP, Code: GBP
Country Code = GHA, Price = 35,147,869.35, Symbol: GHS, Code: GHS
Country Code = GIB, Price = 35,147,869.35, Symbol: GIP, Code: GIP
Country Code = GRL, Price = 35,147,869.35, Symbol: DKK, Code: DKK
Country Code = GMB, Price = 35,147,869.35, Symbol: GMD, Code: GMD
Country Code = GIN, Price = 35,147,869, Symbol: GNF, Code: GNF
Country Code = GLP, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = GNQ, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = GRC, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = SGS, Price = 35,147,869.35, Symbol: GBP, Code: GBP
Country Code = GTM, Price = 35,147,869.35, Symbol: Q, Code: GTQ
Country Code = GUM, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = GNB, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = GUY, Price = 35,147,869.35, Symbol: GYD, Code: GYD
Country Code = HKG, Price = 35,147,869.35, Symbol: HK$, Code: HKD
Country Code = HMD, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = HND, Price = 35,147,869.35, Symbol: L, Code: HNL
Country Code = HRV, Price = 35.147.869,35, Symbol: Kn, Code: HRK
Country Code = HTI, Price = 35,147,869.35, Symbol: HTG, Code: HTG
Country Code = HUN, Price = 35 147 869,35, Symbol: Ft, Code: HUF
Country Code = IDN, Price = 35.147.869,35, Symbol: Rp, Code: IDR
Country Code = IRL, Price = 35,147,869.35, Symbol: €, Code: EUR
Country Code = ISR, Price = 35,147,869.35, Symbol: ש"ח, Code: ILS
Country Code = IMN, Price = 35,147,869.35, Symbol: GBP, Code: GBP
Country Code = IND, Price = 35,147,869.35, Symbol: Rs., Code: INR
Country Code = IOT, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = IRQ, Price = 35,147,869.352, Symbol: د.ع.‏, Code: IQD
Country Code = IRN, Price = 35,147,869.35, Symbol: IRR, Code: IRR
Country Code = ISL, Price = 35.147.869,, Symbol: kr., Code: ISK
Country Code = ITA, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = JEY, Price = 35,147,869.35, Symbol: GBP, Code: GBP
Country Code = JAM, Price = 35,147,869.35, Symbol: JMD, Code: JMD
Country Code = JOR, Price = 35,147,869.352, Symbol: د.أ.‏, Code: JOD
Country Code = JPN, Price = 35,147,869, Symbol: ￥, Code: JPY
Country Code = KEN, Price = 35,147,869.35, Symbol: KES, Code: KES
Country Code = KGZ, Price = 35,147,869.35, Symbol: KGS, Code: KGS
Country Code = KHM, Price = 35,147,869.35, Symbol: KHR, Code: KHR
Country Code = KIR, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = COM, Price = 35,147,869, Symbol: KMF, Code: KMF
Country Code = KNA, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = PRK, Price = 35,147,869.35, Symbol: KPW, Code: KPW
Country Code = KOR, Price = 35,147,869, Symbol: ￦, Code: KRW
Country Code = KWT, Price = 35,147,869.352, Symbol: د.ك.‏, Code: KWD
Country Code = CYM, Price = 35,147,869.35, Symbol: KYD, Code: KYD
Country Code = KAZ, Price = 35,147,869.35, Symbol: KZT, Code: KZT
Country Code = LAO, Price = 35,147,869.35, Symbol: LAK, Code: LAK
Country Code = LBN, Price = 35,147,869.35, Symbol: ل.ل.‏, Code: LBP
Country Code = LCA, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = LIE, Price = 35,147,869.35, Symbol: CHF, Code: CHF
Country Code = LKA, Price = 35,147,869.35, Symbol: LKR, Code: LKR
Country Code = LBR, Price = 35,147,869.35, Symbol: LRD, Code: LRD
Country Code = LSO, Price = 35,147,869.35, Symbol: LSL, Code: LSL
Country Code = LTU, Price = 35 147 869,35, Symbol: Lt, Code: LTL
Country Code = LUX, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = LVA, Price = 35 147 869,35, Symbol: Ls, Code: LVL
Country Code = LBY, Price = 35,147,869.352, Symbol: د.ل.‏, Code: LYD
Country Code = MAR, Price = 35,147,869.35, Symbol: د.م.‏, Code: MAD
Country Code = MCO, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = MDA, Price = 35,147,869.35, Symbol: MDL, Code: MDL
Country Code = MNE, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = MAF, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = MDG, Price = 35,147,869.35, Symbol: MGA, Code: MGA
Country Code = MHL, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = MKD, Price = 35.147.869,35, Symbol: Den, Code: MKD
Country Code = MLI, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = MMR, Price = 35,147,869.35, Symbol: MMK, Code: MMK
Country Code = MNG, Price = 35,147,869.35, Symbol: MNT, Code: MNT
Country Code = MAC, Price = 35,147,869.35, Symbol: MOP, Code: MOP
Country Code = MNP, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = MTQ, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = MRT, Price = 35,147,869.35, Symbol: MRO, Code: MRO
Country Code = MSR, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = MLT, Price = 35,147,869.35, Symbol: €, Code: EUR
Country Code = MUS, Price = 35,147,869.35, Symbol: MUR, Code: MUR
Country Code = MDV, Price = 35,147,869.35, Symbol: MVR, Code: MVR
Country Code = MWI, Price = 35,147,869.35, Symbol: MWK, Code: MWK
Country Code = MEX, Price = 35,147,869.35, Symbol: $, Code: MXN
Country Code = MYS, Price = 35,147,869.35, Symbol: RM, Code: MYR
Country Code = MOZ, Price = 35,147,869.35, Symbol: MZN, Code: MZN
Country Code = NAM, Price = 35,147,869.35, Symbol: NAD, Code: NAD
Country Code = NCL, Price = 35,147,869, Symbol: XPF, Code: XPF
Country Code = NER, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = NFK, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = NGA, Price = 35,147,869.35, Symbol: NGN, Code: NGN
Country Code = NIC, Price = 35,147,869.35, Symbol: $C, Code: NIO
Country Code = NLD, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = NOR, Price = 35 147 869,35, Symbol: kr, Code: NOK
Country Code = NPL, Price = 35,147,869.35, Symbol: NPR, Code: NPR
Country Code = NRU, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = NIU, Price = 35,147,869.35, Symbol: NZD, Code: NZD
Country Code = NZL, Price = 35,147,869.35, Symbol: $, Code: NZD
Country Code = OMN, Price = 35,147,869.352, Symbol: ر.ع.‏, Code: OMR
Country Code = PAN, Price = 35,147,869.35, Symbol: B, Code: PAB
Country Code = PER, Price = 35.147.869,35, Symbol: S/, Code: PEN
Country Code = PYF, Price = 35,147,869, Symbol: XPF, Code: XPF
Country Code = PNG, Price = 35,147,869.35, Symbol: PGK, Code: PGK
Country Code = PHL, Price = 35,147,869.35, Symbol: Php, Code: PHP
Country Code = PAK, Price = 35,147,869.35, Symbol: PKR, Code: PKR
Country Code = POL, Price = 35 147 869,35, Symbol: zł, Code: PLN
Country Code = SPM, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = PCN, Price = 35,147,869.35, Symbol: NZD, Code: NZD
Country Code = PRI, Price = 35,147,869.35, Symbol: $, Code: USD
Country Code = PSE, Price = 35,147,869.35, Symbol: ILS, Code: ILS
Country Code = PRT, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = PLW, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = PRY, Price = 35.147.869, Symbol: G, Code: PYG
Country Code = QAT, Price = 35,147,869.35, Symbol: ر.ق.‏, Code: QAR
Country Code = REU, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = ROU, Price = 35.147.869,35, Symbol: LEI, Code: RON
Country Code = SRB, Price = 35.147.869,35, Symbol: дин., Code: RSD
Country Code = RUS, Price = 35 147 869,35, Symbol: руб., Code: RUB
Country Code = RWA, Price = 35,147,869, Symbol: RWF, Code: RWF
Country Code = SAU, Price = 35,147,869.35, Symbol: ر.س.‏, Code: SAR
Country Code = SLB, Price = 35,147,869.35, Symbol: SBD, Code: SBD
Country Code = SYC, Price = 35,147,869.35, Symbol: SCR, Code: SCR
Country Code = SDN, Price = 35,147,869.35, Symbol: ج.س.‏, Code: SDG
Country Code = SWE, Price = 35 147 869,35, Symbol: kr, Code: SEK
Country Code = SGP, Price = 35,147,869.35, Symbol: S$, Code: SGD
Country Code = SHN, Price = 35,147,869.35, Symbol: SHP, Code: SHP
Country Code = SVN, Price = 35.147.869,35, Symbol: €, Code: EUR
Country Code = SJM, Price = 35,147,869.35, Symbol: NOK, Code: NOK
Country Code = SVK, Price = 35 147 869,35, Symbol: €, Code: EUR
Country Code = SLE, Price = 35,147,869.35, Symbol: SLL, Code: SLL
Country Code = SMR, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = SEN, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = SOM, Price = 35,147,869.35, Symbol: SOS, Code: SOS
Country Code = SUR, Price = 35,147,869.35, Symbol: SRD, Code: SRD
Country Code = STP, Price = 35,147,869.35, Symbol: STD, Code: STD
Country Code = SLV, Price = 35,147,869.35, Symbol: C, Code: SVC
Country Code = SXM, Price = 35,147,869.35, Symbol: ANG, Code: ANG
Country Code = SYR, Price = 35,147,869.35, Symbol: ل.س.‏, Code: SYP
Country Code = SWZ, Price = 35,147,869.35, Symbol: SZL, Code: SZL
Country Code = TCA, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = TCD, Price = 35,147,869, Symbol: XAF, Code: XAF
Country Code = ATF, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = TGO, Price = 35,147,869, Symbol: XOF, Code: XOF
Country Code = THA, Price = 35,147,869.35, Symbol: ฿, Code: THB
Country Code = TJK, Price = 35,147,869.35, Symbol: TJS, Code: TJS
Country Code = TKL, Price = 35,147,869.35, Symbol: NZD, Code: NZD
Country Code = TLS, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = TKM, Price = 35,147,869.35, Symbol: TMT, Code: TMT
Country Code = TUN, Price = 35,147,869.352, Symbol: د.ت.‏, Code: TND
Country Code = TON, Price = 35,147,869.35, Symbol: TOP, Code: TOP
Country Code = TUR, Price = 35.147.869,35, Symbol: TL, Code: TRY
Country Code = TTO, Price = 35,147,869.35, Symbol: TTD, Code: TTD
Country Code = TUV, Price = 35,147,869.35, Symbol: AUD, Code: AUD
Country Code = TWN, Price = 35,147,869.35, Symbol: NT$, Code: TWD
Country Code = TZA, Price = 35,147,869.35, Symbol: TZS, Code: TZS
Country Code = UKR, Price = 35 147 869,35, Symbol: грн., Code: UAH
Country Code = UGA, Price = 35,147,869.35, Symbol: UGX, Code: UGX
Country Code = UMI, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = USA, Price = 35,147,869.35, Symbol: $, Code: USD
Country Code = URY, Price = 35.147.869,35, Symbol: NU$, Code: UYU
Country Code = UZB, Price = 35,147,869.35, Symbol: UZS, Code: UZS
Country Code = VAT, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = VCT, Price = 35,147,869.35, Symbol: XCD, Code: XCD
Country Code = VEN, Price = 35.147.869,35, Symbol: Bs.F., Code: VEF
Country Code = VGB, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = VIR, Price = 35,147,869.35, Symbol: USD, Code: USD
Country Code = VNM, Price = 35.147.869,35, Symbol: đ, Code: VND
Country Code = VUT, Price = 35,147,869, Symbol: VUV, Code: VUV
Country Code = WLF, Price = 35,147,869, Symbol: XPF, Code: XPF
Country Code = WSM, Price = 35,147,869.35, Symbol: WST, Code: WST
Country Code = YEM, Price = 35,147,869.35, Symbol: ر.ي.‏, Code: YER
Country Code = MYT, Price = 35,147,869.35, Symbol: EUR, Code: EUR
Country Code = ZAF, Price = 35,147,869.35, Symbol: R, Code: ZAR
Country Code = ZMB, Price = 35,147,869.35, Symbol: ZMK, Code: ZMK
Country Code = ZWE, Price = 35,147,869.35, Symbol: ZWL, Code: ZWL
nonSupportedLocale : 155
supportedLocale : 94

Thursday, June 5, 2014

Java: Rounding Number To Nearest Interval Such: 0.05, 0.5, 0.1, 5, 10, 100

RoundNumber.java

import java.math.BigDecimal;
import java.math.RoundingMode;
class RoundNumber {
    public static void main(String[] args) throws Exception {
         BigDecimal Price = new BigDecimal("232.573");
         BigDecimal Tick = new BigDecimal("0.05");
         BigDecimal Price2 = Price.divide(Tick, 9, RoundingMode.HALF_EVEN);
         Price2 = Price2.setScale(0, RoundingMode.HALF_UP).multiply(Tick);
         System.out.println("Price: " + Price + ", Round: " + Tick + ", Converted: " + Price2);
    }
}

Output:

Price: 232.573, Round: 0.05, Converted: 232.55
Price: 232.533, Round: 0.05, Converted: 232.55
Price: 232.523, Round: 0.05, Converted: 232.50
Price: 232.5235455, Round: 0.005, Converted: 232.525
Price: 232.5235, Round: 0.5, Converted: 232.5
Price: 232.446, Round: 0.5, Converted: 232.5
Price: 232.246, Round: 0.5, Converted: 232.0
Price: 1455.546, Round: 0.05, Converted: 1455.55
Price: 1455.528, Round: 0.05, Converted: 1455.55
Price: 1455.524, Round: 0.05, Converted: 1455.50
Price: 232.246, Round: 5, Converted: 230
Price: 232.546, Round: 5, Converted: 235
Price: 232.546, Round: 10, Converted: 230
Price: 235.546, Round: 10, Converted: 240
Price: 35.546, Round: 100, Converted: 0
Price: 55.546, Round: 100, Converted: 100
Price: 1455.524, Round: 100, Converted: 1500
Price: 1355.524, Round: 100, Converted: 1400
Price: 1248.524, Round: 100, Converted: 1200
Price: 1455.546, Round: 0.10, Converted: 1455.50
Price: 1455.556, Round: 0.10, Converted: 1455.60

Tuesday, June 3, 2014

MySql Convert String to Date

STR_TO_DATE('Jun/03/2014', '%M/%d/%Y');  => 2014-06-03; [VALID]

STR_TO_DATE('2014-04-25', '%Y-%m-%d'); => 2014-06-25; [VALID]

STR_TO_DATE( '69/Jun/2014', '%d/%M/%Y' ) => NULL; [INVALID]

The formats that can be used are:

Format	Description
%a	Abbreviated weekday name
%b	Abbreviated month name
%c	Month, numeric
%D	Day of month with English suffix
%d	Day of month, numeric (00-31)
%e	Day of month, numeric (0-31)
%f	Microseconds
%H	Hour (00-23)
%h	Hour (01-12)
%I	Hour (01-12)
%i	Minutes, numeric (00-59)
%j	Day of year (001-366)
%k	Hour (0-23)
%l	Hour (1-12)
%M	Month name
%m	Month, numeric (00-12)
%p	AM or PM
%r	Time, 12-hour (hh:mm:ss AM or PM)
%S	Seconds (00-59)
%s	Seconds (00-59)
%T	Time, 24-hour (hh:mm:ss)
%U	Week (00-53) where Sunday is the first day of week
%u	Week (00-53) where Monday is the first day of week
%V	Week (01-53) where Sunday is the first day of week, used with %X
%v	Week (01-53) where Monday is the first day of week, used with %x
%W	Weekday name
%w	Day of the week (0=Sunday, 6=Saturday)
%X	Year of the week where Sunday is the first day of week, four digits, used with %V
%x	Year of the week where Monday is the first day of week, four digits, used with %v
%Y	Year, four digits
%y	Year, two digits

Saturday, May 10, 2014

Display Hibernate Sql Parameter Values

Configure Log4j in Hibernate

Create a file named 'log4j.properties' under main project, where 'hibernate.cfg.xml' exists with following contents. This configuration will log sql in a file, the location you specified and also log in your project IDE console.

# Log everything. Good for troubleshooting  
log4j.logger.org.hibernate=INFO
# Log all SQL DML statements as they are executed
log4j.logger.org.hibernate.SQL=TRACE
# Log all JDBC parameters(TRACE|INHERITED);
log4j.logger.org.hibernate.type=TRACE
log4j.logger.org.hibernate.hql.ast.AST=info
# Log all SQL DDL statements as they are executed(INHERITED|WARN)
log4j.logger.org.hibernate.tool.hbm2ddl=INHERITED
log4j.logger.org.hibernate.hql=debug
log4j.logger.org.hibernate.cache=info
log4j.logger.org.hibernate.jdbc=debug   
# Log all second-level cache activity
log4j.logger.org.hibernate.cache=INHERITED
# Log all OSCache activity - used by Hibernate
log4j.logger.com.opensymphony.oscache=INHERITED
# Log transaction related activity
log4j.logger.org.hibernate.transaction=INHERITED
# Log all JDBC resource acquisition
log4j.logger.org.hibernate.jdbc=INHERITED
# Log all JAAS authorization requests
log4j.logger.org.hibernate.secure=INHERITED
# Root logger option  
log4j.rootLogger=INFO, CUSTOM_FILE, CUSTOM_STD_OUT  

# Define the file appender
log4j.appender.CUSTOM_FILE=org.apache.log4j.DailyRollingFileAppender
# Set the DatePattern (Every hour interval)
log4j.appender.CUSTOM_FILE.DatePattern='['yyyy-MM-dd-HH'].log'
# Set the DatePattern (Every minute interval)
#log4j.appender.CUSTOM_FILE.DatePattern='['yyyy-MM-dd-HH-mm'].log'
# Set the append to false, should not overwrite
log4j.appender.CUSTOM_FILE.Append=true
# Set the name of the file.
# It'll be created every hour/minute with different 
# filename(appnded with yyyy-MM-dd-HH/yyyy-MM-dd-HH-mm).
log4j.appender.CUSTOM_FILE.File=C:/tmp/debug.log
# Define the layout for file appender
log4j.appender.CUSTOM_FILE.layout=org.apache.log4j.PatternLayout
log4j.appender.CUSTOM_FILE.layout.conversionPattern= %d{HH:mm:ss} %m%n

# Direct log messages to stdout  
log4j.appender.CUSTOM_STD_OUT=org.apache.log4j.ConsoleAppender  
log4j.appender.CUSTOM_STD_OUT.Target=System.out  
log4j.appender.CUSTOM_STD_OUT.layout=org.apache.log4j.PatternLayout  
log4j.appender.CUSTOM_STD_OUT.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n 
log4j.appender.CUSTOM_STD_OUT.layout.ConversionPattern=%d{ABSOLUTE} - %m%n

Execute following line of code when project start/run, before performing any CRUD operations:

ClassLoader loader = Thread.currentThread().getContextClassLoader();
URL url = loader.getResource("log4j.properties");
System.out.println(url);
PropertyConfigurator.configure(url);

You have to include log4j-1.2.16.jar in your project

When you perform query, output would be like this in your IDE consle:

/* When perform HQL */
10:30:29,149 - HQL: SELECT MIN(id) FROM com.pkm.domains.User

/* When perform SQL */
10:30:29,149 - SQL: select min(user0_.id) as col_0_0_ from User user0_
10:30:29,149 - throwQueryException() : no errors
10:30:29,191 - select min(user0_.id) as col_0_0_ from User user0_ limit ?
10:30:29,226 - Found [14] as column [col_0_0_]
10:30:29,228 - select user0_.id as id0_0_, user0_.date_updated as date2_0_0_, user0_.email as email0_0_, user0_.first_name as first4_0_0_, user0_.last_name as last5_0_0_, user0_.phone_number as phone6_0_0_, user0_.area_code as area7_0_0_ from User user0_ where user0_.id=?
10:30:29,230 - binding parameter [1] as [BIGINT] - 14
10:30:29,238 - Found [2014-05-10 10:23:08.0] as column [date2_0_0_]
10:30:29,238 - Found [pritomkucse@gmail.com] as column [email0_0_]
10:30:29,238 - Found [Pritom] as column [first4_0_0_]
10:30:29,239 - Found [Kumar Mondal] as column [last5_0_0_]

/* Update Query */
10:30:29,261 - update User set date_updated=?, email=?, first_name=?, last_name=?, phone_number=?, area_code=? where id=?
10:30:29,262 - binding parameter [1] as [TIMESTAMP] - Sat May 10 10:30:29 ALMT 2014
10:30:29,263 - binding parameter [2] as [VARCHAR] - pritomkucse@gmail.com
10:30:29,263 - binding parameter [3] as [VARCHAR] - Pritom
10:30:29,264 - binding parameter [4] as [VARCHAR] - Kumar Mondal
10:30:29,264 - binding parameter [7] as [BIGINT] - 14

Pages