Query database

Hi,

I have a form with a text field that I write a ID number.
But however it only returns the first row i my table.

This is my code:

Code:

---

int id = Integer.parseInt(textID.getText());
       
        String query = "SELECT * FROM PersonTable WHERE ID = id";

---

This code works when i query directly in the server.
What could be wrong in my code?

Quote:

---

Originally Posted by asai

Hi,

I have a form with a text field that I write a ID number.
But however it only returns the first row i my table.

This is my code:

Code:

---

int id = Integer.parseInt(textID.getText());
       
        String query = "SELECT * FROM PersonTable WHERE ID = id";

---

This code works when i query directly in the server.
What could be wrong in my code?

---

"query" uses a single string? or an array of strings?

regards
dhilip

Quote:

---

Originally Posted by asai

Hi,

But however it only returns the first row i my table.
What could be wrong in my code?

---

it's a single string, so it returns only one string

regards
dhilip

Yes, it should only receive the one row with id = the input from the text field... :s:
But it receive only the first row no matter what i write in the textfield.

Quote:

---

Originally Posted by asai

Hi,

I have a form with a text field that I write a ID number.
But however it only returns the first row i my table.

This is my code:

Code:

---

int id = Integer.parseInt(textID.getText());
       
        String query = "SELECT * FROM PersonTable WHERE ID = id";

---

This code works when i query directly in the server.
What could be wrong in my code?

---

The text "id" in your query string has nothing to do with a variable with the same name; change that to:

Code:

---

        String query = "SELECT * FROM PersonTable WHERE ID = "+id;

---

or even better: use a PreparedStatement for that purpose. It has nothing to do with arrays of Strings or whatever; that is hogwash.

kind regards,

Jos

Thanks Jos, it worked like a charm!

Code:

---

String query = "SELECT * FROM PersonTable WHERE ID = "+id;

---

Quote:

---

Originally Posted by asai

Thanks Jos, it worked like a charm!

Code:

---

String query = "SELECT * FROM PersonTable WHERE ID = "+id;

---

---

Code:

---

String query = "SELECT * FROM PersonTable WHERE ID = "+id;

---

can it accept more than one entity?

thx
dhilip

Quote:

---

Originally Posted by noobplus

Code:

---

String query = "SELECT * FROM PersonTable WHERE ID = id";

---

can it accept more than one entity?

---

A Statement can return more than one enitity; why else would the return value be a ResultSet?

kind regards,

Jos

Quote:

---

Originally Posted by JosAH

A Statement can return more than one enitity; why else would the return value be a ResultSet?

kind regards,

Jos

---

i mean a single string "query" can have many entities?
ETA:got it, never-mind :P: