import java.sql.*;
public class dbaccess{
 public static void main(string args[]) throws exception{
  class.forname("sun.jdbc.odbc.jdbcodbcdriver");
  string dburl ="jdbc:odbc:driver={microsoft access driver (*.mdb)};dbq=mobile.mdb";//此为no-dsn方式
  //string dburl ="jdbc:odbc:odbcname";//此为odbc连接方式
  connection conn=drivermanager.getconnection(dburl);
  statement stmt=conn.createstatement();
  resultset rs=stmt.executequery("select top 20 * from mobilesection");
  system.out.println("号段\t地区\t类型\t省份\t区号");
  while(rs.next()){
   system.out.println(rs.getstring(1)+"\t"+rs.getstring(2)+"\t"+rs.getstring(3)+"\t"+rs.getstring(4)+"\t"+rs.getstring(5));
  }
  rs.close();
  stmt.close();
  conn.close();
 }
}