select
<include refid="Base_Column_List"/>
from sys_permission
where id = -sharp{id,jdbcType=INTEGER}
</select>
</mapper> if you change dao to
List < SysRole > getRoleWithPermission (Integer id);
, three records are returned, and each role corresponds to a permission.
because it is true that the sql statement finds three records
if you use < collection select= "> to find it, you can pass in only one value. So the result can only be one record.
if you use < collection resultMap >, mybatis will merge multiple checked results into collection by pressing the primary key id.
</collection>
</resultMap>error prompt use: <dependency> <groupId>org.springframework< groupId> <artifactId>spring-orm< artifactId> <version>4.3.14.RELEASE< version> < dependency> <depend...
I m sorry about my careless problems. < span> ...
how should I open the index implementation on the home page of the website to query the relevant data from the background database and then bind it to the page? ...
the following error should be related to the injection of the data source! But why can it be solved by introducing spring-jdbc as a jar package? spring-jdbcjar:(): : Exception encountered during context initialization - cancelling refresh attempt: o...