@Override public boolean MOD_PADRES( String AP_NOMBRES_PADRE, String AP_NOMBRES_MADRE, String ID_TRABAJADOR, String USER) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_MOD_PADRES( ?, ?, ?, ?, ?)}"); cst.setString(1, AP_NOMBRES_PADRE); cst.setString(2, AP_NOMBRES_MADRE); cst.setString(3, ID_TRABAJADOR); cst.setString(4, USER); cst.setString(5, FactoryConnectionDB.detalle_ip()); cst.execute(); } catch (SQLException ex) { throw new RuntimeException(ex.getMessage()); } catch (Exception e) { throw new RuntimeException("ERROR : " + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } return true; }
@Override public void INSERT_PADRES( String AP_NOMBRES_MADRE, String AP_NOMBRES_PADRE, String ID_TRABAJDOR, String US_MODIF, String IP_USUARIO) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_INSERT_PADRES( ?, ?, ?, ?, ?)}"); cst.setString(1, AP_NOMBRES_MADRE); cst.setString(2, AP_NOMBRES_PADRE); cst.setString(3, ID_TRABAJDOR); cst.setString(4, US_MODIF); cst.setString(5, IP_USUARIO); cst.execute(); } catch (SQLException ex) { throw new RuntimeException(ex.getMessage()); } catch (Exception e) { throw new RuntimeException("ERROR : " + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public List<Map<String, ?>> Listar_Padres(String id) { List<Map<String, ?>> lista = new ArrayList<Map<String, ?>>(); try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); String sql = "select id_trabajador,AP_NOMBRES_PADRE,AP_NOMBRES_MADRE from RHTM_TRABAJADOR where id_trabajador='" + id + "'"; ResultSet rs = this.conn.query(sql); while (rs.next()) { Map<String, Object> rec = new HashMap<String, Object>(); rec.put("id", rs.getString("id_trabajador")); rec.put("padre", rs.getString("AP_NOMBRES_PADRE")); rec.put("madre", rs.getString("AP_NOMBRES_MADRE")); lista.add(rec); } rs.close(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("ERROR"); } finally { try { this.conn.close(); } catch (Exception e) { } } return lista; }
@Override public List<Detalle_Privilegio> List_det_pr_id(String id_pr) { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); String sql = "select * from RHTD_DETALLE_PRIVILEGIO where ID_DETALLE_PRIVILEGIO ='" + id_pr + "'"; List<Detalle_Privilegio> list = new ArrayList<Detalle_Privilegio>(); try { ResultSet rs = this.conn.query(sql); while (rs.next()) { Detalle_Privilegio icd = new Detalle_Privilegio(); icd.setId_detalle_privilegio(rs.getString("id_detalle_privilegio")); icd.setId_rol(rs.getString("id_rol")); icd.setNu_orden(rs.getInt("nu_orden")); icd.setId_privilegio(rs.getString("id_privilegio")); icd.setEs_detalle_privilegio(rs.getString("es_detalle_privilegio")); list.add(icd); } } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } return list; }
@Override public void Registrar_Detalle_Priv( String id_rol, String nu_orden, String id_priv, String es_detalle_priv) { CallableStatement cst; try { String id_det_priv = ""; this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_INSERT_DET_PRIV(?,?,?,?,?)}"); cst.setString(1, id_det_priv.trim()); cst.setString(2, id_rol.trim()); cst.setString(3, nu_orden.trim()); cst.setString(4, id_priv.trim()); cst.setString(5, es_detalle_priv.trim()); cst.execute(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public List<X_Detalle_Privilegio> List_det_pri_id(String id_pr) { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); String sql = "select d.*,r.NO_ROL from RHTD_DETALLE_PRIVILEGIO d, RHTR_ROL r where d.ID_ROL=r.ID_ROL and d.ID_DETALLE_PRIVILEGIO ='" + id_pr + "'"; List<X_Detalle_Privilegio> list = new ArrayList<X_Detalle_Privilegio>(); try { ResultSet rs = this.conn.query(sql); while (rs.next()) { X_Detalle_Privilegio x = new X_Detalle_Privilegio(); x.setId_detalle_privilegio(rs.getString("Id_detalle_privilegio")); x.setEs_datalle_privilegio(rs.getString("ES_DETALLE_PRIVILEGIO")); x.setNu_orden(rs.getInt("Nu_orden")); x.setNo_rol(rs.getString("No_rol")); x.setId_rol(rs.getString("Id_rol")); x.setId_privilegio(rs.getString("Id_privilegio")); list.add(x); } } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } return list; }
@Override public void MOD_PADRE_MADRE_CONYUGUE( String AP_NOMBRES_PADRE, String AP_NOMBRES_MADRE, String ES_TRABAJA_UPEU_CONYUGUE, String AP_NOMBRES_C, String FE_NAC_C, String ID_TIPO_DOC_C, String NU_DOC_C, String LI_INSCRIPCION_VIG_ESSALUD_C, String ID_TRABAJADOR, String US_MODIF, String IP_USUARIO) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_MOD_PADRE_MAD_CON( ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?)}"); cst.setString(1, AP_NOMBRES_PADRE); cst.setString(2, AP_NOMBRES_MADRE); cst.setString(3, ES_TRABAJA_UPEU_CONYUGUE); cst.setString(4, AP_NOMBRES_C); cst.setString(5, FE_NAC_C); cst.setString(6, ID_TIPO_DOC_C); cst.setString(7, NU_DOC_C); cst.setString(8, LI_INSCRIPCION_VIG_ESSALUD_C); cst.setString(9, ID_TRABAJADOR); cst.setString(10, US_MODIF); cst.setString(11, IP_USUARIO); cst.execute(); } catch (SQLException ex) { throw new RuntimeException(ex.getMessage()); } catch (Exception e) { throw new RuntimeException("ERROR : " + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public void INSERT_CONYUGUE( String ES_TRABAJA_UPEU_CONYUGUE, String AP_NOMBRES_CONYUGUE, String FE_NAC_CONYUGUE, String TI_DOC_ID, String NU_DOC, String LI_INSCRIPCION_VIG_ESSALUD, String US_MODIF, String IP_USUARIO, String ID_TRABAJADOR, String ID_CONYUGUE) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_INSERT_CONYUGUE( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}"); cst.setString(1, ES_TRABAJA_UPEU_CONYUGUE); cst.setString(2, AP_NOMBRES_CONYUGUE); cst.setString(3, c.convertFecha(FE_NAC_CONYUGUE)); cst.setString(4, TI_DOC_ID); cst.setString(5, NU_DOC); cst.setString(6, LI_INSCRIPCION_VIG_ESSALUD); cst.setString(7, US_MODIF); cst.setString(8, InetAddress.getLocalHost().getHostAddress()); // cst.setString(9, null); cst.setString(9, ID_TRABAJADOR); cst.setString(10, ID_CONYUGUE); cst.execute(); } catch (SQLException ex) { throw new RuntimeException(ex.getMessage()); } catch (UnknownHostException ex) { throw new RuntimeException(ex.getMessage()); } catch (Exception e) { throw new RuntimeException("ERROR : " + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public void Elim_Detalle_Priv(String ID_pri_rol) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_ELIMINAR_DET_PRI(?)}"); cst.setString(1, ID_pri_rol); cst.execute(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public void Act_r_pr(String id_pr_r) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_ACTIVAR_DET_PRI(?)}"); cst.setString(1, id_pr_r); cst.execute(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }
@Override public void Mod_Detalle_Priv( String id_det_pri, int nu_orden, String id_priv, String es_detalle_priv) { CallableStatement cst; try { this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE); cst = conn.conex.prepareCall("{CALL RHSP_MOD_DET_PRIV(?,?,?,?)}"); cst.setString(1, id_det_pri); cst.setString(2, id_priv); cst.setInt(3, nu_orden); cst.setString(4, es_detalle_priv); cst.execute(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("Error :" + e.getMessage()); } finally { try { this.conn.close(); } catch (Exception e) { throw new RuntimeException(e.getMessage()); } } }