How to pass two parameter to a Query java

Question

So I am trying to execute a query that takes 2 int values from the user however I am getting this error message. What I am doing wrong?

"at least one parameter to the current statement is uninitialized"

This is my Query

selectStudentsInRange = connection.prepareStatement("SELECT* FROM Results WHERE total BETWEEN ? AND ?");

An this is my method, yes is not the whole code.

public List< Results > getTotalMarksInRange( int value1, int value2 )
 {
  List< Results > results = null;
  ResultSet resultSet = null;

  try 
  {
      selectStudentsInRange.setInt( value1, value2 ); // specify id

     // executeQuery returns ResultSet containing matching entries
     resultSet =  selectStudentsInRange.executeQuery(); 

     results = new ArrayList< Results >();

Please notice that this is not the whole code I have many classes I am just wondering what is my error in this part.

SatyaTNV · Accepted Answer · 2016-03-30 04:43:52Z

2

at least one parameter to the current statement is uninitialized

selectStudentsInRange.setInt( value1, value2 ); // specify id

Change to

selectStudentsInRange.setInt(1, value1 ); 
selectStudentsInRange.setInt(2, value2 );

answered Mar 30, 2016 at 4:43

SatyaTNV

4,1473 gold badges17 silver badges32 bronze badges

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

Comments

Robby Cornelissen · Accepted Answer · 2016-03-30 04:44:15Z

1

That should be:

selectStudentsInRange.setInt(1, value1);
selectStudentsInRange.setInt(2, value2);

The first argument is the parameter index, the second argument is the parameter value.

See the documentation here.

answered Mar 30, 2016 at 4:44

Robby Cornelissen

98.6k23 gold badges154 silver badges180 bronze badges

Comments

Vikrant Kashyap · Accepted Answer · 2016-03-30 04:44:02Z

-1

Take a look to this Parameters For-PreparedStatement

selectStudentsInRange.setInt(1, value1 ); //this is how to set First Argument.
selectStudentsInRange.setInt(2, value2 )  // Set Your Second Argument.
//but make sure value1 and value2 both are Integer Type

answered Mar 30, 2016 at 4:44

Vikrant Kashyap

6,9343 gold badges34 silver badges53 bronze badges

Collectives™ on Stack Overflow

How to pass two parameter to a Query java

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related