Statement

class Statement {

this(SqlConnection db, DatabaseOption options);

this(SqlConnection db, string sql, DatabaseOption options);

void prepare(string sql);

void setParameter(string key, R param);

int execute();

int execute(string lastIdName);

int lastInsertId();

int affectedRows();

RowSet query();

}

Constructors

this this(SqlConnection db, DatabaseOption options): Undocumented in source.
this this(SqlConnection db, string sql, DatabaseOption options): Undocumented in source.

Members

Functions

affectedRows int affectedRows(): Undocumented in source. Be warned that the author may not have intended to support it.
count int count(): Undocumented in source. Be warned that the author may not have intended to support it.
execute int execute(): Undocumented in source. Be warned that the author may not have intended to support it.
execute int execute(string lastIdName): Undocumented in source. Be warned that the author may not have intended to support it.
fetch Row fetch(): Undocumented in source. Be warned that the author may not have intended to support it.
lastInsertId int lastInsertId(): Undocumented in source. Be warned that the author may not have intended to support it.
prepare void prepare(string sql): Undocumented in source. Be warned that the author may not have intended to support it.
query RowSet query(): Undocumented in source. Be warned that the author may not have intended to support it.
setParameter void setParameter(string key, R param): Undocumented in source. Be warned that the author may not have intended to support it.

See Also

https://www.codemeright.com/blog/post/named-parameterized-query-java

https://www.javaworld.com/article/2077706/named-parameters-for-preparedstatement.html

https://github.com/marcosemiao/jdbc-named-parameters/tree/master/src/main/java/fr/ms/sql

Meta

Source

See Implementation

hunt database Statement classes

Statement