Synapse techno contains information about new technology,tutorials of computer programming languages like JAVA,JSON,XML,VBA and Web Designing languages like HTML,HTML 5 ,CSS,Scripting languages JavaScript and its library like jquery,react js,node js etc.
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...
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...
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...
Comments
Post a Comment