jilu.java

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

import java.sql.*;
import java.lang.String;
class jilu
{  
   public static void jjl()
   {
     	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
		{
			Connection con=DriverManager.getConnection(ur1);
			Statement stmt=con.createStatement();
        	  stmt.executeUpdate("delete from J0");
            stmt.executeUpdate("delete from J1");//删除记录，注意不能写成大写
           //stmt.executeUpdate("delete from C0 WHERE ID=12");
           // stmt.executeUpdate("delete from C0 WHERE C0.站点 not in (SELECT 站点 FROM C00)");
           stmt.executeUpdate("delete from J2");
          // stmt1.executeUpdate("UPDATE information SET C00_x=''");
           
	   	}
	   catch(SQLException ex)
	   {
	   	ex.printStackTrace();
	   }
   }
}