A query for full-text retrieval of the contents of a file by MSSQL

Delphi has a strong development capability, and the development speed is fast. NEWXY is a database-centric Java Web development tool that now compares the development speed and development capabilities of both.

For the sake of comparability, make some conventions:

1. Only comparison of the use of database development;

2. Both need to be prepared for database connections, and are not compared in this regard;

3.delphi drag components from the component template, design JSP page can use tools to drag tags, or manually add tags, the appearance of the interface to form a speed without comparison;

4. Compare the processing capacity and processing speed of the data only.

One, display a recordset data:

Deiphi write SQL name for query, select the fields to display, drag the DBGrid component to the appropriate length, select the Ammonium button for the Dbnavigator component, and if there is a picture field,

adding Dbimage components;

Newxy in

<nbean:formBean/>

tag to assign the SQL value in the

<td></td>内用<bean:write />

The label determines which field is displayed,

In

<nlogic:navigate/>

The length value in the label determines the size of each page, the front page, the back page, the first page of the Ammonium button, and the

<nhtml:buttos/>The selection of the label to add, delete, update and other ammonium button,

If you have a picture field, join

Label.

The two are evenly matched.

Second, display the main deputy table:

The speed is the same as "one" in the display of the primary table. The methods for displaying the secondary tables are as follows:

Delphi prepares the secondary table as it prepares the main table, connecting the main and secondary tables through the component's Masterfields attribute;

Newxy as well as preparing a secondary table like a primary table, the connection method between the primary and secondary tables is different, newxy is like this:

Add a Label

, the key value is assigned to the data that gets the secondary table.

Sql

Properties, such as

"SELECT * from secondtable where secondkey= ' ${key} '/>

Both are easy.

Third, the data increase, delete, update operation

Delphi can be dbnavigator,newxy available.

The efficiency of the two is the same.