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