public ArrayList sub_respuesta_carta(String id_codrspta) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "SELECT id_codrspta_sub,c_desrspta_sub FROM rspta_carta "
               + "WHERE c_codest = 'ACT' and id_codrspta like '"
               + id_codrspta
               + "' || '%'");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setId_codrspta_sub(rs.getString("id_codrspta_sub"));
     ges.setC_desrspta_sub(rs.getString("c_desrspta_sub"));
     lista.add(ges);
   }
   return lista;
 }
 public ArrayList datos_tiposubrespuesta(String id_codtcon, String id_codtres) throws Exception {
   Conexion co = new Conexion();
   ArrayList lista = new ArrayList();
   ResultSet rs =
       co.listar(
           "SELECT id_codtres_sub,id_codtcon,id_codtres,c_destres_sub FROM tipo_subrspta"
               + " WHERE c_codest='ACT' and id_codtcon='"
               + id_codtcon
               + "' AND id_codtres='"
               + id_codtres
               + "'");
   Gestion ges = new Gestion();
   while (rs.next()) {
     ges = new Gestion();
     ges.setId_codrspta_sub(rs.getString("id_codtres_sub"));
     ges.setC_desrspta_sub(rs.getString("c_destres_sub"));
     lista.add(ges);
   }
   return lista;
 }