package odbcj;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class ads {
    public static Connection getJDBCConnection(){  
         try{  
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载Access驱动    
         Properties prop = new Properties();     
               prop.put("charSet", "gb2312");  //设置编码防止中文出现乱码  
        Connection con = DriverManager.getConnection("jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=E:/text.accdb");    
                 //System.out.println(con);//打印连接  
        return con;  
          
         }catch(Exception e){  
             e.printStackTrace();  
         }  
         return null;  
        }  
    public static void showAllJDBC()throws Exception{  
       Connection con=getJDBCConnection();  
         PreparedStatement ps=con.prepareStatement("select *from 表1");// 07  
          ResultSet rs=ps.executeQuery();  
          while(rs.next()){  
              System.out.println(rs.getString(1)+"   "+rs.getString(2));  
              //s=Integer.toString((int)value);
              
              //jta.setText(rs.getString(1));
          }  
          rs.close();  
          ps.close();  
          con.close();  
  }  
    public static void main(String []argv) throws Exception{
        showAllJDBC();
    }
}

try{
            //String url = "jdbc:odbc:DRIVER=Microsoft Access Driver(*.mdb, *.accdb);DBQ=E:/text.accdb";
            String url="jdbc:odbc:driver=Microsoft Access Driver (*.mdb, *.accdb);DBQ=E:/text.accdb";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection(url);
            Statement sta = (Statement) conn.createStatement();
            ResultSet resu = ((java.sql.Statement) sta).executeQuery("select * from 表1");
            while(resu.next()){
                System.out.println(resu.getString("noise"));
            }
            resu.close();
            sta.close();
            conn.close();
            }catch(Exception e){
                e.printStackTrace();
            }

try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //jdbc:odbc:数据源名称", "数据库用户名(如有)没有则空", "用户密码(如有)没有则空
            Connection conn = DriverManager.getConnection("jdbc:odbc:xxx");
            java.sql.Statement sta = conn.createStatement();
            ResultSet resu=(sta).executeQuery("select * from 表1");
            while(resu.next()){
                System.out.println(resu.getString("noise"));
            }
            resu.close();
            sta.close();
            conn.close();
        }catch(Exception e){
            e.printStackTrace();
        }