EntityManager 查詢指定字段

@PersistenceContext

private EntityManager em;

@Override

public User findUserByAccount(String account) {

User user = new User();

if(account != null){

String sql = "select user_id,create_time,create_user_id,update_time,update_user_id,account,avatar,name,password,role_id from user ORDER BY user_id ASC";

Query query = em.createNativeQuery(sql,User.class); 

user = (User) query.getSingleResult(); //擷取單個結果

List<User> list = query.getResultList(); //擷取結果集

}

return user;

}