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