public static void Persist(Watch_Tv obj, int i, int j)
throws SQLException, ClassNotFoundException {
Connection con = Conexao.getConnection();
PreparedStatement ps =
con.prepareStatement(
"insert into resource(Device_idDevice,Type_) values (?,?)",
Statement.RETURN_GENERATED_KEYS);
ps.setInt(1, obj.getHead().getsTBDevice().getDevices().get(i).getIdDevice());
ps.setString(
2, obj.getHead().getsTBDevice().getDevices().get(i).getResources().get(j).getType());
ps.executeUpdate();
ResultSet rskey = null;
rskey = ps.getGeneratedKeys();
if (rskey != null && rskey.next()) {
obj.getHead()
.getsTBDevice()
.getDevices()
.get(i)
.getResources()
.get(j)
.setIdResource(rskey.getInt(1));
}
ps.close();
con.close();
}
public void Persist(Watch_Tv obj) {
for (int i = 0; i < obj.getIteractions().size(); i++) {
Channel channel = Search(obj.getIteractions().get(i).getProgram().getChannel());
try {
if (channel == null) {
ChannelDao.Persist(obj, i);
} else {
obj.getIteractions()
.get(i)
.getProgram()
.getChannel()
.setIdChannel(channel.getIdChannel());
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
public void Persit(Watch_Tv watchTv) {
try {
watchTv
.getHead()
.getLocation()
.setIdLocation(
new LocationController().Search(watchTv.getHead().getLocation()).getIdLocation());
} catch (Exception e) {
new LocationController().Persist(watchTv);
watchTv
.getHead()
.getLocation()
.setIdLocation(
new LocationController().Search(watchTv.getHead().getLocation()).getIdLocation());
}
try {
watchTv
.getHead()
.getsTBDevice()
.setIdSTB_Device(
new STBDeviceController()
.Search(watchTv.getHead().getsTBDevice().getSerialNumber())
.getIdSTB_Device());
} catch (Exception e) {
new STBDeviceController().Persist(watchTv);
watchTv
.getHead()
.getsTBDevice()
.setIdSTB_Device(
new STBDeviceController()
.Search(watchTv.getHead().getsTBDevice().getSerialNumber())
.getIdSTB_Device());
}
try {
HeadDao.Persist(watchTv);
} catch (SQLException e) {
e.printStackTrace();
}
}