sqlserver2sqlite

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) {
		// TODO Auto-generated method stub
		Vector<Hashtable<String, Object>> vhso = selectSqlServer();

		for (int i = 0; i < vhso.size(); i++) {
			Hashtable<String, Object> hso = vhso.get(i);
			selectSqlite3(hso.get("juan").toString(), Integer.parseInt(hso.get("zhang").toString()),
					Integer.parseInt(hso.get("jie").toString()), hso.get("jingwen").toString());
		}
	}

	public static void selectSqlite3(String juan, int zhang, int jie, String jingwen) {

		String className = "org.sqlite.JDBC";
		String connectionString = "jdbc:sqlite:HolyBible.sqlite3";
		String sql = "insert into t_HolyBible values (?, ?, ?, ?)";

		try {
			Class.forName(className);
			try (Connection c = DriverManager.getConnection(connectionString);
					PreparedStatement ps = c.prepareStatement(sql);) {
				ps.setString(1, juan);
				ps.setInt(2, zhang);
				ps.setInt(3, jie);
				ps.setString(4, jingwen);
				ps.executeUpdate();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public static Vector<Hashtable<String, Object>> selectSqlServer() {

		String className = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		String connectionString = "jdbc:sqlserver://localhost:1433;databaseName=HolyBible;user=sa;password=abcdefg1;encrypt=false;";
		String sql = "select juan,zhang,jie,jingwen from t_HolyBible order by hbid asc";

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

		try {
			Class.forName(className);
			try (Connection c = DriverManager.getConnection(connectionString);
					PreparedStatement ps = c.prepareStatement(sql);) {

				try (ResultSet rs = ps.executeQuery();) {
					ResultSetMetaData rsmd = rs.getMetaData();
					int gcc = rsmd.getColumnCount();

					while (rs.next()) {
						Hashtable<String, Object> hso = new Hashtable<String, Object>();
						for (int i = 1; i <= gcc; i++) {
							String s = rsmd.getColumnName(i);
							Object o = rs.getObject(s);
							if (o == null) {
								o = "";
							}
							hso.put(s, o);
						}
						vhso.add(hso);
					}
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return vhso;
	}
}