Java Code Examples for org.springframework.jdbc.support.rowset.SqlRowSet#next()

The following examples show how to use org.springframework.jdbc.support.rowset.SqlRowSet#next() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: StatusCodeAndDescriptionForPurapDocumentsDaoJdbc.java    From kfs with GNU Affero General Public License v3.0 6 votes vote down vote up
/**
 * @see org.kuali.kfs.module.purap.dataaccess.StatusCodeAndDescriptionForPurapDocumentsDao#getLineItemReceivingDocumentStatuses()
 */
public Map<String, String> getLineItemReceivingDocumentStatuses() {
    LOG.debug("getLineItemReceivingDocumentStatuses() started");
    
    Map<String, String> lineItemReceivingStatuses = new HashMap<String, String>();
    
    try {
        SqlRowSet statusesRowSet = getJdbcTemplate().queryForRowSet("SELECT * FROM PUR_RCVNG_LN_STAT_T ORDER BY RCVNG_LN_STAT_CD"); 

        while (statusesRowSet.next()) {
            lineItemReceivingStatuses.put(statusesRowSet.getString("RCVNG_LN_STAT_CD"), statusesRowSet.getString("RCVNG_LN_STAT_DESC"));
        }
        
        LOG.debug("getLineItemReceivingDocumentStatuses() exited");
        
        return lineItemReceivingStatuses;
    } catch (DataAccessException dae) {
        return lineItemReceivingStatuses;
    }
}
 
Example 2
Source File: AllUserActorConnectorTest.java    From FoxBPM with Apache License 2.0 6 votes vote down vote up
/**
 * 资源共享
 * <p>1.使用场景:将任务共享给所有用户</p>
 * <p>2.预置条件:<p>
 *          1.发布一条带有任务分配(分配所有人)的流程定义
 * <p>3.处理过程:首先,启动任务使流程进入分配任务节点上</p>
 * <p>4.测试用例:</p>
 * <p>		1.执行完成后,相应查看资源分配是否是所以人都能看得到</p>
 * <p>		2.执行完成后,相应查看foxbpm_run_taskidentitylink 记录是否任务的处理者是foxbpm_all_user</p>
 */
@Test
@Deployment(resources = { "org/foxbpm/connector/test/actorconnector/AllUserActorConnector/AllUserActorConnectorTest_1.bpmn" })
public void testAllUserActorConnector() {
	Authentication.setAuthenticatedUserId("admin");
	// 启动流程
	runtimeService.startProcessInstanceByKey("AllUserActorConnectorTest_1");

	Task task = taskService.createTaskQuery().processDefinitionKey("AllUserActorConnectorTest_1").taskNotEnd().singleResult();
	// 同时分配给两个人
	String taskId = task.getId();
	SqlRowSet sqlRowSet = jdbcTemplate.queryForRowSet("select * from foxbpm_run_taskidentitylink WHERE TASK_ID = '" + taskId + "'");

	String userId = null;
	if (sqlRowSet.next()) {
		userId = sqlRowSet.getString("USER_ID");
	}
	assertEquals("foxbpm_all_user", userId);
}
 
Example 3
Source File: StatusCodeAndDescriptionForPurapDocumentsDaoJdbc.java    From kfs with GNU Affero General Public License v3.0 6 votes vote down vote up
/**
 * @see org.kuali.kfs.module.purap.dataaccess.StatusCodeAndDescriptionForPurapDocumentsDao#getPaymentRequestDocumentStatuses()
 */
public Map<String, String> getPaymentRequestDocumentStatuses() {
    LOG.debug("getPaymentRequestDocumentStatuses() started");
    
    Map<String, String> paymentRequestStatuses = new HashMap<String, String>();
    
    try {
        SqlRowSet statusesRowSet = getJdbcTemplate().queryForRowSet("SELECT * FROM AP_PMT_RQST_STAT_T ORDER BY PMT_RQST_STAT_CD"); 

        while (statusesRowSet.next()) {
            paymentRequestStatuses.put(statusesRowSet.getString("PMT_RQST_STAT_CD"), statusesRowSet.getString("PMT_RQST_STAT_DESC"));
        }
        
        LOG.debug("getPaymentRequestDocumentStatuses() exited");
        
        return paymentRequestStatuses;
    } catch (DataAccessException dae) {
        return paymentRequestStatuses;
    }
}
 
Example 4
Source File: ListGrid.java    From dhis2-core with BSD 3-Clause "New" or "Revised" License 6 votes vote down vote up
@Override
public Grid addRows( SqlRowSet rs, int maxLimit )
{
    int cols = rs.getMetaData().getColumnCount();

    while ( rs.next() )
    {
        addRow();

        for ( int i = 1; i <= cols; i++ )
        {
            addValue( rs.getObject( i ) );

            if ( maxLimit > 0 && i > maxLimit )
            {
                throw new IllegalStateException( "Number of rows produced by query is larger than the max limit: " + maxLimit );
            }
        }
    }

    return this;
}
 
Example 5
Source File: SelectUserActorConnectorTest.java    From FoxBPM with Apache License 2.0 6 votes vote down vote up
/**
 * 任务分配给指定用户可以多个
 * <p>1.使用场景:需要将任务分配指定用户</p>
 * <p>2.预置条件:创建一个含有人工任务并且任务分配给指定用户的流程定义并发布<p>
 * <p>3.处理过程:首先,启动任务使流程进入分配任务节点上</p>
 * <p>4.测试用例:</p>
 * <p>		1.执行完成后,相应查看资源是否分配给指定用户</p>
 */
@Test
@Deployment(resources = { "org/foxbpm/connector/test/actorconnector/SelectUserActorConnector/SelectUserActorConnectorTest_1.bpmn" })
public void testSelectUserActorConnector() {
	Authentication.setAuthenticatedUserId("admin");
	// 启动流程
	runtimeService.startProcessInstanceByKey("SelectUserActorConnectorTest_1");
	Task task = taskService.createTaskQuery().processDefinitionKey("SelectUserActorConnectorTest_1").taskNotEnd().singleResult();
	SqlRowSet sqlRowSet = jdbcTemplate.queryForRowSet("select * from foxbpm_run_taskidentitylink WHERE TASK_ID = '" + task.getId() + "'");
	List<String> userIds = new ArrayList<String>();
	while (sqlRowSet.next()) {
		userIds.add(sqlRowSet.getString("USER_ID"));
	}
	if (!userIds.contains("a") || !userIds.contains("b")) {
		throw new FoxBPMConnectorException("选择用户连接器出现异常");
	}
}
 
Example 6
Source File: HibernateTimeZoneIT.java    From java-microservices-examples with Apache License 2.0 5 votes vote down vote up
private void assertThatDateStoredValueIsEqualToInsertDateValueOnGMTTimeZone(SqlRowSet sqlRowSet, String expectedValue) {
    while (sqlRowSet.next()) {
        String dbValue = sqlRowSet.getString(1);

        assertThat(dbValue).isNotNull();
        assertThat(dbValue).isEqualTo(expectedValue);
    }
}
 
Example 7
Source File: JdbcOrgUnitAnalyticsManager.java    From dhis2-core with BSD 3-Clause "New" or "Revised" License 5 votes vote down vote up
@Override
public Map<String, Integer> getOrgUnitData( OrgUnitQueryParams params )
{
    Map<String, Integer> dataMap = new HashMap<>();

    List<String> columns = getMetadataColumns( params );

    String sql = getQuerySql( params );

    SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql );

    while ( rowSet.next() )
    {
        StringBuilder key = new StringBuilder();

        for ( String column : columns )
        {
            key.append( rowSet.getString( column ) ).append( DIMENSION_SEP );
        }

        key.deleteCharAt( key.length() - 1 );

        int value = rowSet.getInt( "count" );

        dataMap.put( key.toString(), value );
    }

    return dataMap;
}
 
Example 8
Source File: JdbcEventStore.java    From dhis2-core with BSD 3-Clause "New" or "Revised" License 5 votes vote down vote up
private void populateCache( IdScheme idScheme, List<Collection<DataValue>> dataValuesList, CachingMap<String, String> dataElementUidToIdentifierCache )
{
    Set<String> deUids = new HashSet<>();

    for ( Collection<DataValue> dataValues : dataValuesList )
    {
        for ( DataValue dv : dataValues )
        {
            deUids.add( dv.getDataElement() );
        }
    }

    if ( !idScheme.isAttribute() )
    {
        List<DataElement> dataElements = manager.get( DataElement.class, deUids );
        dataElements.forEach( de -> dataElementUidToIdentifierCache.put( de.getUid(), de.getCode() ) );
    }
    else
    {
        if ( !deUids.isEmpty() )
        {
            String dataElementsUidsSqlString = getQuotedCommaDelimitedString( deUids );

            String deSql =
                "select de.uid, de.attributevalues #>> '{" + idScheme.getAttribute() + ", value}' as value " +
                    "from dataelement de where de.uid in (" + dataElementsUidsSqlString + ") " +
                    "and de.attributevalues ? '" + idScheme.getAttribute() + "'";

            SqlRowSet deRowSet = jdbcTemplate.queryForRowSet( deSql );

            while ( deRowSet.next() )
            {
                dataElementUidToIdentifierCache.put( deRowSet.getString( "uid" ), deRowSet.getString( "value" ) );
            }
        }
    }
}
 
Example 9
Source File: CmsDataBackDaoImpl.java    From Lottery with GNU General Public License v2.0 5 votes vote down vote up
public List<String> listTables(String catalog) {
//	String sql = " show tables ";
	String sql = " SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='" + catalog + "' "; 
	List<String> tables = new ArrayList<String>();
	SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
	while (set.next()) {
		tables.add(set.getString(1));
	}
	return tables;
}
 
Example 10
Source File: StartEndNodeTest.java    From FoxBPM with Apache License 2.0 5 votes vote down vote up
/**
 * 任务启动和结束时记录任务信息
 * <p>1.使用场景:任务启动和结束需要记录信息 </p>
 * <p>2.预置条件:<p>
 *          1.发布流程定义
 * <p>3.处理过程:首先,启动任务使流程结束</p>
 * <p>4.测试用例:</p>
 * <p>		1.执行完成后,相应查看流程启动和结束任务信息</p>
 */
@Test
@Deployment(resources = { "org/foxbpm/engine/test/impl/runningtrack/ext/StartEndNode_1.bpmn" })
public void testFlowStartEnd() {
	Authentication.setAuthenticatedUserId("admin");
	// 启动流程
	ProcessInstance pi = this.runtimeService.startProcessInstanceByKey("StartEndNode_1");
	// 查看是否插入启动任务信息
	String sql = "select DISTINCT RES.* from FOXBPM_RUN_TASK RES WHERE   PROCESSINSTANCE_ID = '" + pi.getId() + "' and TASKTYPE = 'starteventtask'";
	SqlRowSet rowSet = jdbcTemplate.queryForRowSet(sql);
	boolean flag = false;
	if (rowSet.next()) {
		System.out.println(rowSet.getString("NODE_ID"));
		flag = true;
	}
	assertTrue("任务开始失败", flag);
	// 查询流程并驱动流程
	Task task = this.taskService.createTaskQuery().processDefinitionKey("StartEndNode_1").taskNotEnd().singleResult();

	ExpandTaskCommand expandTaskCommand = new ExpandTaskCommand();
	expandTaskCommand.setProcessDefinitionKey("StartEndNode_1");
	expandTaskCommand.setTaskCommandId("HandleCommand_2");
	expandTaskCommand.setTaskId(task.getId());
	expandTaskCommand.setCommandType("submit");
	expandTaskCommand.setBusinessKey("bizKey");
	expandTaskCommand.setInitiator("a");
	// 执行进入任务节点
	taskService.expandTaskComplete(expandTaskCommand, null);
	// 查看是否插入启动任务信息
	sql = "select DISTINCT RES.* from FOXBPM_RUN_TASK RES WHERE   PROCESSINSTANCE_ID = '" + pi.getId() + "' and TASKTYPE = 'endeventtask'";
	rowSet = jdbcTemplate.queryForRowSet(sql);
	flag = false;
	if (rowSet.next()) {
		System.out.println(rowSet.getString("NODE_ID"));
		flag = true;
	}
	assertTrue("任务结束失败", flag);
}
 
Example 11
Source File: CmsDataBackDaoImpl.java    From Lottery with GNU General Public License v2.0 5 votes vote down vote up
public List<Object[]> createTableData(String tablename) {
	int filedNum = getTableFieldNums(tablename);
	List<Object[]> results = new ArrayList<Object[]>();
	String sql = " select * from   " + tablename;
	SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
	while (set.next()) {
		Object[] oneResult = new Object[filedNum];
		for (int i = 1; i <= filedNum; i++) {
			oneResult[i - 1] = set.getObject(i);
		}
		results.add(oneResult);
	}
	return results;
}
 
Example 12
Source File: StorageServiceImpl.java    From dubbo-samples with Apache License 2.0 5 votes vote down vote up
@Override
public int queryCount(String commodityCode) {
    SqlRowSet rowSet = jdbcTemplate.queryForRowSet("select count from storage_tbl where commodity_code = ?",
            commodityCode);
    if (rowSet.next()) {
        int count = rowSet.getInt("count");
        LOGGER.info("Storage has " + count + " for " + commodityCode);
        return count;
    }
    return -1;
}
 
Example 13
Source File: HibernateTimeZoneIntegrationTest.java    From tutorials with MIT License 5 votes vote down vote up
private void assertThatDateStoredValueIsEqualToInsertDateValueOnGMTTimeZone(SqlRowSet sqlRowSet, String expectedValue) {
    while (sqlRowSet.next()) {
        String dbValue = sqlRowSet.getString(1);

        assertThat(dbValue).isNotNull();
        assertThat(dbValue).isEqualTo(expectedValue);
    }
}
 
Example 14
Source File: RightsDataServlet.java    From document-management-software with GNU Lesser General Public License v3.0 5 votes vote down vote up
/**
 * Useful method for retrieving the label for the users
 */
private Map<Long, String> getUsers(long tenantId) throws PersistenceException {
	UserDAO dao = (UserDAO) Context.get().getBean(UserDAO.class);
	SqlRowSet set = dao.queryForRowSet(
			"select ld_id, ld_username, ld_firstname, ld_name from ld_user where ld_deleted=0 and ld_tenantid="
					+ tenantId,
			null, null);
	Map<Long, String> users = new HashMap<Long, String>();
	while (set.next())
		users.put(set.getLong(1), set.getString(4) + " " + set.getString(3) + " (" + set.getString(2) + ")");
	return users;
}
 
Example 15
Source File: HibernateTimeZoneTest.java    From Spring-5.0-Projects with MIT License 5 votes vote down vote up
private void assertThatDateStoredValueIsEqualToInsertDateValueOnGMTTimeZone(SqlRowSet sqlRowSet, String expectedValue) {
    while (sqlRowSet.next()) {
        String dbValue = sqlRowSet.getString(1);

        assertThat(dbValue).isNotNull();
        assertThat(dbValue).isEqualTo(expectedValue);
    }
}
 
Example 16
Source File: GridUtils.java    From dhis2-core with BSD 3-Clause "New" or "Revised" License 5 votes vote down vote up
/**
 * Writes all rows in the SqlRowSet to the given Grid.
 */
public static void addRows( Grid grid, SqlRowSet rs )
{
    int cols = rs.getMetaData().getColumnCount();

    while ( rs.next() )
    {
        grid.addRow();

        for ( int i = 1; i <= cols; i++ )
        {
            grid.addValue( rs.getObject( i ) );
        }
    }
}
 
Example 17
Source File: HibernateTimeZoneIT.java    From alchemy with Apache License 2.0 5 votes vote down vote up
private void assertThatDateStoredValueIsEqualToInsertDateValueOnGMTTimeZone(SqlRowSet sqlRowSet, String expectedValue) {
    while (sqlRowSet.next()) {
        String dbValue = sqlRowSet.getString(1);

        assertThat(dbValue).isNotNull();
        assertThat(dbValue).isEqualTo(expectedValue);
    }
}
 
Example 18
Source File: OLATUpgrade_7_3_0.java    From olat with Apache License 2.0 4 votes vote down vote up
/**
 * @param string
 */
private void migrateDataFromGUIPreferences(final UpgradeManager upgradeManager, final UpgradeHistoryData uhd) {

    if (!uhd.getBooleanDataValue(TASK_MIGRATE_DATA_FROM_GUI_PROPERTIES_DONE)) {
        GUIPreferencesParser parser = new GUIPreferencesParser();
        JdbcTemplate template = new JdbcTemplate(upgradeManager.getDataSource());
        SqlRowSet srs = template
                .queryForRowSet("SELECT textvalue, identity FROM  o_property WHERE identity IS NOT NULL AND textvalue IS NOT NULL AND textvalue LIKE  '%InfoSubscription::subs%'");
        Long identityKey = 0L;
        int rowCount = 0;
        int counter = 0;
        while (srs.next()) {
            try {

                String prefsXml = srs.getString("textvalue");
                identityKey = srs.getLong("identity");
                Identity identity = security.loadIdentityByKey(identityKey);

                Document doc = parser.createDocument(prefsXml);

                List<String> infoSubscriptions = parser.parseDataForInputQuery(doc, parser.queryInfo);
                persistInfo(infoSubscriptions, "InfoSubscription::subscribed", identity);

                List<String> calendarSubscriptions = parser.parseDataForInputQuery(doc, parser.queryCal);
                persistInfo(calendarSubscriptions, "CourseCalendarSubscription::subs", identity);

                List<String> infoSubscriptionsNot = parser.parseDataForInputQuery(doc, parser.queryInfoNot);
                persistInfo(infoSubscriptionsNot, "InfoSubscription::notdesired", identity);

                List<String> calendarSubscriptionsNot = parser.parseDataForInputQuery(doc, parser.queryCalNot);
                persistInfo(calendarSubscriptionsNot, "CourseCalendarSubscription::notdesired", identity);

            } catch (Exception e) {
                log.error("could not migrate gui preferences for identity: " + identityKey, e);
            }
            counter++;
            if (counter % 10 == 0) {
                DBFactory.getInstance().intermediateCommit();
            }

            rowCount++;
        }
        // Final commit
        DBFactory.getInstance().intermediateCommit();

        uhd.setBooleanDataValue(TASK_MIGRATE_DATA_FROM_GUI_PROPERTIES_DONE, true);
        upgradeManager.setUpgradesHistory(uhd, VERSION);
    }

}
 
Example 19
Source File: JdbcDataAnalysisStore.java    From dhis2-core with BSD 3-Clause "New" or "Revised" License 4 votes vote down vote up
@Override
public List<DataAnalysisMeasures> getDataAnalysisMeasures( DataElement dataElement,
    Collection<CategoryOptionCombo> categoryOptionCombos, Collection<String> parentPaths, Date from )
{
    List<DataAnalysisMeasures> measures = new ArrayList<>();

    if ( categoryOptionCombos.isEmpty() || parentPaths.isEmpty() )
    {
        return measures;
    }

    String catOptionComboIds = TextUtils.getCommaDelimitedString( getIdentifiers( categoryOptionCombos ) );

    String matchPaths = "(";
    for ( String path : parentPaths )
    {
        matchPaths += "ou.path like '" + path + "%' or ";
    }
    matchPaths = TextUtils.removeLastOr( matchPaths ) + ") ";

    String sql = "select dv.sourceid, dv.categoryoptioncomboid, " + "avg( cast( dv.value as "
        + statementBuilder.getDoubleColumnType() + " ) ) as average, " + "stddev_pop( cast( dv.value as "
        + statementBuilder.getDoubleColumnType() + " ) ) as standarddeviation " + "from datavalue dv "
        + "join organisationunit ou on ou.organisationunitid = dv.sourceid "
        + "join period pe on dv.periodid = pe.periodid " + "where dv.dataelementid = " + dataElement.getId() + " "
        + "and dv.categoryoptioncomboid in (" + catOptionComboIds + ") " + "and pe.startdate >= '"
        + DateUtils.getMediumDateString( from ) + "' " + "and " + matchPaths + "and dv.deleted is false "
        + "group by dv.sourceid, dv.categoryoptioncomboid";

    SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql );

    while ( rowSet.next() )
    {
        int orgUnitId = rowSet.getInt( 1 );
        int categoryOptionComboId = rowSet.getInt( 2 );
        double average = rowSet.getDouble( 3 );
        double standardDeviation = rowSet.getDouble( 4 );

        if ( standardDeviation != 0.0 )
        {
            measures
                .add( new DataAnalysisMeasures( orgUnitId, categoryOptionComboId, average, standardDeviation ) );
        }
    }

    return measures;
}
 
Example 20
Source File: BizDataObjectBehaviorImpl.java    From FoxBPM with Apache License 2.0 4 votes vote down vote up
public List<BizDataObject> getDataObjects(String dataSource) {
	LOG.debug("getDataObjects(String dataSource),dataSource=" + dataSource);
	try {
		JdbcTemplate jdbcTemplate = new JdbcTemplate(DBUtils.getDataSource());
		DatabaseMetaData dm = DBUtils.getDataSource().getConnection().getMetaData();
		String databaseType = dm.getDatabaseProductName();
		String databaseVersion = dm.getDatabaseProductVersion();
		LOG.info("the database type is " + databaseType + ",version is " + databaseVersion);
		// 定义sql返回结果集
		SqlRowSet rs = null;
		boolean isOracle = false;
		if (MySQL_TYPE.equalsIgnoreCase(databaseType)) {
			// 获取此 当前数据源连接 对象的当前目录名称。
			String catalog = jdbcTemplate.getDataSource().getConnection().getCatalog();
			LOG.info("the sql is " + TABLE_INFOR);
			rs = jdbcTemplate.queryForRowSet(TABLE_INFOR, new Object[]{catalog});
		} else if (ORACLE_TYPE.equalsIgnoreCase(databaseType)) {
			isOracle = true;
			StringBuffer sql = new StringBuffer("select distinct t_col.DATA_TYPE,t_col.TABLE_NAME,t_col.COLUMN_NAME,t_des.comments as TABLE_COMMENT,c_des.comments as COLUMN_COMMENT from user_tab_columns t_col,user_col_comments c_des,user_tab_comments t_des ").append("where t_col.table_name = c_des.table_name and t_col.table_name = t_des.table_name order by t_col.table_name");
			rs = jdbcTemplate.queryForRowSet(sql.toString());
		} else if("mssql".equalsIgnoreCase(databaseType)){
			
		}
		
		
		List<BizDataObject> bizDataObjects = new ArrayList<BizDataObject>();
		BizDataObject bizDataObject = null;
		DataVariableDefinition dataVariableDefine = null;
		String tableName = null;
		StringBuffer sbExpression = new StringBuffer();
		if(rs != null){
		// 获取表信息
		while (rs.next()) {
			// 处理首次和区分不同表
			if (!rs.getString(TABLE_NAME).equals(tableName)) {
				bizDataObject = new BizDataObject();
				bizDataObject.setId(rs.getString(TABLE_NAME));
				if (isOracle) {
					bizDataObject.setName(rs.getString(TABLE_COMMENT));
				}
				bizDataObject.setDataSource(dataSource);
				// 添加业务数据对象
				bizDataObjects.add(bizDataObject);
			}
			dataVariableDefine = new DataVariableDefinition();
			dataVariableDefine.setId(rs.getString(COLUMN_NAME));
			dataVariableDefine.setFieldName(rs.getString(COLUMN_NAME));
			dataVariableDefine.setDataType(rs.getString(DATA_TYPE));
			// 生成表达式
			sbExpression.append("import org.foxbpm.engine.impl.util.DataVarUtil;\n");
			sbExpression.append("DataVarUtil.getInstance().getDataValue(");
			sbExpression.append("\"" + dataSource + "\"").append(',').append("processInfo.getProcessInstance().getBizKey(),");
			sbExpression.append("\"" + dataVariableDefine.getId() + "\"");
			sbExpression.append(",processInfo);");
			dataVariableDefine.setExpression(sbExpression.toString());
			
			dataVariableDefine.setDocumentation(rs.getString(COLUMN_COMMENT));
			dataVariableDefine.setBizType(Constant.DB_BIZTYPE);
			// 添加数据变量定义
			bizDataObject.getDataVariableDefinitions().add(dataVariableDefine);
			tableName = rs.getString(TABLE_NAME);
			// 清空sbExpression缓存
			sbExpression.delete(0, sbExpression.length());
		}}
		LOG.debug("end getDataObjects(String dataSource)");
		return bizDataObjects;
	} catch (SQLException e) {
		throw ExceptionUtil.getException("获取数据对象失败",e);
	}
}