java sql help! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

java sql help!

java sql help!# Database - 数据库

i*t2002-10-24 07:10

1 楼

I write this query:
String query = null;
query = "SELECT * from messages where " + "destname = '" + name + "'";
ResultSet rs = statement.executeQuery (query);
After running, the system always says: SQLException :No data found
But if I go to the database using SQL: SELECT * from messages where destname =
'clinton'; it works and finds data. What is wrong?

g*n2002-10-24 07:10

2 楼

Check the value of name

【在 i*****t 的大作中提到】

: I write this query:
: String query = null;
: query = "SELECT * from messages where " + "destname = '" + name + "'";
: ResultSet rs = statement.executeQuery (query);
: After running, the system always says: SQLException :No data found
: But if I go to the database using SQL: SELECT * from messages where destname =
: 'clinton'; it works and finds data. What is wrong?