querycheci.java

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

import java.awt.*;
import java.awt.image.*;
import java.sql.*;
public class querycheci  //显示车次的路线
{
   BufferedImage bufc;
   Thread threadc;
   Graphics2D grac;
   Point [] pointc=new Point[40];//保存车次经过的所有站点的坐标
   String [] namec=new String[40];//保存车次经过的所有站点
   String [] query1=new String[40];
   ResultSet [] rr=new ResultSet[40];
   draw1 drawc;
   String checi;
   int numc;
   int x,y,xx,yy,xxxx,yyyy;
   Connection con;
   Statement stmt;
   
   public querycheci(draw1 dc,String chec)
   {    drawc=dc;
        checi=chec;
	   	try{
	            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:lv");
				stmt=con.createStatement();			
	       }
	     catch(Exception ee)
	       {     System.err.print("classNotFoundException:");
	             System.err.println(ee.getMessage());
	       }
    
	    
	     
		  String query="SELECT * FROM C0 WHERE 车次='"+checi+"'";
		  System.out.println(""+query);
		try
		{
		   
          int j=0,i=0;
		  ResultSet r=stmt.executeQuery(query);
		  while(r.next())
		  {
		  	namec[j]=r.getString("站点");
		  	j++;
		  }	
		
		  while(i<j)
		  {
		 
		  query1[i]="SELECT * FROM C00 WHERE 站点='"+namec[i]+"'";
		  
		  rr[i]=stmt.executeQuery(query1[i]);
		  rr[i].next();
		  pointc[i]=new Point(rr[i].getInt("x"),rr[i].getInt("y"));
		  i++;
		  }
		  numc=j-1;
	     }
	    catch(SQLException ex)
	    {
	        ex.printStackTrace();
	    }
	    threadc.start();
	     
	    
   }
  
   	
}