Open the database connection Retrieve a list of user defined tables for each table { Check where there is a corresponding class file if(it is availabe) { load the class file Retrieve lists of key fields and indeces for this table Store these lists in hashtables for easy access } else throw an exception }
清 单3: 初 始 化 数 据 库 连 接 的 伪 码
Take an object A containing a series of (name，value) pairs for each table T { for each (name，value) pair { if(name matches primary_key_field or index_field) store a refrence to both name and value } if all key_fields were found create a query string using key names and values else if all index_fields were found create a query string using index names and values execute the query to oBTain a ResultSet For each record in the ResultSet { Create an object of the class associated with table T initialize the object using the record´´s contents Add the object to the results， e。g。， attach it to A } }
