執行存儲過程
<Code Name="SMS_DocumentType" Description="文檔類型">
?<Table>SMS_documentType</Table>
?<NameField>Name</NameField>
?<ValueField>DocumentTypeID</ValueField>
?<PYField>DocumentTypeID</PYField>
?<DataModel>SMS_DocumentType</DataModel>
?<DataFilter>true</DataFilter>
?<ParentField BaseValue="0">parentid</ParentField>
?<LeafField Value="1">isleaf</LeafField>
?<Type>parentSon</Type>
</Code>
/**
???? * 執行存儲過程
???? * @param sql
???? * @return
???? * @throws SQLException
???? */
??? public ResultSet queryProcedure(String procedure) throws SQLException {
??????? con = super.getConnection();
??????? CallableStatement cstmt = null;
??????? String strSql = " { call " + procedure + " } ";
??????? cstmt = con.prepareCall(strSql);
??????? rs = cstmt.executeQuery();
??????? return rs;
??? }