外文文献翻译-VB知识讲解
- 格式:doc
- 大小:46.50 KB
- 文档页数:8
Visual Basic language and arithmetic The United States launched the Microsoft Visual Basic (may be referred to VB), is the latest version of the current VB 2008 Beta2 (VB9) Chinese version. Visual meaning the visual, visible, referring to the development of operating systems like windows windows graphical graphical graphical user user user interface interface interface (Graphic (Graphic (Graphic User User User Interface, Interface, Interface, GUI) GUI) GUI) method, method, method, it it it does does does not not not need need need to to prepare a large number code to describe the appearance of the interface elements and location, as long as the pre - The establishment of good drag and drop objects on the screen corresponding to the location. Basic Basic is is is actually actually actually an an an abbreviation abbreviation abbreviation of of of the the the phrase; phrase; phrase; this this this phrase phrase phrase is is is Beginners Beginners Beginners all-purpose all-purpose symbolic symbolic instruction instruction instruction code, code, code, the the the Chinese Chinese Chinese meaning meaning meaning "to "to "to the the the initial initial initial directive directive directive GM GM GM symbol symbol symbol code code language." Visual Visual Basic Basic Basic learning, learning, learning, Professional Professional Professional Edition Edition Edition and and and Enterprise Enterprise Enterprise Edition Edition Edition versions versions versions to to to meet meet meet the the different different needs needs needs of of of the the the development. development. development. Study Study Study and and and apply apply apply to to to the the the ordinary ordinary ordinary version version version of of of the the the majority majority majority of of learners and the use of Visual Basic development of the general staff of Windows applications, but; professional professional version version version for for for computer computer computer professional professional professional development development development of of of staff, staff, staff, including including including the the the study study study of of functional functional version version version of of of the the the full full full content content content control control control and and and Internet Internet Internet development development development tools tools tools such such such as as as advanced advanced features features ,Enterprise ,Enterprise ,Enterprise contain contain contain not not not only only only all all all the the the professional professional professional version version version of of of the the the content, content, content, there there there are are automated tools such as Component Manager, professional programmers to make the development of a powerful group essence of distributed applications. Visual Basic Section 1 the summary of Visual Basic Microsoft Visual Basic,( abbreviate VB )as tool the most of application program one of under Windows operating platform. No matter beginner or professional developer, VB has all offered a whole set of tools to them, Development application program that it can be relaxed and convenient. So VB as most computer first-selected the ABC of programming language of beginner. " Visual" mean method to adopt visual user of development figure interface (GUI), need and write a large number of code go and describe interface appearance and position of element seldom, Tow Tow and and and show show show controlling controlling controlling part part part that that that need need need corresponding corresponding corresponding position position position to to to get get get screen screen screen can can can help help help figure figure design interface, user of figure,; " Basic" means BASIC language, because VB is developed on the basis of already existing BAISC language. VB is a kind of programming language in common use of Microsoft, It, including VBA of the numerous Windows application software use VB language in Microsoft Excel, Microsoft Accessed., For users to carry on the secondary development; Make web page use more VBScript script language sub collection of VB too at present. Utilize data of VB visit characteristic user can establish the data base to most data base forms including Microsoft SQL Server and other enterprises data base With the application program of front, front, and and and adjustable adjustable adjustable service service service end end end part. part. part. Utilize Utilize Utilize ActiveX(TM) ActiveX(TM) ActiveX(TM) technology, technology, VB VB can can can use use use word word processor, processor, electronic electronic electronic data data data list list list he he he Windows Windows Windows function function function that that that application application application program program program offers offers offers extremely, extremely, Excel Excel of of of Microsoft,, Microsoft,, Microsoft,, Word Word Word of of of Microsoft,, Microsoft,, Microsoft,, Even Even Even can can can use use use by by by VB VB VB specialty specialty specialty edition edition edition or or or enterprise enterprise application program and target that edition establish directly. The procedure that users established finally is a real .EXE file , can issue freely . VB VB offer offer offer study study study edition, edition, edition, the the the specialty specialty specialty edition edition edition and and and enterprise enterprise enterprise edition, edition, edition, use use use to to to satisfied satisfied satisfied with with different different development development development demands. demands. demands. Study Study Study edition edition edition make make make programming programming programming personnel personnel personnel develop develop develop Windows Windows and and Windows Windows Windows application application application program program program of of of NT NT NT very very very easily. easily. easily. The The The specialty specialty specialty edition edition edition has has has offered offered offered the the developing instrument with complete function to programming personnel of the specialty, Include studying all functions of edition in the specialty edition. Enterprise edition allow the professional personnel to establish strong distributed application program in the form of group. It includes all characteristics characteristics of of of the the the specialty specialty specialty edition. edition. edition. So So So can can can choose choose choose different different different editions editions editions according according according to to to different different needs. Section 2 integrated development environments Integrated environment of VB call IDE, made up of a lot of parts , include title board, menu fence, fence, tool tool tool fence, fence, fence, controlling controlling controlling part part part case, case, case, And And And window window window body body body window, window, window, engineering engineering engineering management management device window, attribute window, code window and window body overall arrangement window body overall arrangement, etc. of designing etc.. Have covered all functions, such as design which develops the application program, editting, compiling and debugging, etc.. In VB, the application program calls the project too. When start VB and open a new project for the first time, can see and pursue integrated development environment interface that show. Visual Basic Integrated development environment VB VB come come come and and and organize organize organize development development development of of of application application application program program program through through through project, project, project, use use use project project come come and and and manage manage manage and and and form form form files files files of of of application application application program. program. program. One One One project project project uses uses uses the the the environment environment environment to to make make up up up by by by several several several window window window bodies, bodies, bodies, standard standard standard module module module generally. generally. generally. The The The system system system manages manages manages project project through the project menu, for instance add the window body, quote . System allow turn on and manage a lot of projects besides. Section 3 Visual Basic language brief introductions Basic use and do the elementary high-level language that used often most. Its full name is Beginner' s All-purpose Symbolic Instruction Code, abbreviate as BASIC. As its name suggests, Basic one specially for language that beginner design, because it easy to learn easy to know, So the body is popular. Early Basic language to belong to and solve translating type, so can carry out line line by by by line line line , , , So So So it it it can can can see see see the the the result result result carried carried carried out out out at at at once once once , , , this this this is is is a a a very very very convenient convenient convenient design design design for for beginner. But it have concept of structure either, one that is in procedure maintain and management have as much as other language problems. But back-end Basic correct shortcoming of the above (such as Quick Basic), make it may used for and develop the large-scaler procedure too. The The language language language is is is the the the basic basic basic composition, composition, composition, which which which forms forms forms VB VB VB procedure. procedure. procedure. VB VB VB has has has stipulated stipulated stipulated the the form of sentences and function. Grammar: The sentence defines incantations [Sentence body] Sentence Sentence define define define agree agree agree with with with and and and used used used in in in fixed fixed fixed function function function of of of sentence, sentence, sentence, sentence sentence sentence body body body appoint appoint concrete concrete content content content or or or want want want concrete concrete concrete operation operation operation that that that carry carry carry out out out of of of sentence. sentence. sentence. All All All set set set of of of sentence sentence sentence VB VB language, language, carry carry carry on on on with with with VB VB VB sentence sentence sentence organic organic organic association association association finish finish finish a a a certain certain certain specific specific specific function function function the the procedure. Interface + procedure can solve a certain application problem. VB application program code window write in" code editing machine" generally. " editing machine of code" is like the word processing software of a piece of height specialization, there are many easies function of writing VB code, Pursue to show [Example Ex-Hello ]In" code editing machine" code that window written. “Editing machine of code” windowSection 4 develop the application program with Visual Basic Use VB programming, design appearance of application program first generally, write every target procedure code or other treatment procedure of incident respectively, Work of programming should be light more. The procedure of establishing the application program is as follows: Establish application program interface The interface is the mutual bridge of user and procedure, Generally formed of window body and and vision vision vision frame frame frame of of of the the the button, button, button, menu, menu, menu, text text text frameset. frameset. frameset. with with with standard standard standard WINDOWS WINDOWS WINDOWS interface interface interface of of application program that VB establish. Require according to function of procedure and user and need of information interchange of procedure, Come to confirm that need those targets , plan the overall arrangement of the interface. 2. Design by each attributes of target in interface Demand Demand and and and set set set up up up each each each attribute attribute attribute of of of target target target such such such as as as appearance, appearance, appearance, name,, name,, name,, size size size of of of targeted. targeted. according to interface of planning. Most attribute person who fetch can set up through the attribute window when design already, Too Too can can can set set set up up up revising revising revising when when when operating operating operating in in in procedure procedure procedure through through through programming programming programming in in in procedure procedure procedure code. code. Have the targets respond programming by procedure code 3. Respond procedure code of programming target Interface determine appearance of procedure only, design window add codes through" code editing editing machine" machine" machine" soon soon soon after after after the the the interface, interface, interface, Realize Realize Realize some some some make make make the the the tasks, tasks, tasks, such such such as as as responding, responding, information processing,etc. after accepting external message, Add code , realize some response, information processing that make after accepting external information task, As editor's window of code pursued shows add codes “code editing machine” window4. Keep project One VB procedure one project, at the time of designing a application program, system will set up one be expanded and called. Project file of vbp, project file include all relevant information of file that project set up this, Keep project keep associated documents of project this at the same time. For example the window body produced when design interfaces is kept and being expanded and being called. Frm sum. In the window body of foxfire. At the time of opening a project( file), this project relevant files load at the same time. 5. Operate and debugged by procedure Operate the procedure thoroughpin operate" selecting in the menu, when the mistake appears, VB system can offer information prompt can looked for and get rid of the mistake thoroughpin debug" within operate" menus too. 6. Can produce by executive program For For make make make procedure procedure procedure can can can break break break away away away from from from VB VB VB environment, environment, environment, order order order to to to become become become next next next life life through" file"" producing project 1.exe" of menu but executive program (eyeful), Can carry out this file directly after this. In produce, + executive program, and then through install guide bale all associated documents, Can run independently after installation under the environment of windows 9 x/2000 as a software product. In In computer computer computer system's system's system's any any any software, software, software, is is is by by by the the the every every every large large large or or or small small small each each each kind kind kind of of of software software constituent constituent constitution, constitution, constitution, defers defers defers to to to the the the specific specific specific algorithm algorithm algorithm to to to realize realize realize respectively, respectively, respectively, the the the algorithm algorithm quality quality direct direct direct decision decision decision realizes realizes realizes the the the software software software performance performance performance fit fit fit and and and unfit unfit unfit quality. quality. Designs Designs the the algorithm algorithm with with with any any any method, method, method, what what what resources resources resources designs designs designs the the the algorithm algorithm algorithm to to to need, need, need, requires requires requires how how how many many running time, how many storage space, how to determine an algorithm the quality, when realizes a software, is must give to solve. In computer system's operating system, the language compiling system, system, the the the database database database management management management system system system as as as well well well as as as in in in various various various computer computer computer application application application system's system's software, must use each one concrete algorithm to realize. Therefore, the algorithm design and the analysis are the computer science and a technical core question. The The algorithm algorithm algorithm is is is the the the problem-solving problem-solving problem-solving step, step, step, we we we may may may define define define the the the algorithm algorithm algorithm Cheng Cheng Cheng Jie Jie Jie a a determination determination class class class question question question the the the random random random one one one special special special method. method. method. In In In the the the computer computer computer science, science, science, the the algorithm algorithm needs needs needs to to to use use use the the the computer computer computer algorithmic algorithmic algorithmic language language language to to to describe, describe, describe, the the the algorithm algorithm algorithm represents represents with with the the the computer computer computer solves solves solves a a a kind kind kind of of of question question question precisely, precisely, precisely, the the the effective effective effective method. method. method. The The The algorithm algorithm construction of data = procedure, solves one to assign may calculate or the solvable question, the different person may compile the different procedure, solves the identical problem, here has two problems: First, with computational method close related algorithm question; Second, programming technical question. Between the algorithm and the procedure has the close relationship. The algorithm is a group has the poor rule, they had stipulated solves some specific type type question question question a a a series series series of of of operations, operations, operations, is is is to to to the the the problem problem problem solving solving solving plan plan plan accurate accurate accurate and and and the the the complete complete description. description. Formulates Formulates Formulates an an an algorithm, algorithm, algorithm, generally generally generally must must must pass pass pass through through through stages stages stages and and and so so so on on on design, design, confirmation, confirmation, analysis, analysis, analysis, code, code, code, test, test, test, debugging, debugging, debugging, time. time. time. To To To algorithm algorithm algorithm study study study including including including five five five aspect aspect contents:① Design algorithm. The algorithm design work is impossible completely the automation, should study the understanding already by the practice to prove that was the useful some some basic basic basic algorithm algorithm algorithm design design design method, method, method, these these these basic basic basic design design design method method method was was was not not not only only only suitable suitable suitable for for for the the computer science, moreover was suitable for domains and so on electrical engineering, operations research;② Expresses the algorithm. The description algorithm's method has many kinds of forms, for example the natural language and the algorithmic language, have the suitable environment and the the characteristic characteristic characteristic respectively;respectively;③Confirms Confirms the the the algorithm. algorithm. algorithm. The The The algorithm algorithm algorithm confirmed confirmed confirmed the the the goal goal goal is is causes the people to believe firmly that this algorithm can work unmistakably correctly, namely this algorithm has the circularity. The correct algorithm describes with the computer algorithmic language, language, constitutes constitutes constitutes the the the computer computer computer program, program, program, the the the computer computer computer program program program moves moves moves on on on the the the computer, computer, obtains the algorithm operation result;④ Parsing algorithm. The algorithmic analysis is requires how many computing time and the storage space to an algorithm makes the quota the analysis. The The parsing parsing parsing algorithm algorithm algorithm may may may forecast forecast forecast that that that what what what environment environment environment this this this algorithm algorithm algorithm does does does suit suit suit in in in moves moves effectively, to solves the identical question different algorithm validity to make the comparison;⑤Confirmation Confirmation algorithm. algorithm. algorithm. With With With machine machine machine language language language description description description algorithm algorithm algorithm whether whether whether can can can calculate calculate effectively, reasonable, must carry on the test to the procedure, the test order work and makes the space and time distribution map by the debugging to be composed. But the algorithm has certain characteristic, it includes:① Determinism. Algorithm each kind of of operation operation operation must must must have have have the the the determination determination determination significance, significance, significance, this this this kind kind kind of of of operation operation operation should should should carry carry carry out out what what kind kind kind of of of movement movement movement should should should not not not to to to have have have the the the ambiguity, ambiguity, ambiguity, the the the goal goal goal is is is clear;clear;② Effectiveness. Requests the operation which in the algorithm waits for realizing is basic, each kind of operation can at least completes in the principle by the human with the paper and the pen in the limited time;③ Input. An algorithm has 0 or the many inputs, before the algorithm operation starts gives the algorithm to need the data the starting value, these inputs are from the specific object set;④Output. Does for the algorithm operation result, an algorithm has or many outputs, the output has some kind of specific relational quantity with the input;⑤ Has poor. An algorithm always after carrying out had the poor step operation has terminated, namely this algorithm was may reach. Satisfies a first four characteristic group of rule not to be able to be called the algorithm, can only be called the computational process, the operating system is a computational process example, the operating system uses for to manage the computer resources, controls the manufacture industry movement, when has not made industry the movement, the computational process does not stop, but is at the waiting status. The algorithm complexity is the algorithm efficiency measure, when appraises the algorithm performance, performance, the the the complexity complexity complexity is is is an an an important important important basis. basis. basis. The The The algorithm algorithm algorithm complex complex complex degree degree degree with with with moves moves computer resources how many which this algorithm needs related, needs the resources are more, indicated that this algorithm the complexity is higher; Needs the resources are less, indicated that this algorithm the complexity is lower. Th The spatial resources, which computer’s resources, operate most importantly, needs the time e spatial resources, which computer’s resources, operate most importantly, needs the time which which and and and the the the stored stored stored routine routine routine and and and the the the data data data need, need, need, the the the algorithm algorithm algorithm complexity complexity complexity has has has division division division time time complexity and the spatial complexity. The algorithm carries out the operation on the computer, needs the data which certain storage space space depositing depositing depositing description description description algorithm algorithm algorithm the the the procedure procedure procedure and and and the the the algorithm algorithm algorithm need, need, need, the the the computer computer completes the operation task to require certain time. The procedure which writes according to the different different algorithm algorithm algorithm places places places when when when on on on the the the computer computer computer operates, operates, operates, needs needs needs the the the time time time and and and the the the space space space are are different, the algorithm complexity is needs the time and the spatial one kind of measure to the algorithm operation. The different computer its operating speed difference is very big, is weighing an algorithm the complexity to note this point. Regarding question, which assigns willfully, a profitable target which designs, the complex low low algorithm algorithm algorithm is is is as as as far far far as as as possible possible possible when when when designs designs designs algorithm algorithm algorithm considered. considered. considered. Moreover, Moreover, Moreover, when when when the the question, which assigns already when has many kinds of algorithms, an important criterion which choice complexity low, is when selects algorithm should follow. Therefore, the algorithm complex analysis or selects to the algorithm design has the important guiding sense and the use value. When discussion algorithm complexity, two questions need to clarify: (1) A n algorithm's complexity expresses with what kind of quantity; An algorithm's complexity expresses with what kind of quantity; (2) H ow How How to to to calculate calculate calculate one one one to to to assign assign assign the the the algorithm algorithm algorithm the the the complexity. complexity. complexity. After After After finding finding finding solves solves solves a a question the algorithm, is this algorithm realization, as for whether could find the method which realized, realized, was was was decided decided decided in in in the the the algorithm algorithm algorithm circularity circularity circularity and and and the the the computation computation computation complexity, complexity, complexity, whether whether whether this this question question did did did have have have the the the solution solution solution algorithm, algorithm, algorithm, whether whether whether to to to provide provide provide the the the time time time resources resources resources which which which and and and the the spatial resources the algorithm needed. Visual Basic 语言和算术 美国发动的美国发动的Microsoft Visual Basic (可简称(可简称VB )中,是当前VB 的2008 Beta2中(VB9)中文版的最新版本。
毕业设计(论文)外文资料翻译系(院):计算机科学系专业:计算机科学与技术姓名:学号: 111001203外文出处:Learn Visual Basic in 24 hours--Hour 1 Visual Basic at Work 附件:1.外文资料翻译译文;2.外文原文。
附件1:外文资料翻译译文Visual Basic简介什么是Visual BasicMicrosoft Visual Basic 5.0是旧的BASIC语言最近的最好的化身,在一个包里给你一个完全的Windows应用开发系统。
Visual Basic (我们常称它VB)能让你写、编辑,并且测试Windows应用程序。
另外,VB有包括你能用来写并且编译帮助文件那的工具,ActiveX控制,并且甚至因特网应用程序Visual Basic是它本身的一个Windows应用程序。
你装载并且执行VB系统就好象你做其它Windows程序。
你将使用这个运行的VB程序创造另外的程序。
虽然VB是一个非常地有用的工具,但VB只是一个程序员(写程序的人)用来写,测试,并且运行Windows应用程序的工具。
尽管程序员们经常可替交地使用术语程序和应用程序,当你正在描述一个Windows 程序时术语应用程序似乎最适合,因为一个Windows程序由若干份代表性的文件组成。
这些文件以工程形式一起工作。
通过双击一个图标或由以Windows开始应用程序运行启动菜单用户从Windows加载并且运行工程产生最终的程序。
过去的45年与计算机硬件一起的编程工具的角色已经演变。
今天一种程序语言,例如Visual Basic,一些年以前与程序语言的非常不一致。
Windows操作系统的视觉的天性要求比一些年以前是可利用的更先进的工具。
在windowed环境以前,一种程序语言是你用来写程序的一个简单的基于文章工具。
今天你需要的不只是一种语言,你需要一种能在windows系统内部工作并且能利用所有的绘画、多媒体、联机和Windows提供的多处理活动开发应用软件的绘图开发工具。
ANALYSIS OF DATABASE PROGRAMMING IN VBVB (Visual Basic) is a visualization programming environment that Microsoft Corporation promotes based on the Basic language.It is simple and easy to study.It has formidable function so that many computer amateurs really like it.A lot of application softwares all use VB as the software development platform.When we use VB to develop the application software,how to use the database and carry on the management of the database is concerned by all exploiters.VB has provided many tools and methods for database programming.What method is used to visit the database depends on users’different demands,a simple analysis of the VB database programming is explained as followings.1.DAO TechnologyBy using Microsoft company’s Jet Database Engine (Jet database engine),DAO (Data Access Object) the technology mainly provides visit to ISAM (smooth index search method) type database,such as the realization of the visit to database like FoxPro,Access, Dbase.1.1 Use Data ControlsData controls are produced by using “Data” button in the toolbox.It has 3 basic attributes:Connect,Database Name and RecordSource.Connect attribute specifys the database type that data controls visit,the default database is the Access database.The value of the Database Name attribute is the database filename which contains the complete path.The Record Source attribute is the recordset that we visit,also can be tables or SQL sentences.If we will visit table stud of database file teacher mdb of TEMP folder under D plate,then Data controls’s Connect attribute is null,and the Database Name attribute is “D: \temp \ teacher mdb”,the value of the Record Source attribute is “stud”.This can accomplish the binding between Data controls and database records. Through the methods of Data controls like Add new,Update,Delete, Move last,we can visit the database as every request.When we browse the content in database,Data controlls is used frequently with DBGrid,it provides data inquiry in grid way.1.2 Use DAO Object StorehouseThe model of the DAO object storehouse is mainly using hierarchical structure, Dentine is the object in the topmost story,below it are two object sets,Errors and workspace, under the workspace object,is the Databases set.When the application procedure quotes the DAO object storehouse,it produces only a Dentine object,and produces a default automatical working space object named workspace.When not mentioned,all database operations are all work in workspace(0),which is a default work area.But we must pay attention:The Jet engine will not starts automatically after VB has been loaded. Only when we choose References in the menu of Project can we select Microsoft DAO 3.5 Object Library to use.We create databases with the method “Create Database”in DAO,use“CreateTable” method to bulid tables,use the “Open Database ” to open the database ,use “Open recordset”method to open recordset,use Add new,Update,Delete,Move first,Edit methods to realize each kind of operations about tables.2.RDO TechnologyRDO provides a connection to related ODBC data pool.When we need to visit other databases like SQL Server,Oracle,especially to establish the customer/server application procedure,we may use the long range data controls RDC (Remote Data Control) and long range data objects RDO (Remote Data Control) to realize the visit to the database through the ODBC driver.By using ODBC to visit some database we must first install the corresponding drivers,like establish a data pool,through assigned data pool to visit corresponding database.To establish the ODBC data pool is open the window of “the control panel”, double-clicks the icon of ODBC executive program,single-click “Add” butt on to create the data pool of the opening ODBC data pool supervisor dialog box,and choose corresponding database.2.1 Use RDC ControlsSimilar to the use of DATA Controls, we use Data source name attributes to assign the data source name that controls bind,and we use SQL attributes to assign the recordset, The difference is that,we have to use the SQL sentences to assign the SQL attribute in RDC Controls . When we browse the database we may find it is used with DBGrid frequently.2.2 Use RDO Object StorehouseBefore we use RDO object,we should choose References in the menu of Project, click”Microsoft Remote Data Object 2.0”,then we can continue.The step we use RDO to visit the ODBC data pool is:(1) Set a RDO environment object.(2) Open an ODBC data pool with the method of Open connection.(3) Establish a result object with the method of Open Result set.(4) Use assigned method to operate the records of resultset.After founds the as this result collection object,is similar with the DAO object storehouse use,may through transfer method realizations and so on its Add new,Update, Delete visit to assign the data pool each kind of request.3.ADO TechnologyADO (ActiveX Data Objects) is the latest data access technology of Microsoft,It uses data accessing connection UDA (Universal Data Access),to standard all datas as a kind of data pool,through the filtration of OLEDB connection,transforms as a kind of general data format in the same way,enables the application procedure to visit this kind of datas.OLEDB is an underlying level of the data accessing connection,with it we may visit kinds of data pools,including traditional related databases,as well as electronic mail systemand self-definition commercial object.3.1 Use ADO ControlsSingle-click the Components command in the menu of the Project,select “Microsoft ADO Data Control in the Components dialog box 6.0 (OLE DB)”,we may add ADO controls to the box of controls.We set the OLEDB Provider and assigned database file by setting the Connection string attribute of ADO,and we set the Record Source attribute as record source that ADO connected.Similar to DAO and RDO, with it, we are able to visit all kinds of database fastly.3.2 Use The ADO Object StorehouseSingle click the References orders in the Project menu, select “Microsoft ActiveX Data Objects 2.0 Library” in the References dialog box, you may add ADO object.Old object models, like DAO and RDO, are look like levels,a lower data object like Recordset is the sub-object of higher level objects like Environment and the Queried. But ADO is actually different, it defined a group of plane top object, the most important ADO objects are Connection, Recordset and Command.The Connection object is used to establish the connection of application procedure and the data pool.The Command object is used in defining a SQL sentence, a memory process or other commands that operates the datas.Recordset object preserves recordsets after executions.By using alternative means of the recordset object, we can modify,delete and inquire the recordset.4 ConclusionsVB provides many methods to accomplish the operation to the database, in which DAO mainly finish the visit to ISAM database, RDO provides connection to the ODBC data pool, both RDO and DAO have developed as matured technology.Before VB 6.0 ,the main technology is about database visit, however,the Active Data Objects(ADO) ,as new generation of database interface which is promoted by Microsoft, is designed to work with new data accessing level OLEDB, so that it provides general data accessing (Universal Data Access), it provides quite a lot advantages to the programmers, including easy use, the familiar contact surface, high velocity ,as well as the lower memory. As a result of above reasons, ADO will gradually replace other data accessing connections, and will becomes the fundamental mode of the VB of visit database.VB的数据库编程分析VB(Visual Basic)是微软公司推出的基于Basic语言的可视化编程环境,以其简单易学、功能强大而倍受广大电脑爱好者的青睐。
实验方法辐射黑色体理论(Chao et al., 1961)和切削表面理论(Friedman and Lenz, 1970)。
随着敏感的红外感光胶片的发展,在一个可被记录切削侧面温度场的工具(Boothroyd, 1961)和电视型红外线敏感的视频设备已被哈里斯等人使用(1980年),以热传感和半导体量子吸收的原则为基础的红外线传感器的不断发展,使得这些传感器的第二敏感性大于第一次,其时间常数很小太- 在微秒到毫秒的范围之内。
图5.21显示了最新使用的第二类的例子。
有两个传感器以及开始投入使用,一个是在1毫米至5毫米的波长范围的敏感型锑化铟,另外一个是从6毫米至13毫米的敏感型碲镉汞类型,通过与两个不同的探测器信号比较可以使用温度测量更敏感的方法。
大部分金属切削温度已进行了调查和了解使得更好地了解这个过程。
原则上,温度测量可能用于条件监测,例如,警告说如果是天气太热导致切割刀具后刀面磨损,然而,尤其是辐射能尺寸,在生产条件,校准问题以及确保辐射能量途径从伤口区到探测器不被打断的困难,使得以温度测量为目的方法不够可靠切削的另一种方式是监测声发射,这虽然是一个间接的方法,但研究过程的状态是一个值得考虑未来。
5.4 声发射材料的活跃形变—例如裂缝的增长,变形夹杂物,快速塑性剪切,甚至晶界,位错运动都是伴随着弹性应力波的排放而产生。
这就是声发射(AE)。
排放的发生在一个很宽的频率范围内,但通常是从10万赫到1兆赫。
虽然波幅度很小,但是他们可以被检测到,通过强烈的压电材料如钛酸钡或压电陶瓷传感器制造从,(Pb(Zr x Ti1–x)O3; x = 0.5 to 0.6)。
图5.22显示了传感器的结构。
声波传送到压力传感器造成直接的压力E(△L/L),其中E是传感器的杨氏模量,L 是它的长度,△L是它的长度变化。
应力产生电场T = g33E(△L/L)(5.7a)g33是传感器材料的压电应力系数。
传感器两端的电压是TL,然后V= g33E△L(5.7b)g33和E的典型值分别是24.4 × 10-3Vm/ N和58.5GPa,以检测电压高达0.01毫伏,这是可能的。
计算机专业外文文献及翻译微软Visual Studio 微软 Visual Studio1 微软 Visual Studio Visual Studio 是微软公司推出的开发环境,Visual Studio 可以用来创建 Windows 平台下的Windows 应用程序和网络应用程序,也可以用来创建网络服务、智能设备应用程序和 Office 插件。
Visual Studio 是一个来自微软的集成开发环境 IDE(inteqrated development environment),它可以用来开发由微软视窗,视窗手机,Windows CE、.NET 框架、.NET 精简框架和微软的 Silverlight 支持的控制台和图形用户界面的应用程序以及 Windows 窗体应用程序,网站,Web 应用程序和网络服务中的本地代码连同托管代码。
Visual Studio 包含一个由智能感知和代码重构支持的代码编辑器。
集成的调试工作既作为一个源代码级调试器又可以作为一台机器级调试器。
其他内置工具包括一个窗体设计的 GUI 应用程序,网页设计师,类设计师,数据库架构设计师。
它有几乎各个层面的插件增强功能,包括增加对支持源代码控制系统(如 Subversion 和 Visual SourceSafe)并添加新的工具集设计和可视化编辑器,如特定于域的语言或用于其他方面的软件开发生命周期的工具(例如 Team Foundation Server 的客户端:团队资源管理器)。
Visual Studio 支持不同的编程语言的服务方式的语言,它允许代码编辑器和调试器(在不同程度上)支持几乎所有的编程语言,提供了一个语言特定服务的存在。
内置的语言中包括 C/C 中(通过Visual C)(通过 Visual ),C,中(通过 Visual C,)和 F,(作为Visual Studio2010),为支持其他语言,如 MPython和 Ruby 等,可通过安装单独的语言服务。
毕业设计(论文)外文文献翻译文献、资料题目:B/S结构文献、资料来源:文献、资料发表(出版)日期:院(部):专业:班级:姓名:学号:指导教师:翻译日期: 2017.02.14附件1:外文资料翻译译文B/S结构B/S结构即Browser/Server(浏览器/服务器)结构,是伴随着互联网技术出现的一种对C/S结构的改变或者说是改进。
在这种结构中,用户界面通过WWW 来达到在前端充分实现部分逻辑的目的,但最主要的逻辑在服务器中实现,从而形成一个所谓的三层结构。
B/S结构主要被用于成熟的WWW技术,与多种浏览器脚本语言(VBScript, JavaScript)以及ActiveX技术相结合。
为了实现强大的功能和开发成本的节约,用一个标准的网页浏览器来与复杂的专用软件相结合,是一种全新的软件架构技术。
在今天的软件应用中,Windows98和Windows2000操作系统在浏览器技术上植入B/S结构已成为优先的架构。
很明显,B/S结构的应用相对于传统的C/S结构的应用程序会有巨大进步。
B/S结构使用星形配置或使用互联网虚拟专网(VPN)来建立内部的通讯系统网络。
前者具有安全、快速和准确的特性。
后者则是投入的节约,与利益相关联。
以公司规模和地理位置分布为前提,利用互联网接入,通过内部防火墙至整个网络。
C/S结构和B/S结构的区别:客户/服务器结构是建立在局域网的基础上的。
浏览器/服务器结构是建立在广域网基础上的。
不同的计算机硬件环境:C/S结构一般建立在专用网络上,在小范围的网络环境中,在经由的局域网服务器之间提供连接和数据交换的专业化服务。
B/S结构建立在广域网以上,不需要在电话网络和租用设备中安装专门的网络硬件环境。
其信息自主化管理,C/S结构比一般的操作系统和浏览器适用范围更广,只要能联网就行。
不同的安全性要求:C/S结构相对固定的一般用户团体,其信息安全控制能力是强大的。
高度机密的信息系统一般采用C/S结构比较合适,因为通过发布,公开了B/S结构的信息。
vb知识点总结VB(Visual Basic)是一种广泛应用于软件应用开发的编程语言,它具有简单易学、功能强大和灵活的特点。
本文将总结一些VB的知识点,从基础概念到高级应用,帮助读者更好地理解和运用VB。
1. VB的基础概念VB是一种基于事件驱动的编程语言,它的核心思想是根据用户的操作(如点击按钮、输入文本等),来触发相应的事件处理程序。
在VB中,开发者可以通过编写代码,来定义和控制这些事件的响应行为。
此外,VB还支持对象导向编程(OOP),开发者可以使用类、对象等概念来组织和管理程序。
2. VB的开发环境VB的开发环境提供了直观、友好的界面,使得开发者可以方便地创建、编辑和调试代码。
在VB的开发环境中,开发者可以通过拖放控件的方式来设计用户界面,例如窗体、按钮、文本框等。
同时,开发者可以在代码编辑器中编写事件处理程序,实现自定义功能。
3. VB的数据类型与变量在VB中,数据类型是用来定义变量和常量的数据类型。
常见的数据类型包括整型、浮点型、字符串型等。
开发者可以根据需要选择合适的数据类型,并使用变量来存储和操作数据。
VB还支持变量的声明和初始化,开发者可以通过赋值语句来初始化变量的值。
4. VB的控件与事件VB提供了丰富的控件库,包括文本框、按钮、列表框等。
开发者可以通过操作这些控件,实现用户界面和功能的设计。
每个控件都有一些内置的事件,例如按钮的点击事件、文本框的文本变化事件等。
开发者可以通过编写事件处理程序,来响应这些事件,实现相应的功能。
5. VB的函数与过程函数和过程是VB中组织和管理代码的重要方式。
函数是具有返回值的代码块,可以接受输入参数并返回结果;而过程则是不返回值的代码块,仅执行一系列操作。
开发者可以自定义和调用函数或过程,使得代码更加模块化和可复用。
6. VB的条件和循环结构条件和循环结构是控制程序执行流程的重要手段。
VB提供了if语句、select语句等条件结构,可以根据不同的条件执行不同的代码块。
门开度的大小,调节进入气缸的混合气的量来控制负荷的大小。
柴油机的负荷调节方式为“质调节”,在一定转速下通过调节向气缸内的喷射的燃油量来控制负荷的大小。
由于负荷调节方式以及燃烧方式不同,汽油机和柴油机的负荷特性也有所不同。
汽油机的指示热效率和柴油机指示热效率随负荷的变化规律相反。
汽油机燃油消耗率随负荷变化曲线比柴油机要陡,汽油机经济性指标比柴油机差,柴油机的燃油消耗率随负荷变化又缓慢又低,所以柴油机的经济性比汽油机的经济性强。
通过将发动机的各个参数绘制在一张图上形成发动机的万有特性曲线图,通过发动机万有特性曲线图可以看出在不同油耗下发动机运行的情况。
绘制万有特性曲线的方法有负荷特性法和速度特性法。
在绘制时,首先绘制不同转速下的负荷特性曲线组或者不同负荷下的速度特性曲线组,然后通过坐标转换,将负荷特性曲线组或者速度特性曲线组转换成等油耗的万有特性。
在等油耗万有曲线图上等油耗线越向外,燃油消耗率越高,经济性越差。
在水平方向上等间隔的油耗线稀疏,说明转速的变化对经济性影响较小,反之影响较大。
同理垂直方向上转速的等油耗线的疏密程度表明了发动机的经济性对负荷变化的适应性。
如果垂直方向上曲线分布密集,表明经济性对负荷变化较为敏感。
Visual Basic是一种由微软公司开发的包含协助开发环境的事件驱动编程语言。
它源自于BASIC编程语言。
VB拥有图形用户界面(GUI)和快速应用程序开发(RAD)系统,可以轻易的使用DAO、RDO、ADO连接数据库,或者轻松的创建ActiveX控件。
程序员可以轻松使用VB提供的组件快速建立一个应用序。
Visual Basic是一种可视化的编程语言,利用这种可视化技术进行编程,能使编程工作变得轻松快捷,摆脱了面向过程语言的许多细节,而是将主要精力集中在解决实际问题和设计友好界面上。
因此Visual Basic在国内外各个领域的应用非常广泛,许多计算机专业和非计算机专业的人员常用它来编制开发应用程序和软件。
毕业设计(论文)外文文献翻译文献、资料中文题目:1.VB的数据库编程分析2.数据库的发展、应用和基本原理文献、资料英文题目:文献、资料来源:文献、资料发表(出版)日期:院(部):专业:软件工程班级:姓名:学号:指导教师:翻译日期: 2017.02.14学生公寓智能化管理系统——学生与房间管理子系统外文文献及翻译专业:软件工程ANALYSIS OF DATABASE PROGRAMMING IN VBVB (Visual Basic) is a visualization programming environment that Microsoft Corporation promotes based on the Basic language.It is simple and easy to study.It has formidable function so that many computer amateurs really like it.A lot of application softwares all use VB as the software development platform.When we use VB to develop the application software,how to use the database and carry on the management of the database is concerned by all exploiters.VB has provided many tools and methods for database programming.What method is used to visit the database depends on users’different demands,a simple analysis of the VB database programming is explained as followings.1.DAO TechnologyBy using Microsoft company’s Jet Database Engine (Jet database engine),DAO (Data Access Object) the technology mainly provides visit to ISAM (smooth index search method) type database,such as the realization of the visit to database like FoxPro,Access, Dbase.1.1 Use Data ControlsData controls are produced by using “Data” button in the toolbox.It has 3 basic attributes:Connect,Database Name and RecordSource.Connect attribute specifys the database type that data controls visit,the default database is the Access database.The value of the Database Name attribute is the database filename which contains the complete path.The Record Source attribute is the recordset that we visit,also can be tables or SQL sentences.If we will visit table stud of database file teacher mdb of TEMP folder under D plate,then Data controls’s Connect attribute is null,and the Database Name attribute is “D:\temp \ teacher mdb”,the value of the Record Source attribute is “stud”.This can accomplish the binding between Data controls and database records. Through the methods of Data controls like Add new,Update,Delete, Move last,we can visit the database as every request.When we browse the content in database,Data controlls is used frequently with DBGrid,it provides data inquiry in grid way.1.2 Use DAO Object StorehouseThe model of the DAO object storehouse is mainly using hierarchical structure, Dentine is the object in the topmost story,below it are two object sets,Errors and workspace, under the workspace object,is the Databases set.When the application procedure quotes the DAO object storehouse,it produces only a Dentine object,and produces a default automatical working space object named workspace.When not mentioned,all database operations are all work in workspace(0),which is a default work area.But we must pay attention:The Jet engine will not starts automatically after VB has been loaded. Only when we choose References in the menu of Project can we select Microsoft DAO 3.5 Object Library to use.We create databases with the method “Create Database”in DAO,use “CreateTable” method to bulid tables,use the “Open Database ” to open the database ,use “Open recordset”method to open recordset,use Add new,Update,Delete,Move first,Edit methods to realize each kind of operations about tables.2.RDO TechnologyRDO provides a connection to related ODBC data pool.When we need to visit other databases like SQL Server,Oracle,especially to establish the customer/server application procedure,we may use the long range data controls RDC (Remote Data Control) and long range data objects RDO (Remote Data Control) to realize the visit to the database through the ODBC driver.By using ODBC to visit some database we must first install the corresponding drivers,like establish a data pool,through assigned data pool to visit corresponding database.To establish the ODBC data pool is open the window of “the control panel”, double-clicks the icon of ODBC executive program,single-click “Add” butt on to create the data pool of the opening ODBC data pool supervisor dialog box,and choose corresponding database.2.1 Use RDC ControlsSimilar to the use of DATA Controls, we use Data source name attributes to assign the data source name that controls bind,and we use SQL attributes to assign the recordset, The difference is that,we have to use the SQL sentences to assign the SQL attribute in RDC Controls . When we browse the database we may find it is used with DBGrid frequently.2.2 Use RDO Object StorehouseBefore we use RDO object,we should choose References in the menu of Project, click”Microsoft Remote Data Object 2.0”,then we can continue.The step we use RDO to visit the ODBC data pool is:。
附录VB And Database1 VB Database Access MethodVB database visit many ways, under normal circumstances is divided into two categories, and each category there are many ways. Below in tabular form for each of the categories, and each category contains methods.1.1Object Interface (API)VBSQL : through DB-Library visit the Microsoft SQL Server ODBC API : any ODBC data source 16 and 32 DAO / Jet : Jet local / Access.MDB. Index sequence database (ISAM) and any ODBC data source DAO / ODBC Direct : any ODBC data source (after RDO) RDO 2.0 : any ODBC data source (Level I or II) ADO : any ODBC data source and any OLE DB interface through the data source interface1.2Data Control ActData Control : DAO / Jet Data Interface Control Data Interface / Direct ODBC : DAO / ODBC data interface Direct Control Interface RemoteData / RD C : RDO data interface Advanced Data Interface Connector / ADC : ADO data interface Interface2 Several of InterfaceADC (Advanced Data Connector) : Advanced Data Connector. ADO provide bundled data source window to the data binding controls on. ADC is essentially a visit or through direct access remote ADO OLE DB object of a technology, It also supports major applications in the Microsoft IE browser bundled with the data control. It is specifically for the Web browser-based application designed.ADO (Active Data Objects) : Active Data Objects. Yes DAO / RDO the successor product, ADO "expansion" of the DAO and RDO used by the object model, This means that it contains fewer targets, more attributes, methods (parameters), and the incident. ADO is a real visit with the various types of data linking mechanism. ADO designed for a very simple format, through the ODBC interface with the database. Can use any ODBC data source, that is not suitable for SQL Server, Oracle, Access such as database applications, but also for Excel spreadsheets, text files, No graphics files and the data file format is an easy-to-use application program interface layer. ADO isMicrosoft's latest and most powerful data access model designed OLE DB, for any OLE DB data source to provide a high-performance interviews, including data sources and non-relational databases, E-mail and file systems, text and graphics, custom business objects, and so on. ADO in key Internet program for at least the network traffic, and the front-end data sources and the use of at least between the layers, all of which are meant to provide light volume, high-performance interface. So ADO through its internal attributes and methods of providing unified data access interface method.DAO (Data Access Objects) : data access object. Is an object-oriented inte rface to the interface. Through DAO / Jet functi on can access ISAM database, use DAO / ODBC Direct functions can be remote RDO function. DAO use the program code is very simpl e. DAO provide rich cursor (Cursor) type and the result of non-cursor (Cursor-Less) type of res ult sets, with the DDL (data description language) is ver y similar to the function. DAO through ODBC, as a direct link to other databases. connect directly to the Access database. DAO sy stem suitable for single applications or small - scale use of the local distribution. DAO model is to design relational database system archit ecture object class collection. They provide a complete management system for the entire oper.html ation of the properties and methods. including the creation of the database, definition of the tables, the fields and indexes, the establishment of the relationship between the tables, positioning and searching tools such as databa ses.JET (Joint Engine Technology) : data connectivity engine technologies. A workstation is based on the adoption of DAO database access mechanism. Although Microsoft Access can be provided by the ODBC driver visit Jet database However, the use of these drivers functional restrictions. Jet has its own mechanism for the inquiry and the result set handling, and can be the same species or dissimilar data sources for query processing.0DBC (Open Database Connectivity) : open database connectivity. Heterogeneous database for the visit provides a unified interface. ODBC based on SQL (Structured Query Language), and regarded it as the standard database. This interface provides maximum interoperability : an application program through a group of generic code access different database management systems. A software developer in the development of client / server applications will not be binding on a particular database above. ODBC for different database for a corresponding driver, is a recognized source of the data Interface. It fast and light to provide a unified interface and the interface to any ODBC data source optimized for neither.ODBC API : manufacturers to the database designer procedures provide direct access to the database of a group function. Note : The point here is that although the ODBC API provides a lot of convenience and powerful functionality. But usually the ODBC API are relatively hard to learn, but it is very prone to error. Although ODBC API allowed to operate ODBC handle, but they still have to be careful If incorrect use ODBC API, it may result in unpredictable error. For example, if the use of ODBC API code to close the connection or ODBC release handle of any one, Then RemoteData control or RDO behavior will be unpredictable. ODBC handle depositary for the reserve is meaningless, because they are variable.ODBC Direct : DAO is a target based on the new DAO mode its methods and attributes and RDO function the same. Use the DAO code of occasions, can be used to access remote data sources.OLE DB : COM model is the database interface. The bottom is a data access interface interface. Is the third driver for the development of businesses exporting data sources to ADO applications, or for C + + developers development of customized database components. It will be able to handle any type of data. OLE DB application to provide a uniform data access methods, without considering their format and storage. In practical application, which means you can visit diversity presence in the electronic data sheets, text files and even mail server Microsoft Exchang such as the data. OLE DB was not directly call VB.RDC (RemoteData Control) : Remote Data Access Control. RDO right is a bundled component data. Can output the result of specific data sources to control.RDO (Remote Data Objects) : Remote Data Objects. ODBC is one of the object-oriented data access interface, Remote data objects and code sets for use to create and operate a remote ODBC database system for the various components a framework. Set targets and have a database describing the characteristics of the various components used to manipulate the attributes and methods of these components. Can set targets and establish relations between these relations on behalf of the database system, the logical structure. It's easy to use the same style DAO combination provides an interface, ODBC form displayed all the bottom function and flexibility. RDO ODBC API is a shallow interfacing. Is designed to access remote data sources ODBC relations and design. Although the visit RDO Jet or ISAM database is restricted, but it can only work through the existing ODBC driver to access the relational database. However, the RDO has been proved to be many SQL Server, Oracle and other major database developers often choose the best interface. RDO provided to access storedprocedures and complex set of results more and more complex objects, attributes and methods.VBSQL : Visual Basic is structured query language. An API is the interface, almost C DB-Library API the same. VBSQL only support Microsoft's SQL Server. VBSQL fast and light but not for the target interface.3Performance Comparison and Application NoteVB-based SQL Server database system Several visits over the SQL Server specific features. DAOs is based on the object, so it is easy to use, However it from Visual Basic to SQL Server slowest way. ODBC API and VBSQL method is essentially based on the procedures. ODBC API method is common, allow the strongest interoperability, a simple programming, However, the slow pace in VBSQL methods. VBSQL VBSQL Control Methods, provided an important SQL Server front-end applications needed flexibility, strong functions and good performance. It is truly event-driven and error handling capability, fully supports asynchronous processing, and pointing out such calculations. These methods are VBSQL other methods beyond the edge, but its slightly complex programming. RDO ODBC API is located at the top of a layer object model, which rely on ODBC API, ODBC driver and the back-end database engine to achieve. RDO used in the procedures necessary for the short (about 250 KB), fast. RDO equipped with the basic approach of ODBC, most direct enforcement ODBC API function, RDO 4.0/VB included in the VB 5.0 Enterprise Edition, MSRDO32.DLL by Dynamic Link Library is to be achieved. RDO is a synthesis of DAO / Jet, VBSQL / DBLib ODBC and the advantages of the object model, ODBC API includes application layer, designed for in the background (server side) have a database exists on the premise of running, against Oracle and SQL Server specially designed. RDO has the advantage of being fully integrated in VB, can directly access SQL Server stored procedures fully supports T-SQL, T-SQL debugging in the integrated development environment, Visual Database Tools integration, and so on. However, Microsoft has announced that in future no longer be right VBSQL / DBLib upgrade, ODBC API function and general programming method is loved by the people, RDO application will be reduced gradually. As for the actual use of any interface, to a large extent dependent on the user's application specific circumstances. 4VB database principleVB access to the database, it is necessary to analyze specific issues, according to the specific circumstances, conditions, request with the appropriate programs, it should pay attention to the following principles :4.1code reuse and efficiency of the operationFor example : through the use of ODBC data sources connecting to the database, we will be able to transform the various types of databases, instead frequent code changes. VBSQL used by DB-Library will not do. ODBC interface and VB database is not running the most efficient method. Similarly, the use of ADO ODBC interface to the efficiency than RDO.4.2achieve simplicity, ease of maintenanceIf a method to achieve together is very complex, the development will inevitably result in the waste of human and material resources. Moreover, the design application will only support up more complex or more difficult to maintain. For example : local needs ISAM or visit Jet types of data sources, the use of DAO / Jet, and it is not necessary to use the method through ODBC. RDC together to achieve more easily than the RDO.4.3safety principlesThis should be an environment and conditions. For example, the LAN network security better in the WAN thus directly control the use of data such as RDC, This realization together fast and convenient, and WAN needs of a large number of errors caught, As the RDC is not as good as using the wrong RDO easy to control.5Concluding remarksThe data access interface DAO system suitable for single applications or small-scale use of the local distribution, RDO which has been proved to be many SQL Server, Oracle and other major database developers often choose the best interface. ADO DAO / RDO the successor product. ADO 2.0 functional and RDO more similar, but generally speaking, In this model between the two species have a similar relationship mapping. ADO "expansion" of the DAO and RDO by the use of the object model, which means that it contains fewer targets, more attributes, methods and parameters, and the incident.Database Interface is the latest ADO, it is more than DAO and RDO more simple, more flexible object model. For new projects, it should be used as ADO data access interface.However, the ADO is not automatic, and the existing data access application code compatible. When ADO Packaging DAO and RDO the function of the need to change many of the elements of language syntax ADO. In some cases, this will mean that some of the existing code of a function of a simple conversion. In other cases, the best approach might be the use of new functional ADO rewriting the application. Also notethat the current ADO DAO does not support all the functions. ADO include RDO style functionality, and to OLE DB data source interaction, It also includes long-range, and DHTML technologies.Generally speaking, in ADO 1984, Most immediately put DAO application ADO transplant may be premature ADO because the current data do not support the definition (DDL), users, groups. However, if only DAO for client / server applications, and is not dependent on the Jet database engine or not to use DDL, then it could be transplanted to ADO.VB与数据库1 VB访问数据库的方法VB访问数据库的方法很多,一般情况下分成两大类,而每一类又有很多方法。
communication method of computer and total-stationinstruments of data at VB environment [Summary]this text mainly inquiry in to carried out communication between computer and the total-station instrument data under VisualBasic6.0(call VB as follows) environments. Two kinds of communication methods: the usage mscomm control and the function of windows API. The application that also combined a solid example to carry out their string to go communication Procedure and step. Finally carried on comparison and summary to two kinds of methods.[Keyword]Visual Basic 6.0 data communication the mscomm controlAll of the electronics total-station instrument because its function is strong and operate convenience and consumedly raised an open country homework efficiency. Therefore it just and gradually replace traditional diagraph instrument and it is expanded for an application. Although making use of the system menu function of total-station instruments can immediately complete normal regulations diagraph, monitor in the big dam safety, side the ascent transform a monitor etc. this kind of data is a little bit greatly and need solid the applied situation of processing data, it is will not satisfy demands only by function and amount of memory of instrument. The data at this time can be output a computer by the instrumental data exportation port, and the data can be processed and saved by software. Along with the extensive usage of calculator, many local open country digatial measure diagram method also need to carry out real-time transport. VB is released by the Microsoft company of according to visual programming language, its adoption faces to the program design method that object, affairs drives and operate simple, therefore doubly be subjected to program design personnel's favor.Underneath with Leica Tc 2002 whole station instrument for example, introduce how to carry out the communication between computer and total-station in the VB 6. 0 environment by making use of mscomm and the function of Windows APIOne,usage MSComm control a piece VB 6.0provided an ActiveX to control Communication of a Microsoft Control, brief name MS Common controlled a piece, customer can at own of imbed MSComm to control a piece in the applied procedure, should control a piece to deliver and receive a data through a string of line port, for applied the procedure provide a string of line communication function. Choose VB 6.0"engineering" menus, open "parts" dialogbox, pick out Microsoft Comm Control 6.0, can immediately control the piece to the mscomm and add a box of controlling of person VB. The mscomm that may use controls the attribute of piece to have several followings:The CommPort: the constitution string go slogan;Settings: constitution string the line communication parameter;Portpopen: constitution or return to a string of communication appearance of;InputMode: the constitution put off to a later time blunt area to read numeral format;Input: from receive buffer area to read data;Output: Write a number toward the buffer area according to:In Buffer Size: receive the size of buffer area;Out Buffer Size: send out the size of buffer area;Out Buffer Count: send out the word stanza of buffer area number;Input Len: constitution or return to Input to read the word stanza of each time number;MS Comm controls the way that the piece provided two kinds of processings string communication: search method and affairs drive I/O method. Searching a way is direct and be easy to comprehension, but take up for a great deal of CPU time;The affairs drives a way from Windows 98 notice applied the procedure some affairs when take place, then according to the matter taken place The feeling comes to carries on an operation to the string. These two kinds of methods each beneficial fraud and oneself apply of realm, so in the different correspondence system, can according to the dissimilarity's requesting adoption different technique. In the middle of monitoring system, because of the contingency and request transmission data of affairs of solid sex, the calculator often adopts affairs to drive I/O method to carry on the spot monitor. It uses a step for:1, open the port that needs to carry on communication, accept for communication and send out a data brigade the row assign memory area.2, carry on a beginning to start to turn to the communication port, lead especially such as the wave, strange accidentally the school check, data, stop etc..3, carry on reading and writing an operation to the communication port.4, such as the be over string go communication, the close beats to rise of communication port.For example, control Leica with the calculator when the Tc2002 whole station instrument auto measure writing the following code can nicely carry out two of communication:The MS CommlCOmmPort=1'the constitution string go a communicationThe MS CommlSettings=''2400, e.7, IP1'constitution wave especially rate, strange accidentally check a school, data number and stop numberThe MS Comml InputLen=1'constitution or return to receive to use Input inside the buffer area an attribute to read the person's character list pieceThe MS Comml InbufferSize =4096'establish Buffer area sizeThe MS CommlPortOpen=True'open a communication portAttention:1, be the string that the procedure would automatically close to open while terminating line.2, if receiving buffer area is more big, the effective memory of procedure usage more small, whereas probably receive buffer area spillage, therefore should pass an experiment to enlarge its size gradually. According to the constitution like this, get up a calculator, the whole station instrument conjunction with an electric cable, can carry out the string of calculator and whole station instruments line communication.Two, make use of the function of Windows APIUnder the some condition, MSComm, control a piece isn't suitable for our requests. We can use Windows at this time API provides of communication function to carry out can transplant sex strong string of line of communication procedure with writing. Windows 98 correspondence the system provided the string of an improvement line application the procedure pick up a people API to use to carry on handing over type string with each other line correspondence. Among them, string the and other correspond by letter an equipments is a document to carry on the processed, open, close, reading of string and write in the function used similar to the function of the operation document.Before adjusting to use APIA function, have to the first essentials pronouncement change to measure and function.Dim dcb As DCBDim ofstructl As OFSTRUCTDim operport As LongOpen an API text to originally look into a machine in the V B wreath territory bottom, open Win32. Txt document, at"pronouncement"ing can the options win election in OpenFilc and Setup Cornm, Setup CommState and ReadFile, WriteFile, CIoscHand, le etc. function, in "type" can the options win election in DCB, OVERLAPPED etc. structure, in "constant" can the options win election in ODDPARITY, EVRXCHAR etc. often quantity, then choose a "replication", make duplicate them to the scrapbook, and glue to stick application procedure code in. Adjust to carry on a string of line communication with API in the VB 6.0 timeses: 1,adjust to use CreateFile line communication first carry on a beginning to start to turn to the string. CreateFile function for read an interview or write an interview to beatOpen a string of, return to that string of sentence handle after opening successfully, then adjust to use SetComm function is in a string of line allotmentbuffer area size, provide to read and write a string of usage, immediately after use DCB the structure change to measure a constitution to need to change the communication parameter of lacking the string line of saving the value, such as wave especially rate, strange accidentally the school check a , data, stop.2,adjust to use Write File, the Read File function carries on reading and writing an operation to the string line. Carry on a data to send out with Write File, for synchronous I/O operation, its last parameter can be NULL, but tread an I/O operation to the difference, its last parameter musts be a direction OVERLAPPED structure of point needle, make reading and writing of data the operation carry on in the backstage and pass this OVERLAPPED'structure to acquire current operation appearance. Use Read File receive buffer area to read from the string data, data before reading, use Clear Comm Error the function acquire word stanza within buffer area number.3, use Clothes Handle function close string line communicationThis method communication code is as follows:The Dim ComDev, Err, Errl, bWriteState, dwBytesRead,dwBytesRead As Long The ComDev = CreateFiles("COM 1", GENERIC-READ|GENERIC -WRITE, 0, NULL,OPEN -EXISTING, FILE -ATTRIBUTE NORMAL, NULL) open COM 1The if ComDev=-1 ThenMsgbox"can not open in a string of line":Exit SubErr= SetupComm(hComDev, 1024, 512), establish to place the size of receiving the buffer area and exportation buffer areaThe GetCommState(hComDev, &cb)'return the constitution circumstance of current string ofdcb .BaudRate=2400'the wave lead to 2400 bpses especiallydcb .f Parity=NOPARITY'have no strange accidentally the school checkDcb.ByteSize=7'data is 7dcb . StopBits=1'establish a stopErrl =SetCommStates'( hComDev, & dcb)DCB the contents within structure write to establish toward the stringDo EventsThe bWrite State= WriteFile(hComDev,1plnBuffer, 1, dwBytesRead, NULL)'send outResultRead File(hComDev, 1 pinBuffer, 1, dwBytesRead, NULIJ'read dataClose Handle(h Comdev)'close an equipments sentence handleThree, end languageIn the VB under 6.0 environments in two kinds of methods of development string line communication procedure, make use of API the function write a string ofcommunication procedure more complicated, need to have a certain plait distance experience, its advantage is to carry out function more abundant, application noodles more extensive, more complicated communication function. But MSComn: control a piece is packed by a series of Windows API function to gather but become, its usage door averted from to carry on to the complicated and low level function direct operation, provide standard affairs processing function, process, and carry on the constitution of communication parameter in a string of line in the way of attribute, can a little bit easily solution string z'Xun problem. Customer while being physically applying can according to the circumstance that review request and oneself, choose an appropriate method, develop a foolish good whole station of an effect the instrument and calculator carry on the procedure of data communication.VB环境下计算机与全站仪的数据通讯方法[摘要 ]本文主要探讨了在VisualBasic6 .0(以下简称VB)环境下实现计算机与全站仪数据通讯的两种方法:使用mscomm控件和windows API函数。