public static List<Contrato> findByClient(String tipoDoc, int numDoc, Connection con)
throws SQLException, ClassNotFoundException, IOException {
PreparedStatement ps =
con.prepareStatement(
"SELECT * FROM Contrato,cliente, inmueble WHERE contrato.clienteId = ? and"
+ "inmueble.inmuebleId = contrato.inmuebleId and cliente.clienteId = contrato.clienteId");
/* promoValida = new PromoValida(rs.getInt("idpromoValida"),
new Calzado(rs.getInt("codigo"), rs.getString("marca"),
rs.getString("modelo"), rs.getString("color"),
rs.getInt("talle")),
new Promocion(
rs.getInt("idPromo"), rs.getString("descripcion"),
rs.getInt("numeroMaximoItems")));
promosValidas.add(promoValida);*/
ps.setLong(1, ClienteService.findByTipoDocAndNumDoc(tipoDoc, numDoc, con).getClienteId());
ResultSet rs = ps.executeQuery();
Contrato acc = null;
if (rs.next()) {
acc =
new Contrato(
rs.getLong("ContratoId"),
rs.getString("userName"),
rs.getString("password"),
rs.getString("permisos"));
}
rs.close();
return acc;
}
