org.orange.kicsa.integration.admin
Class OwnerJDBCDAO

org.orange.util.integration.JDBCDAO
  |
  +--org.orange.kicsa.integration.admin.OwnerJDBCDAO

public class OwnerJDBCDAO

extends JDBCDAO

implements OwnerDAO

Author:

Jérôme Beau pour Orange (c) 2002

Version: $Revision: 1.1.1.1 $

Stereotype singleton

testcase <{test.org.orange.kicsa.integration.skill.TestSkillJDBCDAO}>

Method Summary
void	create(SkillKey someSkill, EmployeeKey someEmployee)           Enregistre une nouveau propriétaire de compétence
static OwnerDAO	getInstance()           Recherche les compétences racines (sans relations parent) public final static String SELECT_ROOTS = SELECT + " distinct " + ALL_FIELDS + FROM + TABLE + " LEFT JOIN " + TABLE + " ON " + TABLE + "."
Collection	getOwnersBySkill(SkillKey someSkill)
Collection	getSkillsByOwner(EmployeeKey someEmployee)           Get skills for a owner
boolean	isCacheEnabled()
void	remove(SkillKey someSkill, EmployeeKey someEmployee)           Supprime un enregistrement de compétence
int	removeByEmployee(EmployeeKey someEmployee)
int	removeBySkill(SkillKey someSkill)
void	setCacheEnabled(boolean someEnabledState)

Methods inherited from class org.orange.util.integration.JDBCDAO

getConnection

Field Detail

EMPLOYEE_KEY

public final static String EMPLOYEE_KEY

public final static String INSERT

Insère une nouvelle compétence

public final static String REMOVE

public final static String REMOVE_BY_EMPLOYEE

public final static String REMOVE_BY_SKILL

public final static String SELECT_OWNERS_BY_SKILL

public final static String SELECT_SKILLS_BY_OWNER

public final static String SKILL_KEY

public final static String TABLE

public void create(SkillKey someSkill, EmployeeKey someEmployee)
             throws org.orange.util.integration.DAOException

Enregistre une nouveau propriétaire de compétence

Parameters:

someSkill La compétence à enregistrer

Returns: La compétence enregistrée, avec sa clé générée (sauf si la clé est celle de la compétence racine)

public static OwnerDAO getInstance()
                             throws org.orange.util.integration.DAOException

Recherche les compétences racines (sans relations parent)

public final static String SELECT_ROOTS = SELECT + " distinct " + ALL_FIELDS + FROM + TABLE + " LEFT JOIN "
+ TABLE + " ON " + TABLE + "." + KEY + "=" + ID_FROM
+ WHERE + ID_FROM + " IS NULL";

/** /
public Collection getRoots() throws DAOException
{
log.debug ("getRoots");

if (roots.size() == 0)
try
{
Connection connection = getConnection();
try
{
PreparedStatement selectAllStatement = connection.prepareStatement (SELECT_ROOTS);
ResultSet rootsResultSet = selectAllStatement.executeQuery();
while (rootsResultSet.next())
{
Skill skill = rowToObject (null, rootsResultSet);
roots.add (skill);
}
}
finally
{
connection.close();
}
}
catch (SQLException sqlProblem)
{
throw new DAOException("Impossible de récupérer les compétences racines", sqlProblem);
}
return roots;
}

/**

Returns: Le singleton

public Collection getOwnersBySkill(SkillKey someSkill)
                             throws org.orange.util.integration.DAOException,
                                    org.orange.kicsa.SkillNotFoundException

public Collection getSkillsByOwner(EmployeeKey someEmployee)
                             throws org.orange.util.integration.DAOException,
                                    org.orange.kicsa.EmployeeNotFoundException

Get skills for a owner

public boolean isCacheEnabled()

public void remove(SkillKey someSkill, EmployeeKey someEmployee)
             throws org.orange.util.integration.DAOException

Supprime un enregistrement de compétence

Parameters:

someSkillKey La clé de la compétence à supprimer

public int removeByEmployee(EmployeeKey someEmployee)
                      throws org.orange.util.integration.DAOException,
                             org.orange.kicsa.EmployeeNotFoundException

public int removeBySkill(SkillKey someSkill)
                   throws org.orange.util.integration.DAOException,
                          org.orange.kicsa.SkillNotFoundException

public void setCacheEnabled(boolean someEnabledState)
                      throws org.orange.util.integration.DAOException

Association Links

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

Insère une nouvelle compétence

to Class java.lang.String

to Class java.lang.String

to Class org.orange.kicsa.integration.admin.OwnerJDBCDAO

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

Dependency Links

to Class test.org.orange.kicsa.integration.skill.TestSkillJDBCDAO

to Class org.orange.util.integration.JDBCDAO

to Class org.orange.kicsa.integration.admin.OwnerDAO

to Class java.lang.String

to Class org.orange.util.integration.DAOException

to Class org.orange.kicsa.business.skill.SkillKey

to Class org.orange.kicsa.business.employee.EmployeeKey

to Class java.sql.Connection

to Class java.sql.PreparedStatement

to Class java.sql.SQLException

to Class java.lang.Throwable

to Class java.util.Collection

to Class org.orange.kicsa.EmployeeNotFoundException

to Class org.orange.util.Assert

to Class java.sql.ResultSet

to Class java.util.ArrayList

to Class java.lang.Class

to Class org.orange.kicsa.SkillNotFoundException

to Class Diagram test.org.orange.kicsa.integration.skill

to Class Diagram test.org.orange.kicsa.integration

to Class Diagram test.org.orange.kicsa

to Class Diagram test.org.orange

to Class Diagram test.org

to Class Diagram test

to Class Diagram <default>

to Class Diagram org.orange.util.integration

to Class Diagram org.orange.util

to Class Diagram org.orange

to Class Diagram org

to Class Diagram org.orange.kicsa.integration.admin

to Class Diagram org.orange.kicsa.integration

to Class Diagram org.orange.kicsa

to Class Diagram org.orange.kicsa.business.skill

to Class Diagram org.orange.kicsa.business

to Class Diagram org.orange.kicsa.business.employee