sql 传参 获取mybatis_MybatisSQL语句动态查询,传入有值,数据库有值,数据查不出来。...

图1

图2

代码如下

private RoleService roleService;

private AdminUserRoleService adminUserRoleService;

@Before

public void befor() {

ApplicationContext applicationContext = new ClassPathXmlApplicationContext("classpath:/spring/spring-content.xml");

this.roleService = applicationContext.getBean(RoleService.class);

this.adminUserRoleService = applicationContext.getBean(AdminUserRoleService.class);

}

@Test

public void test() {

List adminUserRoleList =

adminUserRoleService.queryByField("role_id",""+19);

System.out.println(adminUserRoleList.size());

}

映射文件

SELECT *

FROM wady_admin_user_role

WHERE #{0} = #{1}

求解疑惑，为什么SQL能在MySql里面查询,java里面就查不出来

——补充——

SELECT

FROM wady_admin_user_role

WHERE #{0} =19

SELECT

FROM wady_admin_user_role

WHERE role_id =#{1}

问题应该是， Mybatis的SQL语句查询的列为什么不能通过传入参数代替