Package be.gaudry.dao.edu.derby

Class DerbySchoolAdmin

java.lang.Object

be.gaudry.dao.edu.derby.DerbySchool

be.gaudry.dao.edu.derby.DerbySchoolAdmin

All Implemented Interfaces:

ISchoolAdminDao, ISchoolDao

public class DerbySchoolAdmin
extends DerbySchool
implements ISchoolAdminDao

Since:

1.0 23 oct. 2008

Author:

Steph GAUDRY

Field Summary

Fields

Modifier and Type	Field	Description
(package private) PreparedStatement	insertSchoolClassStatement
(package private) PreparedStatement	insertSchoolStatement

Fields inherited from class be.gaudry.dao.edu.derby.DerbySchool

loadSchoolClassLazyStatement, loadSchoolClassStatement, loadSchoolLazyStatement, loadSchoolStatement

Constructor Summary

Constructors

Constructor	Description
DerbySchoolAdmin()

Method Summary

Modifier and Type	Method	Description
void	add(SchoolClass schoolClass, Student student)	Adds a student into the school class
void	add(SchoolClass schoolClass, Teacher teacher)	Adds a teacher into the school class
void	add(School school, Teacher teacher)	Adds a teacher into the school
int	deleteSchoolClass(int id)
int	insert(School school)
void	remove(SchoolClass schoolClass, Student student)	Removes a student from the school class
void	remove(SchoolClass schoolClass, Teacher teacher)	Removes a teacher from the school class
void	remove(School school, Teacher teacher)	Removes a teacher from the school
int	saveOrUpdate(School school)
int	saveOrUpdate(SchoolClass item)

Methods inherited from class be.gaudry.dao.edu.derby.DerbySchool

loadAsyncSchoolClassesLos, loadAsyncSchoolClassesLos, loadAsyncSchoolsLos, loadAsyncTeachersLos, loadSchool, loadSchoolClass, loadSchoolClassesLos, loadSchoolsLos

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface be.gaudry.dao.edu.ISchoolDao

loadAsyncSchoolClassesLos, loadAsyncSchoolClassesLos, loadAsyncSchoolsLos, loadAsyncTeachersLos, loadSchool, loadSchoolClass, loadSchoolClassesLos, loadSchoolsLos

Field Details

insertSchoolStatement

PreparedStatement insertSchoolStatement

insertSchoolClassStatement

PreparedStatement insertSchoolClassStatement

Constructor Details

DerbySchoolAdmin

public DerbySchoolAdmin()

Method Details

saveOrUpdate

public int saveOrUpdate(School school)

Specified by:

saveOrUpdate in interface ISchoolAdminDao

Parameters:

school - to save or update (only name and director)

Returns:

school id (-1 if an error occurs)

insert

public int insert(School school)

Specified by:

insert in interface ISchoolAdminDao

Returns:

school id (-1 if an error occurs)

saveOrUpdate

public int saveOrUpdate(SchoolClass item)

Specified by:

saveOrUpdate in interface ISchoolAdminDao

Returns:

SchoolClass id (-1 if an error occurs)

remove

public void remove(SchoolClass schoolClass,
 Student student)

Description copied from interface: ISchoolAdminDao

Removes a student from the school class

Specified by:

remove in interface ISchoolAdminDao

remove

public void remove(SchoolClass schoolClass,
 Teacher teacher)

Description copied from interface: ISchoolAdminDao

Removes a teacher from the school class

Specified by:

remove in interface ISchoolAdminDao

add

public void add(SchoolClass schoolClass,
 Student student)

Description copied from interface: ISchoolAdminDao

Adds a student into the school class

Specified by:

add in interface ISchoolAdminDao

add

public void add(SchoolClass schoolClass,
 Teacher teacher)

Description copied from interface: ISchoolAdminDao

Adds a teacher into the school class

Specified by:

add in interface ISchoolAdminDao

add

public void add(School school,
 Teacher teacher)

Description copied from interface: ISchoolAdminDao

Adds a teacher into the school

Specified by:

add in interface ISchoolAdminDao

remove

public void remove(School school,
 Teacher teacher)

Description copied from interface: ISchoolAdminDao

Removes a teacher from the school

Specified by:

remove in interface ISchoolAdminDao

deleteSchoolClass

public int deleteSchoolClass(int id)

Specified by:

deleteSchoolClass in interface ISchoolAdminDao

Returns:

either

• the row count for (SQL) statements
• or 0 for (SQL) statements that return nothing
• or -1 if a persistent (database) error occurs