Midterm Flashcards
JDBC MEANS
Java Database Connectivity
It’s is a standard Java API for database independent connectivity
JDBC
Tasks
Creating SQL
Executing SQL
Java Executables
Java Application
Java Applets
Java Servlets
Java ServerPages
Enterprise JavaBeans
allowing Java programs to contain database
ODBC
JDBC ARCHITECTURE LAYERS 2
JDBC API
JDBC Driver API
This provides the application to JBC Manager connection
JDBC API
This supports the JDBC MANAGER TO DRIVER CONNECTION
JDBC DRIVER API
The _ uses a driver manager and database specific driver
JDBC API
The _ ensures that the correct driver is used access each data source
JDBC Driver Manager
This class manages a list of database drivers
DriverManager
This interface handles the communication with the database server
Driver
This interface with all methods for contacting a database
Connection
you use objects created from this interface to submit to SQL statement
Statement
These objects hold data retrieved from a data base
ResultSet
This class handles any errors that occur in a database
SQLException
what are the primary packages for JDBC 4.0
java.sql
javax.sql
what does SQL means
Structured Query Language
it is a standardized language that allows you to perform operations on a database
SQL
Used for creating a new database
CREATE DATABASE STATEMENT
Used for deleting an existing database
DROP DATABASE STATEMENT
Used for creating a new table
CREATE TABLE STATEMENT
use for deleting an existing table
DROP TABLE STATEMENT
Used to retrieve data from a database
Select Statement
