117
119
con->setSchema(database);
120
122
stmt->execute("DROP TABLE IF EXISTS test");
121
123
stmt->execute("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, label CHAR(1))");
122
124
cout << "#\t Test table created" << endl;
124
std::auto_ptr< sql::PreparedStatement > prep_stmt(con->prepareStatement("INSERT INTO test(id, label) VALUES (?, ?)"));
126
boost::scoped_ptr< sql::PreparedStatement > prep_stmt(con->prepareStatement("INSERT INTO test(id, label) VALUES (?, ?)"));
125
127
for (i = 0; i < EXAMPLE_NUM_TEST_ROWS; i++) {
126
128
prep_stmt->setInt(1, test_data[i].id);
127
129
prep_stmt->setString(2, test_data[i].label);