Shulou(Shulou.com)06/03 Report--

This article is about how Java programs generate Access files. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Package access;import java.io.File;import java.io.IOException;import java.sql.SQLException;import java.sql.Types;import org.junit.Test;import com.healthmarketscience.jackcess.ColumnBuilder;import com.healthmarketscience.jackcess.Database;import com.healthmarketscience.jackcess.DatabaseBuilder;import com.healthmarketscience.jackcess.Table;import com.healthmarketscience.jackcess.TableBuilder Public class AccessUtil {public static void main (String [] args) throws IOException {/ / here also supports mdb and accdbDatabase db = DatabaseBuilder.create (Database.FileFormat.V2000, new File ("d:\ new.mdb"); Table newTable Try {/ / just created the file. Here is to create the table and field name in the file. Field type newTable = new TableBuilder ("Archives") .addColumn (new ColumnBuilder ("file number") .setSQLType (Types.VARcHAR)) .addColumn (new ColumnBuilder ("compilation unit") .setSQLType (Types.VARcHAR)) .addColumn (new ColumnBuilder ("file title") .setSQLType (Types.VARcHAR)) .addColumn (new ColumnBuilder ("file title length") .setSQLType (Types.INTEGER)) .addColumn (new ColumnBuilder ("Archive Box Specification") .setSQLType (Types.VARcHAR) ) .addColumn (new ColumnBuilder ("weave unit length") .setSQLType (Types.INTEGER)) .toTable (db) / insert a data test newTable.addRow ("12", "foo", "44,323,56);} catch (SQLException e) {/ / TODO Auto-generated catch blocke.printStackTrace ();} @ Testpublic void operator () throws Exception {File mdbFile = new File (" C:\ Users\ admin\ Desktop\ test.mdb "); if (mdbFile.exists ()) {Database dbin = DatabaseBuilder.open (mdbFile); Table table = dbin.getTable (" Archives ") Table.addRow ("New Test of File number", "New Test of compiling Unit", "New Test of File correct questions", 55, "File Box Specification Test", 5);} Thank you for your reading! This is the end of the article on "how Java programs generate Access files". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.