com.glstreams.exception.DatabaseException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
------------- ---------------- ---------------
------------- Standard Error -----------------
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)我的SQL为:
select * from User where UserName ='admin' AND Password='admin'
或
select UserId from User where UserName ='admin' AND Password='admin'都不行。我的User表里,有的字段为NULL,但UserName,和Password是有值的。
------------- ---------------- ---------------
------------- Standard Error -----------------
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)我的SQL为:
select * from User where UserName ='admin' AND Password='admin'
或
select UserId from User where UserName ='admin' AND Password='admin'都不行。我的User表里,有的字段为NULL,但UserName,和Password是有值的。
select UserId from User where UserName='admin' AND Password='admin'
看看
可能是因为有空格
select User.UserId from User where User.UserName='admin' and User.Password='admin'
看这条语句应该没有错误,你仔细检查数据库名称对不对?