package com.ruoyi;
|
|
import java.sql.Connection;
|
|
import java.sql.DriverManager;
|
|
import java.sql.ResultSet;
|
|
import java.sql.SQLException;
|
|
import java.sql.Statement;
|
|
|
|
public class JDBCAccess {
|
|
public static void main(String[] args) {
|
|
// url表示需要连接的数据源的位置，此时使用的是JDBC-ODBC桥的连接方式，url是"jdbc:odbc:数据源名"
|
|
String url2= "jdbc:Access://192.168.141.104/jdbc:odbc:EventData";
|
String url = "jdbc:rmi://192.168.141.104/jdbc:odbc:EventData";
|
try {
|
|
Class.forName("com.hxtt.sql.access.AccessDriver");
|
|
Connection conn = DriverManager.getConnection(url);
|
|
Statement stat = conn.createStatement();
|
|
String sql = "select * from events";
|
|
ResultSet rs = stat.executeQuery(sql);
|
|
while(rs.next()){
|
|
System.out.println(rs.getString(2));
|
|
}
|
|
} catch (ClassNotFoundException | SQLException e) {
|
|
e.printStackTrace();
|
|
}
|
|
}
|
|
}
|
