Is there a way to insert input variables inside a database query using Sele [duplicate]

Question

Is it possible to put variable values from the console inside a database query using Selenium WebDriver?

For example:

//Get the variable from console input
Scanner reader = new Scanner(System.in);
System.out.println("Enter a variable: "); 
String input_variable = reader.next();
reader.close();

//Then do something like this:
String query = "select (input_variable) from database_table";`

It looks like you're trying to build a SQL query as a string, for which the linked duplicate is what you're looking for. That said, if it's possible for WebDriver to execute SQL queries against your database, your security model is completely broken. — Daniel Pryden
– Daniel Pryden, Commented Feb 20, 2018 at 16:07
Hi Daniel. Your link fixed my issue. You're right, my question is a duplicate. Thank you. — Andrej Milojeski
– Andrej Milojeski, Commented Feb 21, 2018 at 8:03

Andrew Allison · Accepted Answer · 2018-02-20 15:03:45Z

0

There are a few ways you can accomplish this.

String query = String.format("select %s from database_table", variable);

or

String query = "select " + variable.toString() + " from database_table";

are just two examples off the top of my head.

answered Feb 20, 2018 at 15:03

Andrew Allison

1,1662 gold badges16 silver badges35 bronze badges

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

1 Comment

Andrej Milojeski Over a year ago

Thanks a lot, Andrew, both of these worked! ;)

Collectives™ on Stack Overflow

Is there a way to insert input variables inside a database query using Sele [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related