跨数据库持久层框架的研究与实现

摘要

SQL方言导致直接在特定数据库上开发的业务系统不能在多种数据库间灵活的迁移,为此提出了一个能够跨数据库的持久层框架.通过建立多数据库开发规范,在持久层框架iBATIS的基础上扩展了对多数据库方言的支持,增加了多数据库SQL解析及数据分页的能力.在二次开发和对SQL执行效率要求高的领域首次解决了系统跨数据库的问题.遵循多数据库开发规范并使用该框架开发的系统就可以实现在多种数据库环境下的无缝迁移.%SQL dialect causes the business systems which develop in the specific database can not flexible migrate between different databases. So a persistence framework is presented, which can support multiple databases. The framework based on Ibatis supports for multiple database dialects by establishing multi-database development of norms. The capacities of multi-database SQL parsing and data paging are added to Ibatis. The problem of cross-database is solved in the requiring high efficiency and secondary development area. The systems which follow the multi-database development of norms and use this framework can seamless migrate in the multiple databases environment.