1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
|
/*
Copyright 2007 - 2008 MySQL AB, 2008 - 2010 Sun Microsystems, Inc. All rights reserved.
The MySQL Connector/C++ is licensed under the terms of the GPL
<http://www.gnu.org/licenses/old-licenses/gpl-2.0.html>, like most
MySQL Connectors. There are special exceptions to the terms and
conditions of the GPL as it is applied to this software, see the
FLOSS License Exception
<http://www.mysql.com/about/legal/licensing/foss-exception.html>.
*/
#ifndef _MYSQL_PREPARED_STATEMENT_H_
#define _MYSQL_PREPARED_STATEMENT_H_
#include <boost/scoped_ptr.hpp>
#include <boost/shared_ptr.hpp>
#include <cppconn/prepared_statement.h>
#include <cppconn/parameter_metadata.h>
namespace sql
{
namespace mysql
{
class MySQL_DebugLogger;
class MySQL_ParamBind;
class MySQL_ParameterMetaData;
class MySQL_PreparedResultSetMetaData;
class MySQL_ResultBind;
namespace NativeAPI
{
class NativeStatementWrapper;
}
class MySQL_Prepared_Statement : public sql::PreparedStatement
{
protected:
sql::Connection * connection;
boost::shared_ptr< NativeAPI::NativeStatementWrapper > proxy;
boost::scoped_ptr< MySQL_ParamBind > param_bind;
unsigned int param_count;
int resultSetConcurrency;
int resultSetType;
boost::scoped_ptr< sql::SQLWarning > warnings;
bool isClosed;
boost::shared_ptr< MySQL_DebugLogger > logger;
boost::scoped_ptr< MySQL_PreparedResultSetMetaData > res_meta;
boost::scoped_ptr< MySQL_ParameterMetaData > param_meta;
sql::ResultSet::enum_type resultset_type;
boost::shared_ptr< MySQL_ResultBind > result_bind;
virtual void do_query();
virtual void checkClosed();
virtual void closeIntern();
bool sendLongDataBeforeParamBind();
void setBlob_intern(unsigned int parameterIndex, std::istream * blob, bool deleteBlobAfterExecute);
public:
MySQL_Prepared_Statement(boost::shared_ptr<NativeAPI::NativeStatementWrapper> & s,
sql::Connection * conn, sql::ResultSet::enum_type rset_type,
boost::shared_ptr< MySQL_DebugLogger > & log);
virtual ~MySQL_Prepared_Statement();
sql::Connection *getConnection();
void cancel();
void clearParameters();
void clearWarnings();
void close();
bool execute();
bool execute(const sql::SQLString& sql);
sql::ResultSet *executeQuery();
sql::ResultSet *executeQuery(const sql::SQLString& sql);
int executeUpdate();
int executeUpdate(const sql::SQLString& sql);
size_t getFetchSize();
unsigned int getMaxFieldSize();
sql::ResultSetMetaData * getMetaData();
uint64_t getMaxRows();
bool getMoreResults();
sql::ParameterMetaData * getParameterMetaData();
unsigned int getQueryTimeout();
sql::ResultSet * getResultSet();
sql::ResultSet::enum_type getResultSetType();
uint64_t getUpdateCount();
const SQLWarning * getWarnings();/* should return different type */
Statement * setBuffered();
void setBlob(unsigned int parameterIndex, std::istream * blob);
void setBoolean(unsigned int parameterIndex, bool value);
void setBigInt(unsigned int parameterIndex, const sql::SQLString& value);
void setCursorName(const sql::SQLString &name);
void setDateTime(unsigned int parameterIndex, const sql::SQLString& value);
void setDouble(unsigned int parameterIndex, double value);
void setEscapeProcessing(bool enable);
void setFetchSize(size_t rows);
void setInt(unsigned int parameterIndex, int32_t value);
void setUInt(unsigned int parameterIndex, uint32_t value);
void setInt64(unsigned int parameterIndex, int64_t value);
void setUInt64(unsigned int parameterIndex, uint64_t value);
void setMaxFieldSize(unsigned int max);
void setMaxRows(unsigned int max);
void setNull(unsigned int parameterIndex, int sqlType);
void setResultSetConcurrency(int concurrencyFlag);
void setString(unsigned int parameterIndex, const sql::SQLString& value);
void setQueryTimeout(unsigned int seconds);
sql::PreparedStatement * setResultSetType(sql::ResultSet::enum_type type);
private:
/* Prevent use of these */
MySQL_Prepared_Statement(const MySQL_Prepared_Statement &);
void operator=(MySQL_Prepared_Statement &);
};
} /* namespace mysql */
} /* namespace sql */
#endif // _MYSQL_PREPARED_STATEMENT_H_
/*
* Local variables:
* tab-width: 4
* c-basic-offset: 4
* End:
* vim600: noet sw=4 ts=4 fdm=marker
* vim<600: noet sw=4 ts=4
*/
|
