[Comparison of current popular database program development tools "Procedure Development Series
Wuhan Huazhongshi Dafu Department Xie Gang
Summary: With the continuous development of computer technology, various database programming tools also make today's most program developers can get rid of boring and tasteless computer instructions or assembly language development software, but use a series of efficient, good Visual programming tools to develop a variety of database software, thereby achieving the effect of halving, but now there are many database programming tools on the market, excellent, such as VB, VC, Dephi, PB, etc., I am specially designed for popular development. Language introduces the corresponding relatively mature database programming tools. Keywords: Database Programming Program Development Tool 1 Database Development Tool Introduction 1.1 VB full name Visual Basic, is a visual programming tool in Basic language as its basic language. In China and even the whole world have seen its figure, it was the most popular programming tool in China, and it still has a very important status now. It has a certain understanding for it, VB as a The earlier development procedures have affected several generations of programming staff with its easy learning, high development efficiency, and perfect help system, etc. have affected several generation programmers, but because VB does not have cross-platform characteristics, VB is also determined in the future. The software development will gradually exit its historical stage; it supports the support of component technology based on COM and ActiveX, today's continuous development today, it also shows its backwardness; at the same time VB is under construction It is also relatively complicated, calling the API function to declare, call is inconvenient, can not perform DDK programming, it is impossible to go deep into Ring0 programming, can not be nested; and the object-oriented characteristics are poor; network function and database function is not very specifically The performance, in summary, VB acts as a visualized development tool, due to its own limitations, resulting in gradually replaced by other tools in future software development. 1.2 PB full name PowerBuilder is the first choice for developing MIS systems and various database sides of the platform, easy to learn, easy to master, and have a fairly excellent performance in code execution efficiency. PB is a true 4GL language (fourth generation language), can directly nested the SQL statement return value in variables to statements, support statement cursors, stored procedures, and database functions, is a specification similar to SQLJ. And unparalleled flexibility in data access. However, it has made the same mistake as VB in the underlying development of the system, and the API function needs to be declared. It is inconvenient to call. It is not possible to perform DDK programming. It is impossible to go deep into Ring0 programming, can not be embedded; more dynamic in network development; Generate user objects and services and system objects, which is ideal for writing server dynamic web applications, which is conducive to business logic packages; but is used for network communication; static page customization support limited, make PB applications in network applications It is not very wide. Object-oriented is not too good. 1.3 C Builder / Delphi They are based on VCL library visual development tools, which have considerable performance in all aspects of component technology, database support, system underlying development support, network development support, object-oriented characteristics, etc. And learning is relatively easy to use, fully cash the visualization development method obtained, and the development efficiency is high. Since both are Borland's products, naturally inherit the company's consistent good tradition: the code execution efficiency is high. However, they are not disadvantages, and the biggest shortcomings they do is that their help system belongs to a relatively poor programming tool.
The C Builder VCL library is based on Object Pascal, making C Builder on the program's debugging execution of other programming tools. Delphi is its language is not wide enough, and the development system software is not enough to have two relatively large shortcomings. 1.4 Visual C is a visualized development tool based on the MFC library, which is generally said to be a tool for powerful but inconvenient use. It has a good performance in network development and multimedia development, helping the system is also very good (Microsoft's treatment often makes people feel kind, but although using C as the basic language, it is object-oriented The characteristics are not good, mainly for compatibility with C's procedures, the results are absent; not very good in component support, although in addition to supporting COM, ActiveX support CORBA, but there is no IDE support, all C compilers Function, requires CORBA middleware support; the biggest problem is that development efficiency is not high. 1.5 Java Programming Tools are currently famous for Borland's JBuilder and IBM's Visual Age for Java, both of which have a number of people. JBuilder inherited the characteristics of C Builder / Delphi, which was very good at visualization and easy to use. Due to the characteristics of the Java itself, they have high performance in network development, but also high-oriented features, supported components technology, cross-platform characteristics, make it increasingly important in the development of the present and future. Status. However, it is not so satisfied in the system underlying development and multimedia development, which may be related to design Java's intentions.
2 Various development tools in support comparison analysis of databases 2.1 Data Access Objects: 2.1.1vb: DAO, ADO, RDO functionality; 2.1.2pb: Transaction, dwcontrol, can bind any SQL statement and stored procedure, data access With unpredictable flexibility 2.1.3 C Builder / Dephi: More than 20 components and classes, including DataSource, Table, Query, Midas, ADO, and Class completion data access 2.4 VC: same VB, but no Less-class libraries are available, but it is extremely inconvenient, and the development efficiency is very low. 2.1.5 Java: Java JDBC API, Different IDEs have different components 2.2 Data performance objects: 2.2.1 VB: DBGRID, related to database data performance There is only one of the controls that can only express simple table data, and the representation means single 2.2.2 Pb: DataWindow object (powerful is powerful, its resource description statement constitutes another language similar to HTML, which can be inserted into any object, including including Hundreds of data expressions in DBGRID), only this feature destined that PB's functionality from the database from birth, far exceeds some development tools today 2.2.3 C Builder / Decision: 6 data warehouse components including DBGRID, DBNAVigator, DbEdit, DBlookUplistbox, 6 data warehouse components, including QRCHART, QREXPR, including QRCHART, QREXPR, can be flexible to express data 2.2.4 VC: Tong data access object 2.2.5 Java: Different IDEs have different components, compare JBuilder, Powerj, Visualage for Java 2.3 statement execution mode: 2.3.1 VB: Bind a SQL string to In a command object, the result is returned to the RESULTSET object self-evacuation 2.3.2 PB: is a real 4GL language, can directly nested the SQL statement return value in the variable of the statement, support statement cursors, storage Procedures and database functions are a specification similar to SQLJ 2.3.3 C Builder / DEPHI: Use database components or classes to complete the execution and submission of SQL statement strings 2.3.4 VC: Tong Data Access Object 2.3.5 Java: SQLJ, Java JDBC API 3 Other Comparison Analysis of various development tools 3.1 Object-oriented characteristics VB: Poor; PB: Good; C Builder / Dephi: Very good; VC: General; Java: Very good 3.2 Cross-platform feature VB: Cross-platform is not good, but can be seamlessly connected to the Windows family.
PB: Cross-platform general C Builder / Dephi: Windows family, Linux VC: No Java: All Operating Systems that can run Java Virtual machines 3.3 Component Technical Support VB: COM, ActiveX PB: COM, Javabean, Jaguar, UserObject Used: CORBA ACTI VEX COM, ActiveX CORBA (itself comes with Corba Middleware Visibroker, rich wizard) VC: COM, ActiveX, CORBA (no IDE support, is the function of all C compiler, need CORBA middleware Support) Java: JavaBean, CORBA; ActiveX 3.4 network or web development support VB: ASP, VBScript, has simple IDE written by DHTML, is very convenient to write static pages; support for network communication general PB: DYNASRIPT, Web.PB; More dynamically generated user objects and services and system objects, which is ideal for writing service dynamic web applications, which is conducive to business logic packages; useful for network communication; static page customized support limited C Builder / Dephi: ISAPI, Wininet API and other networks or Internet APIs are free and convenient to call; providing more than 30 components and classes such as Serversocket, ClientSocket to handle network communication control, stream processing, Mail, Email, FTP, HTTP, etc. Application protocol handling and generating dynamic pages and business logic packages; powerful, easy to use VC: SAPI, Wininet API, etc., etc., free and convenient calls; provide CasyncSocket and more, etc.; Not easy to easily call API but have a large network and Internet feature; you can use the servlet API, Java Bean API, and JSP, a strong web application, powerful, powerful, not very convenient for some IDE 4 Comprehensive evaluation: 4.1 VB: is the first choice for newcomer development and system-independent integrated applications; it is easy to use and strong financial resources are only two advantages. VB development efficiency is high, code execution efficiency is general, but the entry and learning speed is fast, there is a good learning atmosphere and help books and help documents. But with Microsoft's promotion, VB will gradually introduce historical stations. PB: It is the first choice for developing large MIS and various types of database-sized platform applications; Multimedia and network functions are relatively weak to other tools. 4.2 The biggest advantage of PB is the maturity and convenience of DataWindow technology, and he has become a capital of PB and other database development tools. At the same time, PB can also foreseeable PB will continue to become the preferred choice for database systems (especially MIS systems) development tools. At the same time, the powerful help documentation of PB also provides beginners to introduce the entry foundation. The freedom and aspects of the PB connection database are also convenient for PB, and the PB is the call to the API, and the processing of the report is powerful. However, the lack of advanced programming books of PB and the penetration of PowerScript have a certain limit on PB tomorrow.
