Hi,

I'm having trouble writing the java code for the following mySql query:

SELECT student_id, first_name, last_name
FROM student
WHERE student_id = given student_id;

I can do it for a set id but need it to work when the student_id is given as a method parameter.

So far, I have:


but need something like:

I'm having some problem with the quotation marks. I need to student_id to be input as a parameter but the whole query to be read as a String. I'm currently getting

Unclosed character literal and Unclosed String literal error messages.

Could someone please help.

You may use Prepared Statements, tutorial

Like dimis2500 said you should use Prepared Statements or better Callable Statements for Stored Procedures.

But... some times is easy to write a query like yours for testing ...
or when a query can be polymorphic, if I am allow to say so.

Almost every dbms can use the ' like a ", you can use the syntax:
... + "WHERE student_id = '" + student_id + "'"
but only when there is no other option