这篇博客主要解决了在使用MyBatis时遇到的'Parameter 'employeeNum' not found.'异常。错误原因是参数未被正确映射。解决方法是在MAPPER接口类中的方法参数前添加注解@RequestParam('你的列名')，确保参数与SQL查询中的列名匹配。
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘employeeNum’ not found. Available parameters are [arg0, name, param1, param2]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate
S
q
l
S
e
s
s
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
S
q
l
S
e
s
s
i
o
n
T
e
m
p
l
a
t
e
.
j
a
v
a
:
446
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)atcom.sun.proxy.Proxy20.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at com.baomidou.mybatisplus.core.override.PageMapperMethod.executeForMany(PageMapperMethod.java:173)
at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:86)
at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)
at com.sun.proxy.$Proxy21.selectEmployeeByEmpNumorName(Unknown Source)
at com.hrms.service.impl.MessageServiceImpl.selectEmployeeByEmpNumorName(MessageServiceImpl.java:30)
at hrms.test.Service.MessageTest.TestGetEmpByempNum_Name(MessageTest.java:25)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner
2.
e
v
a
l
u
a
t
e
(
P
a
r
e
n
t
R
u
n
n
e
r
.
j
a
v
a
:
268
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
t
e
s
t
.
c
o
n
t
e
x
t
.
j
u
n
i
t
4.
s
t
a
t
e
m
e
n
t
s
.
R
u
n
B
e
f
o
r
e
T
e
s
t
C
l
a
s
s
C
a
l
l
b
a
c
k
s
.
e
v
a
l
u
a
t
e
(
R
u
n
B
e
f
o
r
e
T
e
s
t
C
l
a
s
s
C
a
l
l
b
a
c
k
s
.
j
a
v
a
:
61
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
t
e
s
t
.
c
o
n
t
e
x
t
.
j
u
n
i
t
4.
s
t
a
t
e
m
e
n
t
s
.
R
u
n
A
f
t
e
r
T
e
s
t
C
l
a
s
s
C
a
l
l
b
a
c
k
s
.
e
v
a
l
u
a
t
e
(
R
u
n
A
f
t
e
r
T
e
s
t
C
l
a
s
s
C
a
l
l
b
a
c
k
s
.
j
a
v
a
:
70
)
a
t
o
r
g
.
j
u
n
i
t
.
r
u
n
n
e
r
s
.
P
a
r
e
n
t
R
u
n
n
e
r
.
r
u
n
(
P
a
r
e
n
t
R
u
n
n
e
r
.
j
a
v
a
:
363
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
t
e
s
t
.
c
o
n
t
e
x
t
.
j
u
n
i
t
4.
S
p
r
i
n
g
J
U
n
i
t
4
C
l
a
s
s
R
u
n
n
e
r
.
r
u
n
(
S
p
r
i
n
g
J
U
n
i
t
4
C
l
a
s
s
R
u
n
n
e
r
.
j
a
v
a
:
191
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
4.
r
u
n
n
e
r
.
J
U
n
i
t
4
T
e
s
t
R
e
f
e
r
e
n
c
e
.
r
u
n
(
J
U
n
i
t
4
T
e
s
t
R
e
f
e
r
e
n
c
e
.
j
a
v
a
:
86
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
.
r
u
n
n
e
r
.
T
e
s
t
E
x
e
c
u
t
i
o
n
.
r
u
n
(
T
e
s
t
E
x
e
c
u
t
i
o
n
.
j
a
v
a
:
38
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
.
r
u
n
n
e
r
.
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
r
u
n
T
e
s
t
s
(
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
j
a
v
a
:
538
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
.
r
u
n
n
e
r
.
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
r
u
n
T
e
s
t
s
(
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
j
a
v
a
:
760
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
.
r
u
n
n
e
r
.
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
r
u
n
(
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
j
a
v
a
:
460
)
a
t
o
r
g
.
e
c
l
i
p
s
e
.
j
d
t
.
i
n
t
e
r
n
a
l
.
j
u
n
i
t
.
r
u
n
n
e
r
.
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
m
a
i
n
(
R
e
m
o
t
e
T
e
s
t
R
u
n
n
e
r
.
j
a
v
a
:
206
)
C
a
u
s
e
d
b
y
:
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
B
i
n
d
i
n
g
E
x
c
e
p
t
i
o
n
:
P
a
r
a
m
e
t
e
r
′
e
m
p
l
o
y
e
e
N
u
m
′
n
o
t
f
o
u
n
d
.
A
v
a
i
l
a
b
l
e
p
a
r
a
m
e
t
e
r
s
a
r
e
[
a
r
g
0
,
n
a
m
e
,
p
a
r
a
m
1
,
p
a
r
a
m
2
]
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
M
a
p
p
e
r
M
e
t
h
o
d
2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206) Caused by: org.apache.ibatis.binding.BindingException: Parameter 'employeeNum' not found. Available parameters are [arg0, name, param1, param2] at org.apache.ibatis.binding.MapperMethod
2.evaluate(ParentRunner.java:268)atorg.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)atorg.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)atorg.junit.runners.ParentRunner.run(ParentRunner.java:363)atorg.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)atorg.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)atorg.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)atorg.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538)atorg.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760)atorg.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460)atorg.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206)Causedby:org.apache.ibatis.binding.BindingException:Parameter′employeeNum′notfound.Availableparametersare[arg0,name,param1,param2]atorg.apache.ibatis.binding.MapperMethodParamMap.get(MapperMethod.java:204)
at org.apache.ibatis.scripting.xmltags.DynamicContext
C
o
n
t
e
x
t
A
c
c
e
s
s
o
r
.
g
e
t
P
r
o
p
e
r
t
y
(
D
y
n
a
m
i
c
C
o
n
t
e
x
t
.
j
a
v
a
:
115
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
O
g
n
l
R
u
n
t
i
m
e
.
g
e
t
P
r
o
p
e
r
t
y
(
O
g
n
l
R
u
n
t
i
m
e
.
j
a
v
a
:
2685
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
A
S
T
P
r
o
p
e
r
t
y
.
g
e
t
V
a
l
u
e
B
o
d
y
(
A
S
T
P
r
o
p
e
r
t
y
.
j
a
v
a
:
114
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
S
i
m
p
l
e
N
o
d
e
.
e
v
a
l
u
a
t
e
G
e
t
V
a
l
u
e
B
o
d
y
(
S
i
m
p
l
e
N
o
d
e
.
j
a
v
a
:
212
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
S
i
m
p
l
e
N
o
d
e
.
g
e
t
V
a
l
u
e
(
S
i
m
p
l
e
N
o
d
e
.
j
a
v
a
:
258
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
O
g
n
l
.
g
e
t
V
a
l
u
e
(
O
g
n
l
.
j
a
v
a
:
470
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
o
g
n
l
.
O
g
n
l
.
g
e
t
V
a
l
u
e
(
O
g
n
l
.
j
a
v
a
:
434
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
s
c
r
i
p
t
i
n
g
.
x
m
l
t
a
g
s
.
O
g
n
l
C
a
c
h
e
.
g
e
t
V
a
l
u
e
(
O
g
n
l
C
a
c
h
e
.
j
a
v
a
:
44
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
s
c
r
i
p
t
i
n
g
.
x
m
l
t
a
g
s
.
T
e
x
t
S
q
l
N
o
d
e
ContextAccessor.getProperty(DynamicContext.java:115) at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2685) at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114) at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434) at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44) at org.apache.ibatis.scripting.xmltags.TextSqlNode
ContextAccessor.getProperty(DynamicContext.java:115)atorg.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2685)atorg.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114)atorg.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)atorg.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)atorg.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470)atorg.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434)atorg.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44)atorg.apache.ibatis.scripting.xmltags.TextSqlNodeBindingTokenParser.handleToken(TextSqlNode.java:77)
at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)
at org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:51)
at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33)
at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41)
at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
… 37 more
解决办法：
在你定义的MAPPER接口类中参数加上@param(“你的列名”)
直接上图
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
