| org.apache.beehive.controls.system.jdbc.JdbcControl
All known Subclasses: org.apache.beehive.controls.system.jdbc.JdbcControlImpl, org.apache.beehive.controls.system.jdbc.DefaultJndiContextFactory,
JdbcControl | public interface JdbcControl (Code) | | Simplifies access to a relational database from your Java code using SQL commands.
The Jdbc Control handles the work of connecting to, sending queries to, and ResultSet mapping from
the database. You don't need to know how to use JDBC in order to use the Jdbc Control, just basic SQL.
To use a Jdbc Control create a .jcx file (java file with a .jcx extension) which extends this interface.
Add annotations to the jcx to tell the Jdbc Control how to connect to your database instance (either
ConnectionDataSource or ConnectionDriver), then add methods which include SQL annotations to access the database.
|
Inner Class :abstract public static class JndiContextFactory | |
Inner Class :public @interface ConnectionDataSource | |
Inner Class :public @interface ConnectionDriver | |
Inner Class :public @interface ConnectionOptions | |
Inner Class :public @interface TypeMapper | |
Inner Class :public interface UndefinedIteratorType | |
Inner Class :public interface UndefinedResultSetMapper | |
Inner Class :public enum ScrollType | |
Inner Class :public enum FetchDirection | |
Inner Class :public enum HoldabilityType | |
Inner Class :public @interface SQL | |
Inner Class :public static class SQLParameter | |
Inner Class :public static class ComplexSqlFragment | |
Field Summary | |
final public int | DEFAULT_FETCH_SIZE The default fetch size for result sets, indicates the database should determine the fetch size. | final public int | MAXROWS_ALL This constant can be used as the value for the maxRows element of the SQL annotation.
It indicates that all rows should be returned (i.e. |
DEFAULT_FETCH_SIZE | final public int DEFAULT_FETCH_SIZE(Code) | | The default fetch size for result sets, indicates the database should determine the fetch size.
|
MAXROWS_ALL | final public int MAXROWS_ALL(Code) | | This constant can be used as the value for the maxRows element of the SQL annotation.
It indicates that all rows should be returned (i.e. no limit)
|
getConnection | public Connection getConnection() throws SQLException(Code) | | Returns a database connection to the server associated
with the control. It is typically not necessary to call this method
when using the control.
A Connection a database. |
getDataSourceCalendar | public Calendar getDataSourceCalendar()(Code) | | Gets the Calendar instance used when setting and getting
java.sql.Date Date ,
java.sql.Time Time , and
java.sql.Timestamp Timestamp values. This is the Calendar
set by the setDataSourceCalendar method.
The Calendar instance. |
setDataSourceCalendar | public void setDataSourceCalendar(Calendar cal)(Code) | | Sets the Calendar instance that should be used when setting and getting
java.sql.Date Date ,
java.sql.Time Time , and
java.sql.Timestamp Timestamp values.
See Also: java.sql.ResultSet.getDate(intCalendar) See Also: java.sql.ResultSet#getDate(int, Calendar) See Also: java.sql.ResultSet.getTime(intCalendar) See Also: java.sql.ResultSet#getTime(int, Calendar) See Also: java.sql.ResultSet.getTimestamp(intCalendar) See Also: java.sql.ResultSet#getTimestamp(int, Calendar) See Also: java.sql.PreparedStatement.setDate(intjava.sql.DateCalendar) See Also: java.sql.PreparedStatement#setDate(int, Date, Calendar) See Also: java.sql.PreparedStatement.setTime(intjava.sql.TimeCalendar) See Also: java.sql.PreparedStatement#setTime(int, Time, Calendar) See Also: java.sql.PreparedStatement.setTimestamp(intjava.sql.TimestampCalendar) See Also: java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar) |
|
|