代码错误
com.microsoft.sqlserver.jdbc.SQLServerException: 无法绑定由多个部分组成的标识符 “t.ZFRQ”。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement
P
r
e
p
S
t
m
t
E
x
e
c
C
m
d
.
d
o
E
x
e
c
u
t
e
(
S
Q
L
S
e
r
v
e
r
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
338
)
a
t
c
o
m
.
m
i
c
r
o
s
o
f
t
.
s
q
l
s
e
r
v
e
r
.
j
d
b
c
.
T
D
S
C
o
m
m
a
n
d
.
e
x
e
c
u
t
e
(
I
O
B
u
f
f
e
r
.
j
a
v
a
:
4026
)
a
t
c
o
m
.
m
i
c
r
o
s
o
f
t
.
s
q
l
s
e
r
v
e
r
.
j
d
b
c
.
S
Q
L
S
e
r
v
e
r
C
o
n
n
e
c
t
i
o
n
.
e
x
e
c
u
t
e
C
o
m
m
a
n
d
(
S
Q
L
S
e
r
v
e
r
C
o
n
n
e
c
t
i
o
n
.
j
a
v
a
:
1416
)
a
t
c
o
m
.
m
i
c
r
o
s
o
f
t
.
s
q
l
s
e
r
v
e
r
.
j
d
b
c
.
S
Q
L
S
e
r
v
e
r
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
C
o
m
m
a
n
d
(
S
Q
L
S
e
r
v
e
r
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
185
)
a
t
c
o
m
.
m
i
c
r
o
s
o
f
t
.
s
q
l
s
e
r
v
e
r
.
j
d
b
c
.
S
Q
L
S
e
r
v
e
r
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
S
t
a
t
e
m
e
n
t
(
S
Q
L
S
e
r
v
e
r
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
160
)
a
t
c
o
m
.
m
i
c
r
o
s
o
f
t
.
s
q
l
s
e
r
v
e
r
.
j
d
b
c
.
S
Q
L
S
e
r
v
e
r
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
(
S
Q
L
S
e
r
v
e
r
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
320
)
a
t
c
o
m
.
m
c
h
a
n
g
e
.
v
2.
c
3
p
0.
i
m
p
l
.
N
e
w
P
r
o
x
y
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
(
N
e
w
P
r
o
x
y
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
67
)
a
t
s
u
n
.
r
e
f
l
e
c
t
.
G
e
n
e
r
a
t
e
d
M
e
t
h
o
d
A
c
c
e
s
s
o
r
44.
i
n
v
o
k
e
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
s
u
n
.
r
e
f
l
e
c
t
.
D
e
l
e
g
a
t
i
n
g
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
(
D
e
l
e
g
a
t
i
n
g
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
j
a
v
a
:
43
)
a
t
j
a
v
a
.
l
a
n
g
.
r
e
f
l
e
c
t
.
M
e
t
h
o
d
.
i
n
v
o
k
e
(
M
e
t
h
o
d
.
j
a
v
a
:
498
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
l
o
g
g
i
n
g
.
j
d
b
c
.
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
L
o
g
g
e
r
.
i
n
v
o
k
e
(
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
L
o
g
g
e
r
.
j
a
v
a
:
59
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:320) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67) at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.
PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)atcom.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)atcom.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)atcom.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)atcom.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:320)atcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67)atsun.reflect.GeneratedMethodAccessor44.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:498)atorg.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)atcom.sun.proxy.Proxy50.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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
:
433
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) at com.sun.proxy.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)atcom.sun.proxy.Proxy18.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy27.selectCountByParams(Unknown Source)
at cn.njhq.wechat.impl.ZfjlServiceImpl.selectCountByParams(ZfjlServiceImpl.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor
1.
p
r
o
c
e
e
d
W
i
t
h
I
n
v
o
c
a
t
i
o
n
(
T
r
a
n
s
a
c
t
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
j
a
v
a
:
99
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
t
r
a
n
s
a
c
t
i
o
n
.
i
n
t
e
r
c
e
p
t
o
r
.
T
r
a
n
s
a
c
t
i
o
n
A
s
p
e
c
t
S
u
p
p
o
r
t
.
i
n
v
o
k
e
W
i
t
h
i
n
T
r
a
n
s
a
c
t
i
o
n
(
T
r
a
n
s
a
c
t
i
o
n
A
s
p
e
c
t
S
u
p
p
o
r
t
.
j
a
v
a
:
281
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
t
r
a
n
s
a
c
t
i
o
n
.
i
n
t
e
r
c
e
p
t
o
r
.
T
r
a
n
s
a
c
t
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
T
r
a
n
s
a
c
t
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
j
a
v
a
:
96
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
a
o
p
.
f
r
a
m
e
w
o
r
k
.
R
e
f
l
e
c
t
i
v
e
M
e
t
h
o
d
I
n
v
o
c
a
t
i
o
n
.
p
r
o
c
e
e
d
(
R
e
f
l
e
c
t
i
v
e
M
e
t
h
o
d
I
n
v
o
c
a
t
i
o
n
.
j
a
v
a
:
179
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
a
o
p
.
i
n
t
e
r
c
e
p
t
o
r
.
E
x
p
o
s
e
I
n
v
o
c
a
t
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
E
x
p
o
s
e
I
n
v
o
c
a
t
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
j
a
v
a
:
92
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
a
o
p
.
f
r
a
m
e
w
o
r
k
.
R
e
f
l
e
c
t
i
v
e
M
e
t
h
o
d
I
n
v
o
c
a
t
i
o
n
.
p
r
o
c
e
e
d
(
R
e
f
l
e
c
t
i
v
e
M
e
t
h
o
d
I
n
v
o
c
a
t
i
o
n
.
j
a
v
a
:
179
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
a
o
p
.
f
r
a
m
e
w
o
r
k
.
J
d
k
D
y
n
a
m
i
c
A
o
p
P
r
o
x
y
.
i
n
v
o
k
e
(
J
d
k
D
y
n
a
m
i
c
A
o
p
P
r
o
x
y
.
j
a
v
a
:
208
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.
1.proceedWithInvocation(TransactionInterceptor.java:99)atorg.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)atcom.sun.proxy.Proxy41.selectCountByParams(Unknown Source)
at cn.njhq.wechat.controller.ZfjlController.selectZfjlAndSkrxxByParams(ZfjlController.java:146)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
仔细一看
sql语句写错啦
select count(*) from TB_ZFJL where QDZFJG = 1 and HDZFJG = 1 and t.ZFRQ between ? and ?
[QC] DEBUG [http-bio-8080-exec-5] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(159) | ==> Parameters: 2019-03-06(String), 2019-03-28(String)