mysql框架.docVIP

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\n); 35: scanf(%d,%d,x,y); 36: fflush(stdin); 37: printf(input over\n); 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!\n); 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 !!!\n,mysql_error(con)); 56: } 57: else 58: { 59: printf(query %s succeed!\n,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); //注