access转sqlite3

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.Hashtable;
import java.util.Vector;

public class Main {
	public static void main(String[] args) {
		try {
			Class.forName(Main.className);
			try (Connection conn = DriverManager.getConnection(connectionString);
					PreparedStatement ps = conn.prepareStatement(
							"insert into t_HolyBible (FullName, ShortName, PY, ChapterSN, VerseSN, strjw, NCB, LCC, TCB, NIV) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
				Vector<Hashtable<String, Object>> vhso = Main.selectSqlite3("access");
				for (Hashtable<String, Object> hso : vhso) {
					ps.setString(1, hso.get("FullName").toString());
					ps.setString(2, hso.get("ShortName").toString());
					ps.setString(3, hso.get("PY").toString());
					ps.setString(4, hso.get("ChapterSN").toString());
					ps.setString(5, hso.get("VerseSN").toString());
					ps.setString(6, hso.get("strjw").toString());
					ps.setString(7, hso.get("NCB").toString());
					ps.setString(8, hso.get("LCC").toString());
					ps.setString(9, hso.get("TCB").toString());
					ps.setString(10, hso.get("NIV").toString());
					ps.executeUpdate();
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private static String className = "org.sqlite.JDBC";
	private static String connectionString = "jdbc:sqlite:HolyBible.sqlite3";
	private static String user = "";
	private static String password = "";
	private static String sql = "select * from t_HolyBible where FullName = ? and ChapterSN = ? and VerseSN >= ? order by rowid asc";

	public static Vector<Hashtable<String, Object>> selectSqlite3(String sqlClass) {
		if (sqlClass != null && sqlClass.equals("access")) {
			className = "net.ucanaccess.jdbc.UcanaccessDriver";
			connectionString = "jdbc:ucanaccess://bible7.dat";
			user = "admin";
			password = "gqrjabcde";
			sql = "select * from bible, bibleid where bible.VolumeSN = bibleid.SN order by bible.id asc";
		}

		Vector<Hashtable<String, Object>> vhso = new Vector<Hashtable<String, Object>>();

		try {
			Class.forName(className);
			try (Connection connection = DriverManager.getConnection(connectionString, user, password);
					PreparedStatement preparedStatement = connection.prepareStatement(sql);) {
//				for (int i = 0; i < slist.length; i++) {
//					preparedStatement.setString(i + 1, slist[i]);
//				}
				try (ResultSet resultSet = preparedStatement.executeQuery();) {
					ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
					int getColumnCount = resultSetMetaData.getColumnCount();

					while (resultSet.next()) {
						Hashtable<String, Object> hso = new Hashtable<String, Object>();
						for (int i = 1; i <= getColumnCount; i++) {
							String getColumnName = resultSetMetaData.getColumnName(i);
							Object sCellValue = resultSet.getObject(getColumnName);
							if (sCellValue == null) {
								sCellValue = "";
							}
							hso.put(getColumnName, sCellValue);
						}
						vhso.add(hso);
					}
				}
			}
		} catch (Exception exception) {
			exception.printStackTrace();
		}
		return vhso;
	}

}