软件环境
spring springmvc mybatis
数据库:mysql
报错信息:
mybatis 修改关联表报错Parameter 'key_dm' not found. Available parameters are [0, member, param1, param2]
代码提示:
//mybatis.xml代码<?xml version="1.0" encoding="UTF-8"?>
mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
UPDATE dt_member_permission AS t1
LEFT JOIN dt_member AS t2 ON t1.member_id=t2.id
t1.key_dm=#{_key_dm},
WHERE t1.ttys=#{ttys}
AND t2.phone=#{phone}
AND t2.password=#{password}