Class Connection

Description
Description | Methods (details)

The Connection represents the channel of communication with the database.

It is the means of submitting a query or update for execution. A ResultTable is returned by the executeQuery() methods. The executeUpdate() methods are used to execute commands that do not return resultsets such as inserts, deletes, and other data management commands.

<p> OSID Version: 2.0 </p>

<p> Licensed under the org.osid.SidImplementationLicenseMIT. </p>

Located in /harmoni/oki2/osid/sql/Connection.php (line 21) 


	
			







	
	

		
Method Summary

		

			Description |
												Methods (details)
		

		
			
			

								
				

											object ResultTable
										executeQuery
											(mixed $sql, string $sql
)
									

								
				

											object ResultTable
										executeQueryWithArgs
											(string $sql, mixed $args, string $args
)
									

								
				

											int
										executeUpdate
											(mixed $sql, string $sql
)
									

								
				

											int
										executeUpdateWithArgs
											(string $sql, mixed $args, string $args
)
									

								
				

											object TypeIterator
										getSqlTypes
										()
									

							

		

	
		

	
	
	

		
Methods

		

			Description |
																Methods (details)
						
		

		

			



	
	

		executeQuery (line 41)
	
 
	
	

execute the SQL statement

	
    
				
  • access: public
    • 
				
  • throws: object SqlException An exception with one of the following          messages defined in org.osid.sql.SqlException may be thrown:          OPERATION_FAILED, PERMISSION_DENIED,          CONFIGURATION_ERROR, UNIMPLEMENTED
    • 
			

	
	

		object ResultTable
		
			executeQuery
		
					(mixed $sql, string $sql
)
			

	
			
    
					
  • 
				string
				$sql
			
    • 
				

		
		
	




	
	

		executeQueryWithArgs (line 64)
	
 
	
	

execute the SQL statement replacing '?'s sequentially with the args.

	
    
				
  • access: public
    • 
				
  • throws: object SqlException An exception with one of the following          messages defined in org.osid.sql.SqlException may be thrown:          OPERATION_FAILED, PERMISSION_DENIED,          CONFIGURATION_ERROR, UNIMPLEMENTED
    • 
			

	
	

		object ResultTable
		
			executeQueryWithArgs
		
					(string $sql, mixed $args, string $args
)
			

	
			
    
					
  • 
				string
				$sql			
    • 
					
  • 
				string
				$args
			
    • 
				

		
		
	




	
	

		executeUpdate (line 86)
	
 
	
	

update the database using the SQL statement.

	
    
				
  • access: public
    • 
				
  • throws: object SqlException An exception with one of the following          messages defined in org.osid.sql.SqlException may be thrown:          OPERATION_FAILED, PERMISSION_DENIED,          CONFIGURATION_ERROR, UNIMPLEMENTED
    • 
			

	
	

		int
		
			executeUpdate
		
					(mixed $sql, string $sql
)
			

	
			
    
					
  • 
				string
				$sql
			
    • 
				

		
		
	




	
	

		executeUpdateWithArgs (line 110)
	
 
	
	

update the database using the SQL statement replacing '?'s sequentially  with the args.

	
    
				
  • access: public
    • 
				
  • throws: object SqlException An exception with one of the following          messages defined in org.osid.sql.SqlException may be thrown:          OPERATION_FAILED, PERMISSION_DENIED,          CONFIGURATION_ERROR, UNIMPLEMENTED
    • 
			

	
	

		int
		
			executeUpdateWithArgs
		
					(string $sql, mixed $args, string $args
)
			

	
			
    
					
  • 
				string
				$sql			
    • 
					
  • 
				string
				$args
			
    • 
				

		
		
	




	
	

		getSqlTypes (line 130)
	
 
	
	

return the SQL data types supported by this implementation

	
    
				
  • access: public
    • 
				
  • throws: object SqlException An exception with one of the following          messages defined in org.osid.sql.SqlException may be thrown:          OPERATION_FAILED, PERMISSION_DENIED,          CONFIGURATION_ERROR, UNIMPLEMENTED
    • 
			

	
	

		object TypeIterator
		
			getSqlTypes
		
				()
			

	
		
		
	

						
		

	



	

		Documentation generated on Wed, 19 Sep 2007 10:22:08 -0400 by phpDocumentor 1.3.0RC3