mybatis 常见错误

错误一：

mybatis is not known to the MapperRegistry.

先检查对应的mapper.xml文件的namespace是不是对应的全路径

比如写成

<!-- namespace:名称空间，全局的唯一标识 -->

<mapper namespace="com.rskj.core.data.mapper.JGhmdMapper">

而不是

<mapper namespace="JGhmdMapper">

错误二：

org.apache.ibatis.binding.BindingException

1. <resources>  
2.     <resource>  
3.         <directory>src/main/java</directory>  
4.         <includes>  
5.             <include>**/*.xml</include>  
6.         </includes>  
7.         <filtering>true</filtering>  
8.     </resource>  
9. </resources>  

错误三：Error getting generated key or setting result to parameter object：

### Error updating database.  Cause: org.apache.ibatis.executor.ExecutorException: Error getting generated key or setting result to parameter object. Cause: org.apache.ibatis.binding.BindingException: Parameter 'id' not found. Available parameters are [param18, param14, jid, param15, param16, param17, description, content, mac, req_id, score, bankSN, dataSourceTime, hits_overdue_score, param10, param11, param12, param13, returnUrl, param7, param8, param5, id_number, param6, param9, hits_break_score, param3, param4, hits_risk_score, param1, param2, createTime, phone, appID, name, imei]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO jghmd (    req_id,    appID,    bankSN,    createTime,    dataSourceTime,        content,    returnUrl,    name,    id_number,    phone,        imei,    mac,    hits_overdue_score,    hits_break_score,    hits_risk_score,        score,    jid,    description   )   VALUES    (     ?,     ?,     ?,     ?,     ?,               ?,     ?,     ?,     ?,     ?,          ?,     ?,     ?,     ?,     ?,          ?,     ?,     ?    );
### Cause: org.apache.ibatis.executor.ExecutorException: Error getting generated key or setting result to parameter object. Cause: org.apache.ibatis.binding.BindingException: Parameter 'id' not found

<insert id="insertTable" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
INSERT INTO jghmd (
req_id,
appID,
bankSN,
createTime,
dataSourceTime,

content,
returnUrl,
name,
id_number,
phone,

imei,
mac,
hits_overdue_score,
hits_break_score,
hits_risk_score,

score,
jid,
description
)
VALUES
(
#{req_id},
#{appID},
#{bankSN},
#{createTime},
#{dataSourceTime},


#{content},
#{returnUrl},
#{name},
#{id_number},
#{phone},

#{imei},
#{mac},
#{hits_overdue_score},
#{hits_break_score},
#{hits_risk_score},

#{score},
#{jid},
#{description}
);
</insert>