Example of using jdbc-odbc to insert data to an OLE-type table in an Access database

/**
* Note:
* You can insert images or messy files to the Access database through jdbc-odbc.
* Note: an error occurs when you use DataInputStream.
*
/
Import java. SQL .*;
Import java. io. FileInputStream;
Public class sss
{
Public static void main (String args [])
{
Try
{
// Connect to the ACCESS database. The connection string is used here.
Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver"). newInstance ();
Java. SQL. Connection conctn = DriverManager. getConnection (
"Jdbc: odbc:;" +
"DRIVER = Driver do Microsoft Access (*. mdb);" +
"UID = admin;" +
"UserCommitSync = Yes;" +
"Threads = 3;" +
"SafeTransactions = 0;" +
"PageTimeout = 5;" +
"MaxScanRows = 8;" +
"MaxBufferSize = 2048;" +
"FIL = MS Access;" +
"DriverId = 25;" +
// "DefaultDir = C: Documents and SettingsAdministratorMy Documents;" +
"DBQ = D: gtk. mdb"
);
Int length = 0;
//
// Set the connection object
//