mybatis-mapper | Mybatis框架实现用户订单管理的综合查询功能，包含用户，订单，订单详细，商品详细。 | Object-Relational Mapping library

You seem to be confused about input and output parameters.
As the procedure declares no OUT parameter, the result will be mapped to a different object.
I'll use the new class below for this explanation.

You do not need SqlSession, MyBatis uses its own implementation, the only thing you need to do is to create MyBatis configuration and set all its dependencies.

Simply put, you need to do following:

Create your POJO:

Problem is with your mybatis config:

Here and now, I have not resources to clone and run your project to confirm what I will say. But I will on Monday if necessary and in the meantime, the following may be a track:

I think it does not work because something very important is missing: the SqlSessionFactory.

mybatis-cdi doc states in the first paragraph:

The SqlSessionFactory is the source of any MyBatis bean so first you need to create one (at least) and let the container know about it existence.

Indeed, there is no reason to obtain a Mapper instance if there is no Session. if @Mapper annotation was sufficient, it could only provide an empty shell because not link to any underlying datasource. Then if there is no Mapper, it cannot be injected into the EJB, that's what Weld complains about.

When deployment succeeds, is it with the @Inject private AccountDao accountDao? I don't see why Weld would allow injecting with nothing. But if it does, check accountDao value (debug break point or log).

Your condition is put twice in the query.

Once correctly by the code inside the if and a second time by the code after the if statement.

Your query ends with "MY_COLUMN IN ?":