mardi 8 mars 2016

How to pass variable values into sql query

My problem is that I have two tables (price and logs). From table logs I calculate the mass of each log. Each log has length, diameter, sort and grade. In table Price I also have parameters length, sort, grade, and diameter(but for diameter I have 2 columns, one for upper limit and one for lover limit) and 4 prices in different currency. Now I want to calculate all price currency based on log length, sort, grade and diameter and then display the price on each log.

I tried to do that in my Display activity but I get stuck. Also tried to pass parameters via Intent and get sql query but couldn't done that. So I started now to call sql query inside activity but. I've been doing this in my logs class(where constructors, getters and setters are).

I have made Sql query but don't know is it good and how to pass the variables inside it? Now I need to pass length, sort, grade, diameter into sql query to get price but don't know how?

Here is my Logs class where I started to doing this. Please help!

public Logs(String sort_id, String grade, String diameter, String length) {
        this.sort_id = sort_id;
        this.grade = grade;
        this.diameter = diameter;
        this.length = length;
    }
    public Logs(){ }

    public long getId() {
        return id;
    }
    public String getSort_id() { return sort_id; }
    public String getGrade() { return grade; }
    public String getDiameter() { return diameter; }
    public String getLength() { return length; }
    public void setId(long id) {
        this.id = id;
    }
    public void setSort_id(String sort_id) {
        this.sort_id = sort_id;
    }
    public void setGrade(String grade) {
        this.grade = grade;
    }
    public void setDiameter(String diameter) { this.diameter = diameter; }
    public void setLength(String length) { this.length = length; }

    public double getResult() {
        double log_length, log_diameter, length, diameter, result;
        log_length = Integer.parseInt(getLength().toString());
        log_diameter = Integer.parseInt(getDiameter().toString());
        length = log_length / 100;
        diameter = log_diameter * log_diameter * 3.14159265;
        result = length * diameter / 40000;
        return result;
    }

    public void getPrice() {
        //here i made sql query for getting price
        dbHandler query = "SELECT price_stump_kn, price_stump_eur, road_price_kn, road_price_eur FROM Price WHERE sort = ? AND grade = ? AND length = ? BETWEEN diameter_dg = ? AND diameter_gg = ?";
    }

Aucun commentaire:

Enregistrer un commentaire