CAJ | 학술논문

在塑料"挤出模具2008"系统的基础上,利用VBA强大的数据库检索接口对SQL关系数据库系统兼容性,创建模架结构的数据库,用以不断补充新的模具设计方案.同时利用VBA丰富的可视化控件编写出漂亮的对话框,为用户提供直观的提示.综合对VBA和AutoCAD集成Microsoft SQL Sever数据库进行研究,证明三者完全可以结合使用,SQL数据库的应用对于图形数据交换、利用经验数据、提高设计效率起到了很好的作用.充分展现模具设计的新思路,即利用已有的设计经验、模块标准化,并大大提高设计效率.
재소료"제출모구2008"계통적기출상,이용VBA강대적수거고검색접구대SQL관계수거고계통겸용성,창건모가결구적수거고,용이불단보충신적모구설계방안.동시이용VBA봉부적가시화공건편사출표량적대화광,위용호제공직관적제시.종합대VBA화AutoCAD집성Microsoft SQL Sever수거고진행연구,증명삼자완전가이결합사용,SQL수거고적응용대우도형수거교환、이용경험수거、제고설계효솔기도료흔호적작용.충분전현모구설계적신사로,즉이용이유적설계경험、모괴표준화,병대대제고설계효솔.
The mould bases database was built according to the database retrieval interface function of VBA and the compatibility of SQL-relational database management system on the base of "extrusion system 2008". The system was used for appending new designs of molds,which endued it with a long life. Meanwhile the visible dialogs were given for the convenience of user. It was an instructive taste and proved to be feasible for the combination of VBA, AutoCAD and Microsoft SQL Sever. The application of SQL provided the system good properties of data exchange and the usage of the expert design. It exhibited a new way to design the molds,ulicl to refer to the experience sufficiently and to standarlize the mold bases. It was a successful way to promote the design efficiency.