Do I need multiple result sets to execute SQL statement with multiple parameters in JSP

Question

In my JSP I use the following code to fetch data from the database:

select * from parks where parkArea = 'abc' AND parkType = 'abcd'

I can't write the statement to execute correctly in my JSP, this is what I've tried:

statement = con.prepareStatement("select * from parks ("WHERE parkArea like "abc"") + ("AND parkType = "abcd"")")

What am i doing wrong?

Show us your full code so that we'd be able to tell. – skuntsel Apr 29 '13 at 12:40 — skuntsel, Apr 29 '13 at 12:40
maybe you need to escape the quotes in your sql – John Kane Apr 29 '13 at 12:42 — John Kane, Apr 29 '13 at 12:42
Could you post the error you are getting? – John Kane Apr 29 '13 at 12:49 — John Kane, Apr 29 '13 at 12:49

score 2 · Answer 1 · answered Apr 29 '13 at 12:41

2

select * from parks ("WHERE parkArea like "abc"") + ("AND parkType = "abcd"")"

should be

"select * from parks WHERE parkArea like 'abc%' AND parkType = 'abcd')"

answered Apr 29 '13 at 12:41

Satya

8,693
5
34
55

In 'abcd')" -> is ) needed? – Gnanz Apr 29 '13 at 12:51

score 0 · Accepted Answer · answered Apr 29 '13 at 12:43

0

con.prepareStatement
("select * from parks WHERE parkArea like \"abc%\" AND parkType = \"abcd\"");

OR

con.prepareStatement
("select * from parks WHERE parkArea like 'abc' AND parkType = 'abcd'");

answered Apr 29 '13 at 12:43

AllTooSir

48,828
16
130
164

score 0 · Answer 3 · edited May 23 '17 at 12:18

0

One thing it could be is that you are not escaping your quotes. Try writing your inner quotes as \". It is difficult to determine the exact cause without seeing the error you are getting.

edited May 23 '17 at 12:18

Community

1
1

answered Apr 29 '13 at 12:50

John Kane

4,383
1
24
42

Do I need multiple result sets to execute SQL statement with multiple parameters in JSP

3 Answers3