Reference Source
public class | source

SqlQuery

SQL query information from the server.

See:

Example:

var sql_query = KQ.Query.SqlQuery.getInstance();
console.log(sql_query);
try {
   var options = {
     url: 'http://172.16.1.157:8699/KQGis/rest/services/zy',
     sql: "select distinct " + "XZBM" + " from " + "$$" + 145 + "$$",
   };

   sql_query.queryAsync(options,
     function query_good () {
       console.log('query_good');

       var data = sql_query.data();
       console.log('sql query data.length:' + data.length);

       data.forEach(function (d) {
         console.log(d.properties);
       })
     },
     function query_error () {
       console.log('query_error');
     });
 }
catch (e) {
   console.log('catch error:' + e);
 }

Static Method Summary

Static Public Methods
public static

Get instance object(Singleton mode)

Method Summary

Public Methods
public

data(): Object[]

Get data

public

Get last error message

public

Whether server return error

public

queryAsync(options: Object, function_good: function(): null, function_error: function(): null): Promise<TResult>

SQL query information from the server.

Static Public Methods

public static getInstance(): SqlQuery source

Get instance object(Singleton mode)

Return:

SqlQuery

Public Methods

public data(): Object[] source

Get data

Return:

Object[]

public errorMsg(): String source

Get last error message

Return:

String

public isLastError(): Boolean source

Whether server return error

Return:

Boolean

public queryAsync(options: Object, function_good: function(): null, function_error: function(): null): Promise<TResult> source

SQL query information from the server.

Params:

NameTypeAttributeDescription
options Object

SQL query options

options.url String

Service url

options.startindex Number

Start index of result

options.reqcount Number

Upper limit of result

options.sql String

SQL statement

function_good function(): null

The function will run after querying successfully.

function_error function(): null

The function will run after querying unsuccessfully.

Return:

Promise<TResult>