|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectnet.sf.borg.model.db.jdbc.JdbcDB
net.sf.borg.model.db.jdbc.JdbcBeanDB<Appointment>
net.sf.borg.model.db.jdbc.ApptJdbcDB
public class ApptJdbcDB
this is the JDBC layer for access to the appointment table.
Field Summary |
---|
Fields inherited from class net.sf.borg.model.db.jdbc.JdbcDB |
---|
connection_ |
Constructor Summary | |
---|---|
ApptJdbcDB()
Creates a new instance of AppJdbcDB. |
Method Summary | |
---|---|
void |
addObj(Appointment appt)
Adds a KeyedEntity to the database |
(package private) Appointment |
createFrom(ResultSet r)
Fills in an entity from a result set |
void |
delete(int key)
Delete a KeyedEntity from the database |
Collection<Integer> |
getKeys()
Gets the keys. |
(package private) PreparedStatement |
getPSAll()
|
(package private) PreparedStatement |
getPSOne(int key)
|
Collection<Integer> |
getRepeatKeys()
Gets the keys of all Appointments that are marked as repeating |
Collection<Integer> |
getTodoKeys()
Gets the keys of all Appointments that are marked as Todo's. |
Appointment |
newObj()
Return a new instance of the KeyedEntity |
int |
nextkey()
get the next available key value for this entity type |
void |
updateObj(Appointment appt)
Update a KeyedEntity in the database |
Methods inherited from class net.sf.borg.model.db.jdbc.JdbcBeanDB |
---|
delCache, emptyCache, readAll, readCache, readObj, sync, writeCache |
Methods inherited from class net.sf.borg.model.db.jdbc.JdbcDB |
---|
beginTransaction, buildDbDir, close, commitTransaction, connect, execSQL, getConnection, getOption, getOptions, getUrl, rollbackTransaction, setOption, toInt, toInt, toStr, toVect |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface net.sf.borg.model.db.EntityDB |
---|
readAll, readObj, sync |
Constructor Detail |
---|
public ApptJdbcDB()
Method Detail |
---|
public void addObj(Appointment appt) throws Exception
EntityDB
addObj
in interface EntityDB<Appointment>
appt
- the KeyedEntity
Exception
public void delete(int key) throws Exception
EntityDB
delete
in interface EntityDB<Appointment>
key
- the key of the entity
Exception
public Collection<Integer> getKeys() throws Exception
Exception
- the exceptionpublic Collection<Integer> getTodoKeys() throws Exception
AppointmentDB
getTodoKeys
in interface AppointmentDB
Exception
- the exceptionpublic Collection<Integer> getRepeatKeys() throws Exception
AppointmentDB
getRepeatKeys
in interface AppointmentDB
Exception
- the exceptionpublic int nextkey() throws Exception
EntityDB
nextkey
in interface EntityDB<Appointment>
Exception
public Appointment newObj()
EntityDB
newObj
in interface EntityDB<Appointment>
PreparedStatement getPSOne(int key) throws SQLException
getPSOne
in class JdbcBeanDB<Appointment>
SQLException
PreparedStatement getPSAll() throws SQLException
getPSAll
in class JdbcBeanDB<Appointment>
SQLException
Appointment createFrom(ResultSet r) throws SQLException
JdbcBeanDB
createFrom
in class JdbcBeanDB<Appointment>
r
- the result set
SQLException
public void updateObj(Appointment appt) throws Exception
EntityDB
updateObj
in interface EntityDB<Appointment>
appt
- the KeyedEntity
Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |