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