用Java连接Access
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("号段地区类型省份区号");
whil...[ 查看全文 ]
