一种不使用数据源用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://projects//demo.mdb";
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection conn=drivermanager.getconnection(strurl) ;
statement stmt=conn.createstatement();
resultset rs=stmt.executequery("select * from mcp_swty_player");
while(rs.next())
system.out.println(rs.getstring("player_mobile"));
rs.close();
stmt.close();
conn.close();
}
}
闽公网安备 35060202000074号