java-jdbc(參考版)
2024-10-06 16:29本頁面
【正文】 A 。 // ... // The author has been added, but not updated. ()。)。 + WHERE last_name = 39。 // ... JDBC 新功能 Prepared statement pooling rows = ( UPDATE authors set type = 39。))。, 39。 int rows = ( INSERT INTO authors + (first_name, last_name) VALUES + (39。 // Set a conservative transaction isolation level. (BLE)。 ()。 if (retval == true) { ResultSet rs2 = ()。 if (retval == false) { // The statement returned an update count, so handle it. // ... } else { // ResultSet JDBC 新功能 Returning multiple results ResultSet rs1 = ()。 // Set the value of procCall to call a stored procedure. // ... CallableStatement cstmt = (procCall)。 if ( () ) { // Retrieve the auto generated key(s). int key = (1)。), )。, 39。 // Obtain the generated key that results from the query. (INSERT INTO authors + (first_name, last_name) + VALUES (39。 A JDBC 新功能 Named parameters in CallableStatements ? Prior to JDBC , the way to set a parameter in a stored procedure was by specifying the parameter39。 }catch (exception e){ ……….. ()。 1. 什麼是 JDBC? 2. JDBC Drivers之分類與使用時機(jī) 3. 使用 JDBC開發(fā)資料庫應(yīng)用程式 4. 物件導(dǎo)向分析與資料庫設(shè)計(jì)技巧 5. Connection pooling 6. 交易 (Transaction)處理方式 7. JDBC 新功能 8. Q amp。 Context ctx = new InitialContext()。 (“)。 ()。 (false)。 A 物件導(dǎo)向分析與資料庫設(shè)計(jì)技巧 ObjectRelation Mapping ? One table for each class ? One table for each concrete class ? One table for an entire class hierarchy 物件導(dǎo)向分析與資料庫設(shè)計(jì)技巧 ObjectRelation Mapping ? One table for each class 物件導(dǎo)向分析與資料庫設(shè)計(jì)技巧 Advantages: ? This approach most closely conforms to objectoriented concepts. ? It supports polymorphism. ? Maintenance is easy because there is no duplication. Disadvantages: ? There are many tables to maintain. ? It takes longer to read and write to the tables. ? Reporting directly from tables is table for each concrete classOne table for an entire class hierarchy 物件導(dǎo)向分析與資料庫設(shè)計(jì)技巧 ObjectRelation Mapping ? One table for each c
公司管理相關(guān)推薦
鄂ICP備17016276號-1