Java 访问access

2015-05-07 02:18:28 386 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

EEVDF调度算法核心实现解析（一）本文深入解析Linux kernel 6.6引入的EEVDF调度算法核心实现，详细讲解其基于虚拟截止时间（virtual deadline）的进程挑选机制和红黑树优化设计。通过代码实例展示算法如何平衡系统响应速度与公平性，特别适合需要优化Linux系统性能的开发者参考。阅读详情

public static void main(String[] args) {

		 Connection dbCon=null;  

		 Statement stmt=null;  

		try {

			      ///加载驱动jar

			      Class.forName("com.hxtt.sql.access.AccessDriver");    

			      //指定Access数据库文件的位置

			      String url = "jdbc:Access:/d:/school.mdb";

			      //建立连接

			      dbCon = DriverManager.getConnection(url, "username", "password");

			      if(dbCon!=null){  

		                System.out.println("步骤2：连接数据库——成功！");  

		            }  

			    //步骤3：建立JDBC的Statement对象  

		            stmt=dbCon.createStatement();  

		            if(stmt!=null){  

		                System.out.println("步骤3：建立JDBC的Statement对象——成功！");  

		            }  

		            

		            String sSQL="SELECT * FROM Classes";  

		            ResultSet rs=stmt.executeQuery(sSQL);  

		            while(rs.next()){  

		                System.out.print(rs.getString("ID")+"  ");  

		                System.out.print(rs.getString("classid")+"  ");  

//		                System.out.print(rs.getString("name")); 

//		                System.out.print(rs.getString("sex")); 

//		                System.out.println("  " +rs.getFloat("age"));  

		            }

			  } catch (Exception e) {

			      e.printStackTrace();

			 }

		 finally{  

             try{  

                 //关闭步骤3所开启的statement对象  

                 stmt.close();  

                 System.out.println("关闭statement对象");  

             }  

             catch(SQLException e){}  

             try{  

                 //关闭数据库连接  

                 dbCon.close();  

                 System.out.println("关闭数据库连接对象");  

             }  

             catch(SQLException e){}  

        }  

	}

控制台消息：
步骤2：连接数据库——成功！
步骤3：建立JDBC的Statement对象——成功！
java.sql.SQLException: Failed to load database school! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.aw.int(Unknown Source)
at com.hxtt.sql.access.aw.for(Unknown Source)
at com.hxtt.sql.access.aw.<init>(Unknown Source)
at com.hxtt.sql.access.au.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.aw.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bc.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeQuery(Unknown Source)
at xml.AccessDBHelper.main(AccessDBHelper.java:34)
关闭statement对象
关闭数据库连接对象

求解答

...全文