assigning variable in SQL query statement

Question

In my current project, I have a function with argument (e.g., int badgID in the following code snippet). This function connects with Apache Derby database, creates table (e.g., FIRSTTABLE), then query to FIRSTTABLE table. The query statement uses function argument for query (e.g., ID = $badgeID ). My question: Is ID = $badgeID the right way from a syntax point of view?. I have tried this case, but it is not working.

public void getprofile (int badgeID) {

// Create connection with Apache-Derby Database.   

// Create table in Apache Derby datbase.
String createString = " CREATE TABLE FIRSTTABLE "
                    + "(ID INT PRIMARY KEY, "
            + "PREF INT, "
                    + " NAME VARCHAR(12))";


//  SQL query on table
querystmt = "SELECT * FROM FIRSTTABLE WHERE  ID = $badgeID"

}

Alix Martin · Accepted Answer · 2012-10-09 09:47:35Z

3

that's php syntax...

in java you would write

String querystmt = "SELECT * FROM FIRSTTABLE WHERE  ID = " + badgeID;

answered Oct 9, 2012 at 9:47

Alix Martin

4322 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bryan Pendleton Over a year ago

Simple string concatenation like this often works fine. For more complex scenarios, you'll want to use a prepared statement, and use placeholders, and use the JDBC API to supply placeholder values at execution time. But for now, start with string concatentation to become comfortable with how the queries work.

Collectives™ on Stack Overflow

assigning variable in SQL query statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related