public class UsersDAO {

    @Autowired
    SessionFactory factory;

    public int add(User user) {
        Session session = factory.openSession();
        Serializable id = session.save(user);
        session.close();
        return (Integer) id;
    }
}

@Entity
@Table(name = "users")
@NamedQuery(name = User.SELECT_USER_COUNT_BY_LOGIN, query = "select count(id) from User where email=:login")
public class User {

    public static final String SELECT_USER_COUNT_BY_LOGIN = "select_user_count_by_login";

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    @Column(name = "date", columnDefinition = "Integer", nullable = false)
    private int date;
    @Column(name = "name", columnDefinition = "varchar(255)", nullable = false)
    private String name;
    @Column(name = "userName", columnDefinition = "varchar(256)", nullable = false)
    private String userName;
    @Column(name = "password", columnDefinition = "varchar(256)", nullable = false)
    private String password;
    @Column(name = "country", columnDefinition = "varchar(256)", nullable = false)
    private String country;
    @Column(name = "phone", columnDefinition = "varchar(256)", nullable = false)
    private String phone;
    @Column(name = "email", columnDefinition = "varchar(256)", nullable = false, unique = true)
    private String email;

    public User() {}

db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://localhost:5432/personal
db.username=postgres
db.password=root

hibernate.dialect=org.hibernate.dialect.PostgreSQL9Dialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update