标题:MS Access JDBC驱动(共享)
只看楼主
Starlove
Rank: 1
等 级:新手上路
帖 子:169
专家分:0
注 册:2007-4-26
 问题点数:0 回复次数:0 
MS Access JDBC驱动(共享)
本人找到了真正的可以用的MS Access JDBC驱动程序
再此共享一下
 Test java code
--------------------------------
public DataBase(String TableName){
        
         try{
            
             Class.forName("com.hxtt.sql.access.AccessDriver");
             con = DriverManager.getConnection("jdbc:access:/./db/Test.mdb");
             //System.out.println("OK");
             state=con.createStatement();
             rs=state.executeQuery("select * from "+TableName+" order by User_ID");
             rsmd = rs.getMetaData();
            
             Datas = new Vector<String>();
                while(rs.next()){     
                   for(int i =1;i<=rsmd.getColumnCount();i++)
                       Datas.add(rs.getString(i).trim());
                }
                
             Titles = new Vector<String>();
             for(int i =1;i<=rsmd.getColumnCount();i++)
                   Titles.add(rsmd.getColumnName(i).trim());
            // System.out.println(Datas+"\n"+Titles);
         }catch(Exception e){
             e.printStackTrace();
         }

     }
--------------------------------------------
具体用法可以看里面的html帮助文挡

.......................................
无语了
太大传不上去
搜索更多相关主题的帖子: JDBC Access 驱动 
2008-02-29 17:29



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-201459-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.249156 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved