ÔÚVC6ÖÐʹÓÃc API·½Ê½Á¬½ÓMySQLÊý¾Ý¿â
ÔÚVC6ÖÐʹÓÃc API·½Ê½Á¬½ÓMySQLÊý¾Ý¿â
Ò»¡¢»·¾³ÅäÖÃ
1¡¢ÔÚMySqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØmysql-connector-c-noinstall£¬²¢½«½âѹºóµÄbinºÍincludeÎļþ¼Ð¿½±´µ½MysqlµÄ°²×°Ä¿Â¼
2¡¢ÉèÖÃVC6»·¾³£¬ÔÚvc¹¤¾ß-Ñ¡Ïî-Ŀ¼£¬¼ÓÈë¸Õ²ÅµÄIncludeÎļþ¼ÐµÄ·¾¶£¬ÀýÈ磺C:\Program Files\MySQL\MySQL Server 5.1\include
¶þ¡¢¹¤³ÌÉèÖÃ
3¡¢½«libÎļþ¼ÐÖеÄlinmysql.libºÍlibmysql.dll¿½±´µ½¹¤³ÌĿ¼Ï£¬¹¤³Ì-ÉèÖÃ-Á¬½Ó£¬ÔÚ¶ÔÏó/¿âÄ£¿éÖÐÌí¼Ówsock32.libºÍlibmysql.lib
Èý¡¢Ê¾Àý
4¡¢Ïȵ¼Èë²âÊÔ³ÌÐòËùÐèµÄ»·¾³£¬½«ÒÔÏÂSQLÓï¾ä±£´æÎªsql½Å±¾Îļþ²¢µ¼Èë
#VC6ͨ¹ýAPIÁ¬½ÓMysql²âÊÔ»·¾³
#´´½¨Êý¾Ý¿â
drop database if exists `test`; #Èç¹ûÓÐÕâ¸öÊý¾Ý¿â£¬ÔòÒÆ³ýËü create database test; #´´½¨Êý¾Ý¿â
use test; #ʹÓÃÊý¾Ý¿â
#´´½¨±íUser£¬±£´æ»áÔ±ÊôÐÔ
drop table if exists `User`;
create table User (
id int(11) not null auto_increment,
name varchar(20),
age int(11),
primary key (id)
);
#²åÈëһЩÊý¾Ý
insert into user values (NULL, 'name1', 11);
insert into user values (NULL, 'name2', 22);
insert into user values (NULL, 'name3', 33);
5¡¢²âÊÔ´úÂë
#include <windows.h>
#include <mysql.h>
#include "stdio.h"
MYSQL mysql, *sock; //mysqlÁ¬½Ó
MYSQL_RES *res; //Õâ¸ö½á¹¹´ú±í·µ»ØÐеÄÒ»¸ö²éѯ½á¹û¼¯
MYSQL_ROW row; //Ò»¸öÐÐÊý¾ÝµÄÀàÐͰ²È«(type-safe)µÄ±íʾ
char query[150]; //²éѯÓï¾ä
bool ConnectDatabase(); //º¯ÊýÉùÃ÷
void FreeConnect();
bool QueryDatabase();
bool InsertData();
int main()
{
ConnectDatabase();
QueryDatabase();
InsertData();
QueryDatabase();
FreeConnect();
return 0;
}
//Á¬½ÓÊý¾Ý¿â
bool ConnectDatabase()
{
//³õʼ»¯mysql
mysql_init(&mysql); //Á¬½Ómysql£¬Êý¾Ý¿â
if (!(sock = mysql_real_connect(&mysql,"localhost", "root", "root", "test",0,NULL,0)))
{
printf( "Error connecting to datab
Ïà¹ØÎĵµ£º
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
Í·ÎļþµÄ×÷ÓÃ
ÔçÆÚµÄ±à³ÌÓïÑÔÈçBasic¡¢Fortran ûÓÐÍ·ÎļþµÄ¸ÅÄC++/C ÓïÑԵijõѧÕßËäÈ»»áÓÃʹÓÃÍ·Îļþ£¬µ«³£³£²»Ã÷ÆäÀí¡£ÕâÀï¶ÔÍ·ÎļþµÄ×÷ÓÃÂÔ×÷½âÊÍ£º
£¨1£©Í¨¹ýÍ·ÎļþÀ´µ÷Óÿ⹦ÄÜ¡£ÔںܶೡºÏ£¬Ô´´úÂë²»±ã£¨»ò²»×¼£©ÏòÓû§¹«²¼£¬Ö»ÒªÏòÓû§ÌṩͷÎļþºÍ¶þ½øÖƵĿ⼴¿É¡£Óû§Ö»ÐèÒª°´ÕÕÍ·ÎļþÖеĽӿÚÉùÃ÷À´µ÷Óÿ⹦ ......
c º¯ÊýÖ¸Õë
º¯ÊýÖ¸ÕëÊÇʲô£¿
Ò»¸öº¯ÊýÕ¼ÓÃÒ»¶ÎÁ¬ÐøÄÚ´æ¡£µ±µ÷ÓÃÒ»¸öº¯Êýʱ£¬Êµ¼ÊÉÏÊÇÌø×ªµ½º¯ÊýÈë¿ÚµØÖ·£¬Ö´Ðк¯ÊýÌåµÄ´úÂ룬Íê³Éºó·µ»Ø¡£
ÈçºÎÕÒµ½¶ÔÓ¦µÄÈë¿ÚµØÖ·£¿
ÕâÊÇÓɺ¯ÊýÃûÀ´±ê¼ÇµÄ£¬Êµ¼ÊÉÏ£¬º¯ÊýÃû¾ÍÊǺ¯ÊýµÄÈë¿ÚµØÖ·¡£ º¯ÊýÖ¸ÕëÊÇÒ»ÖÖÌØÊâÀàÐ͵ÄÖ¸Õë£¬Ë ......
CºÍC++µÄ±ê×¼¿â
ĬÈÏ·ÖÀà 2008-02-28 14:28 ÔĶÁ3 ÆÀÂÛ0
×ֺţº ´ó´ó ÖÐÖРСС
http://blog.chinaunix.net/u/6776/showart_186792.html C/C++Éî²ã̽Ë÷
±¾Ð¡½ÚÎÒÃǸÅÀÀÒ»ÏÂC/C++±ê×¼¿âµÄȫò¡£
C/C++±ê×¼¿âµÄÄÚ ......
ÎÊÌâÊÇÕâÑùµÄ£ºÔÚ²åÈëÒ»ÐÐÊý¾Ýǰ¾ÍÏëÒªÖªµÀ½«Òª²úÉúµÄid¡£±ÈÈç˵ÏëÓÃÀ´ÃüÃûÉÏ´«µÄÎļþ¡£Èç¹û²»ÊÂÏÈ»ñµÃid¾Í²»ÖªµÀÎļþÃû£¬¾Íû·¨ÔÚ²åÈëʱ°ÑÎļþ·¾¶±£´æµ½Êý¾Ý¿âÀïÁË¡£Èç¹û²»ÐèÒªÊÂÏÈ»ñµÃid£¬´ó¿ÉÒÔÔÚ²åÈëºóµ÷ÓÃmysql_insert_id()»òÕßÖ´ÐÐselect last_insert_id()£¬¾Í²»±ØÍùÏ¿´ÁË¡£ÎªÁËÕÕ¹ËÐÔ¼±µÄͬѧ£¬Ïȸø´ð°¸£º
$resul ......