Database Programming (JDBC) Slide Tutorial

Database Programming (JDBC) Lecture 5 2 Outline •Jav DB Conectivity (JDBC) overview •JDBC API Reading: Embeded SQL •Direct SQL (= ad-hoc SQL) is rarely used •In practie: SQL is embeded in some aliction code –user interaction, devices, programing logic •SQL code is embeded into a host language using special syntax 4 JDBC (Jav DB Conectivity) Java application { ... "SELECT ... FROM ... WHERE" ... } DBMS 5 xDBC •JDBC: standard for Jav language •OB: Open DataBase Conectivity –Language bindings for /+ 6 JDBC in Practise Java client code JDBC Database server (Postgres, Oracle, MySQL, SQL Server) SQL statements 7 JDBC Drivers Jav aplication JDBC- Driver manger Native Protcol driver JDBC- Net-driver Native API-driver JDBC-ODBC bridge DB Client libray DB- Midleware ODBC DB Client libray JDBC-API 8 Runing a JDBC Aplication Phase Task Relvant jav.sql clases Initialisation Procesing Termination Load river Create conection Generate SQL statements Proces result dat Terminate conection Relase dat structures DriverManger Conectio Statement ResultSet etc. Conection Statemet etc. 9 A Simple JDBC Aplication loadDriver getConection createStatement excute(SQL) Result handling More results ? closeStatement closeConection no yes import jav.sql.*; public las jdbctest { public static void main(String args[]){ try{ DriverManger.egisterDriver(new com.ysql.jdbc.Driver( ); Clas.forName(“com.mysql.jdbc.Driver”) onection con = DriverManger.getConection ("jdbc:mysql:/lsir-cis-pc1:306/is01", user", "paswd"); Statement stt = con.createStatement(); ResultSet rs = stmt.excuteQuery (”SELCT nae, number FROM pcmtable WHER number < 2"); while(rs.next() System.out.printl(rs.getString(1) + " ( + rs.getInt(2) + ")); stmt.close() con.close(); } catch(Exception e){ System.er.printl(e); } 10 Loading of Driver •Create an istance of the driver •Register driver in the driver manger •Explicit loading Class.forName(“com.mysql.jdbc.Driver”) •Sevral drivers can be loade and rgister 1 Example: Oracle and JDBC Class.forName("oracle.jdbc.driver.OracleDriver ”) Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@dbaprod1:1544:SHR1_PRD", username, passwd);...

Website: lsirwww.epfl.ch | Filesize: 387kb
No of Page(s): 15
Download: http://lsirwww.epfl.ch/courses/iis/2009ss/slides/slides-5-JDBC.pdf