Dao.java升级版

package a;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;

public class Dao {
	public static ArrayList<HashMap<String, Object>> select(String juan, String zhang, String jie) {
		ArrayList<HashMap<String, Object>> alhmso = new ArrayList<HashMap<String, Object>>();
		try {
			Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
			try (Connection conn = DriverManager.getConnection("jdbc:ucanaccess://bible7.dat", "admin", "gqrjabcde")) {
				try (PreparedStatement ps = conn.prepareStatement(
						"select * from bible, bibleid where bible.VolumeSN = bibleid.SN and FullName = ? and ChapterSN = ? and VerseSN >= ?")) {
					ps.setString(1, juan);
					ps.setString(2, zhang);
					ps.setString(3, jie);
					try (ResultSet rs = ps.executeQuery()) {
						ResultSetMetaData rsmd = rs.getMetaData();
						int getColumnCount = rsmd.getColumnCount();
						while (rs.next()) {
							HashMap<String, Object> hmso = new HashMap<String, Object>();
							for (int i = 1; i <= getColumnCount; i++) {
								String getColumnName = rsmd.getColumnName(i);
								Object sCellValue = rs.getObject(getColumnName);
								if (sCellValue == null) {
									sCellValue = "";
								}
								hmso.put(getColumnName, sCellValue);
							}
							alhmso.add(hmso);
						}
					}
				}
			}
		} catch (

		Exception e) {
			e.printStackTrace();
		}
		return alhmso;
	}
}