回複:accessing data table means access its schame....

來源: 2009-10-18 20:03:46 [舊帖] [給我悄悄話] 本文已被閱讀:

I guess people see questions from different point view.
One is from DBA more on database performance,tunning, create indexes, trigger, .....
The other is from application developer's view, more on database functionality CRUD, application performance.

In enterprise J2EE application, We can use open source framworks such as spring framework and hibernate of O/R mapping and EJB to write java code for all database related operation CRUD, we do define database info and schema in xml configuration file.

From my experience, there are performace issues on using hibernate pure OO for search, the alternative approach is to use preparedstatement to do direct query in java.