@Override
public void insert(DataObject dataObject) throws SQLException {
checkCache(dataObject, CHECK_INSERT);
checkClass(dataObject, ObjetivoDO.class, CHECK_INSERT);
ObjetivoDO objetivoDO = (ObjetivoDO) dataObject;
objetivoDO.setId(getNextId());
StringBuffer strbuf = new StringBuffer();
strbuf.append("INSERT INTO ");
strbuf.append(getTableName());
strbuf.append(" VALUES (");
strbuf.append(objetivoDO.getId());
strbuf.append(", ");
strbuf.append(singleQuotes(objetivoDO.getDescripcion()));
strbuf.append(", ");
strbuf.append(objetivoDO.getNumeroDeNpc());
strbuf.append(", ");
Reference<PlanetaDO> refPl = objetivoDO.getPlanetaRef();
refPl.checkInsert();
strbuf.append(refPl.getIdAsString());
strbuf.append(")");
System.err.println(strbuf.toString());
connection.createStatement().execute(strbuf.toString());
dtaSession.add(dataObject);
}
public void loadOrdenList(ObjetivoDO objetivo) throws Exception {
checkCache(objetivo, CHECK_UPDATE);
// checkClass(departmentDO, DepartmentDO.class, CHECK_UPDATE);
OrdenDAO ordenDAO =
(OrdenDAO)
FactoryDAO.getDAO( //
OrdenDAO.class, connectionBean);
objetivo.setOrdenList(ordenDAO.listByObjetivoId(objetivo.getId()));
}
@Override
public void update(DataObject dataObject) throws SQLException {
checkCache(dataObject, CHECK_UPDATE);
checkClass(dataObject, ObjetivoDO.class, CHECK_UPDATE);
ObjetivoDO objetivoDO = (ObjetivoDO) dataObject;
StringBuffer strbuf = new StringBuffer();
strbuf.append("UPDATE ");
strbuf.append(getTableName());
strbuf.append(" SET ");
strbuf.append(ObjetivoDO.DESCRIPCION);
strbuf.append(" = ");
strbuf.append(singleQuotes(objetivoDO.getDescripcion()));
strbuf.append(", ");
strbuf.append(ObjetivoDO.NUMERO_DE_NPC);
strbuf.append(" = ");
strbuf.append(objetivoDO.getNumeroDeNpc());
strbuf.append(", ");
strbuf.append(ObjetivoDO.PLANETA_ID);
strbuf.append(" = ");
Reference<PlanetaDO> refPl = objetivoDO.getPlanetaRef();
refPl.checkUpdate();
strbuf.append(refPl.getIdAsString());
strbuf.append(" WHERE ");
strbuf.append(ObjetivoDO.ID);
strbuf.append(" = ");
strbuf.append(objetivoDO.getId());
System.err.println(strbuf.toString());
connection.createStatement().execute(strbuf.toString());
}
@Override
public void delete(DataObject dataObject) throws SQLException {
checkCache(dataObject, CHECK_DELETE);
checkClass(dataObject, ObjetivoDO.class, CHECK_DELETE);
ObjetivoDO objetivoDO = (ObjetivoDO) dataObject;
StringBuffer strbuf = new StringBuffer();
strbuf.append("DELETE FROM ");
strbuf.append(getTableName());
strbuf.append(" WHERE ");
strbuf.append(ObjetivoDO.ID);
strbuf.append(" = ");
strbuf.append(objetivoDO.getId());
System.err.println(strbuf.toString());
connection.createStatement().execute(strbuf.toString());
dtaSession.del(dataObject);
}
