(seit Version 0.0.1)
executeQuery -- Executes a SQL-Statement, and returns (depending on the Type
of SQL-Statement) a ResultSet Object or an int
ResultSet/int executeQuery (string sqlQueryString)
Executes a SQL-Statement on the Database.
Not all Keywords and Statements of the SQL Standard are supported (See the SQL
Syntax Page of this Manual)
Dont forget to escape " with a \ (See Escape Page of this Manual)
sqlQueryString |
Sql Statement String (example:"SELECT nr, name FROM person WHERE person.name=\"HANS\";") |
SELECT Satements:
- A ResultSet Object, containing the Data returned by the Query
- In case of an Error NULL or FALSE is returned.
UPDATE/INSERT/DELETE Statements:
- The Number of Rows changed is returned as int
- In case of an Error FALSE is returned.
CREATE TABLE Statements:
- If ok: TRUE
- In case of an Error FALSE is returned.