db_command.h

Go to the documentation of this file.
00001 /*
00002 **  ClanLib SDK
00003 **  Copyright (c) 1997-2011 The ClanLib Team
00004 **
00005 **  This software is provided 'as-is', without any express or implied
00006 **  warranty.  In no event will the authors be held liable for any damages
00007 **  arising from the use of this software.
00008 **
00009 **  Permission is granted to anyone to use this software for any purpose,
00010 **  including commercial applications, and to alter it and redistribute it
00011 **  freely, subject to the following restrictions:
00012 **
00013 **  1. The origin of this software must not be misrepresented; you must not
00014 **     claim that you wrote the original software. If you use this software
00015 **     in a product, an acknowledgment in the product documentation would be
00016 **     appreciated but is not required.
00017 **  2. Altered source versions must be plainly marked as such, and must not be
00018 **     misrepresented as being the original software.
00019 **  3. This notice may not be removed or altered from any source distribution.
00020 **
00021 **  Note: Some of the libraries ClanLib may link to may have additional
00022 **  requirements or restrictions.
00023 **
00024 **  File Author(s):
00025 **
00026 **    Magnus Norddahl
00027 */
00028 
00031 
00032 #pragma once
00033 
00034 #include "api_database.h"
00035 
00036 class CL_DataBuffer;
00037 class CL_DateTime;
00038 class CL_DBConnection;
00039 class CL_DBCommandProvider;
00040 class CL_DBCommand_Impl;
00041 
00045 class CL_API_DATABASE CL_DBCommand
00046 {
00049 public:
00050         enum Type
00051         {
00052                 stored_procedure,
00053                 sql_statement
00054         };
00055 
00057         CL_DBCommand();
00058 
00062         CL_DBCommand(const CL_SharedPtr<CL_DBCommand_Impl> &impl);
00063 
00064         ~CL_DBCommand();
00066 
00069 public:
00071         int get_input_parameter_column(const CL_StringRef &name) const;
00072 
00074         int get_output_last_insert_rowid() const;
00075 
00077         CL_DBCommandProvider *get_provider();
00079 
00082 public:
00084         void set_input_parameter_string(int index, const CL_StringRef &value);
00085 
00087         void set_input_parameter_bool(int index, bool value);
00088 
00090         void set_input_parameter_int(int index, int value);
00091 
00093         void set_input_parameter_double(int index, double value);
00094 
00096         void set_input_parameter_datetime(int index, const CL_DateTime &value);
00097 
00099         void set_input_parameter_binary(int index, const CL_DataBuffer &value);
00100 
00102         template<class ValueType>
00103         void set_input_parameter(int index, ValueType value);
00104 
00106         template<class ValueType>
00107         void set_input_parameter(const CL_StringRef &name, ValueType value);
00108 
00110 
00113 private:
00114         CL_SharedPtr<CL_DBCommand_Impl> impl;
00115 
00117 };
00118