JDBC Java Data Base Connectivity Java API java
JDBC (Java Data. Base Connectivity) – технология доступа к базам данных для Java Состоит из: • API (java. sql and javax. sql) • Driver Manager • Test Suite + JDBC-ODBC Bridge
JDBC API • • java. sql. Connection java. sql. Statement (Prepared + Callable) java. sql. Result. Set java. sql. *
Driver Class. for. Name("com. my. My. Driver"); // mydriver Connection conn = Driver. Manager. get. Connection( "jdbc: mydriver: my. Database", username, password); // Class. for. Name("com. mysql. jdbc. Driver"); // "jdbc: mysql: //localhost: 3306/db_name"
Driver
SQL Lector. ID First. Name Last. Name Date. Of. Start Count 1 Max Tyukh 2013 -04 -23 4 2 Eugene Bochkov 2013 -04 -25 4 3 Max Mashnitsky 2013 -05 -21 5 4 Andrew Grigoruk 2013 -06 -13 6
SQL Connection conn = Driver. Manager. get. Connection( "jdbc: my. Driver: my. Database", username, password); Statement stmt = conn. create. Statement(); String q = "SELECT First. Name, Last. Name, Count FROM Lessions WHERE Count > 4"; Result. Set rs = stmt. execute. Query(q); while (rs. next()) { String f = rs. get. String("First. Name"); String l = rs. get. Float("Last. Name"); int c = rs. get. Int("Count"); System. out. println(f + l + " : " + c); } conn. close();
SQL SELECT First. Name, Last. Name, Count FROM Lessions WHERE Count > 4; First. Name Last. Name Count Max Mashnitsky 5 Andrew Grigoruk 6
SQL INSERT INTO Lessions (First. Name, Last. Name, Date. Of. Start, Count) VALUES ('Ivan', 'Petrov', '2013 -07 -04', 2); Lector. ID First. Name Last. Name Date. Of. Start Count 1 Max Tyukh 2013 -04 -23 4 2 Eugene Bochkov 2013 -04 -25 4 3 Max Mashnitsky 2013 -05 -21 5 4 Andrew Grigoruk 2013 -06 -13 6 5 Ivan Petrov 2013 -07 -04 2
SQL • Data Manipulation Language (DML) – SELECT, INSERT, DELETE, UPDATE • Data Definition Language (DDL) – CREATE, DROP, ALTER • Data Control Language (DCL) – GRANT, REVOKE, DENY • Transaction Control Language (TCL) – COMMIT, ROLLBACK, SAVEPOINT
Q&A
- Slides: 12