给你一个不用使用数据源用java直接连接数据源的方法:import java.sql.*; public class Access{ public static void main(String args[]) throws Exception{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\databases\\access.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from table");
while(rs.next())
System.out.println(rs.getString("player"));
rs.close();
stmt.close();
conn.close();
}
}
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\databases\\access.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from table");
while(rs.next())
System.out.println(rs.getString("player"));
rs.close();
stmt.close();
conn.close();
}
}
你把你的这句SQL语句放到ACCESS中去执行一下,看一看执行的通吗?如果你调试好了再来调试JAVA的程序的话, 那就肯定没有问题的了