The Connection interface maintains a session with the database. It can be used for transaction management. It provides factory methods that returns the instance of Statement, PreparedStatement, CallableStatement and DatabaseMetaData.
The DriverManager class manages the registered drivers. It can be used to register and unregister drivers. It provides factory method that returns the instance of Connection.
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…