@Override
public Pay mapRow(ResultSet rs, int rowNum) throws SQLException {
Pay pay = new Pay();
pay.setId(rs.getInt("id"));
Timestamp timestamp = rs.getTimestamp("time");
if (timestamp != null) {
pay.setTime(new java.util.Date(timestamp.getTime()));
}
pay.setDemand_id(rs.getString("demand_id"));
Manufacturer manufacturer =
new Manufacturer(rs.getInt("manufacturer_id"), rs.getString("manufacturer_name"), null);
pay.setManufacturer(manufacturer);
User user =
new User(
rs.getInt("user_id"),
rs.getString("user_name"),
rs.getString("user_email"),
rs.getString("user_login"));
pay.setUser(user);
pay.setStorno((rs.getInt("storno") == 0 ? false : true));
pay.setSumm(rs.getDouble("summ"));
pay.setNumDoc(rs.getString("numDoc"));
pay.setClient(
new Client(
rs.getInt("client_id"),
rs.getString("client_name"),
rs.getString("client_email"),
rs.getString("client_address"),
null));
return pay;
}
