jdbc insert语句插入不生效的问题
请问各位大虾,为何我的insert语句不生效呢??
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection coon = DriverManager.getConnection(url, user, password);
CreateSqlHelper sqlHelper = new CreateSqlHelper();
String sql = sqlHelper.createTableSql();
Statement stmt = coon.createStatement();
stmt.addBatch(sql);
String sql2 = sqlHelper.createInsertSql(this.path,sqlHelper.getTablename(),this.getColCount());
System.out.println("*********sql2 :"+sql2);
String[] sql3 = sql2.split(";");
for(int i = 0 ; i < sql3.length ; i++){
stmt.addBatch(sql3[i]);
}
stmt.executeBatch();
coon.close();
其中stmt.addBatch(sql);sql是建表的sql语句 ,stmt.addBatch(sql3[i]);是逐个添加insert语句,stmt.executeBatch();执行批处理。
可是表创建成功了,却没有数据导入进来。插入语句也都有输出。都正确。而且整个过程无任何报错。希望高人指点~~~