铁通公司进销存系统

铁通公司进销存系统文件标识：XiaoXiaoStudio－Paper－Trade作者：杨华文件状态：[]草稿[√]正式发布[]正在修改机构公开信息铁通公司进销存系统©小小工作室第1页共48页摘要随着互联网的发展，人们对WEB网页的要求越来越多的趁向于动态交互性，而这很大程度上依赖于WEB数据库。因为动态交互需要强大的信息系统支持，信息数据以数据库形式表示更容易更新和管理。通过网页如何动态交互的访问数据库成为最关键的问题。本论文介绍利用ASP(ActiveServerPage，动态服务器页面)技术,采用网页嵌入服务器脚本(VBscript或Javascript)机制，并应用ASP内置的数据库存取组件ADO实现对数据库表直接访问，从而实现网上WEB信息系统的数据发布。接下来的文章将用网上办公系统来加以阐述，在此基础上应用基于多知识的Web网页信息和方法,在MicrosoftVisualInterDev6.0和Dreamweaver环境下编程实现了一个快速、有效的Web系统。该系统分为前台管理（工作计划、通告管理、公文管理、通讯助理和资源管理等）功能。后台管理（用户权限管理和用户账号管理等）功能。并将所得信息放入Access数据库中。此外在完成该系统的同时还分析了系统的整体结构和工作原理，介绍了系统核心数据库中各表的联系。对该系统的实验结果进行了描述。ASP技术使得WEB开发变得更加简单、快速、高效，因此ASP与ADO的组合已成为目前动态网页中访问数据库的最终解决方案。关键词：动态服务器、ActiveX数据对象、网页嵌入服务器脚本。铁通公司进销存系统©小小工作室第2页共48页ABSTRACTRequestWEBpagetomoreandmoretakeadvantagethedirectionalongwiththeInternet'sdevelopment,peopletohandoverinthedevelopmentwitheachothersex,butthisisverythebigdegreeupdependonintheWEBdatabase.Becausethedevelopmenthandovertowitheachotherneedthesupportofmightyinformationsystem,informationdatawiththedatabaseformtomeanmoreeasilytorenewwithmanage.Passthewebpagehowthedynamicandalternantinterviewdatabasebecomemostthekey'sproblem.ThisthesistheintroductionmakeuseoftheASP(ActiveServerPage)technique,adoptionwebpagetheintotheserverscriptthemechanism,andcombinetheappliedASPinsidedatathatplacethatdatabaseaccessthemoduleADOrealizestodirectinterviewofdatabasewatch,frombutrealizenetthesystemoflastWEBinformationannounce.Thearticleconnectingdownwillusethenetisontheshoppingsystemtakeintothedescribes,herefoundationtopapplicationaccordingtotheWebpageofmanyknowledgeinformationiswiththemethod,undertheMicrosoftVisualtheInterDev6.0withtheDreamweaverenvironmenttheplaitrealizesacanfleetness,availablyWebsystem.Thatsystemisdividedintothestagemanagement(taskscheduler,managemessage,managedocument,communicationassistantandmanageresourceetc.)thefunction.Backstagemanagement(thesettingofusers’purviewwithmanageetc.tousers’account)function.AndputintotheAccessthedatabaseinsidetheincomeinformation.Inadditionatcompletethatsystematthesametimetostillanalyzedthesystem'sthewholeconstructionwithworkprinciple,introducedthesystemcorethedatabasetheinsideofeachwatch.Experimentedthatsystemtoconsequentlyproceededtodescribe.ThecombinationthatASPtechniquemaketheWEBdevelopmenttobecomeismoreinbrief,fleetness,efficiently,theforthisreasonASPandADOhavebecomenowdynamicwebpageinsideinterviewdatabaseofmostsolution.KeyWords：Dynamicserver,ActiveXdataobject,ScriptLanguageintotheServer铁通公司进销存系统©小小工作室第3页共48页目录第1章绪论.....................................................................................................................................41.1VB语言的概述..................................................................................................................41.1.1VB简介...................................................................................................................41.1.2VB语言的基本特点及VB应用程序的基本持点................................................41.1.3为何选择VB作为开发语言.................................................................................51.2本课题的意义.....................................................................................................................61.3开发背景.............................................................................................................................61.3.1ActiveX数据对象——ADO..................................................................................61.3.2配置SQLServer2000中的数据库........................................................................91.3.3SQL查询基础.......................................................................................................20第2章系统功能描述及功能图...................................................................................................242.1系统功能...........................................................................................................................24第3章数据库设计.......................................................................................................................253.1建立有特色的数据库.......................................................................................................253.1.1概念模式................................................................................................................253.1.2数据模型................................................................................................................263.2数据表...............................................................................................................................303.2.1客户信息表...........................................................................................................303.2.2订单信息表...........................................................................................................313.2.3产品信息表...........................................................................................................313.2.4库存信息表...........................................................................................................313.2.5厂商信息表..........................