public void loadPlanetRef(ObjetivoDO objetivo) throws SQLException {
// XXX: Check this method's semantic
checkClass(objetivo, ObjetivoDO.class, CHECK_UPDATE);
PlanetaDAO planetaDAO = new PlanetaDAO();
planetaDAO.init(connectionBean);
// PlanetaDAO planetaDAO = (PlanetaDAO) FactoryDAO.getDAO(//
// PlanetaDAO.class, connectionBean) throws ClassNotFoundException, Exception;
// unmanageable exceptions...
Reference<PlanetaDO> ref = objetivo.getPlanetaRef();
// ----------------------------------------
// If ident == 0 there is nothing to do
// ----------------------------------------
if (ref.getRefIdent() == 0) {
return;
}
PlanetaDO planetaDO = //
(PlanetaDO) planetaDAO.loadById(ref.getRefIdent());
ref.setRefValue(planetaDO);
}
@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);
}
@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());
}
