EJBQL condition query for help in EJB, LIST array

flypigzj

I am using EJB to develop a web application. I created a user registry, mapped him as an entity, and made a simple query on the entity or by user.

There is no problem with searching by name. Now I want to combine with other systems, get a list of user names from other systems, and use the form LIST to list

Show listuser.
    I want to query in the registry all records where all usernames are contained in listuser. I want to use EJBSQL language to implement, but the experimental results are always unsuccessful

. Please help me analyze it.

   @PersistenceContext
    private EntityManager em;
 public List find (List listuserid)
{
       String connselect = "select OBJECT (o) from userinfo o where o.userID IN: userid";
            

Query query = em.createQuery (connselect);

               query.setParameter ("userid", listuserid);
   

          return query.getResultList ();
}




I found this usage in hibernate and setParameterlist method in hibernate, but I don't know why there isn't in EJB, as if I

Run to em.createQuery (connselect); and an error occurs.

leodutl

@PersistenceContext
private EntityManager em;
public List find(List listuserid){
Query query = em.createQuery("from userinfo o where o.userID IN(?1)");
query.setParameter(1, listuserid);
return query.getResultList();
}

flypigzj

Theleodutlupstairs, according to your method, can't get through, the same error.

leodutl

What is wrong?

flypigzj

After executing query.setParameter(1, listuserid); still catches an error, saying that it is a remote call error

flypigzj

Upstairsleodutl, I just tried it again, according to the method you said,
@PersistenceContext
private EntityManager em;
public List find(List listuserid){
Query query = em.createQuery("from userinfo o where o.userID IN(?1)");
query.setParameter(1, listuserid);
return query.getResultList();
}
When listuserid is a string type, there is no error, but when it is a LIST type, it is an error

syde8868

Is there any relationship with the type of entity BEAN defined by the host? query.setParameter(1, listuserid); the attribute type of the corresponding bean should also be of type String, so there is no error when the passed listuserid is of type String.

PS: I guessed it. I just learned EJB for less than 2 weeks. I don’t want to say something wrong, don’t BS I, let’s study together.

syde8868

@DataModel
private List<User> userList;//A view for display
@In(create=true)
@Out(required=false, scope=SESSION)
private User user;
...
public void findUsers() {
  Query query;
  query = em.createQuery("from User");
  query.setParameter("code", user.getUserCode());
  query.setParameter("userName",user.getUserName());
  userList = query.getResultList();
}


For reference, hehe, I wrote this easy to use, the other processing in the method body has been deleted, and the writing is the main one. ^^

syde8868

Part of the code on the front page

<h:dataTable var="uls" value="#{userList}" rendered="#{userList.rowCount>0}"
styleClass="table" headerClass="tableHeader" columnClasses="right80, right80, right80, .left60">
<h:column>
           <f:facet name="header">
            <h:outputText value="ユーザコード"/>
           </f:facet>
           <s:link value="#{uls.userCode}" action="#{userManager.select}" escape="false"/>
        </h:column>
        <h:column>
           <f:facet name="header">
            <h:outputText value="ユーザ名"/>
           </f:facet>
           <s:link value="#{uls.userName}" action="#{userManager.select}" escape="false"/>
        </h:column>
     </h:dataTable>

flypigzj

Can the person upstairs give all of the following functions, why can't I pass it?

public void findUsers() {
  Query query;
  query = em.createQuery("from User");
  query.setParameter("code", user.getUserCode());
  query.setParameter("userName",user.getUserName());
  userList = query.getResultList();
}