connectaccess.java

在eclipse开发环境下使用java变成语言连接ODBC,读取数据

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectAccess {

    public static void main(String[] args) {
	try {
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    Connection con = DriverManager.getConnection("jdbc:odbc:stu", "",
		    "");
	    Statement stmt = con.createStatement();
	    ResultSet rs = stmt.executeQuery("select * from info");
	    while (rs.next()) {
		System.out.print("\t编号:" + rs.getString(1));
		System.out.print("\t姓名:" + rs.getString(2));
		System.out.print("\t性别:" + rs.getString(3));
		System.out.println();
	    }
	    rs.close();
	    stmt.close();
	    con.close();
	} catch (Exception e) {
	    e.printStackTrace();
	}

    }

}