sczd.java

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

import java.sql.*;
import java.lang.String;
 class sccz
{
	public static void main(String args[]) throws Exception
	{
		
            String ur1="jdbc:odbc:lv";
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                }
                catch(java.lang.ClassNotFoundException e)
                {
                        System.err.print("classNotFoundException:");
                        System.err.println(e.getMessage());
                }
                try
                {       int i=1,x,y,z;
                        Connection con=DriverManager.getConnection(ur1);
                        Statement stmt=con.createStatement();
                        Statement stmt1=con.createStatement();
                        ResultSet r1;
                        String s;                                           
                      stmt.executeUpdate("delete from C0 WHERE C0.站点 not in (SELECT 站点 FROM C00)");
                     /* r1=stmt1.executeQuery("SELECT * FROM C00");
                      
                      while(r1.next())
                      {  x=r1.getInt("x");
                         y=r1.getInt("y");
                         z=r1.getInt("ID"); 
                         stmt.executeUpdate("update information set C00_x='(int)(x*600.0f/1818)' WHERE ID=z");
                         stmt.executeUpdate("UPDATE information SET C00_y='(int)(y*600.0f/1818)' WHERE ID=z");
                          i++;
                      }*/
                     stmt.close();   
                }
                        
               catch(SQLException ex)
               {
                   ex.printStackTrace();
               }     
	}
}