mysql数据库 二次开发_NX二次开发-NX连接MySQL数据库(增删改查)C++版

1 //DataBaseTest2

3 //Mandatory UF Includes

4 #include

5 #include

6

7 //Internal Includes

8 #include

9 #include

10 #include

11

12 //Internal+External Includes

13 #include

14 #include

15 #include

16 #include

17 #include

18 #include

19 #include

20 #include

21 #include

22 #include

23 #include

24 #include

25

26 #include

27 #include

28

29 //头文件

30 #include

31 #include

32 //MySQL support on Windows

33 #include

34 #include

35 #pragma comment(lib,"libmysql")

36

37

38

39 //Std C++ Includes

40 #include

41 #include

42

43 using namespaceNXOpen;44 using std::string;45 usingstd::exception;46 usingstd::stringstream;47 usingstd::endl;48 usingstd::cout;49 usingstd::cerr;50

51

52 //------------------------------------------------------------------------------53 //NXOpen c++ test class54 //------------------------------------------------------------------------------

55 classMyClass56 {57 //class members

58 public:59 static Session *theSession;60 static UI *theUI;61

62 MyClass();63 ~MyClass();64

65 voiddo_it();66 void print(const NXString &);67 void print(const string &);68 void print(const char*);69

70 private:71 Part *workPart, *displayPart;72 NXMessageBox *mb;73 ListingWindow *lw;74 LogFile *lf;75 };76

77 //------------------------------------------------------------------------------78 //Initialize static variables79 //------------------------------------------------------------------------------

80 Session *(MyClass::theSession) =NULL;81 UI *(MyClass::theUI) =NULL;82

83 //------------------------------------------------------------------------------84 //Constructor85 //------------------------------------------------------------------------------

86 MyClass::MyClass()87 {88

89 //Initialize the NX Open C++ API environment

90 MyClass::theSession =NXOpen::Session::GetSession();91 MyClass::theUI =UI::GetUI();92 mb = theUI->NXMessageBox();93 lw = theSession->ListingWindow();94 lf = theSession->LogFile();95

96 workPart = theSession->Parts()->Work();97 displayPart = theSession->Parts()->Display();98

99 }100

101 //------------------------------------------------------------------------------102 //Destructor103 //------------------------------------------------------------------------------

104 MyClass::~MyClass()105 {106 }107

108 //------------------------------------------------------------------------------109 //Print string to listing window or stdout110 //------------------------------------------------------------------------------

111 void MyClass::print(const NXString &msg)112 {113 if(! lw->IsOpen() ) lw->Open();114 lw->WriteLine(msg);115 }116 void MyClass::print(const string &msg)117 {118 if(! lw->IsOpen() ) lw->Open();119 lw->WriteLine(msg);120 }121 void MyClass::print(const char *msg)122 {123 if(! lw->IsOpen() ) lw->Open();124 lw->WriteLine(msg);125 }126

127

128 //------------------------------------------------------------------------------129 //定义结构体130 //------------------------------------------------------------------------------

131 structStudent132 {133 intid;134 char name[32];135 char birthday[16];136 char cellphone[12];137 };138

139

140 //------------------------------------------------------------------------------141 //接收界面输入参数，增加一条数据142 //------------------------------------------------------------------------------

143 int do_insert(Student*stu)144 {145 MYSQL conn;146 mysql_init(&conn);147

148 //连接服务器

149 if (NULL == mysql_real_connect(&conn,150 "127.0.0.1", "root", "123456", "example"

151 , 0, NULL, 0))152 {153 printf("Failed to connect to database: %s\n",154 mysql_error(&conn));155 return -1;156 }157

158 //构造SQL语句

159 char sql[256];160 sprintf(sql,161 "INSERT INTO `student`"

162 "(`id`, `name`, `birthday`, `cellphone`)"

163 "VALUES"

164 "('%d', '%s', '%s', '%s')"

165 , stu->id166 , stu->name167 , stu->birthday168 , stu->cellphone169 );170

171 //执行SQL语句

172 int ret = mysql_query(&conn, sql);173 if (ret != 0)174 {175 printf("error: %s \n", mysql_error(&conn));176 }177 else

178 {179 my_ulonglong affected_rows = mysql_affected_rows(&conn); //a 64-bit large number

180 printf("%d rows affected. \n", (int)affected_rows); //cast to int

181 }182

183 //关闭连接

184 mysql_close(&conn);185

186 return 0;187 }188

189

190 //------------------------------------------------------------------------------191 //增加一条数据192 //------------------------------------------------------------------------------

193 int my_insert(MYSQL*conn)194 {195 //SQL语句的末尾不要加分号

196 const char* sql =

197 "INSERT INTO `student`"

198 "(`id`, `name`, `birthday`, `cellphone`)"

199 "VALUES"

200 "('17', 'qian22', '1992-12-2', '18601088987')"

201 ;202

203 int ret = mysql_query(conn, sql);//执行SQL语句

204 char msg[256];205 if (ret != 0)206 {207 sprintf_s(msg, "error: %s\n", conn, sql);208 uc1601(msg, 1);209 return -1;210 }211 my_ulonglong affected_rows = mysql_affected_rows(conn);//获得受影响的行数

212 sprintf_s(msg, "%d rows affected\n", (int)affected_rows);213 uc1601(msg, 1);214

215 return 0;216 }217

218

219 //------------------------------------------------------------------------------220 //查找数据221 //------------------------------------------------------------------------------

222 int my_select(MYSQL*conn)223 {224 //SQL语句，末尾不加分号。每次只执行一条SQL语句。

225 const char* sql = "SELECT * FROM student";226 int ret =mysql_query(conn, sql);227 char msg[256];228 UF_UI_open_listing_window();229 if (ret != 0)230 {231 sprintf_s(msg,"error: %s \n", mysql_error(conn));232 uc1601(msg, 1);233 return -1;234 }235

236 MYSQL_RES * result =mysql_store_result(conn);237 if (result ==NULL)238 {239 //printf("error(%d): %s \n", mysql_errno(conn), mysql_error(conn));

240 }241 else

242 {243 //how many rows

244 my_ulonglong num_rows =mysql_num_rows(result);245 sprintf_s(msg,"got %d rows: \n", (int)num_rows);246 UF_UI_write_listing_window(msg);247

248 //number of fields for each row

249 unsigned int num_fields =mysql_num_fields(result);250 sprintf_s(msg,"number of fields: %d \n", (int)num_fields);251 UF_UI_write_listing_window(msg);252

253 //fetch the rows

254 MYSQL_ROW row;255 while ((row =mysql_fetch_row(result)))256 {257 unsigned long *lengths =mysql_fetch_lengths(result);258 for (int i = 0; i < num_fields; i++)259 {260 char* field = row[i]; //can be a NULL value

261 unsigned int field_length = lengths[i]; //the data length

262

263 sprintf_s(msg,"column[%d], length[%d] , data[%s] \n",264 i, field_length, field ? field : "null");265 UF_UI_write_listing_window(msg);266 }267 UF_UI_write_listing_window("\n");268 }269

270 //release the memory

271 mysql_free_result(result);272 }273

274 return 0;275 }276

277 //------------------------------------------------------------------------------278 //Do something279 //------------------------------------------------------------------------------

280 voidMyClass::do_it()281 {282

283 //TODO: add your code here

284

285 /*

286 //获取用户输入287 Student stu;288 printf("ID:");289 char buf[128];290 gets(buf);291 stu.id = atoi(buf);292 printf("Name:");293 gets(stu.name);294 printf("Birthday:");295 gets(stu.birthday);296 printf("CellPhone:");297 gets(stu.cellphone);298 */

299

300 if (mysql_library_init(0, NULL, NULL))//初始化

301 {302 uc1601("could not initialize MySQL library\n", 1);303 return;304 }305 //连接服务器

306 MYSQL conn;307 mysql_init(&conn);308

309 MYSQL* ret = mysql_real_connect(&conn, "127.0.0.1", "root", "123456", "example", 0, NULL, 0);310 if (!ret)311 {312 char msg[256];313 sprintf_s(msg, "Failed to connect to database: %s\n", mysql_error(&conn));314 uc1601(msg, 1);315 }316

317 //增加一条数据

318 my_insert(&conn);319

320 //查找数据

321 my_select(&conn);322

323 //关闭连接

324 mysql_close(&conn);325

326 mysql_library_end();//结束

327 }328

329 //------------------------------------------------------------------------------330 //Entry point(s) for unmanaged internal NXOpen C/C++ programs331 //------------------------------------------------------------------------------332 //Explicit Execution

333 extern "C" DllExport void ufusr( char *parm, int *returnCode, intrlen )334 {335 try

336 {337 //Create NXOpen C++ class instance

338 MyClass *theMyClass;339 theMyClass = newMyClass();340 theMyClass->do_it();341 deletetheMyClass;342 }343 catch (const NXException&e1)344 {345 UI::GetUI()->NXMessageBox()->Show("NXException", NXOpen::NXMessageBox::DialogTypeError, e1.Message());346 }347 catch (const exception&e2)348 {349 UI::GetUI()->NXMessageBox()->Show("Exception", NXOpen::NXMessageBox::DialogTypeError, e2.what());350 }351 catch(...)352 {353 UI::GetUI()->NXMessageBox()->Show("Exception", NXOpen::NXMessageBox::DialogTypeError, "Unknown Exception.");354 }355 }356

357

358 //------------------------------------------------------------------------------359 //Unload Handler360 //------------------------------------------------------------------------------

361 extern "C" DllExport intufusr_ask_unload()362 {363 return (int)NXOpen::Session::LibraryUnloadOptionImmediately;364 }365

366

367 Caesar卢尚宇368 2020年2月12日