Home
last modified time | relevance | path

Searched refs:statement (Results 1 – 25 of 222) sorted by relevance

123456789

/trunk/main/connectivity/java/sdbc_postgresql/src/com/sun/star/sdbcx/comp/postgresql/
H A DPostgresqlViews.java75 XPreparedStatement statement = null; in createObject() local
88 results = statement.executeQuery(); in createObject()
98 CompHelper.disposeComponent(statement); in createObject()
119 XStatement statement = null; in dropObject() local
127 statement = metadata.getConnection().createStatement(); in dropObject()
128 statement.execute(sql); in dropObject()
132 CompHelper.disposeComponent(statement); in dropObject()
143 XStatement statement = null; in appendObject() local
148 statement = metadata.getConnection().createStatement(); in appendObject()
149 statement.execute(sql); in appendObject()
[all …]
H A DPostgresqlTables.java111 XStatement statement = null; in dropObject() local
113 statement = metadata.getConnection().createStatement(); in dropObject()
114 statement.execute(sql); in dropObject()
116 CompHelper.disposeComponent(statement); in dropObject()
140 XStatement statement = null; in createTable() local
143 statement = metadata.getConnection().createStatement(); in createTable()
144 statement.execute(sql); in createTable()
146 CompHelper.disposeComponent(statement); in createTable()
/trunk/main/offapi/com/sun/star/sdbc/
H A DXStatement.idl49 different Statements. All statement
52 close a statement's current ResultSet if an open one exists.
58 /** executes a SQL statement that returns a single ResultSet.
60 the SQL statement which should be executed
69 /** executes an SQL INSERT, UPDATE, or DELETE statement. In addition,
74 a SQL INSERT, UPDATE or DELETE statement or a SQL statement that returns nothing
83 /** executes a SQL statement that may return multiple results.
87 Under some (uncommon) situations a single SQL statement may return
97 method executes a SQL statement and indicates
108 any SQL statement
[all …]
H A DXConnection.idl77 executed using Statement objects. If the same SQL statement
104 A SQL statement with or without IN parameters can be
106 object can then be used to efficiently execute this statement
120 the statement to the database for precompilation. Some drivers
121 may not support precompilation. In this case, the statement may
161 statement to the database when the method
185 native form of the statement that the driver would have sent.
190 the native form of this statement
213 The commit occurs when the statement completes or the next
215 statements returning a ResultSet, the statement completes when
[all …]
H A DPreparedStatement.idl49 /** represents a precompiled SQL statement.
51 A SQL statement is pre-compiled and stored in a PreparedStatement object.
52 This object can then be used to efficiently execute this statement multiple
90 different Statements. All statement
92 methods implicitly close a statement's current ResultSet if an open one exists.
104 /** freeing all resources of a statement. A related resultset will be
113 the DBMS and the driver support aborting an SQL statement.
130 statement.
204 identify the current row in the ResultSet generated by this statement. If
207 updates, the cursor's SELECT statement should be of the form
H A DStatement.idl47 /** is used for executing a static SQL statement and obtaining the results
54 different Statements. All statement <code>execute</code> methods implicitly
55 close a statement's current ResultSet if an open one exists.
67 /** freeing all resources of a statement. A related resultset will be
76 the DBMS and the driver support aborting an SQL statement.
158 identify the current row in the ResultSet generated by this statement. If
161 updates, the cursor's SELECT statement should be of the form
H A DXPreparedStatement.idl40 /** provides the possibility of executing a precompiled SQL statement.
44 A SQL statement is pre-compiled and stored in a PreparedStatement object.
45 This object can then be used to efficiently execute this statement multiple
63 /** executes the SQL INSERT, UPDATE or DELETE statement in this
77 /** executes any kind of SQL statement.
/trunk/main/offapi/com/sun/star/sdb/
H A DXSingleSelectQueryAnalyzer.idl67 the single select statement to set
70 or the statement isn't a single select statement
71 or the statement isn't valid
72 or the statement can not be parsed.
190 the query in the <code>FROM</code> part of a <code>SELECT</code> statement will be handled
195 This query is not known to the underlying database, so an SQL statement like
226 means in case the <member>Command</member> specifies an SQL statement, the inherited
229 It then can be to used to specify whether the SQL statement should be analyzed on the
242 or the statement isn't a single select statement
243 or the statement isn't valid
[all …]
H A DXSingleSelectQueryComposer.idl68 or the statement isn't valid
69 or the statement isn't parseable.
117 or the statement isn't valid
118 or the statement isn't parseable..
126 statement. The column must be a <type scope="com::sun::star::sdbcx">Column</type>.
144 or the statement isn't valid
145 or the statement isn't parseable.
193 or the statement isn't parseable.
201 statement. The column must be a <type scope="com::sun::star::sdbcx">Column</type>.
219 <p>An elementary query or statement is a (single select) statement whose parts are
[all …]
H A DSingleSelectQueryComposer.idl36 /** represents a service for composing a single select statement.
39 It hides the complexity of parsing and evaluating a single select statement and provides
40 sophisticated methods for expanding a statement with filter, group by, having and order
41 …criteria. To get the new extended statement use the methods from <type scope="com::sun::star::sdb"…
58 …/** is the orignal SQL statement set with the interface <type scope="com::sun::star::sdb">XSingleS…
H A DSingleSelectQueryAnalyzer.idl38 /** represents a service for analyzing a single select statement.
41 It hides the complexity of parsing and evaluating a single select statement and provides
56 of a <code>SELECT</code> statement.</p>
60 … a query named <code>All Orders</code>, the SQL statement <code>SELECT * FROM "All Orders"</code>
65 this object still acts as a table in the SQL statement.</p>
/trunk/main/connectivity/java/sdbc_jdbc/src/com/sun/star/comp/sdbc/
H A DJavaSQLConnection.java92 JavaSQLStatementBase statement = (JavaSQLStatementBase) it.next(); in postDisposing() local
94 CompHelper.disposeComponent(statement); in postDisposing()
180 JavaSQLStatement statement = new JavaSQLStatement(this); in createStatement() local
181 statements.put(statement, statement); in createStatement()
183 return statement; in createStatement()
276 JavaSQLCallableStatement statement = new JavaSQLCallableStatement(this, sqlStatement); in prepareCall() local
277 statements.put(statement, statement); in prepareCall()
279 return statement; in prepareCall()
287 JavaSQLPreparedStatement statement = new JavaSQLPreparedStatement(this, sqlStatement); in prepareStatement() local
288 statements.put(statement, statement); in prepareStatement()
[all …]
/trunk/main/connectivity/java/dbtools/src/org/apache/openoffice/comp/sdbc/dbtools/util/
H A DAutoRetrievingBase.java52 String statement = ""; in getTransformedGeneratedStatement() local
54 statement = autoRetrievingStatement; in getTransformedGeneratedStatement()
57 index = statement.indexOf("$column"); in getTransformedGeneratedStatement()
63 index = statement.indexOf("$table"); in getTransformedGeneratedStatement()
87 … statement = statement.substring(0, index) + tableName + statement.substring(index + 6); in getTransformedGeneratedStatement()
90 return statement; in getTransformedGeneratedStatement()
/trunk/main/connectivity/source/resource/
H A Dconn_log_res.src42 Text = "c$1$: creating statement";
47 Text = "c$1$: created statement, statement id: s$2$";
52 Text = "c$1$: preparing statement: $2$";
57 Text = "c$1$: prepared statement, statement id: s$2$";
67 Text = "c$1$: prepared call, statement id: s$2$";
112 Text = "s$1$: getGeneratedValues: falling back to statement: $2$";
127 Text = "s$1$: closing/disposing statement";
167 Text = "s$1$: executing previously prepared statement";
172 Text = "s$1$: executing previously prepared update statement";
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/mod/_dbaccess/
H A DTableWindowAccessibility.java193 XStatement statement = null; in createTestEnvironment() local
202 statement = connection.createStatement(); in createTestEnvironment()
203 statement.executeUpdate("drop table if exists " + tbl_name1); in createTestEnvironment()
204 statement.executeUpdate("drop table if exists " + tbl_name2); in createTestEnvironment()
205 statement.executeUpdate("create table " + tbl_name1 + " (" + in createTestEnvironment()
207 statement.executeUpdate("create table " + tbl_name2 + " (" + in createTestEnvironment()
214 statement = connection.createStatement(); in createTestEnvironment()
215 statement.executeUpdate("drop table if exists " + tbl_name1); in createTestEnvironment()
216 statement.executeUpdate("drop table if exists " + tbl_name2); in createTestEnvironment()
217 statement.executeUpdate("create table " + tbl_name1 + " (" + in createTestEnvironment()
[all …]
H A DJoinViewAccessibility.java204 XStatement statement = null; in createTestEnvironment() local
214 statement = connection.createStatement (); in createTestEnvironment()
215 statement.executeUpdate ("drop table if exists " + tbl_name1); in createTestEnvironment()
216 statement.executeUpdate ("drop table if exists " + tbl_name2); in createTestEnvironment()
217 statement.executeUpdate ("create table " + tbl_name1 + " (" + in createTestEnvironment()
219 statement.executeUpdate ("create table " + tbl_name2 + " (" + in createTestEnvironment()
228 statement = connection.createStatement (); in createTestEnvironment()
229 statement.executeUpdate ("drop table if exists " + tbl_name1); in createTestEnvironment()
230 statement.executeUpdate ("drop table if exists " + tbl_name2); in createTestEnvironment()
231 statement.executeUpdate ("create table " + tbl_name1 + " (" + in createTestEnvironment()
[all …]
H A DConnectionLineAccessibility.java212 XStatement statement = null; in createTestEnvironment() local
222 statement = connection.createStatement(); in createTestEnvironment()
223 statement.executeUpdate("drop table if exists " + tbl_name1); in createTestEnvironment()
224 statement.executeUpdate("drop table if exists " + tbl_name2); in createTestEnvironment()
225 statement.executeUpdate("create table " + tbl_name1 + " (" + in createTestEnvironment()
227 statement.executeUpdate("create table " + tbl_name2 + " (" + in createTestEnvironment()
237 statement = connection.createStatement(); in createTestEnvironment()
238 statement.executeUpdate("drop table if exists " + tbl_name1); in createTestEnvironment()
239 statement.executeUpdate("drop table if exists " + tbl_name2); in createTestEnvironment()
240 statement.executeUpdate("create table " + tbl_name1 + " (" + in createTestEnvironment()
[all …]
/trunk/main/connectivity/java/dbtools/src/org/apache/openoffice/comp/sdbc/dbtools/sdbcx/
H A DOColumnContainer.java143 XStatement statement = null; in appendObject() local
145 statement = table.getConnection().createStatement(); in appendObject()
146 statement.execute(sql); in appendObject()
148 CompHelper.disposeComponent(statement); in appendObject()
163 XStatement statement = null; in dropObject() local
165 statement = table.getConnection().createStatement(); in dropObject()
166 statement.execute(sql); in dropObject()
168 CompHelper.disposeComponent(statement); in dropObject()
H A DOIndexContainer.java167 XStatement statement = null; in appendObject() local
169 statement = connection.createStatement(); in appendObject()
170 statement.execute(sql); in appendObject()
172 CompHelper.disposeComponent(statement); in appendObject()
197 XStatement statement = null; in dropObject() local
199 statement = connection.createStatement(); in dropObject()
200 statement.execute(sql); in dropObject()
202 CompHelper.disposeComponent(statement); in dropObject()
H A DOKeyContainer.java162 XStatement statement = null; in appendObject() local
164 statement = connection.createStatement(); in appendObject()
165 statement.execute(sql); in appendObject()
167 CompHelper.disposeComponent(statement); in appendObject()
255 XStatement statement = null; in dropObject() local
257 statement = connection.createStatement(); in dropObject()
258 statement.execute(sql); in dropObject()
260 CompHelper.disposeComponent(statement); in dropObject()
/trunk/main/connectivity/qa/connectivity/tools/sdb/
H A DConnection.java61 XStatement statement = createStatement(); in execute() local
62 return statement.execute( _sql ); in execute()
67 XStatement statement = createStatement(); in executeQuery() local
68 return statement.executeQuery( _sql ); in executeQuery()
73 XStatement statement = createStatement(); in executeUpdate() local
74 return statement.executeUpdate( _sql ); in executeUpdate()
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/util/
H A DDBTools.java700 Statement statement = connection.createStatement(); in initTestTableUsingJDBC() local
703 dropMySQLTable(statement, tbl_name); in initTestTableUsingJDBC()
706 createMySQLTable(statement, tbl_name); in initTestTableUsingJDBC()
709 insertContentMySQLTable(statement, tbl_name); in initTestTableUsingJDBC()
719 protected void insertContentMySQLTable(Statement statement, String tbl_name) in insertContentMySQLTable() argument
753 statement.executeUpdate(query); in insertContentMySQLTable()
767 protected void createMySQLTable(Statement statement, String tbl_name) in createMySQLTable() argument
806 statement.execute(query); in createMySQLTable()
815 protected void dropMySQLTable(Statement statement, String tbl_name) in dropMySQLTable() argument
817 statement.executeUpdate("drop table if exists " + tbl_name); in dropMySQLTable()
/trunk/main/offapi/com/sun/star/rdf/
H A DStatement.idl37 /** represents a RDF statement, or triple.
45 /// the subject of the RDF statement.
47 /// the predicate of the RDF statement.
49 /// the object of the RDF statement.
51 /// the named graph that contains this statement, or <NULL/>.
/trunk/main/forms/qa/integration/forms/
H A DListBox.java211 XPreparedStatement statement = connection.prepareStatement( sql.toString() ); in impl_createDatabase() local
212 … XParameters statementParameters = UnoRuntime.queryInterface( XParameters.class, statement ); in impl_createDatabase()
220 statement.execute(); in impl_createDatabase()
236 … XPreparedStatement statement = connection.prepareStatement( foreignKeyInsertSQL.toString() ); in impl_createDatabase() local
237 … XParameters statementParameters = UnoRuntime.queryInterface( XParameters.class, statement ); in impl_createDatabase()
245 statement.execute(); in impl_createDatabase()
/trunk/main/reportbuilder/java/com/sun/star/report/
H A DSDBCReportDataFactory.java545 String statement = command; in fillOrderStatement() local
549 statement = composer.getQuery(); in fillOrderStatement()
550 composer.setQuery(statement); in fillOrderStatement()
557 statement = composer.getQuery(); in fillOrderStatement()
572 statement = "SELECT * FROM (" + queryCommand + ")"; in fillOrderStatement()
578 statement = "SELECT * FROM (" + command + ")"; in fillOrderStatement()
581 rowSetProp.setPropertyValue(UNO_COMMAND, statement); in fillOrderStatement()

Completed in 105 milliseconds

123456789