Navicat for Premium 9.0.2激活(C／C++连接MySql数据库使用总结)

 1: #include <windows.h>

 2: #include "stdio.h"

 3: #include "winsock.h" 

 4: #include "mysql.h" 

 5:  

 6:  

 7: int main()

 8: {

 9:  

 10: MYSQL * con; //= mysql_init((MYSQL*) 0); 

 11: MYSQL_RES *res;

 12: MYSQL_ROW row;

 13:  

 14:  

 15: char tmp[400];

 16:  

 17: //database configuartion

 18: char dbuser[30]="root"; 

 19: char dbpasswd[30]="apple";

 20: char dbip[30]="localhost";

 21: char dbname[50]="excel";

 22: char tablename[50]="test";

 23: char *query=NULL;

 24:  

 25:  

 26: int x;

 27: int y;

 28: int rt;//return value

 29: unsigned int t;

 30:  

 31: int count = 0;

 32:  

 33:  

 34: printf("input x,y ");

 35: scanf("%d,%d",&x,&y);

 36: fflush(stdin);

 37: printf("input over ");

 38: con = mysql_init((MYSQL*) 0); 

 39:  

 40:  

 41: if ( con !=NULL && mysql_real_connect(con,dbip,dbuser,dbpasswd,dbname,3306/*TCP IP端口*/,NULL/*Unix Socket 连接类型*/,0/*运行成ODBC数据库标志*/) ) 

 42: { 

 43:  if (!mysql_select_db(con,dbname)) 

 44:  { 

 45:  printf("Select successfully the database! "); 

 46:  

 47:  con ->reconnect = 1; 

 48:  

 49:  query = "set names 'GBK'";

 50:  //mysql_query(con,"set names 'GBK'"); 

 51:  

 52:  rt=mysql_real_query(con,query,strlen(query));

 53:  if (rt)

 54:  {

 55:  printf("Error making query: %s !!! ",mysql_error(con));

 56:  }

 57:  else

 58:  {

 59:  printf("query %s succeed! ",query);

 60:  }

 61:  

 62:  }

 63: }

 64:  

 65: else

 66: {

 67:  MessageBoxA(NULL,"Unable to connect the database,check your configuration!","",NULL);

 68:  

 69: }

 70:  

 71:  //sprintf(tmp,"update %s set 商品='%s',卖出=%d,成交=%d,涨跌=%d,买进=%d,总量=%d,涨幅=%f,时间='%s' where %s",tablename,goods,sold,deal,fluctuate,buy,total,delta,time,UpdateCon);

 72:  sprintf(tmp,"insert into %s values(%s,%d,%d)",tablename,"null",x,y); //注意如何向具有自增字段的数据库中插入记录

 73:  //MessageBoxA(NULL,tmp,tmp,MB_OK);

 74:  //mysql_query(con,tmp);

 75:  

 76:  rt=mysql_real_query(con,tmp,strlen(tmp));

 77:  if (rt)

 78:  {

 79:  printf("Error making query: %s !!! ",mysql_error(con));

 80:  }

 81:  else

 82:  {

 83:  printf("%s executed!!! ",tmp);

 84:  }

 85:  

 86:  sprintf(tmp,"select * from %s",tablename);

 87:  

 88:  rt=mysql_real_query(con,tmp,strlen(tmp));

 89:  if (rt)

 90:  {

 91:  printf("Error making query: %s !!! ",mysql_error(con));

 92:  } 

 93:  else

 94:  {

 95:  printf("%s executed!!! ",tmp);

 96:  }

 97:  

 98:  res = mysql_store_result(con);//将结果保存在res结构体中

 99:  

 100:  while(row = mysql_fetch_row(res)) 

 101:  { 

 102:  / 

 103:  * MYSQL_ROW STDCALL mysql_fetch_row(MYSQL_RES *result); 

 104:  * 检索行 

 105:  */ 

 106:  

 107:  for(t=0;t<mysql_num_fields(res);t++) 

 108:  { 

 109:  printf("%s ",row[t]); 

 110:  } 

 111:  printf("............. "); 

 112:  count ++;

 113:  } 

 114:  printf("number of rows %d ",count);

 115:  printf("mysql_free_result... "); 

 116:  mysql_free_result(res); 

 117:  

 118:  mysql_close(con);

 119:  return 0;

 120:  

 121: }

 1: SET FOREIGN_KEY_CHECKS=0;

 2: -- ----------------------------

 3: -- Table structure for `test`

 4: -- ----------------------------

 5: DROP TABLE IF EXISTS `test`;

 6: CREATE TABLE `test` (

 7:  `x` bigint(4) NOT NULL AUTO_INCREMENT,

 8:  `y` int(4) DEFAULT NULL,

 9:  `z` int(4) DEFAULT NULL,

 10:  PRIMARY KEY (`x`)

 11: ) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=latin1;

 12:  

 13: -- ----------------------------

 14: -- Records of test

 15: -- ----------------------------

 16: INSERT INTO `test` VALUES ('95', '12432', '4334');

 17: INSERT INTO `test` VALUES ('96', '213', '321');

 18: INSERT INTO `test` VALUES ('97', '213', '213');

 19: INSERT INTO `test` VALUES ('98', '123', '231');

 20: INSERT INTO `test` VALUES ('99', '321', '231');

 21: INSERT INTO `test` VALUES ('100', '123', '32132');

 22: INSERT INTO `test` VALUES ('101', '777', '32213');

 23: INSERT INTO `test` VALUES ('102', '123', '213');

 24: INSERT INTO `test` VALUES ('103', '21', '321');

 25: INSERT INTO `test` VALUES ('104', '324', '432');

 26: INSERT INTO `test` VALUES ('105', '132', '231');

 27: INSERT INTO `test` VALUES ('106', '324', '342');

 28: INSERT INTO `test` VALUES ('107', '23', '23');

 29: INSERT INTO `test` VALUES ('108', '12', '21');

 30: INSERT INTO `test` VALUES ('109', '231', '321');

 31: INSERT INTO `test` VALUES ('110', '123', '231');

 32: INSERT INTO `test` VALUES ('111', '123', '231');

 33: INSERT INTO `test` VALUES ('112', '123', '123');

 34: INSERT INTO `test` VALUES ('113', '312', '231');

 35: INSERT INTO `test` VALUES ('114', '312', '321');

 36: INSERT INTO `test` VALUES ('115', '23', '3');

 37: INSERT INTO `test` VALUES ('116', '213', '312');

 38: INSERT INTO `test` VALUES ('117', '2', '3');

 39:  

 40: -- ----------------------------

 41: -- Table structure for `xqdata`

 42: -- ----------------------------

 43: DROP TABLE IF EXISTS `xqdata`;

 44: CREATE TABLE `xqdata` (

 45:  `代码` varchar(20) NOT NULL DEFAULT '',

 46:  `商品` varchar(20) CHARACTER SET utf8 DEFAULT NULL,

 47:  `卖出` bigint(20) DEFAULT NULL,

 48:  `成交` bigint(20) DEFAULT NULL,

 49:  `涨跌` bigint(20) DEFAULT NULL,

 50:  `买进` bigint(20) DEFAULT NULL,

 51:  `总量` bigint(20) DEFAULT NULL,

 52:  `涨幅` double DEFAULT NULL,

 53:  `时间` time DEFAULT NULL,

 54:  PRIMARY KEY (`代码`)

 55: ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 56:  

 57: -- ----------------------------

 58: -- Records of xqdata

 59: -- ----------------------------

 60: INSERT INTO `xqdata&#Navicat for Premium 9.0.2激活96; VALUES ('FITX*1', '商品', '34', '43', '23', '34', '0', '1.4', '13:23:08');