(Sinhala) How TO Use Visual Studio 2015 With Oracle Database Video
In this 3 videos i will show how to use Visual Studio 2015 with Oracle Database and do the basic functions such as Add, Edit, Delete and View.
Posts
How To - Creating An Auto SQL Query Class In Java
This class was developed to eliminate the need to type SQL statements, in any java application where databases are used. This class needs 'AutoDBConnect' class to work properly. it will able to add, edit and delete images from a DB.
How To - Creating A Textbox ( jTextbox) Validation Class In Java
This class was developed to be used in a java windows form application to validated jtextboxes easily. 1. Add the class to project 2. Create an object 3. use appropriate method with your parameters eg;- AutoValidation validation =new AutoValidation(); validation.ValidationCheck(CustomerId, true,0,'@'); so here CustomerID is jTextbox and true is to check if it's empty and 0 means no length check and @ is a special character so you can input number and alphabetic. Read class comments for more information Download Source Code
How To - Create a Database Connection Class in Java (MySQL)
This was created when i was doing a project and was creating lot of database connections and i final spend my time to create a proper class to be used by other class of my projects. special attention was given to the variable creation. so that same could be used all over the project and to make standardized the code as possible. also to reduce the amount of memory used. You can use the methods in this class to execute or get a resultset just insert the SQL query in a String format Warning- this class returns a resultset this could lead to memory leak so better to close connection which are created. Download Source Code