Connection con;
Statement st;
ResultSet result;
String url = "jdbc:odbc:dataBaseName";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url);
st = con.createStatement();
result = st.executeQuery("select * from table");
while (result.next()) {
System.out.println(result.getObject(1));
}
具体步骤如下:
1.先创建系统数据源(DSN),如数据源名为 test
2.参考代码如下import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DBUtility { private final static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
private String url = "jdbc:odbc:test";
private String username = "";
private String passwd = ""; protected DBUtility() {
try {
Class.forName(driver);//加载数据库驱动程序
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
} public Connection getConnection() throws SQLException {
Connection conn = DriverManager.getConnection(url, username, passwd);
conn.setAutoCommit(false);
return conn;
} public static void main(String[] args) throws Exception {
DBUtility dbu = new DBUtility();
dbu.getConnection();
}