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++)
{
for(j=4;j<43;j++)
{
C=cursor2.getString(0);
D=cursor2.getString(j);
if(D.compareTo(end)==0)
{
if(g==i) //表示单线程
{
continue;
}
else
for(k=5;k<cursor2.getCount();k++)
{
G=cursor2.getString(k);
for(l=4;l<cursor2.getCount();l++)
{
I=cursor2.getString(l);
if(G==I&&G!=B&&G!=D)
{
F=null;
z=1;
if(k>j&&l>h)
{
e++;
for(m=k;m>=j;m--)
H+=cursor2.getString(m)+"\t";
for(n=h;n<=l;n++)
J+=cursor1.getString(n)+"\t";}
}
if(k>j&&l<h)
{
e++;
for(m=k;m>=j;m--)
H+=cursor2.getString(m)+"\t";
for(n=h;n>=l;n--)
J+=cursor1.getString(n)+"\t";
}
if(k<j&&l>h)
{
e++;
for(m=k;m<=j;m++)
H+=cursor2.getString(m)+"\t";
for(n=h;n<=l;n++)
J+=cursor1.getString(n)+"\t";
}
if(k<j&&l<h)
{
e++;
for(m=k;m<=j;m++)
H+=cursor2.getString(m)+"\t";
for(n=h;n>=l;n--)
J+=cursor1.getString(n)+"\t";
}
F="方案"+e+":\t需换乘:您可以选择从"+B+"处乘坐"+A+"车,途经:\n"+J+"\n共"+
abs(h-n)+"站,到"+I+"处下车。\n然后换乘"+C+"途经:\n"+H+
"\n共"+abs(m-k)+"站,到"+D+"下车即可\n";
result.setText(F);
}
}
if(z==1)
break;
}
}
H=null;J=null;
}
cursor2.moveToNext();
}
}
E=null;
}
cursor2.moveToNext();
}
private int abs(int i)
{
if(i<0)
return -i;
else
return i;
} //求绝对值
};
{
@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++)
{
for(j=4;j<43;j++)
{
C=cursor2.getString(0);
D=cursor2.getString(j);
if(D.compareTo(end)==0)
{
if(g==i) //表示单线程
{
continue;
}
else
for(k=5;k<cursor2.getCount();k++)
{
G=cursor2.getString(k);
for(l=4;l<cursor2.getCount();l++)
{
I=cursor2.getString(l);
if(G==I&&G!=B&&G!=D)
{
F=null;
z=1;
if(k>j&&l>h)
{
e++;
for(m=k;m>=j;m--)
H+=cursor2.getString(m)+"\t";
for(n=h;n<=l;n++)
J+=cursor1.getString(n)+"\t";}
}
if(k>j&&l<h)
{
e++;
for(m=k;m>=j;m--)
H+=cursor2.getString(m)+"\t";
for(n=h;n>=l;n--)
J+=cursor1.getString(n)+"\t";
}
if(k<j&&l>h)
{
e++;
for(m=k;m<=j;m++)
H+=cursor2.getString(m)+"\t";
for(n=h;n<=l;n++)
J+=cursor1.getString(n)+"\t";
}
if(k<j&&l<h)
{
e++;
for(m=k;m<=j;m++)
H+=cursor2.getString(m)+"\t";
for(n=h;n>=l;n--)
J+=cursor1.getString(n)+"\t";
}
F="方案"+e+":\t需换乘:您可以选择从"+B+"处乘坐"+A+"车,途经:\n"+J+"\n共"+
abs(h-n)+"站,到"+I+"处下车。\n然后换乘"+C+"途经:\n"+H+
"\n共"+abs(m-k)+"站,到"+D+"下车即可\n";
result.setText(F);
}
}
if(z==1)
break;
}
}
H=null;J=null;
}
cursor2.moveToNext();
}
}
E=null;
}
cursor2.moveToNext();
}
private int abs(int i)
{
if(i<0)
return -i;
else
return i;
} //求绝对值
};
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货