xianshicheci.java

java写的一交通导航程序点击任意两站点就可以以可视化的方式将转车次数最少的乘车方案找出来 注：连ACCESS数据库 odbc数据源名称为lv

import java.sql.*;
import java.lang.String;
import java.io.*;
public class xianshicheci
{
	

        
         public xianshicheci()
         {
         
         int i=0,k,j=0; che="1";
		  String query99="SELECT * FROM C0 WHERE 车次='"+che+"'";
		  System.out.println(""+query99);
		  try
		  {
		   
          Statement stmt99=con.createStatement();
		  ResultSet r99=stmt99.executeQuery(query99);
		  while(r99.next())
		  {
		  	pt[j]=r99.getString("站点");
		  	j++;
		  }	
		  for(k=0;k<j;k++)
		  {
		  	System.out.println("第"+k+"个站点"+pt[k]);
		  }
		  while(i<j)
		  {
		 
		  query1[i]="SELECT * FROM C00 WHERE 站点='"+pt[i]+"'";
		  
		  rr[i]=stmt99.executeQuery(query1[i]);
		  rr[i].next();
		  pp[i]=new Point();
		  pp[i].x=rr[i].getInt("x");
		  pp[i].y=rr[i].getInt("y");i++;
		  }
		  zd=j-1;
	      }
	       catch(SQLException ex)
	       {
	           ex.printStackTrace();

	       }
	      }
}