designinghub


Comments

Post a Comment

Popular posts from this blog

Introduction to VBA

Image
VBA stands for Visual Basic Application. . It is an event driven Programming language by Microsoft   now a days   it is predominantly used with Microsoft applications such as MS –Excel , MS-Word, MS-Access. VBA Application MS-Excel Provides loads on inbuilt functions.MS-Excel Provides only basic inbuilt functions which may not be sufficient to perform complex calculations but by using VBA we can create our own functions and perform our desirable tasks How to Access VBA Editor  In excel windows Press “ALT +F11”  to open VBA editor .. Step 1:   At first open Excel sheet Step 2:  Follow Above Tricks and open VBA Editor will be open  which looks like this . Some Important VBA Terminologies  Modules : Modules is the area where code is written. In above figure there is no any modules. How to insert Module ??? To insert modules in VBA right click on Microsoft Office Objects and then  a win...
Keep reading

Secure Database Connectivity in node.js with mysql

Image
Hi Everyone! Yesterday my friend Andrea from Italy asked me a question about secure Database connectivity in node.js with mysql i.e. he wants to a secure database connection in node.js for some secure keys like username,password,database name that we use during database connectivity.His problem is obviously right from security point of view as we know that JavaScript is client side scripting knowledge so it is compiled on client side so after inspecting page some one can be able to view these secure keys which I discussed previously. I surf internet and found there are various ways to solve this problem I am not discussing all of them here but also I discussing here two of them and after this discussion I think Andrea and other reader who are facing with same problem can be able to resolve their problem. I choose two ways to solve this problem. Connection code in app.js file Create a Json file Connection code in app.js file : Javascript is client side language and code i...
Keep reading

Java Regular Expression

Image
Java Regex or Regular Expression is an API to define Pattern for searching or manipulating Strings, In simple word we can say that Regular expression is a representation of a group of String object according to a particular Pattern. Java provides the java.util.regex package for pattern matching with regular expressions. java.util.regex package consists of following three classes : Pattern Class In Pattern class Pattern object is a compiled version of a regular expression. It contains a compile() method which is used to create a Pattern. Pattern class provides no Public constructors.              Public static Pattern compile(String) Matcher Class Matcher object match the given pattern in the  target String Matcher object is created by matcher() method of Pattern Class     Public Matcher matcher (String target) Important Methods of Matcher class S. No. Method Description 1 bo...
Keep reading