安卓数据库操作,出了点小疑点,在比较从数据库中读到的数据与输入的数据的时候出了有关问题,好心人帮忙改一上吧
安卓数据库操作,出了点小问题,在比较从数据库中读到的数据与输入的数据的时候出了问题,好心人帮忙改一下吧?
private OnClickListener queding = new OnClickListener()
{
@SuppressLint({ "ParserError", "NewApi" })
@Override
public void onClick(View v) {
int g=0,h=0,i=0,j=0,k=0,l=0,m=0,n = 0;
int e=0,z=0;
String A=null,B=null,C=null,D=null,E=null,F=null,G=null,H=null,I=null,J=null;;
String start=myAutoqidian.getText().toString();
String end=myAutozhongdian.getText().toString();
if(start.isEmpty())
{
Toast.makeText(zhuye.this, R.string.pleaseinputstart, Toast.LENGTH_SHORT).show();
return;
}
EditText result = (EditText)findViewById(R.id.answer);
result.setText("");
String sql = "select * from '洛阳公交'";
Cursor cursor1 = mSQLiteDatabase.rawQuery(sql, null);
Cursor cursor2 = mSQLiteDatabase.rawQuery(sql, null);
if(cursor1.getCount()>0)
{
for(cursor1.moveToFirst();!(cursor1.isAfterLast());cursor1.moveToNext())
{
for(h=4;h<47;h++)
{
A=cursor1.getString(0); //记录车次
B=cursor1.getString(h);
result.append(A);
if(B.isEmpty())
continue;
else
if(B.equals(start))
for(j=4;j<43;j++)
{
D=cursor1.getString(j);
if(end==D)
{
if(j>h)
{
e++; //统计方案数
for(m=h;m<=j;m++)
E+=cursor1.getString(m);
}
else
{
e++;
for(m=h;m>=j;m--)
E+=cursor1.getString(m);
}
F="方案"+e+":\t不换乘(直达车):您可以选择从您所在起点"+B+"乘坐"+A+"车,途经:\n"+E+"\n共"+
(h-j)+"站,然后到"+D+"站下车\n";
result.append(F);
}
}
E=null;
}
cursor1.moveToNext();
}
}
//到此单线程查询结束
//下面是可换成代码
cursor1.moveToFirst();
for(g=0;g<cursor1.getCount();g++)
{
for(h=4;h<43;h++)
{
A=cursor1.getString(0);
B=cursor1.getString(h);
if(B.compareTo(start)==0)
{
cursor2.moveToFirst();
for(i=0;i<cursor1.getCount();i++)
{
private OnClickListener queding = new OnClickListener()
{
@SuppressLint({ "ParserError", "NewApi" })
@Override
public void onClick(View v) {
int g=0,h=0,i=0,j=0,k=0,l=0,m=0,n = 0;
int e=0,z=0;
String A=null,B=null,C=null,D=null,E=null,F=null,G=null,H=null,I=null,J=null;;
String start=myAutoqidian.getText().toString();
String end=myAutozhongdian.getText().toString();
if(start.isEmpty())
{
Toast.makeText(zhuye.this, R.string.pleaseinputstart, Toast.LENGTH_SHORT).show();
return;
}
EditText result = (EditText)findViewById(R.id.answer);
result.setText("");
String sql = "select * from '洛阳公交'";
Cursor cursor1 = mSQLiteDatabase.rawQuery(sql, null);
Cursor cursor2 = mSQLiteDatabase.rawQuery(sql, null);
if(cursor1.getCount()>0)
{
for(cursor1.moveToFirst();!(cursor1.isAfterLast());cursor1.moveToNext())
{
for(h=4;h<47;h++)
{
A=cursor1.getString(0); //记录车次
B=cursor1.getString(h);
result.append(A);
if(B.isEmpty())
continue;
else
if(B.equals(start))
for(j=4;j<43;j++)
{
D=cursor1.getString(j);
if(end==D)
{
if(j>h)
{
e++; //统计方案数
for(m=h;m<=j;m++)
E+=cursor1.getString(m);
}
else
{
e++;
for(m=h;m>=j;m--)
E+=cursor1.getString(m);
}
F="方案"+e+":\t不换乘(直达车):您可以选择从您所在起点"+B+"乘坐"+A+"车,途经:\n"+E+"\n共"+
(h-j)+"站,然后到"+D+"站下车\n";
result.append(F);
}
}
E=null;
}
cursor1.moveToNext();
}
}
//到此单线程查询结束
//下面是可换成代码
cursor1.moveToFirst();
for(g=0;g<cursor1.getCount();g++)
{
for(h=4;h<43;h++)
{
A=cursor1.getString(0);
B=cursor1.getString(h);
if(B.compareTo(start)==0)
{
cursor2.moveToFirst();
for(i=0;i<cursor1.getCount();i++)
{