如何在unix下用java程序连接Nt 上的access?
我已经实现了NT访问NT上的access:
import java.sql.*;
public class connect {
public static void main(String[] args)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
java.sql.Connection conn = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=\\192.168.10.88\\soon\\db2.mdb;PWD=","","");
java.sql.Statement st = conn.createStatement();
java.sql.ResultSet rs = st.executeQuery("select * from table1");
} catch (Exception e) {
System.out.println(e.toString());
}
System.out.println("over");
}
}