Prévia do material em texto
148 3. JDBC Note: - For JDBC we will use “postgresql” you can download the same from http:// www.postgresql.org/. PostgreSQL is Copyright © 1996-2005 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright © 1994-5 by the Regents of the University of California (B) How does JAVA interact with databases? Twist: - What is JDBC? JAVA interacts with database using a common database application programming interface called as JDBC. JDBC allows a developer to write applications that is database independent. So the developer will be interacting with JDBC API rather than getting in to complications of the database.JDBC allows you to write Java code, and leave the platform (database) specific code to the driver. JAVA was designed to be platform independent and JDBC takes java one step ahead making java database code database independent. That means if you use JDBC for connectivity for SQL Server you can run the same code with out changing for ORACLE. Figure 3.1 : - JDBC as a layer (B) Can we interact with non-relational sources using JDBC? Yes