|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DbInterface
Represents a connection to a (real or simulated) database.
Method Summary | |
---|---|
void |
commit()
Commit a pending transaction. |
void |
connect()
Connect to the database. |
void |
createIndex(Index index)
Create an index. |
void |
createTable(org.h2.test.synth.sql.Table table)
Create the specified table. |
org.h2.test.synth.sql.Result |
delete(org.h2.test.synth.sql.Table table,
java.lang.String condition)
Delete a number of rows. |
void |
disconnect()
Disconnect from the database. |
void |
dropIndex(Index index)
Drop an index. |
void |
dropTable(org.h2.test.synth.sql.Table table)
Drop the specified table. |
void |
end()
Close the connection and the database. |
org.h2.test.synth.sql.Result |
insert(org.h2.test.synth.sql.Table table,
org.h2.test.synth.sql.Column[] c,
Value[] v)
Insert a row into a table. |
void |
reset()
Drop all objects in the database. |
void |
rollback()
Roll back a pending transaction. |
org.h2.test.synth.sql.Result |
select(java.lang.String sql)
Execute a query. |
void |
setAutoCommit(boolean b)
Enable or disable autocommit. |
org.h2.test.synth.sql.Result |
update(org.h2.test.synth.sql.Table table,
org.h2.test.synth.sql.Column[] columns,
Value[] values,
java.lang.String condition)
Update the given table with the new values. |
Method Detail |
---|
void reset() throws java.sql.SQLException
java.sql.SQLException
void connect() throws java.lang.Exception
java.lang.Exception
void disconnect() throws java.sql.SQLException
java.sql.SQLException
void end() throws java.sql.SQLException
java.sql.SQLException
void createTable(org.h2.test.synth.sql.Table table) throws java.sql.SQLException
table
- the table to create
java.sql.SQLException
void dropTable(org.h2.test.synth.sql.Table table) throws java.sql.SQLException
table
- the table to drop
java.sql.SQLException
void createIndex(Index index) throws java.sql.SQLException
index
- the index to create
java.sql.SQLException
void dropIndex(Index index) throws java.sql.SQLException
index
- the index to drop
java.sql.SQLException
org.h2.test.synth.sql.Result insert(org.h2.test.synth.sql.Table table, org.h2.test.synth.sql.Column[] c, Value[] v) throws java.sql.SQLException
table
- the tablec
- the column listv
- the values
java.sql.SQLException
org.h2.test.synth.sql.Result select(java.lang.String sql) throws java.sql.SQLException
sql
- the SQL statement
java.sql.SQLException
org.h2.test.synth.sql.Result delete(org.h2.test.synth.sql.Table table, java.lang.String condition) throws java.sql.SQLException
table
- the tablecondition
- the condition
java.sql.SQLException
org.h2.test.synth.sql.Result update(org.h2.test.synth.sql.Table table, org.h2.test.synth.sql.Column[] columns, Value[] values, java.lang.String condition) throws java.sql.SQLException
table
- the tablecolumns
- the columns to updatevalues
- the new valuescondition
- the condition
java.sql.SQLException
void setAutoCommit(boolean b) throws java.sql.SQLException
b
- the new value
java.sql.SQLException
void commit() throws java.sql.SQLException
java.sql.SQLException
void rollback() throws java.sql.SQLException
java.sql.SQLException
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |