1.导入dmp文件:
imp cw/cw@XE fromuser=cw touser=cw file=f:\cw10.dmp
导出dmp:
exp 用户名/密码@网络服务名 file=xxx.dmp tables=(表名);
2.大数据写入
DataSource dataSource = jdbcTemplate.getDataSource();
try {
Connection con = dataSource.getConnection();
// sql前缀
String prefix ="INSERT INTO tzdata(ProbMac,DevcMac,Intime,OutTime,Rssi,ProbKey)values";
// 保存sql后缀
StringBuffer suffix = new StringBuffer();
// 设置事务为非自动提交
con.setAutoCommit(false);
int z =0;
PreparedStatement pst = con.prepareStatement("");
for (int i = 0; i < mapLists.size(); i++) {
z++;
suffix.append("('" + list.get(i).get("ProbMac") + "', '"+list.get(i).get("DevcMac")+"', '" +list.get(i).get("Intime")+"', '" +list.get(i).get("Intime")+"'," +Integer.parseInt(list.get(i).get("Rssi").replaceAll(" ", ""))+",'" +list.get(i).get("ProbKey")+ "'),");
if(z%2000==0){
// 构建完整sql
String sql = prefix + suffix.substring(0, suffix.length() - 1);
// 添加执行sql
pst.addBatch(sql);
// 执行操作
pst.executeBatch();
// 提交事务
con.commit();
suffix = new StringBuffer();
System.out.println("导入数据===="+z+"条");
}
}
pst.close();
con.close();
} catch (SQLException e1) {
e1.printStackTrace();
}