statement.columns()
-
返回:<Array> 对象数组。每个对象对应于准备好的语句中的一列,并包含以下属性:
¥Returns: <Array> An array of objects. Each object corresponds to a column in the prepared statement, and contains the following properties:
-
column
:<string> | <null> 原始表中列的未别名,如果该列是表达式或子查询的结果,则为null
。此属性是sqlite3_column_origin_name()
的结果。¥
column
: <string> | <null> The unaliased name of the column in the origin table, ornull
if the column is the result of an expression or subquery. This property is the result ofsqlite3_column_origin_name()
. -
database
:<string> | <null> 原始数据库的未别名,如果该列是表达式或子查询的结果,则为null
。此属性是sqlite3_column_database_name()
的结果。¥
database
: <string> | <null> The unaliased name of the origin database, ornull
if the column is the result of an expression or subquery. This property is the result ofsqlite3_column_database_name()
. -
name
:<string> 分配给SELECT
语句结果集中的列的名称。此属性是sqlite3_column_name()
的结果。¥
name
: <string> The name assigned to the column in the result set of aSELECT
statement. This property is the result ofsqlite3_column_name()
. -
table
:<string> | <null> 原始表的未别名,如果该列是表达式或子查询的结果,则为null
。此属性是sqlite3_column_table_name()
的结果。¥
table
: <string> | <null> The unaliased name of the origin table, ornull
if the column is the result of an expression or subquery. This property is the result ofsqlite3_column_table_name()
. -
type
:<string> | <null> 列的声明数据类型,如果列是表达式或子查询的结果,则为null
。此属性是sqlite3_column_decltype()
的结果。¥
type
: <string> | <null> The declared data type of the column, ornull
if the column is the result of an expression or subquery. This property is the result ofsqlite3_column_decltype()
.
-
此方法用于检索有关准备好的语句返回的列的信息。
¥This method is used to retrieve information about the columns returned by the prepared statement.