?? 新建 文本文檔.txt
字號:
java連接Access數(shù)據(jù)庫的代碼
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地區(qū)\t類型\t省份\t區(qū)號 " );
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();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -