Package com.signalapp.dao

Class EsquematicoDAO

java.lang.Object

com.signalapp.dao.BaseDAO<Esquematico>

com.signalapp.dao.EsquematicoDAO

public class EsquematicoDAO
extends BaseDAO<Esquematico>

Data Access Object for the Esquematicos table Handles database operations for schematic entities

Field Summary

Fields inherited from class com.signalapp.dao.BaseDAO

connection

Constructor Summary

Constructors

Constructor	Description
EsquematicoDAO()

Method Summary

Modifier and Type	Method	Description
void	deleteBySimulacion(int idSimulacion)	Deletes all schematic components for a specific simulation
java.util.List<Esquematico>	getBySimulacion(int idSimulacion)	Retrieves all schematic components for a specific simulation
java.util.List<Esquematico>	getBySimulacionAndPiso(int idSimulacion, int piso)	Retrieves all schematic components for a specific simulation and floor
protected java.lang.String[]	getColumnNames()	Gets the column names for the database table
protected java.lang.String	getTableName()	Gets the name of the database table this DAO operates on
protected Esquematico	mapResultSetToEntity(java.sql.ResultSet rs)	Maps a ResultSet row to an entity object
protected void	setPreparedStatementParams(java.sql.PreparedStatement ps, Esquematico entity)	Sets the parameters for a PreparedStatement based on entity properties

Methods inherited from class com.signalapp.dao.BaseDAO

delete, findAll, findById, insert, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

EsquematicoDAO

public EsquematicoDAO()

Method Detail

getTableName

protected java.lang.String getTableName()

Description copied from class: BaseDAO

Gets the name of the database table this DAO operates on

Specified by:

getTableName in class BaseDAO<Esquematico>

Returns:

The table name

getColumnNames

protected java.lang.String[] getColumnNames()

Description copied from class: BaseDAO

Gets the column names for the database table

Specified by:

getColumnNames in class BaseDAO<Esquematico>

Returns:

Array of column names

mapResultSetToEntity

protected Esquematico mapResultSetToEntity(java.sql.ResultSet rs)
                                    throws java.sql.SQLException

Description copied from class: BaseDAO

Maps a ResultSet row to an entity object

Specified by:

mapResultSetToEntity in class BaseDAO<Esquematico>

Parameters:

rs - The ResultSet containing the database row

Returns:

The mapped entity object

Throws:

java.sql.SQLException - if a database error occurs

setPreparedStatementParams

protected void setPreparedStatementParams(java.sql.PreparedStatement ps,
                                          Esquematico entity)
                                   throws java.sql.SQLException

Description copied from class: BaseDAO

Sets the parameters for a PreparedStatement based on entity properties

Specified by:

setPreparedStatementParams in class BaseDAO<Esquematico>

Parameters:

ps - The PreparedStatement to set parameters for

entity - The entity containing the values to set

Throws:

java.sql.SQLException - if a database error occurs

getBySimulacion

public java.util.List<Esquematico> getBySimulacion(int idSimulacion)
                                            throws java.sql.SQLException

Retrieves all schematic components for a specific simulation

Parameters:

idSimulacion - The ID of the simulation

Returns:

List of schematic components for the simulation

Throws:

java.sql.SQLException - if a database error occurs

getBySimulacionAndPiso

public java.util.List<Esquematico> getBySimulacionAndPiso(int idSimulacion,
                                                          int piso)
                                                   throws java.sql.SQLException

Retrieves all schematic components for a specific simulation and floor

Parameters:

idSimulacion - The ID of the simulation

piso - The floor number

Returns:

List of schematic components for the simulation and floor

Throws:

java.sql.SQLException - if a database error occurs

deleteBySimulacion

public void deleteBySimulacion(int idSimulacion)
                        throws java.sql.SQLException

Deletes all schematic components for a specific simulation

Parameters:

idSimulacion - The ID of the simulation

Throws:

java.sql.SQLException - if a database error occurs