SQL Index and co.

SQL Index and co.

In research progress in development, we need to have a good structure of our DataBase. Today I will show you the importance of a great organisation in your Data! His name is “index”. First of all, what are the basics of this idea? Based on: … What that: Structured Query Language (SQL). What for? Permit a communication with the database. How? Allow to write scripts. Ok, now we can begin : First of all: How to use index? To fully understand…

Lire la suite Lire la suite

Data Protections.

Data Protections.

In research progress in development, you must keep in mind the protection for your data. Today i will show you dependency of protetcions. It has a lot of name, because it has a lot of breaches. First of all, what are the basics of this idea ? Based on : Here I use SQL langage What that : It’s a langage uses to manipulate database. What for ? It’s to create and manipulate information. How ? With scripts and that’s why it’s dangerous. Ok, now…

Lire la suite Lire la suite

PHP Prepared Statement – a practical approach

PHP Prepared Statement – a practical approach

In this article, I will show you about the PHP prepared statements in PDO, their avantages and how to use them effectively. What is PHP prepared statements in PHP? Prepared statements for executing a plurality of the same SQL statement, when a database server executes a query, it goes through two main phases: preparation and execution. Preparation – the database server checks the syntax of the SQL statement and initializes internal server resources for the execution stage. Execution – the…

Lire la suite Lire la suite

Microsoft SQL Server

Microsoft SQL Server

What is Microsoft SQL Server used for? Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. Is SQL Server from Microsoft? Microsoft SQL Server is a relational database management system developed by Microsoft. Today SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability. The rise of data represents a tremendous opportunity and also poses challenges. Companies…

Lire la suite Lire la suite

Java Annotations

Java Annotations

Annotation has been a part of the core Java API from JDK5 onwards. Annotation means adding comments or instructions into the Java code so that the compiler provides a special treatment to the designated element. This feature, when incorporated appropriately, can leverage productivity by reducing bugs in the code. Annotation instructs the compiler to enforce some specific rules. These rules, if violated, crop compiler time errors. Errors are better managed if they surface during compilation simply because error messages often…

Lire la suite Lire la suite

Java inheritance

Java inheritance

The concept of inheritance is one of the most important concepts in object-oriented programming, because it irreversibly affects how Java code is written. Inheritance is a mechanism for creating a new class from an existing class by providing properties and methods. Inheritance is the third paradigm (how to use techniques/mold) of object-oriented programming (the first being encapsulation, the second the class structure). Inheritance can be single or multiple.It represents the relationship: is a kind of Example: A car is a…

Lire la suite Lire la suite

Access to databases with Java.

Access to databases with Java.

We will talk about how to connect to a database with Java, To do this we will use the JDBC (Java DataBase Connectivity) which is nothing else than java database connection. 1 : Establish the connection. We have to start at the beginning and so we will have to use a database, here I will use the Dragon database. then place in the library of your java project a : « mysql-connector-java-version.jar ». And then we can begin our Java project ! Once we…

Lire la suite Lire la suite

GWT (Google Web Toolkit)

GWT (Google Web Toolkit)

This framework has been around long enough but it is not still mentioned as one of the most used frameworks. It does bring some useful features nevertheless. Some developers have been using it for specific actions such UI components because it can be executed in the browser. Let me introduce you to this framework as succinct as possible.  What is GWT? Google Web Toolkit (GWT) is a framework obviously created by Google to create rich internet applications in Java. It…

Lire la suite Lire la suite

Exception (Java)

Exception (Java)

Ok now we can begin: First of all: How to keep calm? Breath and read calmly all information throw at you. How to use? It’s written just after that. Is it ok ? Now we can finally use it ! First step and first example. Take a code where it asks for birthday. You can write a birthday like what’s you have been asking for or you can do like Paul and writes his name on the sentence. First possibility to do…

Lire la suite Lire la suite

Java Swing

Java Swing

Swing in Java is a lightweight GUI toolkit which has a wide variety of widgets for building optimized window based applications. It is a part of the JFC (Java Foundation Classes). It is build on top of the AWT API and entirely written in Java. It is platform independent unlike AWT and has lightweight components. Here you can see the hierarchy of Java Swing classes: A Swing application must contain at least one container class. Here are three types of…

Lire la suite Lire la suite