Skip to main content
lutece-dao Lutece 8 DAO and Home layer patterns: DAOUtil lifecycle, SQL constants, Home static facade, CDI lookup, collection types, interface conventions. MUST be consulted before creating or modifying DAO/Home classes.
Aller à l'installation Skills Marketplace Découvrez et explorez les compétences IA créées par la communauté.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Afficher les détails du prompt Une commande directe contourne le prompt de vérification. Examinez la source avant de l'exécuter.
npx skills add https://github.com/lutece-platform/lutece-dev-plugin-claude --skill lutece-daoLa commande reste sur une seule ligne. Faites défiler horizontalement pour la vérifier avant de la copier.
Vous préférez une copie locale ? Téléchargez les fichiers actuellement disponibles dans SkillsMP.
Télécharger Zip Téléchargement... Métiers associés
SOC
Basé sur la classification professionnelle SOC
name lutece-dao description Lutece 8 DAO and Home layer patterns: DAOUtil lifecycle, SQL constants, Home static facade, CDI lookup, collection types, interface conventions. MUST be consulted before creating or modifying DAO/Home classes. user-invocable true
DAO & Home Patterns — Lutece 8
Before writing DAO or Home code, consult ~/.lutece-references/lutece-core/ and ~/.lutece-references/lutece-form-plugin-forms/ using Read, Grep and Glob.
DAO Class Structure
@ApplicationScoped
@Named( "myplugin.entityDAO" )
public class EntityDAO implements IEntityDAO
{
private static final String SQL_QUERY_NEWPK = "SELECT max( id_entity ) FROM myplugin_entity" ;
private static final String SQL_QUERY_SELECT = "SELECT id_entity, title, description FROM myplugin_entity WHERE id_entity = ?" ;
private static
final
String
SQL_QUERY_INSERT
=
"INSERT INTO myplugin_entity ( id_entity, title, description ) VALUES ( ?, ?, ? )"
private
static
final
String
SQL_QUERY_UPDATE
=
"UPDATE myplugin_entity SET title = ?, description = ? WHERE id_entity = ?"
private
static
final
String
SQL_QUERY_DELETE
=
"DELETE FROM myplugin_entity WHERE id_entity = ?"
private
static
final
String
SQL_QUERY_SELECTALL
=
"SELECT id_entity, title, description FROM myplugin_entity"
SQL Constant Naming Constant Usage SQL_QUERY_NEWPKSELECT max(id_xxx) FROM tableSQL_QUERY_SELECTSingle row by PK SQL_QUERY_INSERTInsert row SQL_QUERY_UPDATEUpdate row by PK SQL_QUERY_DELETEDelete row by PK SQL_QUERY_SELECTALLAll rows SQL_QUERY_SELECT_BY_*Custom finders SQL_QUERY_COUNT_*Count queries
DAOUtil Lifecycle Always use try-with-resources (auto-closes):
INSERT / UPDATE / DELETE public void insert ( Entity entity, Plugin plugin )
{
try ( DAOUtil daoUtil = new DAOUtil ( SQL_QUERY_INSERT, plugin ) )
{
int nIndex = 1 ;
daoUtil.setInt( nIndex++, entity.getId( ) );
daoUtil.setString( nIndex++, entity.getTitle( ) );
daoUtil.setString( nIndex++, entity.getDescription( ) );
daoUtil.executeUpdate( );
}
}
SELECT (single row) public Entity load ( int nKey, Plugin plugin )
{
Entity entity = null ;
try ( DAOUtil daoUtil = new DAOUtil ( SQL_QUERY_SELECT, plugin ) )
{
daoUtil.setInt( 1 , nKey );
daoUtil.executeQuery( );
if ( daoUtil.next( ) )
{
int nIndex = 1 ;
entity = new Entity ( );
entity.setId( daoUtil.getInt( nIndex++ ) );
entity.setTitle( daoUtil.getString( nIndex++ ) );
entity.setDescription( daoUtil.getString( nIndex++ ) );
}
}
return entity;
}
SELECT (collection) public List<Entity> selectAll ( Plugin plugin )
{
List<Entity> listEntities = new ArrayList <>( );
try ( DAOUtil daoUtil = new DAOUtil ( SQL_QUERY_SELECTALL, plugin ) )
{
daoUtil.executeQuery( );
while ( daoUtil.next( ) )
{
int nIndex = 1 ;
Entity entity = new Entity ( );
entity.setId( daoUtil.getInt( nIndex++ ) );
entity.setTitle( daoUtil.getString( nIndex++ ) );
entity.setDescription( daoUtil.getString( nIndex++ ) );
listEntities.add( entity );
}
}
return listEntities;
}
DAOUtil Parameter Types Parameters and results are 1-indexed . Use nIndex++ for sequential access.
Type Setter Getter int setInt( n, val )getInt( n )String setString( n, val )getString( n )long setLong( n, val )getLong( n )boolean setBoolean( n, val )getBoolean( n )double setDouble( n, val )getDouble( n )Timestamp setTimestamp( n, val )getTimestamp( n )Date setDate( n, val )getDate( n )
Interface Pattern Every DAO has an interface:
public interface IEntityDAO
{
void insert ( Entity entity, Plugin plugin ) ;
Entity load ( int nKey, Plugin plugin ) ;
void store ( Entity entity, Plugin plugin ) ;
void delete ( int nKey, Plugin plugin ) ;
List<Entity> selectAll ( Plugin plugin ) ;
ReferenceList selectReferenceList ( Plugin plugin ) ;
}
Home — Static Facade public final class EntityHome
{
private static IEntityDAO _dao = CDI.current( ).select( IEntityDAO.class ).get( );
private static Plugin _plugin = PluginService.getPlugin( "myplugin" );
private EntityHome ( ) { }
public static Entity create ( Entity entity )
{
_dao.insert( entity, _plugin );
return entity;
}
public static Entity update ( Entity entity )
{
_dao.store( entity, _plugin );
return entity;
}
public static void remove ( int nKey )
{
_dao.delete( nKey, _plugin );
}
public static Entity findByPrimaryKey ( int nKey )
{
return _dao.load( nKey, _plugin );
}
public static List<Entity> findAll ( )
{
return _dao.selectAll( _plugin );
}
public static ReferenceList findReferenceList ( )
{
return _dao.selectReferenceList( _plugin );
}
}
Collection Types Return type When List<Entity>Standard list of entities ReferenceListKey-value pairs for dropdowns (<select>) Optional<Entity>Optional single result (modern style)
Reference Sources Need File to consult Core DAO patterns ~/.lutece-references/lutece-core/src/java/**/business/Core Home patterns ~/.lutece-references/lutece-core/src/java/**/business/DAOUtil source ~/.lutece-references/lutece-core/src/java/**/util/sql/DAOUtil.javaForms plugin DAO examples ~/.lutece-references/lutece-form-plugin-forms/src/java/**/business/
