基于嵌入式Qt下的MySQL数据库设计与开发  

Design and Development of MySQL Database Based on Embedded Qt

作　　者：韩改宁 李永锋 高伊腾 HAN Gaining;LI Yongfeng;GAO Yiteng(School of Computer Science, Xianyang Normal University, Xianyang, Shanxi 712000, China;Northwest Institute of Mechanical & Electrical Engineering, Xianyang, Shanxi 712000, China)

机构地区：[1]咸阳师范学院计算机学院,陕西咸阳712000 [2]西北机电研究所,陕西咸阳712000

出　　处：《微型电脑应用》2020年第5期25-27,共3页Microcomputer Applications

基　　金：陕西省教育厅项目(17JK0826);咸阳师范学院国家级大学生创新创业训练计划资助项目(201910722016);陕西省教科所项目(SGH17H197)。

摘　　要：由于嵌入式设备中可使用的资源相对较少,针对嵌入式系统下的数据库设计问题,利用Qt和MySQL实现数据库开发,从而解决数据库大,占用资源多的问题。Qt提供的QtSql模块实现Qt数据库应用程序的关联,采用MySQL轻型数据库,支持Windows和Linux等操作系统,同时提供ODBC接口。利用Qt开发平台,通过Qt中QSql模块及相关数据库驱动,创建面向应用的数据库系统开发,并通过SQL语句进行数据库交互操作,然后通过交叉编译器,将其移植到ARM Cortex-A8开发板上,从而实现嵌入式下的数据库系统的设计与开发。Because resources which can be used are relatively few in the embedded devices.For embedded system,a database is designed in this paper,by using Qt and MYSQL,to solve problems of large volume of database and occupying more resources.QtSql module provides a seamless connection to database and Qt applications,MYSQL is used for lightweight database,to support Windows and Linux operating systems and provide ODBC interface.In the paper,Qt development platform is used to create an application database system development through QtSql modules and related database driver,and interact with the database through SQL statements.Then,it is compiled through cross-compiler,and transplanted to ARM Cortex-A8 development board in order to realize the development and design of the database system in embedded environment.

关 键 词：嵌入式 QT QtSQL模块 MYSQL数据库 ARM CORTEX-A8 

分 类 号：G642[文化科学—高等教育学]