java创建临时表代码_JAVA 创建临时表

// 创建一个临时表

String ceatetable = null;

if (getDao().getDBType() == DBConsts.SQLSERVER) {

ceatetable = "select * into  temp" + InvocationInfoProxy.getInstance().getUserCode() + "  from  (" + sqlbook + " union all " + sqlcus + ") temp1";

} else if (getDao().getDBType() == DBConsts.ORACLE) {

ceatetable = "create table temp" + InvocationInfoProxy.getInstance().getUserCode() + " as (" + sqlbook + " union all " + sqlcus + ")";

} else if (getDao().getDBType() == DBConsts.DB2) {

ceatetable = "create table temp" + InvocationInfoProxy.getInstance().getUserCode() + " as (" + sqlbookdb2 + " union all " + sqlcusdb2 + ") data initially deferred refresh deferred";

}

createTable(ceatetable);

if (getDao().getDBType() == DBConsts.DB2) {

// getDao().executeUpdate("refresh table temp"+InvocationInfoProxy.getInstance().getUserCode());

String refrshtable = "refresh table temp" + InvocationInfoProxy.getInstance().getUserCode();

JdbcSession session = null;

try {

session = new JdbcSession();

session.getConnection().createStatement().execute(refrshtable);

} catch (Exception e) {

nc.bs.logging.Logger.error(e);

e.printStackTrace();

} finally {

if (session != null) {

session.closeAll();

}

}

}

/** * 创建一个表写法 方法说明 *  * @author Think 2012-8-29 * @throws BusinessException */ private void createTable(String sql) throws BusinessException { JdbcSession session = null; try { session = new JdbcSession(); session.getConnection().createStatement().execute(sql); } catch (Exception e) { Logger.error(e.getMessage(), e); throw new BusinessException(e); } finally { if (session != null) { session.closeAll(); } } }