CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
            CriteriaQuery<Object> criteriaQuery = criteriaBuilder.createQuery();
            Root<Object> from = criteriaQuery.from(classname);
            CriteriaQuery<Object> select = criteriaQuery.select(from);
            Predicate main_predicate = criteriaBuilder.equal(from.get("mcod").as(classname), Integer.valueOf(lpucode));
            criteriaQuery.where(main_predicate);
            TypedQuery<Object> typedQuery = em.createQuery(select);
            List some_ret = typedQuery.getResultList();

    @Column(name = "INDEX", length = 6)
    private String index;
    @Column(name = "RGN1")
    private Short rgn1;
    @Column(name = "RGN2")
    private Short rgn2;

    @Size(max = 6)
    @Column(name = "\"INDEX\"", length = 6)
    private String index;