Cursor cursor1=db1.query("cmdetailed",new String[]{"total(subtotal) as sale"}, " name='"+tempname+"'", null, null, null, null);
if(cursor1.getCount()>0)
{
if(cursor1.moveToFirst())
{
String sale=cursor1.getString(cursor1.getColumnIndex("sale"));
//float a=Float.parseFloat(sale);
System.out.println("sale:"+sale+" classname:"+tempname);
lssale.add(sale);
}
}
tempname为中文
查询不到任何数据(数据库里面是有数据的)
请各位大侠指教一下 谢谢!
Cursor cursor1 = db.rawQuery("select total(subtotal) as sale from cmdetailed where name=? ", new String[]{tempname});