Java连接access数据库-2

package com.access;

import java.sql.*;

/**

* This is a sample program for RmiJdbc client/server jdbc Driver RmiJdbc relies

* on Java RMI for jdbc objects distribution

*

* 使用ODBC连接Access数据库

*

* 必须在 控制面板 --> 管理工具 --> 数据源 (ODBC) -->中添加一个数据源Microsoft Access Driver

*

*/

public class ODBCDemo2 {

public static void main(String[] args) {

try {

// Register JDBC/ODBC Driver in jdbc DriverManager

// On some platforms with some java VMs, newInstance() is

// necessary...

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

// Test with MS Access database (rjdemo ODBC data source)

String url = "jdbc:odbc:rjdemo";

java.sql.Connection c = DriverManager.getConnection(url, "admin", "rjdemo");

java.sql.Statement st = c.createStatement();

java.sql.ResultSet rs = st.executeQuery("select * from contact");

ResultSetMetaData md = rs.getMetaData();

while (rs.next()) {

for (int i = 1; i <= md.getColumnCount(); i++) {

System.out.print(rs.getString(i) + " | ");

}

System.out.println();

}

rs.close();

} catch (Exception e) {

e.printStackTrace();

}

}

};

---

---

package com.access;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

/**

* 使用ODBC连接Access数据库

*

*

* @author Thomas.Tang

* @author 2011-3-10

*/

public class ODBCDemo1 {

static {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

public static void main(String[] args) throws Exception {

String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://MSaccess//rjdemo.mdb";

Connection conn = DriverManager.getConnection(url, "admin", "rjdemo");

String sql = "select * from contact";

PreparedStatement stm = conn.prepareStatement(sql);

ResultSet rs = stm.executeQuery();

ResultSetMetaData md = rs.getMetaData();

while (rs.next()) {

for (int i = 1; i <= md.getColumnCount(); i++) {

System.out.print(rs.getString(i) + " | ");

}

System.out.println();

}

rs.close();

stm.close();

conn.close();

}

}