实验中遇到这个需求,可等了一天…
分析:
正常思维
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class SqlServer {
public static void main(String[] args) {
Getinfo();
}
public static void Getinfo(){
// List<Map<String,String>> list=new ArrayList<>();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:sqlserver://;databaseName=database";
Connection conn = DriverManager.getConnection("jdbc:mysql://","用户名","密码");
Connection con = DriverManager.getConnection(url,"用户名","密码");
System.out.println("数据库连接成功");
Statement stmt = con.createStatement();
Statement stmt1 = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from table");
int count=0;
while(rs.next()){
if(count>4646622){
String sql="insert into ......";
stmt1.execute(sql);
}
count++;
if(count>10000000){
break;
}
}
System.out.println("执行完成");
con.close();
}
catch(Exception e) {
System.out.println("数据库连接失败\n" + e.toString());
}
// return list;
}
}
找个工具,学习下前辈
Navicat
找到需要导入的数据库
注:
1、不保存密码往往会报错无法打开文件
2、列太多有时也会报错,未具体测试