Java SQL Statement for selecting record from database and using as double variable

Question

Java - Netbeans IDE

I have this code but the variable Priceperitem is not found, can anyone explain? or show me an easier way of selecting a record from a table in a database and setting its value as a variable?

Price P/Item is the name of column within the database table.

    String sql = "SELECT Price P/Item FROM tblResources";
 try {

pst = conn.prepareStatement(sql);

        rs = pst.executeQuery();

       while (rs.next()){

      double Priceperitem = rs.getDouble("Price P/Item");

       }

  } catch (Exception e) {

        JOptionPane.showMessageDialog(null, "Runtime Error");
    }

and then :

try {

 Total = Quantity * Priceperitem;       (This is where Priceperitem is not found.)

   btnCalculateTotal.setText("Total: £"+Total+"0");

 }catch (Exception e){

     System.out.println("Error Calculating Total");
}

Does that SQL execute when run directly on the database? If that really is the column name, then you'll need to escape it in your query to prevent the database misinterpreting it. — Rory Hunter
– Rory Hunter, Commented Jan 23, 2014 at 10:26
To start i would suggest modifying Database column name instead of P/Item -> Per_Item — Maciej Cygan
– Maciej Cygan, Commented Jan 23, 2014 at 11:25

Henry · Accepted Answer · 2014-01-23 10:28:32Z

1

You have declared Priceperitem locally within the while loop. It is not visible outside the loop.

To fix this, move the declaration to to the outer level:

double Priceperitem = 0;

Side note: you should respect the Java naming conventions. So a better name is pricePerItem.

answered Jan 23, 2014 at 10:28

Henry

43.9k7 gold badges74 silver badges89 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Java SQL Statement for selecting record from database and using as double variable

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related