对比两个数据库是否有不同的地方

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) {
		int i = selectSqlite3().size();
		int j = selectSqlite3hlly().size();
		System.out.println(i == j);

		Vector<Hashtable<String, Object>> vhso = selectSqlite3();
		Vector<Hashtable<String, Object>> vhsoh = selectSqlite3hlly();
		int l = 0;
		for (int k = 0; k < i; k++) {
			String s1 = vhso.get(k).get("FullName").toString();
			String s2 = vhsoh.get(k).get("juan").toString();
			String s3 = vhso.get(k).get("ChapterSN").toString();
			String s4 = vhsoh.get(k).get("zhang").toString();
			String s5 = vhso.get(k).get("VerseSN").toString();
			String s6 = vhsoh.get(k).get("jie").toString();
			String s7 = vhso.get(k).get("strjw").toString();
			String s8 = vhsoh.get(k).get("jingwen").toString();

			System.out.println(s1.equals(s2));
			System.out.println(s3.equals(s4));
			System.out.println(s5.equals(s6));
			System.out.println(s7.equals(s8));
			if (!s1.equals(s2)) {
				l++;
			}
			if (!s3.equals(s4)) {
				l++;
			}
			if (!s5.equals(s6)) {
				l++;
			}
			if (!s7.equals(s8)) {
				l++;
				System.out.println(s7);
				System.out.println(s8);
				try {
					Thread.sleep(500);
				} catch (InterruptedException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}

		}
		System.out.println("不同之处有" + l);
	}

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

		String className = "org.sqlite.JDBC";
		String connectionString = "jdbc:sqlite:HolyBible.sqlite3";
		String sql = "select * from t_HolyBible order by rowid 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;
	}

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

		String className = "org.sqlite.JDBC";
		String connectionString = "jdbc:sqlite:HolyBiblesjhlly.sqlite3";
		String sql = "select * from t_HolyBible order by rowid 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;
	}

	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;
	}
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值