德比遇到:“@” [英] derby Encountered: "@"
本文介绍了德比遇到:“@”的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我运行sql查询时
从GRABBER.CANDIDATES中选择*,其中 EMAIL=xxx@xxxxx.xx
i get
错误代码-1,SQL状态42X02:第1行第55列的词汇错误。遇到:" @" (64),之后:"。
当我从GRABBER.CANDIDATES中选择*时EMAIL = mmmm
i得到一个列mmmm的错误不存在
当我从GRABBER.CANDIDATES运行选择EMAIL时id = 1
它工作正常
?
?
谢谢
when i run sql query
select * from GRABBER.CANDIDATES where EMAIL=xxx@xxxxx.xx
i get
Error code -1, SQL state 42X02: Lexical error at line 1, column 55. Encountered: "@" (64), after : "".
when i do select * from GRABBER.CANDIDATES where EMAIL=mmmm
i get an error that column "mmmm" doesnt exists
when i run select EMAIL from GRABBER.CANDIDATES where id=1
it works fine
?
?
thank You
推荐答案
使用围绕这些String值的单引号;更好的是,为此目的使用PreparedStatements,他们为你做了非常好的工作。
亲切的问候,
Jos
Use single quotes around those String values; better yet, use PreparedStatements for that purpose, they do the nitty gritty work for you.
kind regards,
Jos
谢谢你Jos
i do
resultSet.last();
this.numberOfRows = resultSet .getRow();
来获取行数
然后我想将这些记录作为地图返回
但是当我这样做的时候则resultset.last();它没有显示任何行
我如何回到第一条记录?
thank You Jos
i do
resultSet.last();
this.numberOfRows = resultSet.getRow();
to get the number of rows
but then i want to return these records as a map
but when i do resultSet.last(); it doesnt display any rows
how do i come back to the first record?
我做了resultSet.first();但它不显示记录
i did resultSet.first(); but it doesnt display records
这篇关于德比遇到:“@”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文