复旦大学：《面向对象分析和设计》课程资料_IBatis Charpter 2

BATIS Charpter 2 By0461097 0461006:0461084:0461097;*0461118:0461124

Charpter 2 By 0461097 0461006; 0461084;0461097; *0461118; 0461124

Review What is iBATIS iBATIS is an opening object/relation mapping persistance framework. It works for mapping the object to SQL sentence TWo core framework of iBATIS SQL Maps SQL Maps DAO

Review ⚫ What is iBATIS ? ⚫ iBATIS is an opening object/relation mapping persistance framework. It works for mapping the object to SQL sentence. ⚫ Two core framework of iBATIS: ⚫ SQL Maps ⚫ DAO

What is DAO DAO- Data Access object Data accessing interface Position between operation logic data Source effect: to abstract and encapsulate all access to the data source. The dao manages the connection with the data source to obtain and store data

What is DAO ? ⚫ DAO - Data Access Object ⚫ Data accessing interface ⚫ Position: between operation logic & data source ⚫ effect：to abstract and encapsulate all access to the data source. The DAO manages the connection with the data source to obtain and store data

What is DAO DAO is one of the standard J2EE design pattern Programmers use DAO to separate data access at low level from operation logic at high level

What is DAO ? ⚫ DAO is one of the standard J2EE design pattern. ⚫ Programmers use DAO to separate data access at low level from operation logic at high level

DAO With Microsoft o DAO is an application program interface (API) available with Microsoft's Visual basic that lets a programmer request access to a Microsoft Access database DAO was Microsoft's first object-oriented interface with databases. DAo objects encapsulate Accesss Jet functions o Through Jet functions, it can also access other Structured Query Language(SQL) databases

DAO with Microsoft ⚫ DAO is an application program interface（API） ⚫ available with Microsoft's Visual Basic that lets a programmer request access to a Microsoft Access database. ⚫ DAO was Microsoft's first object-oriented interface with databases. DAO objects encapsulate Access's Jet functions. ⚫ Through Jet functions, it can also access other Structured Query Language (SQL) databases

Basic Components for DAO A DAO factory A DAO interface A simple class implementing a DAO interface Data transmission object

Basic Components for DAO ⚫ A DAO factory ⚫ A DAO interface ⚫ A simple class implementing a DAO interface ⚫ Data transmission object

Application vs data source DAO eb application DB DAO Web application DB DAO ERP DAO Web application system DAO

Application vs. data source

DAO VS。 Service Service layer- business layer DAo layer-persistent layer interface DAO layer interact with data

DAO vs. Service ⚫ Service layer – business layer ⚫ DAO layer – persistent layer interface ⚫ DAO layer interact with data

Use of dao Data Source Encapsulation Connection conn= DAOFacotry create Connection( Driver, URL username, passpword Change database type getConnection(

Use of DAO ⚫ Data Source Encapsulation Connection conn = DAOFacotry.createConnection() ⚫ Driver, URL, username, passpword ⚫ Change database type getConnection()

Use of dao Database operation encapsulation CRUD-create, read, update, delete insertUser(User user)

Use of DAO ⚫ Database operation encapsulation ⚫ CRUD-create, read, update, delete ⚫ insertUser(User user)