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;
}