org.orange.kicsa.integration.skill
Class SkillJDBCDAO

org.orange.util.integration.JDBCDAO
  |
  +--org.orange.kicsa.integration.skill.SkillJDBCDAO

public class SkillJDBCDAO

extends JDBCDAO

implements SkillDAO

Skill Data Access Object (DAO)

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	clearCache()
Skill	create(Skill someSkill)           Enregistre une nouvelle compétence
Map	getAll()
Skill	getByPrimaryKey(SkillKey someKey)
Collection	getChilds(Skill someParentSkill)
Collection	getDestinations(Skill someSourceSkill)           Return all relationship destinations from a given skill.
Collection	getDestinations(Skill someSourceSkill, String someRelationshipType)
static SkillDAO	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 + "."
SortedMap	getLevels(SkillKey someSkillKey)
Collection	getParents(Skill someChildSkill)
Collection	getSources(Skill someDestinationSkill, String someRelationshipType)           Get skills linking to some skill with some relationship type This method lookup in cache first, and then read if not found in cache; return them.
boolean	isCacheEnabled()
void	link(Skill someFromSkill, String someType, SkillKey someToSkillKey)           Crée une nouvelle relation entre deux compétences
Map	readAll()
Skill	readByPrimaryKey(SkillKey someKey)           Get a skill by its name
SortedMap	readLevels(SkillKey someSkillKey)
int	remove(SkillKey someSkillKey)           Supprime un enregistrement de compétence
void	removeRelationship(SkillKey someSource, String someRelationshipType, SkillKey someDestination)
int	removeRelationships(SkillKey someSkillKey)           Remove relationships to or from a skill
void	setCacheEnabled(boolean someEnabledState)
Skill	update(Skill someSkill)           Met à jour une nouvelle compétence Cette méthode ne prend pas en compte la mise à jour des relations de la compétence.
void	updateRelationship(SkillKey someSource, String someRelationshipType, SkillKey someDestination)           Update a relationship between two skills

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

getConnection

Field Detail

ALL_FIELDS

public final static String ALL_FIELDS

SkillMemoryDAO cache

Cache

supplierQualifier cache

public final static String COMMENTS

public final static String INSERT

Insère une nouvelle compétence

public final static String KEY

public final static String LEVEL_DESCRIPTIONS

public final static String LEVELS_SEPARATOR

public final static String LONG_NAME

public final static String RELATIONSHIP_ID_FROM

public final static String RELATIONSHIP_ID_TO

public final static String RELATIONSHIP_INSERT

Création d'une nouvelle relation

public final static String RELATIONSHIP_REMOVE

public final static String RELATIONSHIP_REMOVE_FOR_SKILL

public final static String RELATIONSHIP_TABLE

public final static String RELATIONSHIP_TYPE

public final static String RELATIONSHIP_UPDATE

public final static String REMOVE

public final static String SELECT_ALL

public final static String SELECT_ALL_DESTINATIONS

Récupère les clés, noms courts et longs des compétences parentes

public final static String SELECT_BY_PRIMARY_KEY

public final static String SELECT_DESTINATIONS

Récupère les clés, noms courts et longs des compétences parentes

public final static String SELECT_LEVELS_BY_SKILL

public final static String SELECT_NEW_KEY

Recherche la plus grande clé.

Utilisé pour déterminer la clé d'un nouvel enregistrement : max + 1

public final static String SELECT_SOURCES

Récupère toutes les clés de compétences destinations pour une compétence donnée

public final static String SELECT_ALL_DESTINATIONS = SELECT + ID_TO + FROM + TABLE
+ WHERE + ID_FROM + "=?";

/**
Récupère toutes les clés de compétences sources pour un type de relation donné

public final static String RELATIONSHIP_SELECT_SOURCES
= SELECT + RELATIONSHIP_ID_FROM + FROM + RELATIONSHIP_TABLE
+ WHERE + RELATIONSHIP_ID_TO + "=?"
+ AND + RELATIONSHIP_TYPE+ "=?";

/** Récupère les clés, noms courts et longs des compétences parentes

public final static String SHORT_NAME

public final static String SKILL_UPDATE

Modification d'un enregistrement de compétence

public final static String STATUS

public final static char STATUS_APPROVED

public final static char STATUS_PROPOSED

public final static String TABLE

public void clearCache()

public Skill create(Skill someSkill)
              throws org.orange.util.integration.DAOException

Enregistre une nouvelle 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 Map getAll()
            throws org.orange.util.integration.DAOException

Returns: L'ensemble des noms courts de compétences, indexés par leur clé (Integer id)

public Skill getByPrimaryKey(SkillKey someKey)
                       throws org.orange.util.integration.DAOException,
                              org.orange.kicsa.SkillNotFoundException

public Collection getChilds(Skill someParentSkill)
                      throws org.orange.util.integration.DAOException

Returns: The childs of the skill

public Collection getDestinations(Skill someSourceSkill)
                            throws org.orange.util.integration.DAOException

Return all relationship destinations from a given skill.

Parameters:

someSourceSkill The skill you want to find destinations from

Returns: The set of relationships' destinations from this skill

public Collection getDestinations(Skill someSourceSkill, String someRelationshipType)
                            throws org.orange.util.integration.DAOException

Parameters:

someSourceSkill Une compétence

someRelationshipType Un type de relation ("Parent", etc.)

Returns: L'ensemble des relations d'un certain type partant de la compétence

public static SkillDAO 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 SortedMap getLevels(SkillKey someSkillKey)
                     throws org.orange.util.integration.DAOException,
                            org.orange.kicsa.SkillNotFoundException

public Collection getParents(Skill someChildSkill)
                       throws org.orange.util.integration.DAOException

Parameters:

someChildSkill The skill you want to find parents of

Returns: Skills that have a parent-typed relationship with some skill

public Collection getSources(Skill someDestinationSkill, String someRelationshipType)
                       throws org.orange.util.integration.DAOException

Get skills linking to some skill with some relationship type

This method lookup in cache first, and then read if not found in cache; return them.

public boolean isCacheEnabled()

public void link(Skill someFromSkill, String someType, SkillKey someToSkillKey)
           throws org.orange.util.integration.DAOException

Crée une nouvelle relation entre deux compétences

public Map readAll()
             throws org.orange.util.integration.DAOException

Returns: L'ensemble des noms courts de compétences persistantes, indexés par leur clé (Integer id)

public Skill readByPrimaryKey(SkillKey someKey)
                        throws org.orange.util.integration.DAOException,
                               org.orange.kicsa.SkillNotFoundException

Get a skill by its name

public SortedMap readLevels(SkillKey someSkillKey)
                      throws org.orange.kicsa.SkillNotFoundException,
                             org.orange.util.integration.DAOException

Parameters:

someSkillKey La clé d'une compétence

Returns: Les descriptions (String) des niveaux de la compétence, indexés par leur rang (Integer)

See Also:

#stringToLevels

public int remove(SkillKey someSkillKey)
            throws org.orange.util.integration.DAOException

Supprime un enregistrement de compétence

Parameters:

someSkillKey La clé de la compétence à supprimer

public void removeRelationship(SkillKey someSource, String someRelationshipType, SkillKey someDestination)
                         throws org.orange.util.integration.DAOException

public int removeRelationships(SkillKey someSkillKey)
                         throws org.orange.util.integration.DAOException

Remove relationships to or from a skill

Parameters:

someSkillKey The key of the skill

Returns: The count of removed relationships

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

public Skill update(Skill someSkill)
              throws org.orange.util.integration.DAOException

Met à jour une nouvelle compétence

Cette méthode ne prend pas en compte la mise à jour des relations de la 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 void updateRelationship(SkillKey someSource, String someRelationshipType, SkillKey someDestination)
                         throws org.orange.util.integration.DAOException

Update a relationship between two skills

Association Links

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class org.orange.kicsa.integration.skill.SkillMemoryDAO

Cache

Supplier Qualifier cache

to Class java.lang.String

Création d'une nouvelle relation

to Class java.lang.String

Insère une nouvelle compétence

to Class java.lang.String

to Class java.lang.String

Récupère toutes les clés de compétences destinations pour une compétence donnée

public final static String SELECT_ALL_DESTINATIONS = SELECT + ID_TO + FROM + TABLE
+ WHERE + ID_FROM + "=?";

/**
Récupère toutes les clés de compétences sources pour un type de relation donné

public final static String RELATIONSHIP_SELECT_SOURCES
= SELECT + RELATIONSHIP_ID_FROM + FROM + RELATIONSHIP_TABLE
+ WHERE + RELATIONSHIP_ID_TO + "=?"
+ AND + RELATIONSHIP_TYPE+ "=?";

/** Récupère les clés, noms courts et longs des compétences parentes

to Class java.lang.String

Récupère les clés, noms courts et longs des compétences parentes

to Class java.lang.String

to Class java.lang.String

Recherche la plus grande clé.

Utilisé pour déterminer la clé d'un nouvel enregistrement : max + 1

to Class java.lang.String

to Class org.orange.kicsa.integration.skill.SkillJDBCDAO

Supplier Role instance

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

Modification d'un enregistrement de compétence

to Class java.lang.String

to Class java.lang.String

to Class java.lang.String

Récupère les clés, noms courts et longs des compétences parentes

Dependency Links

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

to Class org.orange.util.integration.JDBCDAO

to Class org.orange.kicsa.integration.skill.SkillDAO

to Class java.lang.String

to Class org.orange.util.integration.DAOException

to Class org.orange.kicsa.integration.skill.SkillMemoryDAO

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

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

to Class org.orange.util.Assert

to Class java.sql.Connection

to Class java.sql.PreparedStatement

to Class java.sql.SQLException

to Class org.orange.kicsa.Application

to Class java.util.Collection

to Class org.orange.kicsa.integration.skill.RelationshipTypeJDBCDAO

to Class java.util.Iterator

to Class java.util.HashSet

to Class java.util.Set

to Class java.sql.ResultSet

to Class java.util.ArrayList

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

to Class java.lang.Throwable

to Class org.orange.kicsa.SkillNotFoundException

to Class java.util.SortedMap

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

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

to Class java.util.StringTokenizer

to Class java.util.List

to Class java.util.Map

to Class java.util.HashMap

to Class java.lang.Integer

to Class java.lang.StringBuffer

to Class java.util.Date

to Class java.lang.Class

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

to Class java.util.TreeMap

to Class java.lang.NumberFormatException

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

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

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