67,515
社区成员
发帖
与我相关
我的任务
分享
static String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
static String DBURL = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=c:\\db3.mdb";
static String DBUSER = "";
static String DBPASSWORD = "";
static Connection conn = null;
public static void main(String[] args){
try{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from test");
while(rs.next()){
System.out.println(rs.getObject(1));
}
}catch(Exception e){
System.out.println(e);
}
}