|
||||||||
| 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 | |||||||