java-jdbc-文庫(kù)吧資料
2024-10-08 16:29本頁(yè)面
【正文】 oncrete class 物件導(dǎo)向分析與資料庫(kù)設(shè)計(jì)技巧 Advantages: ? Reporting directly from tables is easy. Disadvantages: ? If you modify a class, you must modify its table and the table for any subclasses. ? Data definitions are duplicated. 物件導(dǎo)向分析與資料庫(kù)設(shè)計(jì)技巧 ObjectRelation Mapping ? One table for an entire class hierarchy 物件導(dǎo)向分析與資料庫(kù)設(shè)計(jì)技巧 Advantages: ? The model is easy to understand. ? Polymorphism is supported. ? Reporting directly from tables is easy. Disadvantages: ? Database table must be changed with each addition. ? Database tables can bee extremely large. ? It is difficult to enforce rules on the database. 物件導(dǎo)向分析與資料庫(kù)設(shè)計(jì)技巧 Disadvantages: ? Each time you add a new attribute, the database table requires a change. ? When you add a new column, you might need to update all records with a value for that column. ? Routine maintenance takes more time. 1. 什麼是 JDBC? 2. JDBC Drivers之分類(lèi)與使用時(shí)機(jī) 3. 使用 JDBC開(kāi)發(fā)資料庫(kù)應(yīng)用程式 4. 物件導(dǎo)向分析與資料庫(kù)設(shè)計(jì)技巧 5. Connection pooling 6. 交易 (Transaction)處理方式 7. JDBC 新功能 8. Q amp。 ? Statement ? PreparedStatement A prepiled SQL statement that is more efficient than repeatedly calling the same SQL statement ? CallableStatement Lets you execute nonSQL statements against the database 使用 JDBC開(kāi)發(fā)資料庫(kù)應(yīng)用程式 3. Create an SQL wrapper object. Statement stmt = ()。 A 步驟 1. Register the vendorsupplied JDBC driver with the DriverManager class. 2. Establish a DBMS session. 3. Create an SQL wrapper object. 4. Submit a query and receive a result. 5. Extract the data from the result wrapper object. 使用 JDBC開(kāi)發(fā)資料庫(kù)應(yīng)用程式 1. Register the vendorsupplied JDBC driver with the DriverManager class. (“Driver”)。 A 打開(kāi)藏寶庫(kù)的鑰匙 ? JDBC提供連接 Database的一組標(biāo)準(zhǔn) API ? 將 SQL指令包裹後送回 Database執(zhí)行 ? 並提供 API解析 Database的回傳值 什麼是 JDBC? 優(yōu)點(diǎn) ? 寫(xiě)一次可在不同的平臺(tái)上到處執(zhí)行 ? 更換 Database不需改寫(xiě)程式 ? 可同時(shí)連接數(shù)個(gè)異質(zhì)的 Database ? 是 J2EE架構(gòu)中重要的功能 什麼是 JDBC? 1. 什麼是 JDBC? 2. JDBC Drivers之分類(lèi)與使用時(shí)機(jī) 3.
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1