我想比较两个数据库,看看里面的表格是不是相同,现在的问题是如何对两个数据库进行比较,数据库名取DATABASE1和DATABASE2,如果DATABASE1里多了一张表格,那我希望能在DATABASE2里也能创建一张表格出来,不知道这样能不能实现?请高手指点下啊,谢谢了,下面是我的一部分代码,希望能在此基础上改进,非常感谢。
import java.io.*;
import java.sql.*; public class Mainupdate {
private Connection Scon = null;
private PreparedStatement Spstmt=null;
private Statement Sstmt=null;
private ResultSet Srst = null;
private Connection Ccon = null;
private PreparedStatement Cpstmt=null;
private Statement Cstmt=null;
private ResultSet Crst = null; /**
* @param args
*/
public Mainupdate()
{
FileReader fr2=null;
try {
fr2=new FileReader("//usr/jakarta-tomcat-5.0.28/webapps/nong/data/IPS.txt");
fr2=new FileReader("//usr/jakarta-tomcat-5.0.28/webapps/nong/data/IPC.txt");
} catch (FileNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}//建立FileReader对象,并实例化为fr
BufferedReader br2=new BufferedReader(fr2);//建立BufferedReader对象,并实例化为br
BufferedReader br3=new BufferedReader(fr2);
String Line2 = null;
String Line3=null;
try {
Line2 = br2.readLine();
Line3=br3.readLine();
System.out.println(Line2);
System.out.println(Line3);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//从文件读取一行字符串
//服务端
String Surl="jdbc:mysql://"+Line2+"/nongc";
String Suser="myuser";
String Spassword="123456";
/* String Surl="jdbc:mysql://127.0.0.1/nongc";
String Suser="nong";
String Spassword="zqsic";
*/
//客户端
String Curl="jdbc:mysql://"+Line3+"/nongc";
String Cuser="myuser";
String Cpassword="123456";
//连接数据库
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("加载不到com.mysql.jdbc.Driver");
System.exit(1);
}
try {
Scon =DriverManager.getConnection(Surl, Suser, Spassword);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接不到远程数据库"+Surl);
System.exit(1);
}
try {
Ccon=DriverManager.getConnection(Curl, Cuser, Cpassword);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接不到本地数据库");
System.exit(1);
}
try {
br2.close();
fr2.close();//关闭文件
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
}
两个数据库连上了,现在就差比较数据库里面的表格
import java.io.*;
import java.sql.*; public class Mainupdate {
private Connection Scon = null;
private PreparedStatement Spstmt=null;
private Statement Sstmt=null;
private ResultSet Srst = null;
private Connection Ccon = null;
private PreparedStatement Cpstmt=null;
private Statement Cstmt=null;
private ResultSet Crst = null; /**
* @param args
*/
public Mainupdate()
{
FileReader fr2=null;
try {
fr2=new FileReader("//usr/jakarta-tomcat-5.0.28/webapps/nong/data/IPS.txt");
fr2=new FileReader("//usr/jakarta-tomcat-5.0.28/webapps/nong/data/IPC.txt");
} catch (FileNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}//建立FileReader对象,并实例化为fr
BufferedReader br2=new BufferedReader(fr2);//建立BufferedReader对象,并实例化为br
BufferedReader br3=new BufferedReader(fr2);
String Line2 = null;
String Line3=null;
try {
Line2 = br2.readLine();
Line3=br3.readLine();
System.out.println(Line2);
System.out.println(Line3);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//从文件读取一行字符串
//服务端
String Surl="jdbc:mysql://"+Line2+"/nongc";
String Suser="myuser";
String Spassword="123456";
/* String Surl="jdbc:mysql://127.0.0.1/nongc";
String Suser="nong";
String Spassword="zqsic";
*/
//客户端
String Curl="jdbc:mysql://"+Line3+"/nongc";
String Cuser="myuser";
String Cpassword="123456";
//连接数据库
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("加载不到com.mysql.jdbc.Driver");
System.exit(1);
}
try {
Scon =DriverManager.getConnection(Surl, Suser, Spassword);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接不到远程数据库"+Surl);
System.exit(1);
}
try {
Ccon=DriverManager.getConnection(Curl, Cuser, Cpassword);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接不到本地数据库");
System.exit(1);
}
try {
br2.close();
fr2.close();//关闭文件
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
}
}
两个数据库连上了,现在就差比较数据库里面的表格
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货