Spring Hibernate获取选定列

Question

我试图使用hibernate获取一些特定的列，但此查询总是失败。

@Override
public Users findByEmail(String emailID) {
    // TODO Auto-generated method stub
    try{

        List<Users> users = new ArrayList<Users>();

        users = this.sessionFactory.getCurrentSession().createQuery("SELECT userID, firstName, lastName, imageURL, password, emailID, enabled FROM Users WHERE emailID = :email_ID")
                .setParameter("email_ID", emailID).list();

        if(users.size() > 0)
            return (Users)users.get(0);
        else
            return null;
    }
    catch(Exception exc)
    {
        log.error(exc.getMessage());
        return null;
    }
}

此查询总是失败，因此我使用以下查询

    @Override
public Users findByEmail(String emailID) {
    // TODO Auto-generated method stub
    try{

        List<Users> users = new ArrayList<Users>();

        users = this.sessionFactory.getCurrentSession().createQuery("FROM Users WHERE emailID = :email_ID")
                .setParameter("email_ID", emailID).list();

        if(users.size() > 0)
            return (Users)users.get(0);
        else
            return null;
    }
    catch(Exception exc)
    {
        log.error(exc.getMessage());
        return null;
    }
}

如何使用hibernate只获取特定列，而不是获取20个列？

Answer 1

每当您选择多列时，查询将返回列表

List<Object[]> rows = this.sessionFactory.getCurrentSession()
                     .createQuery("SELECT userID, firstName, lastName,
                      imageURL, password,emailID, enabled 
                       FROM Users WHERE emailID = :email_ID")
                      .setParameter("email_ID", emailID).list();

现在迭代

(Object[] row: rows) {
    System.out.println(" ------------------- ");
    System.out.println("userid: " + row[0]);
    System.out.println("firstName: " + row[1]);
    User u=new User();
    u.setUserId(row[0]);
    u.setFirstName(row[1]);
    u.setLastName(row[2]);

}

其他行也一样

参考文献

Answer 2

您可以尝试使用结果转换器

List<User> users = session
.createQuery(
"SELECT userID as userID, firstName as firstName FROM Users WHERE emailID = :email_ID")
.setParameter("email_ID", emailID)
.setResultTransformer(new AliasToBeanResultTransformer(User.class)).list();

您需要将投影别名指定为firstName，但可以不使用它。