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.
Ir a la instalación Skills Marketplace Descubre y explora habilidades de IA creadas por la comunidad.
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Mostrar detalles del prompt Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.
npx skills add https://github.com/lutece-platform/lutece-dev-plugin-claude --skill lutece-daoEl comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.
¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.
Descargar Zip Descargando... Ocupaciones relacionadas
SOC
Basado en la clasificación ocupacional 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/
