xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 3KB
    文件類型: .cpp
    金幣: 1
    下載: 0 次
    發(fā)布日期: 2021-05-10
  • 語(yǔ)言: C/C++
  • 標(biāo)簽: mysql??blob??讀寫??

資源簡(jiǎn)介

mysql寫入或讀取一段數(shù)據(jù)塊時(shí),數(shù)據(jù)類型為blob型,本代碼詳細(xì)介紹在mysqll中如何讀寫blob格式數(shù)據(jù)

資源截圖

代碼片段和文件信息

#include?
#include?
#include?
#include?
#include?
#include?“mysql_connection.h“
#include?“mysql_driver.h“
#include?
#include?
#include?
#include?
#include?

using?namespace?std;

class?DataBuf?:?public?std::streambuf
{
public:
????DataBuf(char*?d?size_t?s)
????{
????????setg(d?d?d+s);
????}
};

int?main(int?argc?const?char?**argv)
{
cout?<
try?{
sql::mysql::MySQL_Driver?*driver;
sql::Connection?*con;
sql::Statement?*stmt;
driver?=?sql::mysql::get_mysql_driver_instance();
con?=?driver->connect(“tcp://127.0.0.1:3306“?“root“?“123456“);
stmt?=?con->createStatement();
stmt->execute(“USE?test“);
stmt->execute(“DROP?TABLE?IF?EXISTS?test_a“);
stmt->execute(“CREATE?TABLE?test_a(id?INT?primary?key?label?CHAR(1))“);
stmt->execute(“INSERT?INTO?test_a(id?label)?VALUES?(1?‘a(chǎn)‘)“);

stmt->execute(“DROP?TABLE?IF?EXISTS?test_b“);
stmt->execute(“CREATE?TABLE?test_b(id?INT?primary?key?b?BLOB)“);

//寫入blob字段
sql::PreparedStatement*?pstmt;
pstmt?=?con->prepareStatement(“INSERT?INTO?test_b?VALUES(???)“);

int?a?=?1;
char?buf[64]?=?“I?am?a?good?boy!“;
//memcpy(buf&asizeof(a));
//memcpy(buf?+?sizeof(a)&asizeof(a));
//memcpy(buf?+?2?*?sizeof(a)&asizeof(a));
DataBuf?buffer(buf?strlen(buf));

std::istream?s(&buffer

評(píng)論

共有 條評(píng)論