Topic: 怎样查找或插入以'号开头的数据库中的数据 |
 Print this page
|
| 1.怎样查找或插入以'号开头的数据库中的数据 | Copy to clipboard |
|
Posted by: xcj84311 Posted on: 2006-01-08 13:58 各位大虾们: 我有一个数据库里面有些记录例如:  怎样才能查找以'号开头的数据库中的数据 或插入以'号开头数据到数据库中,用JAVA语言进行操作数据库. | |
| 2.Re:怎样查找或插入以'号开头的数据库中的数据 [Re: xcj84311] | Copy to clipboard |
|
Posted by: why Posted on: 2006-01-08 20:13 Which database is this? Usually two single quotation marks, '', would work. e.g. select grade from YOURTABLENAME where cno = '''3' insert into YOURTABLENMAE (cno, grade) values ('''4-doubleQuote''''', 77) This is the SQL standard. However, you don't have to do so if you're using the setString method of a JDBC PreparedStatement. | |
| 3.Re:怎样查找或插入以'号开头的数据库中的数据 [Re: xcj84311] | Copy to clipboard |
|
Posted by: xcj84311 Posted on: 2006-01-09 16:38 thanks to why ,the question have been solved . you answer is right. 谢谢 | |
 |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |