本文介绍了一个使用Java通过ODBC驱动连接并查询Microsoft Access数据库的例子。示例代码展示了如何建立数据库连接、执行SQL查询以及获取查询结果。
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();
}
}
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();
}
}
扫一扫
1459
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
