What steps will reproduce the problem?
1. excute sql:
select DLBM,DLMC,TBBH,sum(Area(Intersection((select Geometry from '2012TB' where JCBH=99),Geometry))) as area
from '2012DL'
where Intersects((select Geometry from '2012TB' where JCBH=99),Geometry)group
by DLMC,DLBM
2. db.exec(query, cb);
3. Callback cb = new Callback() {
public void columns(String[] coldata) {
}
public void types(String[] types) {
}
public boolean newrow(String[] rowdata) {
// 爸从spatialite中得到的空间数据在GrpahicsLayer中显示出来
Log.d("DBUtil", rowdata[0]+"|"+rowdata[2]+"|"+rowdata[3]);
String dlbm = rowdata[0];
String dlmc = rowdata[1];
if(rowdata[2]==null){
return false;
}
double area = Double.valueOf(rowdata[2]);
if(area<0.0001){
return false;
}
ResultBean resultBean = new ResultBean();
resultBean.setName(dlmc);
resultBean.setType(dlbm);
resultBean.setArea(area);
features.add(resultBean);
return false;
}
};
What is the expected output? What do you see instead?
可以返回面积,但是面积返回为null。在gui中查询是ok的。
12-17 14:10:59.981: D/DBUtil(13970): 102|131|null
12-17 14:10:59.986: D/DBUtil(13970): 114|99|null
12-17 14:10:59.986: D/DBUtil(13970): 202|6 |null
12-17 14:10:59.986: D/DBUtil(13970): 012|31|null
12-17 14:10:59.986: D/DBUtil(13970): 011|103|null
12-17 14:10:59.986: D/DBUtil(13970): 101|12|null
最后面积查询出来时null
What version of the product are you using? On what operating system?
Android
Please provide any additional information below.
Original issue reported on code.google.com by Myeasy...@gmail.com on 17 Aug 2013 at 6:25
Original issue reported on code.google.com by
Myeasy...@gmail.com
on 17 Aug 2013 at 6:25