基于mybatis的数据持久层研究  

Research on Data Persistence Layer based on Mybatis

作　　者：陈小虎[1] 邓惠俊[2] CHEN Xiaohu;DENG Huijun(Department of Education,Wanbo Technology Vocational College,Hefei 230007,China;Department of Computer Science and Technology,Wanbo Technology Vocational College,Hefei 230007,China)

机构地区：[1]万博科技职业学院教务部,合肥230031 [2]万博科技职业学院计算机科学技术系,合肥230031

出　　处：《成都工业学院学报》2020年第2期29-32,共4页Journal of Chengdu Technological University

基　　金：安徽省高等学校自然科学研究重点项目(KJ2019A1039);安徽省高等学校质量工程项目(2017jxtd129)。

摘　　要：为解决传统的Mybatis数据库持久层在灵活性,可扩展性上存在的问题,在深入研究mybatis的技术架构和应用流程的基础上,利用数据库连接池技术和基于映射表的设计方案提出了基于连接池的mybatis持久层优化技术,通过实验的方式证明了该优化方案的有效性和可行性。在和c3p0、JDBC、tomcat-jdbc等中间件的性能对比实验证明,优化后的mybatis在持久层的读写性能有了10%以上的提升,有效地节约了服务器硬件成本,具有较高的实用性。In order to solve the problems of flexibility and extendibility of persistence layer of traditional mybatis database,the technical framework and application process of mybatis was studied in-depth,and on this basis,the mybatis persistence layer optimization technology based on connection pool technology was proposed by using the database connection pool technology and the design scheme based on mapping table.The effectiveness and feasibility of this optimization scheme have been proved through experiments.Compared with the performance of c3p0,JDBC,Tomcat JDBC and other middleware,it proves that the read-write performance of mybatis optimized in this paper has been improved by more than 10%in the persistence layer,which effectively saves the cost of server hardware and has high practicability.

关 键 词：mybatis 持久层优化 高并发架构 读写性能 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]