Data is a tool for storing and processing data, and the database is an important foundation that constitutes many companies. Current due to database products are complicated, in a company often use multiple databases, there is no need to have different companies. When using Java for database development, through JDBC technology, different databases can be accessed, and different databases can be consistently accessible to different databases of different platforms, and their superiority is obvious.
JDBC concept
JDBC (Java Data Base Connectivity, Java Database Connection) is a Java API for executing a SQL statement that can provide unified access for a variety of relational databases, composed of a set of classes and interfaces written in Java language. JDBC provides a benchmark, which can build more advanced tools and interfaces, enabling database developers to write database applications, and JDBC is also a trademark name.
With jdbc, send SQL statements to various relationship data is a very easy thing. In other words, there is a JDBC API, you don't have to write a program for accessing the Sybase database, and write another program for accessing the Oracle database, or prepare another program for accessing the Informix database, programmers only need to write one with JDBC API. The program is enough, it can send SQL calls to the corresponding database, combine the Java language and JDBC to make the programmer only need to write a program to run on any platform, this is also a Java language "writing, run everywhere" purpose.
JDBC provides application developers with independent database, unified API, this API provides a standard for writing, and considering all different application design standards, the key is a set of Java interfaces implemented by the driver. The driver is responsible for the standard JDBC call, when the application is ported to a different platform or database system, the application is constant, changing the driver, the driver plays the role of the intermediate (or middleware) in multi-layer data design .
Java has rugged, safe, easy to use, easy to understand and automatically downloaded from the network, is an outstanding language to write database applications, which is just a method of dialogue between Java applications with various databases. JDBC is a mechanism for such uses.
JDBC extends the functionality of Java. For example, using Java and JDBC APIs can publish a web page containing the applet, and the information used by the applet may come from a remote database. Enterprises can also use JDBC to connect all staff to one or more internal databases over Intranet (ever, the computer used by these staff has various operating systems such as Windows, Macintosh, and UNIX).
As more and more programmers began using Java programming languages, the requirements from Java in conjunction with the database are also increasing. For server-side database applications, JDBC is often mixed with RMI, CORBA, JSP, or Servlet, EJB, and other techniques for implementing a multi-layer structure.
In the J2EE development environment, JDBC is usually used to access the EIS (Enterprise Information System), JDBC's concept and programming, whether in J2SE or in the J2EE environment, the use method is the same.