Problem: One Excel sheet named “Account Info” contains accountnumber and account name. The other sheet named “Order Info” contains order mapping between orderid and accountnumber. Now we need to add another column to the second sheet to show the matching … Continue reading
You can use the “&” operator for this purpose, see the attached screenshot.
Imagining that you want to open the Windows console when you are browsing to a deep directory hierarchy M:\liuzy163\projects\PictureManager\src\java\ca\zl\picturemanager\flow\action, and you need to perform some command line actions in this folder. You can do so easily by shift+right click the … Continue reading
Problem: An application deployed on Tomcat server (via Coldfusion11) suffers slowness problem. Sometimes opening up a https page could take 20 seconds or so. The problem was not experienced on CF9 (which doesn’t use Tomcat). And the same application runs … Continue reading
Posted in Coldfusion, Java, Linux, Tool and Debug
Tagged Coldfusion, Coldfusion 11, entropy, Java, Linux, Random number, SeedGenerator, Tomcat
Apache POI is a Java library for processing Microsoft Office files. Here below are a few limited examples of its operation on Excel files(both in xls and xlsx format). Maven POM Add the following dependency into your project pom.xml file … Continue reading
Posted in Excel, Java
Tagged Excel, Java, POI
HSQLDB in-memory database is often used with Hibernate for testing, prototyping and even in production environment. With Hibernate, you can perform powerful database operations either using the ORM based APIs, HSQL or native SQL. As a developer, sometimes you want … Continue reading
PageSPeed Insight is provided by Google to test your web pages loading speed and give you advice on how to make them faster. Simply copy your web page URL and paste to the page to have a try.