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();

 

}

 

}