The java.sql package contains interfaces and classes for JDBC API. Interfaces: · Connection · Statement · PreparedStatement · ResultSet · ResultSetMetaData · DatabaseMetaData · CallableStatement etc. Classes: · DriverManager · Blob · Clob · Types · SQLException etc.
· Registering the driver class · Creating connection · Creating statement · Executing queries · Closing connection
JDBC Driver is a software component that enables java application to interact with the database. There are 4 types of JDBC drivers: 1. JDBC-ODBC bridge driver 2. Native-API driver (partially java driver)…
Creating a function In MySQL, Function can also be created. A function always returns a value using the return statement. The function can be used in SQL queries. Syntax CREATE…
MySQL command-line client commands This command allows us to connect with MySQL Server with a username and passwords using below syntax. mysql -u -p; If you want to connect with…
A Data Type specifies a particular type of data, like integer, floating points, Boolean, etc. It also identifies the possible values for that type, the operations that can be performed…
We can create and use forms in PHP. To get form data, we need to use PHP superglobals $_GET and $_POST. The form request may be get or post. To…
In object oriented programming terminology, constructor is a method defined inside a class that is called automatically at the time of creation of the object. Purpose of a constructor method…
Inheritance is an important principle of object oriented programming methodology. Using this principle, relations between two classes can be defined. PHP supports inheritance in its object model. PHP uses extended…
Overloading in PHP provides means to dynamically create properties and methods. These dynamic entities are processed via magic methods, one can establish in a class for various action types. All…