package ru.mrchebik.model;

import javax.persistence.*;

/**
* Created by mrchebik on 23.07.16.
*/
@Entity
@Table(name = "Notes")
public class Note {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(unique = true)
    private long id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "USER_ID", nullable = false)
    private User user;

    @Column(nullable = false, length = 25)
    private String title;

    @Column(nullable = false)
    private String text;

    public Note() {

    }

    public Note(final long id, final String title, final String text) {
        this.id = id;
        this.title = title;
        this.text = text;
    }

    public Note(final User user, final String title, final String text) {
        this.user = user;
        this.title = title;
        this.text = text;
    }

    public User getUser() {
        return user;
    }

    public void setUser(final User user) {
        this.user = user;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(final String title) {
        this.title = title;
    }

    public String getText() {
        return text;
    }

    public void setText(final String text) {
        this.text = text;
    }

    public long getId() {
        return id;
    }

    public void setId(final long id) {
        this.id = id;
    }

}

package ru.mrchebik.model;

import javax.persistence.*;
import java.util.HashSet;
import java.util.Set;

/**
* Created by mrchebik on 22.07.16.
*/
@Entity
@Table(name = "Users")
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(unique = true, nullable = false)
    private long USER_ID;

    @Column(unique = true, nullable = false, length = 12)
    private String username;

    @Column(nullable = false, length = 16)
    private String password;

    @OneToMany(fetch = FetchType.LAZY, orphanRemoval = true)
    private Set<Note> notes = new HashSet<Note>(0);

    public User() {

    }

    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(final String name) {
        this.username = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(final String password) {
        this.password = password;
    }

    public long getUSER_ID() {
        return USER_ID;
    }

    public void setUSER_ID(final long id) {
        this.USER_ID = id;
    }

    public Set<Note> getNotes() {
        return this.notes;
    }

    public void setNotes(Set<Note> notes) {
        this.notes = notes;
    }
}

package ru.mrchebik.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.repository.query.Param;
import ru.mrchebik.model.Note;

import java.util.List;

/**
* Created by mrchebik on 07.08.16.
*/
public interface NoteRepository extends JpaRepository<Note, Long> {
    List<Note> findByUser(@Param("USER_ID") long id);
}

CREATE TABLE Users
(
    USER_ID BIGINT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    username VARCHAR(12) NOT NULL,
    password VARCHAR(16) NOT NULL
);
CREATE UNIQUE INDEX username ON Users (username);
CREATE TABLE Notes
(
    id BIGINT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    USER_ID BIGINT(20) NOT NULL,
    title VARCHAR(25) NOT NULL,
    text VARCHAR(255) NOT NULL,
    CONSTRAINT FK47F5EA160804239 FOREIGN KEY (USER_ID) REFERENCES Users (USER_ID)
);
CREATE INDEX FK47F5EA160804239 ON Notes (USER_ID);

@Query("select note.title, note.text from ru.mrchebik.model.Note note where note.user.userId = :userId")

select note0_.id as id1_0_, note0_.text as text2_0_, note0_.title as title3_0_, note0_.userId as userId4_0_ from Notes note0_ left outer join Users user1_ on note0_.userId=user1_.userId where user1_.userId=?

@Override
    public List<Note> findNotes(final long userId) {
        return commandFactory.transaction(() -> {
            Query query = getSession().createQuery("select N.id, N.title, N.text from ru.mrchebik.model.Note N where USER_ID = :USER_ID").setLong("USER_ID", userId);
            List<Note> note = new ArrayList<Note>();
            Iterator itr = query.list().iterator();
            while (itr.hasNext()) {
                Object[] objects = (Object[]) itr.next();

                long id = Long.parseLong(String.valueOf(objects[0]));
                String title = String.valueOf(objects[1]);
                String text = String.valueOf(objects[2]);

                note.add(new Note(id, null, title, text));
            }
            return note;
        });
    }