JAva jdbcを使用してアクセスアクセスを容易にする


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

public class TestAccess {
	public static void main(String[] args) {
		String path = TestAccess.class.getResource("testaccess.mdb").getPath().substring(1);
		//String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=src\\test\\testaccess.mdb";
		String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn = DriverManager.getConnection(strurl);

			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from user");
			while(rs.next()){
				System.out.print(rs.getString("id")+"\t");
				System.out.print(rs.getString("name")+"\t");
				System.out.println(rs.getString("password"));
			}
			rs.close();
			stmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}