org.orange.kicsa.integration.ability
Class AbilityJDBCDAO

org.orange.util.integration.JDBCDAO
  |
  +--org.orange.kicsa.integration.ability.AbilityJDBCDAO

public class AbilityJDBCDAO
extends JDBCDAO
implements AbilityDAO

Author:
Jérôme Beau pour Orange (c) 2002
Version: 0.1, Initiale
Stereotype singleton
testcase test.org.orange.kicsa.integration.ability.TestAbilityJDBCDAO

Field Summary
 final static StringABILITIES_EMPLOYEE_KEY
           
 final static StringABILITIES_FIELDS
           
 final static StringABILITIES_LEVEL
           
 final static StringABILITIES_SELECT_BY_EMPLOYEE
           
 (package private) final static StringABILITIES_SELECT_BY_SKILL
           
 final static StringABILITIES_SKILL_KEY
           
 final static StringABILITIES_TABLE
           
 final static StringABILITY_INSERT
           
 final static StringABILITY_REMOVE
           
 final static StringABILITY_UPDATE
           
 (package private) AbilityMemoryDAOcache
          Cache
 final static StringREMOVE_ABILITIES_BY_EMPLOYEE
           
 final static StringREMOVE_ABILITIES_BY_SKILL
           
 final static StringSELECT_BEST_EMPLOYEES_FOR_SKILLS_1STPART
           

Fields inherited from class org.orange.util.integration.JDBCDAO
AND, CONNECTION_FACTORY_CLASS_NAME, CONNECTION_FACTORY_CLASS_NAME_DEFAULT, DELETE_FROM, DISTINCT, EQUAL_PARAMETER, FROM, IN, INSERT_INTO, LIKE, NOT, OR, ORDER_BY, SELECT, SET, UPDATE, VALUES, WHERE

Method Summary
 Abilitycreate(Ability someAbility)
          Crée un nouvel enregistrement de capacité
 CollectiongetBestBySkill(Collection someSkillKeys)
           
 CollectiongetByEmployee(EmployeeKey someEmployeeKey)
           
 CollectiongetBySkill(SkillKey someSkillKey)
           
 static AbilityJDBCDAOgetInstance()
           
 booleanisCacheEnabled()
           
 voidremove(Ability someAbility)
          Crée un nouvel enregistrement de capacité
 intremoveByEmployee(EmployeeKey someEmployeeKey)
           
 intremoveBySkill(SkillKey someSkillKey)
           
 Abilityupdate(Ability someAbility)
          Update some ability

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

Field Detail

ABILITIES_EMPLOYEE_KEY

public final static String ABILITIES_EMPLOYEE_KEY

ABILITIES_FIELDS

public final static String ABILITIES_FIELDS

ABILITIES_LEVEL

public final static String ABILITIES_LEVEL

ABILITIES_SELECT_BY_EMPLOYEE

public final static String ABILITIES_SELECT_BY_EMPLOYEE

ABILITIES_SELECT_BY_SKILL

final static String ABILITIES_SELECT_BY_SKILL

ABILITIES_SKILL_KEY

public final static String ABILITIES_SKILL_KEY

ABILITIES_TABLE

public final static String ABILITIES_TABLE

ABILITY_INSERT

public final static String ABILITY_INSERT

ABILITY_REMOVE

public final static String ABILITY_REMOVE

ABILITY_UPDATE

public final static String ABILITY_UPDATE

cache

AbilityMemoryDAO cache
Cache
supplierQualifier cache

REMOVE_ABILITIES_BY_EMPLOYEE

public final static String REMOVE_ABILITIES_BY_EMPLOYEE

REMOVE_ABILITIES_BY_SKILL

public final static String REMOVE_ABILITIES_BY_SKILL

SELECT_BEST_EMPLOYEES_FOR_SKILLS_1STPART

public final static String SELECT_BEST_EMPLOYEES_FOR_SKILLS_1STPART
Method Detail

create

public Ability create(Ability someAbility)
throws org.orange.util.integration.DAOException
Crée un nouvel enregistrement de capacité
Parameters:
someAbility La capacité à enregistrer
Returns: La capacité enregistrée

getBestBySkill

public Collection getBestBySkill(Collection someSkillKeys)
throws org.orange.util.integration.DAOException,
org.orange.kicsa.SkillNotFoundException

getByEmployee

public Collection getByEmployee(EmployeeKey someEmployeeKey)
throws org.orange.util.integration.DAOException

getBySkill

public Collection getBySkill(SkillKey someSkillKey)
throws org.orange.util.integration.DAOException
Returns: Les capacités liées à cette compétence
someSkillKey La clé d'une compétence

getInstance

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

isCacheEnabled

public boolean isCacheEnabled()

remove

public void remove(Ability someAbility)
throws org.orange.util.integration.DAOException
Crée un nouvel enregistrement de capacité
Parameters:
someAbility La capacité à enregistrer
Returns: La capacité enregistrée

removeByEmployee

public int removeByEmployee(EmployeeKey someEmployeeKey)
throws org.orange.util.integration.DAOException

removeBySkill

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

update

public Ability update(Ability someAbility)
throws org.orange.util.integration.DAOException
Update some ability
Returns: The written ability (so, unmodified).

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 java.lang.String

to Class org.orange.kicsa.integration.ability.AbilityJDBCDAO

to Class org.orange.kicsa.integration.ability.AbilityMemoryDAO

Cache

Supplier Qualifier cache

Dependency Links

to Class test.org.orange.kicsa.integration.ability.TestAbilityJDBCDAO

to Class org.orange.util.integration.JDBCDAO

to Class org.orange.kicsa.integration.ability.AbilityDAO

to Class java.lang.String

to Class org.orange.util.integration.DAOException

to Class org.orange.kicsa.integration.employee.EmployeeJDBCDAO

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

to Class java.util.Collection

to Class org.orange.kicsa.SkillNotFoundException

to Class org.orange.util.NotImplementedException

to Class java.lang.Class

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

to Class java.sql.Connection

to Class java.sql.PreparedStatement

to Class java.sql.ResultSet

to Class java.util.ArrayList

to Class org.orange.kicsa.business.ability.Ability

to Class java.sql.SQLException

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

to Class org.orange.util.Assert

to Class org.orange.kicsa.business.ability.AbilityImpl

to Class org.orange.kicsa.integration.ability.AbilityMemoryDAO

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

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

to Class Diagram org.orange.kicsa.integration

to Class Diagram org.orange.kicsa

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

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

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

to Class Diagram org.orange.kicsa.business

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

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