📄 selebus.java
字号:
public DefaultTableModel seleAZmax(String ststa) //站点大全
{
String[] strin={"AE","FK","LQ","RW","XX"};
Vector veson=new Vector();
Vector veou=new Vector();
for(int f=0;f<4;f++)
{
veou.add("");
}
String[] strll={"A","B","C","D","E","F","G","H","I","J",
"K","L","M","N","O","P","Q","R",
"S","T","U","V","W","X","Y","Z","0"};
String sss="";
int i=0,j=0,v=0;
if(ststa.equals("ABCDE"))
{
i=0;
j=4;
}
if(ststa.equals("FGHIJK"))
{
i=1;
j=11;
v=5;
}
if(ststa.equals("LMNOPQ"))
{
i=2;
j=16;
v=11;
}
if(ststa.equals("RSTUVW"))
{
i=3;
j=22;
v=17;
}
if(ststa.equals("XYZ其它"))
{
i=4;
j=26;
v=23;
}
try
{
for(;v<=j;v++)
{
sss="select AEname"+" from AZ where AEmark="+"'"+strll[v]+"'";
ResultSet res=st.executeQuery(sss);
Vector ve=new Vector();
Vector vvee=new Vector();
vvee.add(strll[v]);
vvee.add("");
vvee.add("");
vvee.add("");
veson.add(vvee);
int er=0,s=2;
while(res.next())
{
ve.add(res.getString(1));
}
res.close();
er=(ve.size()+1)%4;
if(er==0)
{
for(int iu=1;iu<=4-er;iu++)
{
ve.add("");
}
}
for(int pp=0;pp<ve.size();)
{
Vector vvve=new Vector();
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(vvve.size()!=0)
{
veson.add(vvve);
}
}
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
DefaultTableModel de=new DefaultTableModel(veson,veou);
return de;
}
public DefaultTableModel selebusmax(String ststa) //线路大全
{
String[] strin={"CSBashi","HNBashi","Longxiang","QiTa"};
Vector veson=new Vector();
Vector veou=new Vector();
String st2="";
String strll="";
String strpp="";
for(int f=0;f<2;f++)
{
veou.add("");
}
String sss="";
int i=0;
if(ststa.equals("长沙巴士"))
{
strll="长沙巴士";
i=0;
}
if(ststa.equals("湖南巴士"))
{
i=1;
strll="湖南巴士";
}
if(ststa.equals("湖南龙骧巴士"))
{
i=2;
strll="湖南龙骧巴士";
}
if(ststa.equals("其它公司"))
{
i=3;
strll="其它公司";
}
try
{
st2=strin[i].substring(0,1);
sss="select "+st2+"BusName,"+st2+"StartArea,"+st2+"EndArea from "+strin[i];
ResultSet res=st.executeQuery(sss);
Vector ve=new Vector();
Vector vvee=new Vector();
veson.add(vvee);
int er=0;
while(res.next())
{
er++;
strpp= res.getString(1);
strpp=strpp+" ( "+res.getString(2)+"---"+res.getString(3)+" )";
ve.add(strpp);
}
vvee.add(strll+":"+er+"辆");
vvee.add("");
res.close();
er=(ve.size()+1)%2;
if(er!=0)
{
ve.add("");
}
for(int pp=0;pp<ve.size();)
{
Vector vvve=new Vector();
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(pp<ve.size())
{
vvve.add(ve.get(pp++));
}
if(vvve.size()!=0)
{
veson.add(vvve);
}
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
DefaultTableModel de=new DefaultTableModel(veson,veou);
return de;
}
public DefaultTableModel selectZhongzhuan(String ststa,String stend) //中转站;
{
Vector veson=new Vector();
Vector veou=new Vector();
veou.add("起点");
veou.add("车次");
veou.add("中转站");
veou.add("车次");
veou.add("终点");
try
{
String stln= "select AEbus from AZ where AEname='"+ststa+"'";
ResultSet res=st.executeQuery(stln);
res.next();
ArrayList astr=this.sebus(res.getString(1),",");
res.close();
stln= "select AEbus from AZ where AEname='"+stend+"'";
ResultSet ress=st.executeQuery(stln);
ress.next();
ArrayList aend= this.sebus(ress.getString(1),",");
ress.close();
/* for(int iie=0;iie<aend.size();iie++)
{
System.out.print(aend.get(iie));
} */
// System.out.print(this.seendand);
for(int i=0;i<astr.size();i++)
{
for(int j=0;j<aend.size();j++)
{
Vector vest=new Vector();
selesele((String)astr.get(i));
String st=seendand;
System.out.print(st+"ffffffff");
selesele((String)aend.get(j));
String st2=this.seendand;
ArrayList arou=this.sebus(st," - ");
ArrayList arop=this.sebus(st2," - ");
ArrayList ok= this.busis(arou,arop);
if(ok.size()!=0)
{
for(int u=0;u<ok.size();u++)
{
vest.add(ststa);
vest.add(astr.get(i));
vest.add(ok.get(u));
vest.add(aend.get(j));
vest.add(stend);
} veson.add(vest);
}
}
}
}
catch(Exception se)
{
se.printStackTrace();
}
DefaultTableModel de=new DefaultTableModel(veson,veou);
return de;
}
public ArrayList sebus(String st , String wher) //分离功能;
{
StringBuffer ss=new StringBuffer(st);
if(wher.equals(","))
{
ss.delete(0,1);
ss.delete(ss.length()-1,ss.length());
}
if(wher.equals(" - "))
{
ss.delete(0,2);
ss.delete(ss.length()-2,ss.length()) ;
}
String ee=new String(ss);
String[] strArray = null;
strArray = ee.split(wher);
ArrayList al = new ArrayList();
for (int i = 0 ; i < strArray.length ; i ++)
{
al.add(strArray[i]);
}
return al;
}
public ArrayList busis(ArrayList steee , ArrayList enddd) //反回相同的;
{
ArrayList arr=new ArrayList();
for(int i=0;i<steee.size();i++)
{
for(int j=0;j<enddd.size();j++)
{
if(steee.get(i).equals(enddd.get(j)))
{
arr.add(steee.get(i));
}
}
}
return arr;
}
public boolean isExistZhanDian(String strZhanDian)
{
boolean bool=true;
String strSql="select * from AZ where AEname='"+strZhanDian+"'";
try
{
java.sql.ResultSet rs=st.executeQuery(strSql);
if(rs.next()){
System.out.println (rs.getString(1));
bool=true;
}else{
bool=false;
}
rs.close();
}
catch(java.sql.SQLException sqle)
{
sqle.printStackTrace();
bool=false;
}
return bool;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -