ʹÓÃC²Ù×÷MySQLÊý¾Ý¿â£¨vs 2008£©
×î½ü¼¸ÌìÏÐÀ´ÎÞÊ£¬±ã³¢ÊÔÁËÒ»ÏÂÓÃC²Ù×÷Êý¾Ý¿â£¬ÏÂÃæ±ãÊÇÎÒ²âÊԵľßÌå½á¹û£º
¿ª·¢»·¾³ÊÇwindows 7 ultimate(Ó¢Îİæ) IDE ÊÇvs 2008 professional ÖÐÎİæ,Êý¾Ý¿âÊÇmysql 5.1
Ê×ÏÈ£¬ÎÒÔÚMySQL¿âÖд´½¨ÁËÒ»¸ötest±í£º
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`age` int(3) DEFAULT NULL,
`gender` char(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
È»ºó£¬ÒªÅäÖúÃvs 2008ϵĿª·¢»·¾³£º
¹¤¾ß->Ñ¡Ïî->ÏîÄ¿ºÍ½â¾ö·½°¸->vc++Ŀ¼
1. ÔÚ´°¿ÚÓÒ±ßÌí¼Ó°üº¬Îļþ£¨ÎÒµÄÊÇD:\Program Files\MySQL\MySQL Server 5.1\include£©
2.Ìí¼Ó¿âÎļþ£¨D:\Program Files\MySQL\MySQL Server 5.1\lib\opt£©
ÅäÖúú󣬼´¿É´´½¨ÐµĹ¤³ÌÁË¡£ÏÂÃæ±ãÊÇÎҵIJâÊÔ´úÂ룬עÊͱȽÏÏêϸ£¬ÎÒÕâÀï¾Í²»×ö¹ý¶àµÄ½éÉÜÁË¡£
×¢ÊÍ´ó¶àÊý¶¼ÊÇÎÒ·ÒëÁËÓ¢ÎÄÎĵµ£¬Ó¢ÎĺõĿÉÒÔÖ±½Ó²Î¿¼MySQLµÄ¹Ù·½Îĵµ¡£
MySQL¹ÙÍø£ºwww.mysql.com
#include <iostream>
#include <windows.h>
#include <stdio.h>
#include "mysql.h"
//·Ç³£ÖØÒª
#pragma comment(lib, "libmysql.lib")
using namespace std;
int main() {
MYSQL *mysql;
MYSQL_RES *result;
MYSQL_ROW row;
unsigned int field_count;
unsigned int num_fields;
my_ulonglong affected_rows;
const char* selectString = "SELECT name,age,gender from test";
const char* updateString = "UPDATE test SET age=30 WHERE id=4";
const char* deleteString = "DELETE from test WHERE id=4";
const char* insertString = "INSERT INTO test VALUES(null,'zhaoliu',24,'m')";
const char* mutilExecution = "INSERT INTO test VALUES(null,'zhaoliu',24,'m');DELETE from test WHERE id=4";
/*
MYSQL *mysql_init(MYSQL *mysql)
º¯ÊýÃèÊö£º
·ÖÅä»ò³õʼ»¯Ò»¸öÊʺÏmysql_real_connect()º¯ÊýµÄMYSQL¶ÔÏó¡£Èç¹ûmysqlÊÇ¿ÕÖ¸Õ룬Ôòº¯Êý·ÖÅä²¢³õʼ»¯
Ò»¸öеÄMYSQL¶ÔÏó£¬×÷Ϊ·µ»ØÖµ·µ»Ø¡£·ñÔò£¬Ö±½Ó³õʼ»¯¶ÔÏ󣬲¢·µ»Ø¶ÔÏóµÄµØÖ·¡£Èç¹ûÓÃmysql_init()º¯Êý
³õʼ»¯ÁËÒ»¸öеĶÔÏó£¬ÔòÔÚµ÷ÓÃmysql_clos
Ïà¹ØÎĵµ£º
´Óprintf̸¿É±ä²ÎÊýº¯ÊýµÄʵÏÖ ×ªÌù
ÔÎÄ×÷ÕߣºÈÖÑÇÐÂ
ÕªÒª£ºÒ»Ö±ÒÔÀ´¶¼¾õµÃprintfËÆºõÊÇcÓïÑÔ¿âÖй¦ÄÜ×îÇ¿´óµÄº¯ÊýÖ®Ò»£¬²»½öÒòΪËüÄܸñʽ»¯Êä³ö£¬¸üÔÚÓÚËüµÄ²ÎÊý¸öÊýûÓÐÏÞÖÆ£¬Òª¼¸¸ö¾Í¸ø¼¸¸ö£¬À´Õß²»¾Ü¡£printfÕâÖÖ¶Ô²ÎÊý¸öÊýºÍ²ÎÊýÀàÐ͵ÄÇ¿´óÊÊÓ¦ÐÔ£¬ÈÃÈ˲úÉúÁ˶ÔËü½øÐÐ̽Ë÷µÄŨºñÐËȤ¡£
¹Ø¼ü×Ö£ºprintf, ¿É±ä²ÎÊ ......
ʲôÊǽṹÌ壿
¼òµ¥µÄÀ´Ëµ£¬½á¹¹Ìå¾ÍÊÇÒ»¸ö¿ÉÒÔ°üº¬²»Í¬Êý¾ÝÀàÐ͵ÄÒ»¸ö½á¹¹£¬ËüÊÇÒ»ÖÖ¿ÉÒÔ×Ô¼º¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ËüµÄÌØµãºÍÊý×éÖ÷ÒªÓÐ
Á½µã²»Í¬£¬Ê×ÏȽṹÌå¿ÉÒÔ
ÔÚÒ»¸ö½á¹¹ÖÐÉùÃ÷²»Í¬µÄÊý¾ÝÀàÐÍ£¬µÚ¶þÏàͬ½á¹¹µÄ½á¹¹Ìå±äÁ¿ÊÇ¿ÉÒÔÏ໥¸³ÖµµÄ£¬¶øÊý×éÊÇ×ö²»µ½µÄ£¬ÒòΪÊý×éÊǵ¥Ò»Êý¾ÝÀàÐ͵ÄÊý¾Ý¼¯ºÏ£¬Ëü±¾Éí²»ÊÇÊý¾ÝÀàÐÍ ......
Ò»¼ÒÖ®ÑÔ£¬»¶ÓÅÄש¹þ¡£
1¡¢¿ÉÒÔ¿¼ÂÇÏÈѧϰC.
´ó¶àÊýʱºò£¬ÎÒÃÇѧϰÓïÑÔµÄÄ¿µÄ£¬²»ÊÇΪÁ˳ÉΪһ¸öÓïÑÔר¼Ò£¬¶øÊÇÏ£Íû³ÉΪһ¸ö½â¾öÎÊÌâµÄר¼Ò¡£×öÒ»¸öÓÐÓõijÌÐòÔ±£¬×öÒ»¸ö׬ǮµÄ³ÌÐòÔ±¡£ÎÒÃǵļÛÖµ£¬½«ÌåÏÖÔÚ¿Í»§¼ÛÖµÉÏ£¬¶ø²»ÊÇÓïÑÔдµÃºÃ²»ºÃ¿´¡£
C++ÊÇCµÄÒ»¸öÃæÏò¶ÔÏóµÄ½âÊÍ£¬C++ΪCÀ ......
1 fseekÒÆ¶¯Ö¸Õë»ñÈ¡
#include <stdio.h>
#include <stdlib.h>
long filesize( FILE *fp )
{
long int save_pos;
long size_of_file;
/* Save the current position. */
save_pos = ftell( fp );
/* ......
ÔÚ×öwindowsÇý¶¯³ÌÐò¿ª·¢Ö®Ç°£¬Ê×ÏÈҪȷ¶¨¿ª·¢µÄÓïÑÔ¡£ÔÚ³£¼ûµÄ±à³ÌÓïÑÔÖУ¬ÎÒÃÇ¿ÉÒÔÑ¡ÔñC¡¢C++¡¢»ã±àÓïÑÔÉõÖÁDelphi¡£²»¹ýÓÉÓÚ
΢ÈíÌṩµÄDDK¿ª·¢»·¾³ËùÌṩµÄÎļþºÍÁ´½ÓÓõĿâÖ»Ö§³ÖCºÍC++ÓïÑÔ¡£ËùÒÔÒ»°ã¶¼²ÉÓÃC»òÕßC++¡£
ʹÓÃCÓïÑÔ£¬ÊDZȽÏÈÝÒ×ÉÏÊÖ£¬ÒòΪºÜ¶àÈ˶¼ÊÇ´ÓѧϰCÓïÑÔ¶øÑ§Ï°³ÌÐò¿ª·¢µÄ£¬¶øÔÚÇý¶¯¿ª·¢µÄ ......