Reference Source
public class | source

SqlQuery

从服务器中进行SQL查询

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

获取实例对象 (单例模式)

Method Summary

Public Methods
public

data(): Object[]

获取数据

public

获取最后的错误信息

public

服务器是否返回了错误

public

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

从服务器中进行SQL查询

Static Public Methods

public static getInstance(): SqlQuery source

获取实例对象 (单例模式)

Return:

SqlQuery

Public Methods

public data(): Object[] source

获取数据

Return:

Object[]

public errorMsg(): String source

获取最后的错误信息

Return:

String

public isLastError(): Boolean source

服务器是否返回了错误

Return:

Boolean

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

从服务器中进行SQL查询

Params:

NameTypeAttributeDescription
options Object

SQL查询的配置参数

options.url String

服务器的url地址

options.startindex Number

请求返回结果的起始索引

options.reqcount Number

请求返回结果的最大记录数

options.sql String

进行查询的SQL语句

function_good function(): null

查询成功后执行的函数

function_error function(): null

查询失败后执行的函数

Return:

Promise<TResult>