摘要
为了解决在信息管理系统中要求数据库表结构可动态修改的问题,结合数据表结构和面向对象编程的技术特点,提出了一种动态数据库表结构设计思路。首先定义了一个可视化的控件类,利用该类型控件与数据表结构字段属性建立关联,通过调整该控件属性,动态生成SQL语句,最后借助一个界面设计工具,实现了动态维护数据库表结构的功能,详细阐述了其在能效信息数据库管理系统中的实现过程,着重介绍了该系统实现过程中解决的关键技术点,为主要用能产品和设备能效技术的研究提供了一个有效的管理工具和技术手段。
To solve the problem that the database table structure can be dynamically modified in information management system applica-tions,combined with the technical characteristics of the data table structure and the object-oriented programming a dynamic database table structure design ideas is proposed.First of all,a visual control class is designed,the link between this control class and the field properties of database table structure is established,then the SQL statements is dynamically generated by adjusting the control properties.Finally by creating an interface design tool,the function is implemented which the database table structure is dynamically maintained,the application implementing process is described in detail in the energy efficiency information database management system,and the key technology points solved in the system implementing process are introduced specifically.An effective information management tools and technical means is provided for researching the energy efficiency technology about major energy-using products and equipments.
出处
《计算机工程与设计》
CSCD
北大核心
2010年第12期2922-2925,共4页
Computer Engineering and Design
基金
国家科技支撑计划基金项目(2006BAK04A22)
关键词
动态控件
能效信息数据库
节能减排
动态表结构
界面设计
dynamic control
energy efficiency information database
energy saving and emission reduction
dynamic table structure
interface design