Jackcess 2.x的更新：現(xiàn)在使用DatabaseBuilder創(chuàng)建(或打開)數(shù)據(jù)庫,因此要創(chuàng)建一個新的數(shù)據(jù)庫文件,我們這樣做

import java.io.File;

import java.io.IOException;

import com.healthmarketscience.jackcess.Database;

import com.healthmarketscience.jackcess.Database.FileFormat;

import com.healthmarketscience.jackcess.DatabaseBuilder;

public class JackcessDemoMain {

public static void main(String[] args) {

String dbPath = "C:/Users/Public/newDb.accdb";

// using try-with-resources is recommended to ensure that

// the Database object will be closed properly

try (Database db = DatabaseBuilder.create(FileFormat.V2010, new File(dbPath))) {

System.out.println("The database file has been created.");

} catch (IOException ioe) {

ioe.printStackTrace(System.err);

}

}

}

Jackcess 1.x的原始答案(已棄用)：

如果您想通過java創(chuàng)建“.mdb”文件,可以使用Jackcess Java庫,它是用于讀取和寫入MS Access數(shù)據(jù)庫的純Java庫之一.目前支持的版本包括2000-2007我猜.請查看以下示例以便更好地理解：

>下載Jackcess Java庫(jackcess-1.2.6.jar)

從http://jackcess.sourceforge.net/

和commons-logging-1.1.jar

從http://commons.apache.org/logging/download_logging.cgi開始

和commons-lang-2.0.jar

從http://www.findjar.com/index.x?query=commons-lang

>將兩個罐子添加到類路徑中.

>嘗試以下代碼自動創(chuàng)建數(shù)據(jù)庫：

package com.jackcess.lib;

import com.healthmarketscience.jackcess.ColumnBuilder;

import com.healthmarketscience.jackcess.Database;

import com.healthmarketscience.jackcess.Table;

import com.healthmarketscience.jackcess.TableBuilder;

import java.io.File;

import java.io.IOException;

import java.sql.SQLException;

import java.sql.Types;

/**

*

* @author sarath_ivan

*/

public class JackcessLibrary {

private static Database createDatabase(String databaseName) throws IOException {

return Database.create(new File(databaseName));

}

private static TableBuilder createTable(String tableName) {

return new TableBuilder(tableName);

}

public static void addColumn(Database database, TableBuilder tableName, String columnName, Types sqlType) throws SQLException, IOException {

tableName.addColumn(new ColumnBuilder(columnName).setSQLType(Types.INTEGER).toColumn()).toTable(database);

}

public static void startDatabaseProcess() throws IOException, SQLException {

String databaseName = "C:/Users/compaq/Desktop/employeedb.mdb"; // Creating an MS Access database

Database database = createDatabase(databaseName);

String tableName = "Employee"; // Creating table

Table table = createTable(tableName)

.addColumn(new ColumnBuilder("Emp_Id").setSQLType(Types.INTEGER).toColumn())

.addColumn(new ColumnBuilder("Emp_Name").setSQLType(Types.VARCHAR).toColumn())

.addColumn(new ColumnBuilder("Emp_Employer").setSQLType(Types.VARCHAR).toColumn())

.toTable(database);

table.addRow(122875, "Sarath Kumar Sivan","Infosys Limited.");//Inserting values into the table

}

public static void main(String[] args) throws IOException, SQLException {

JackcessLibrary.startDatabaseProcess();

}

}

總結(jié)

以上是生活随笔為你收集整理的java创建access数据库_使用Java创建Access数据库文件(.mdb或.accdb)的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。