//定义事务处理
Statement st = connection.createStatement();
st.addBatch(instancesql);
//添加主insert
st.addBatch(mainsql);
st.addBatch(updatesql);
//设置连接
connection.setAutoCommit(false);
/**提交事务*/
st.executeBatch();
connection.commit();
st.close();
connection.setAutoCommit(true);
执行到 st.executeBatch(); 就停止了!!!!!!!不在往下执行