Put variable into SQL Statement (Java/SQL)

Question

So i have two tabels, Student and Klas_student which are described below.

Student

CREATE TABLE IF NOT EXISTS Studenten(
Studentenummer varchar(7) CHECK (Studentenummer ~'[0-9A-ZA-Z]{7}'),
}

Klas

CREATE TABLE IF NOT EXISTS Klas(
Student varchar(7) REFERENCES studenten (Studentenummer) ON DELETE CASCADE NOT NULL,
Klas text NOT NULL REFERENCES Klas (Naam_id) ON DELETE CASCADE NOT NULL
);

As you can see in Klas_student Student references to Studentnumber in Table Studenten. Now in java i need to take studentenummer from Studenten en put that in Klas_student.

To do that i execute a query and take all studentenummer from Studenten.

sql = "INSERT INTO Studenten " + "VALUES ('1559335')";
statement2.executeUpdate(sql);

Then i want to take value from it and i do :

String studentnummer = result.getString(1).toString();
sqlStudenToKlas = "INSERT INTO Klas " + "VALUES (studentnummer)";
statement2.executeUpdate(sqlStudenToKlas);
conn.commit();

However in sqlStudentToKlas, it doesnt take the studentnummer(result.getString(1))string as an argument.

Anybody how i could pass the result.getString(1) as an argument/variable in Values?

Thanks in advance.

Use PreparedStatement: docs.oracle.com/javase/8/docs/api/java/sql/… — Balkrishna Rawool
– Balkrishna Rawool, Commented Jun 13, 2015 at 15:10

P_M · Accepted Answer · 2015-06-13 15:13:05Z

1

Here mistake:

sqlStudenToKlas = "INSERT INTO Klas " + "VALUES (studentenummer)";

you pass string studentenummer, instead of it's value. Try:

sqlStudenToKlas = "INSERT INTO Klas " + "VALUES (" + studentenummer+")";

or

sqlStudenToKlas = "INSERT INTO Klas " + "VALUES ('" + studentenummer+"')";

answered Jun 13, 2015 at 15:13

P_M

3,0006 gold badges38 silver badges68 bronze badges

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

3 Comments

AndroidTestor Over a year ago

I want to pass value of the result ( string stundentnummer). if i apply your code my variable studentnummer is still never used anyway. At least thats what my IDE says. What i want is pass value of string studentnummer to field Student of Klas.

P_M Over a year ago

put System.out.println(studentnummer) after this

AndroidTestor Over a year ago

Thanks for you answer Pavlo. I took Hasan's answer as correct cause i think thats the way for the future and also good for other programmers.

Hasan Fathi · Accepted Answer · 2015-06-13 15:25:59Z

0

C#:

You are Using '@' to passing parameter to your query string in ADO.net

String studentnummer = result.getString(1).toString();
sqlStudenToKlas = "INSERT INTO Klas " + "VALUES (@studentenummer)";
Command.Parameters.AddWithValue("@List", studentenummer);
statement2.executeUpdate(sqlStudenToKlas);
conn.commit();

And Use This Tutorial :The C# Station ADO.NET Tutorial

Java with JDBC:

String studentnummer = result.getString(1).toString();
sqlStudenToKlas = "INSERT INTO Klas " + "VALUES (?)";
sqlStudenToKlas.setString(1, studentenummer);
statement2.executeUpdate(sqlStudenToKlas);
conn.commit();

And Use This Tutorial :Named Parameters for PreparedStatement

edited Jun 13, 2015 at 15:25

answered Jun 13, 2015 at 15:13

Hasan Fathi

6,1764 gold badges49 silver badges67 bronze badges

Collectives™ on Stack Overflow

Put variable into SQL Statement (Java/SQL)

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related