?
?? ODBC访问 Access数据库
?
class="java" name="code"> try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); try { Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=\\192.168.1.108/db/EyeTest.mdb"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); }
??? ODBC访问Paradox数据库 (如果遇到连接不同设置编码问题 设置language driver 为需要的语言)更改语言需要 database Desktop 查看器更改
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); try { Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.x;DefaultDir=\\192.168.1.138/db;Dbq=\\192.168.1.138/db;CollatingSequence=ASCII"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
?
?