Transcription of JDBCプログラミング基礎 - knowledge-ex.jp
1 1 Copyright 2006-2010 Some rights 2 Copyright 2006-2010 Some rights reserved. - 559 Nathan Abbott Way, Stanford, California 94305, USA 3 Copyright 2006-2010 Some rights jdbc jdbc API 4 Copyright 2006-2010 Some rights 5 Copyright 2006-2010 Some rights jdbc jdbc jdbc jdbc jdbc 6 Copyright 2006-2010 Some rights Java Database Connectivity (RDBMS) Java API RDBMS = Relational Database Management System Java DBMS API DBMS API DBMS 7 Copyright 2006-2010 Some rights DBMS DBMS SQL SQL Java SQL SQL Java 8 Copyright 2006-2010 Some rights jdbc API jdbc jdbc API jdbc Java jdbc APIJDBC jdbc APIJDBC DBMS 9 Copyright 2006-2010 Some rights API API jdbc API jdbc jdbc API 10 Copyright 2006-2010
2 Some rights jdbc jdbc 11 Copyright 2006-2010 Some rights API jdbc API jdbc API 12 Copyright 2006-2010 Some rights DBMS SQL jdbc API 13 Copyright 2006-2010 Some rights jdbc jdbc DBMS DBMS JAR ZIP jdbc CLASSPATH jdbc CLASSPATH 14 Copyright 2006-2010 Some rights 2 DBMS / 3 DBMS Web 15 Copyright 2006-2010 Some rights reserved.
3 jdbc Java jdbc DBMSDBMS jdbc 16 Copyright 2006-2010 Some rights reserved. jdbc Java jdbc DBMS DBMS HTML HTTP jdbc 17 Copyright 2006-2010 Some rights reserved. TYPE1 jdbc -ODBC TYPE2 TYPE3 TYPE4 18 Copyright 2006-2010 Some rights jdbc -ODBC jdbc ODBC jdbc jdbc ODBC OS JDK ODBC Java jdbc -ODBC ODBC DBMSDBMS jdbc APIODBC API 19 Copyright 2006-2010 Some rights jdbc DBMS API jdbc -ODBC OS/DBMS DBMS API Java Java
4 DBMSDBMS jdbc API 20 Copyright 2006-2010 Some rights jdbc API Java DBMSDBMS jdbc API 21 Copyright 2006-2010 Some rights : jdbc API Java DBMS Java jdbc Java Java DBMSDBMS jdbc API 22 Copyright 2006-2010 Some rights API 23 Copyright 2006-2010 Some rights API jdbc DBMS SQL 24 Copyright 2006-2010 Some rights API Java API 25 Copyright 2006-2010 Some rights (1) jdbc DriverManager (1)
5 JavaVM jdbc DriverManager (2) JVM jdbc DriverManager 26 Copyright 2006-2010 Some rights (2) (1) ( ); 27 Copyright 2006-2010 Some rights (3) (2) JVM -D :java 28 Copyright 2006-2010 Some rights reserved. DBMS DBMS jdbc DB2 29 Copyright 2006-2010 Some rights try { (" "); } catch (ClassNotFoundException ex) { ().}
6 } ClassNotFoundException 30 Copyright 2006-2010 Some rights DriverManager getConnection jdbc URL ID Connection DBMS DBMS 31 Copyright 2006-2010 Some rights URL jdbc DBMS jdbc jdbc :subprotocol:subname 32 Copyright 2006-2010 Some rights reserved. DBMS jdbc URLDBMS jdbc URL DB2 jdbc :db2:// : / jdbc :mysql:// : / Oracle8 jdbc :oracle:thin:@ : : jdbc :postgresql:// : / SQLS erver 2000jdbc:microsoft:sqlserver:// : ;DatabaseName= 2005 jdbc :sqlserver:// : ;DatabaseName= ODBC jdbc :odbc: = IP 33 Copyright 2006-2010 Some rights try {String url = jdbc :mysql://localhost/companydb ;String id = root ;String pass = passwd ;Connection conn = (url,id,pass);} catch (SQLE xception ex) { ().
7 } SQLE xception 34 Copyright 2006-2010 Some rights reserved. (1) 1 Connection 2 DBMS MySQL companydb localhost IDmyuser mypass 35 Copyright 2006-2010 Some rights SQL RDBMS ANSI / ISO jdbc SQL jdbc API SQL SQL DBMS 36 Copyright 2006-2010 Some rights API Statement SQL PreparedStatement SQL CallableStatement 37 Copyright 2006-2010 Some rights Connection
8 CreateStatement try { Connection conn = (url,id,pass);Statement stmt = (); } catch (SQLE xception ex) { ();} SQLE xception 38 Copyright 2006-2010 Some rights SQL SQL SELECT Statement executeQuerry() SQL UPDATE DELETE INSERT Statement executeUpdate() 39 Copyright 2006-2010 Some rights , * WHERE ' AND OR SELECT FROM WHERE 40 Copyright 2006-2010 Some rights , ( ) ( ) INSERT INTO ( ) VALUES ( )
9 41 Copyright 2006-2010 Some rights = , WHERE UPDATE SET = WHERE 42 Copyright 2006-2010 Some rights WHERE DELETE FROM WHERE 43 Copyright 2006-2010 Some rights reserved. SQL Statement executeQuerry() SQL String try { Statement stmt = ();String query = SELECT * FROM addrbk ;ResultSet rs = (query); } catch (SQLE xception ex) { ();} 44 Copyright 2006-2010 Some rights reserved.
10 SQL Statement executeUpdate() SQL String int try { Statement stmt = ();String query = INSERT INTO addrbk (ID, , ) + VALUES (1,' ',43) int count = (query); } catch (SQLE xception ex) { ();} DDL Data Definition Language CREATE TABLE ) executeUpdate ( 0 ) 45 Copyright 2006-2010 Some rights executeQuery ResultSet SQL executeUpdate int SQL 46 Copyright 2006-2010 Some rights ResultSet next() getter 47 Copyright 2006-2010 Some rights #next() (1)
