Lecture-2培训课件.pptVIP

Lecture 2 Introduction to JDBC 精品文档 Introducing JDBC According to Sun, JDBC is not an acronym, but is commonly misinterpreted to mean Java DataBase Connectivity JDBC: is an API that provides “universal data access for the Java2 platform” Supports ANSI SQL 92 精品文档 The Standard Query Language (SQL) Composed of two categories: Data Definition Language (DDL) create database create table drop database Data Manipulation Language (DML) used to manipulate the data select delete update 精品文档 Data Definition Language CREATE DATABASE - allows you to create a database CREATE TABLE - allows you to create a table definition in a database DROP TABLE - removes a table from a database ALTER TABLE - modifies the definition of a table in a database 精品文档 Data Manipulation Language SELECT - query the database select * from customer where id 1001 INSERT - adds new rows to a table. Insert into customer values (1009, ‘John Doe’) DELETE - removes a specified row delete from customer where amount = 100 UPDATE - modifies an existing row update customers set amount = 10 where id 1003 精品文档 What Does JDBC Do? Allows you to connect to a known data source using common OO semantics using Java Allows you to issue standard SQL commands on that data source Provides you with classes to facilitate access to and manipulation of: returned data and, generated exceptions 精品文档 A standard JDBC application // Load the JDBC driver Class.forName(oracle.jdbc.OracleDriver).newInstance(); // Connect to the database Connection conn = DriverManager.getConnection (connect-string,user, pass); // Create a statement Statement stmt = conn.createStatement (); // Execute the statement: select data from the emp table boolean results = stmt.execute(select * from emp); ResultSet rset = null; if (results) rset = stmt.getResultSet(); // Process results: walk through the result set while (rset.next ()) { System.out.println (rset.getString (1) + rset.getString(2)); …. } 精品文档 JDBC Driver Types