import java.sql.*;
import java.io.*;
class Access{
public static void main(String[] args){
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\helpdb.mdb";
//String url = "jdbc:odbc:helpdb";//helpdb為ODBC資料來源名稱
Connection conn = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url , "" , "");
Statement statement=conn.createStatement();
ResultSet rs=statement.executeQuery("select * from TAttachment");
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}//end of main
}
全站熱搜
留言列表
