| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.util.CollectionUtils; |
| | | import plm.ddlTool.client.DDLToolClient; |
| | | |
| | | import java.io.File; |
| | | import java.io.FileNotFoundException; |
| | |
| | | String alterSql = BtmProvider.getInstance().getAddPKSql(btmItem.name); |
| | | sql = sql.substring(0, sql.lastIndexOf(",")); |
| | | sql = sql + "\n)"; |
| | | DDLToolClient.getService().executeUpdateOracle(sql); |
| | | DDLToolClient.getService().executeUpdateOracle(alterSql); |
| | | //TODO 暂时不清楚用何种方式创建表,此处先注释掉 |
| | | // DDLToolClient.getService().executeUpdateOracle(sql); |
| | | // DDLToolClient.getService().executeUpdateOracle(alterSql); |
| | | }catch (PLException vciError){ |
| | | throw WebUtil.getVciBaseException(vciError); |
| | | } |
| | |
| | | } |
| | | addSql = VciBaseUtil.removeComma(addSql.replace("\n\t","")); |
| | | addSql = addSql + ")"; |
| | | DDLToolClient.getService().batchExecuteUpdateOracle(new String[]{addSql}); |
| | | //TODO 不清楚具体使用什么方法,暂时注释,但不要删除 |
| | | // DDLToolClient.getService().batchExecuteUpdateOracle(new String[]{addSql}); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | removeSql = VciBaseUtil.removeComma(removeSql.replace("\n\t","")); |
| | | removeSql = removeSql + ")"; |
| | | DDLToolClient.getService().batchExecuteUpdateOracle(new String[]{removeSql}); |
| | | //TODO 不清楚具体使用什么方法,暂时注释,但不要删除 |
| | | // DDLToolClient.getService().batchExecuteUpdateOracle(new String[]{removeSql}); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | sql = sql.substring(0, sql.lastIndexOf(",")); |
| | | sql = sql + "\n)"; |
| | | DDLToolClient.getService().executeUpdateOracle(sql); |
| | | DDLToolClient.getService().executeUpdateOracle(LinkTypeProvider.getInstance().getAddPKSql(linkType.name)); |
| | | //TODO 不清楚具体使用什么方法,暂时注释,但不要删除 |
| | | // DDLToolClient.getService().executeUpdateOracle(sql); |
| | | // DDLToolClient.getService().executeUpdateOracle(LinkTypeProvider.getInstance().getAddPKSql(linkType.name)); |
| | | }catch (PLException vciError){ |
| | | throw WebUtil.getVciBaseException(vciError); |
| | | } |