摘要
基于SQL技术与密度贪婪算法的自动拼箱软件系统,采用VB6.0和SQL分模块进行设计。其数据录入模块完成运输工具数据的录入和编辑;拼箱模块筛选集装箱并列出清单;查询模块查询库存数据并打印。软件的实现步骤为:首先连接数据库并据密度贪婪算法自动计算每件货物的体积、密度,然后将货物记录按密度降序排序。最后根据车辆编号,系统自动筛选货物并修改数据库以获得密度最大的货物数据。
The automatic encasement software system based on SQL technology and density greedy algorithm is designed with three modules by VB6.0 and SQL. Entering and editing of tool data is accomplished by data entering module. The encasement module selects the cases and then print the list. The inquiring module inquires and prints storage data. The steps of software development are: at first, link the database and auto-count the volume and the density of each encasement then sort descending the encasement according to the density. At last, the system will auto-select the encasement and change the database in according with the numbers of cars.
出处
《兵工自动化》
2004年第1期63-64,共2页
Ordnance Industry Automation
基金
四川省教育厅青年基金资助项目(2000-A53)
关键词
SQL技术
自动拼箱
软件开发
贪婪算法
Automatic encasement
Software development
Greedy algorithm
SQL technology
