executeSql

/**
	 * 独立提交的执行sql方法
	 * 
	 * @param sql
	 *            完整执行sql 支持多租户表 <br/>
	 *            例：UPDATE {MR_MKT_RES_INST} SET AMOUNT=AMOUNT+:amount
	 * @param param
	 *            sql中的参数
	 * @throws Exception
	 * @return 返回表示更新的结果集的条数
	 */
	public static int executeSQL(String sql, Map param) throws Exception {
		Connection conn = ServiceManager.getSession().getConnection();
		List<String> subTableList = new ArrayList<String>();
		for (int i = 0; i < sql.length(); i++) {
			if (sql.charAt(i) == '{') {
				StringBuilder sb = new StringBuilder();
				for (int j = i; j < sql.length(); j++) {
					sb.append(sql.charAt(j));
					if (sql.charAt(j) == '}') {
						subTableList.add(sb.toString());
						i = j;
						break;
					}
				}
			}
		}
		for (String subTableName : subTableList) {
			String newTableName = SplitTableFactory.createTableName(subTableName.toUpperCase(), new DataContainer());
			sql = sql.replace(subTableName, newTableName);
		}
		return ServiceManager.getDataStore().execute(conn, sql, param);
	}
	
	/**
	 * 独立提交的执行sql方法
	 * 
	 * @param sql
	 *            完整执行sql 支持多租户表 <br/>
	 *            例：UPDATE {MR_MKT_RES_INST} SET AMOUNT=AMOUNT+:amount
	 * @param param
	 *            sql中的参数
	 * @throws Exception
	 * @return 返回表示更新的结果集的条数
	 */
	public static int executeSql(String sql, Map param) throws Exception {
		Connection conn = ServiceManager.getSession().getConnection();
		Matcher m = Pattern.compile("\\{(.*?)\\}").matcher(sql);
		while (m.find()) {
			String newTableName = SplitTableFactory.createTableName(m.group().toUpperCase(), new DataContainer());
			sql = sql.replace(m.group(), newTableName);
		}
		return ServiceManager.getDataStore().execute(conn, sql, param);
	}