package com.core;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class Mytest {
public static void main(String[] args) throws Exception {
Connection con=null ;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String filename = "F:/workspace/Demo5/src/com/core/aaa.mdb";
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end
con = DriverManager.getConnection( database ,"","");
}
catch (Exception e) {
System.out.println("Error: " + e);
}
String sql =null;
for(int i=1;i<10;i++){
sql = "insert into aaa(aa,bb) values ("+i+","+i+")";
PreparedStatement pre = con.prepareStatement(sql);
pre.executeUpdate();
}
con.close();
}
}