把access数据倒入到mysql数据库中,帮忙看看,多谢!!
我想把access数据倒入到mysql数据库中,下面是相应的两个数据库连接语句,
帮忙看看,对不对??谢谢!
//access数据源连接语句
Connection con;
Statement stmt;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:CIC","","");
stmt=con.createStatement();
//mysql数据库的连接语句
String sDBDriver = "org.gjt.mm.mysql.Driver";
Class.forName(sDBDriver);
Connection conn=DriverManager.getConnection("jdbc:mysql://10.0.0.3/CMS","mysql","123456");
Statement stmt2=conn.createStatement();