JDBC (Java Database Connectivity) is a Java library for accessing a database and executing SQL statements. If database vendors make their own libraries, the programming method will vary from product to product, and Java programmers will have to learn how to use the classes created by each vendor. JDBC that Sun Microsystems has provided as a standard Java library for accessing RDBMS and executing SQL statements. JDBC has very few implementation classes, most of which are interfaces. It is the responsibility of each vendor to create a class that implements the interface. From now on, we will learn how to use the interface provided by Sun. In the JDBC example source, you cannot see the JDBC implementations created by each vendor. Only the Sun's interfaces are visible.
- Relational Database
- In 1970, E.F. Codd introduced "A set of relational tables can represent data". Since then, many companies have created relational database management systems (RDBMS). Oracle is the first company to commercialize an RDBMS. There are many RDBMS products as IBM's DB2 and Microsoft's Microsoft SQL Server.
SQL (Structured Query Language) is the standard language of RDBMS.
With SQL, you can the following.
- Create a table
- Insert, update, and delete records in a table
- Control the privileges of a database user