linuxÏÂgtkÖÐʹÓÃCÁ¬½Ómysql
Code:
1.»·¾³ÅäÖÃ
Ò»°ãÇé¿öϰ²×°ÁËMySQLµÄ»úÆ÷ºÜÉÙ°²×°¿ª·¢°ü£¬Õâ¸öÐèҪעÒâ¡£Ò²¾ÍÊÇÄúÐèÒªÔÚ³ÌÐòÖаüº¬ÕâÑùµÄÓï¾ä£º
#include <mysql.h>
Èç¹ûÔÚ±àÒëµÄʱºòÌáʾº¬ÓÐÀàËÆÓÚÕÒ²»µ½ mysql.h µÄÐÅÏ¢£¬Õâ¾Í˵Ã÷ÄúûÓа²×°Ïà¹Ø¿ª·¢°ü¡£
»¹ÓÐÄú±ØÐ뽨Á¢Ò»¸öÊý¾Ý¿âÓëһЩ±í£¬Õâ¸öÔÚ±¾ÎÄÖлáʹÓá£
2.ÎÒÃÇÏÈÁ´½ÓÊý¾Ý¿â¡£
/****Á¬½Ó****Êý¾Ý¿â****/
#include <mysql.h> /*°üº¬Îļþ*/
MYSQL *myconnect = NULL; /*¶¨ÒåÒ»¸öMYSQLÀàÐ͵ÄÖ¸Õ룬Ëü´ú±íµÄÊÇMySQLÊý¾Ý¿âµÄ²Ù×÷¶ÔÏó*/
GtkWidget *disconnect (void) /*ÕâÀïÊÇÎÒÔÏÈÒ»¸ö³ÌÐòÖÐÓùýµÄº¯Êý£¬²¢²»ÊôÓÚ±¾ÎÄÖØµã*/
{
char *user = "root", *pwd = "", *dbname = "test"; /*ÕâÀïÒª×÷Êʵ±Ð޸ģ¬ÓÃÊý¾Ý¿âÓû§root£¬Óû§ÃÜÂëΪ¿Õ£¬Á¬½ÓtestÊý¾Ý¿â*/
myconnect = mysql_init(myconnect); /*Óú¯Êýmysql_init³õʼ»¯myconnect*/
if (mysql_real_connect (myconnect, "localhost", user, pwd,dbname,MYSQL_PORT,NULL,0)== NULL)
{
error("δÄÜÁ¬½ÓÉÏÊý¾Ý¿â.");
}
/*Óú¯Êýmysql_real_connectÁ¬½ÓÊý¾Ý¿â£¬ËüÐèÒª8¸ö²ÎÊý£¬ÓëÒÔÉ϶ÔÓ¦·Ö±ðÊÇ£º1.³õʼ»¯µÄMySQL½á¹¹£¬2.ËùÒªÁ´½ÓµÄÊý¾Ý¿âµÄIPµØÖ·»òÖ÷»úÃû£¬3.Á´½ÓÊý¾Ý¿âµÄÓû§£¬4.Óû§¿ÚÁ5.Êý¾Ý¿âÃû£¬6.¶Ë¿ÚºÅ£¬ÉϱߵÄMYSQL_PORTÊÇÒ»¸öºê£¬Èç¹ûÒ»Çж¼ÊÇĬÈϵϰ²»ÓÃÏÔʽ¶¨Ò壬7.Ì×½Ó×Ö£¬Ò»°ãΪNULL£¬8.Õâ¸ö²ÎÊýÒ»°ãΪ0¡£µ±È»£¬²¢²»ÊÇ8¸ö²ÎÊý¶¼±ØÐëдÉÏ£¬Ò»Ð©²ÎÊý¿ÉÒÔÒÔºóÔÙÓá£*/
}
3.µäÐͲÙ×÷
²åÈë²Ù×÷£º
gchar query_buf [100]; /*¶¨ÒåÒ»¸öÊý×éÓÃÀ´´æ·ÅSQLÓï¾ä*/
const gchar *username,*passwd,*passwd_ffirm,*email,*email_ffirm;
................/*ÕâÀïÊ¡ÂÔ¶ÔusernameµÈµÄ¸³ÖµÓï¾ä*/
sprintf (query_buf,"INSERT INTO Users values (\'%s\',\'%s\',\'%s\',\'%s\')",NULL,username,passwd,email);/*½«Óï¾ä´æ·ÅÔÚÊý×équery_bufÖУ¬ÎÒÔÚÊý¾Ý¿âµÄUsers±íÖеÚÒ»¸öÊÇ×Ô¶¯Ôö³¤µÄID£¬ËùÒÔµÚÒ»¸öÐè²åÈëNULL¡£×¢Ò⣺SQLÖеĵ¥ÒýºÅµÈ²»ÄÜÖ±½Ó³öÏÖÔÚCÓïÑÔÖУ¬ÐèÒªÓÃתÒå×Ö·û*/
if (mysql_query (myconnect,query_buf) == 0) /*mysql_queryÖ´Ðк¯ÊýÖ´Ðгɹ¦·µ»Ø0*/
{
ok("×¢²á³É¹¦.");
}
else
{ error("×¢²áʧ°Ü!¿ÉÄÜÊÇÒѾ´æÔÚÕâ¸öÓû§Ãû³ÆÁË¡£Çë³¢ÊÔ»»Ò»¸öÓû§Ãû¡£"); }
ɾ³ýµÈ²Ù×÷ÀàËÆ¡£
SELECT²Ù×÷£º
MYSQL_RES *sqlres;
Ïà¹ØÎĵµ£º
¿â´Ó±¾ÖÊÉÏÀ´ËµÊÇÒ»ÖÖ¿ÉÖ´ÐдúÂëµÄ¶þ½øÖƸñʽ£¬¿ÉÒÔ±»ÔØÈëÄÚ´æÖÐÖ´ÐС£¿â·Ö¾²Ì¬¿âºÍ¶¯Ì¬¿âÁ½ÖÖ¡£
¾²Ì¬¿âºÍ¶¯Ì¬¿âµÄÇø±ð
1. ¾²Ì¬º¯Êý¿â
ÕâÀà¿âµÄÃû×ÖÒ»°ãÊÇlibxxx.a£»ÀûÓþ²Ì¬º¯Êý¿â±àÒë³ÉµÄÎļþ±È½Ï´ó£¬ÒòΪÕû¸ö º¯Êý¿âµÄËùÓÐÊý¾Ý¶¼»á±»ÕûºÏ½øÄ¿±ê´úÂëÖУ¬ËûµÄÓŵã¾ÍÏÔ¶øÒ×¼ûÁË£¬¼´±àÒëºóµÄÖ ......
Ò»¡¢ÆÁÄ»²Ù×÷º¯Êý
1. clrscr()Çå³ý×Ö·û´°¿Úº¯Êý
2. window()×Ö·û´°¿Úº¯Êý
3. gotoxy()¹â±ê¶¨Î»º¯Êý
4. clreol() Çå³ý¹â±êÐÐβ×Ö·ûº¯Êý
5. insline() ²åÈë¿ÕÐк¯Êý
6. delline() ɾ³ýÒ»Ðк¯Êý
7. gettext() ¿½½øÎÄ×Öº¯Êý
8. puttext() ¿½³öÎÄ×Öº¯Êý
9. movetext() ÒÆ¶¯ÎÄ×Öº¯Êý
¶þ¡¢×Ö·ûÊôÐÔº¯Êý
10. textmode( ......
CÊä³ö¸ñʽ×ܽá
2007-07-08 12:09
1 Ò»°ã¸ñʽ
printf(¸ñʽ¿ØÖÆ£¬Êä³ö±íÁУ©
ÀýÈ磺printf("i=%d,ch=%c\n",i,ch);
˵Ã÷:
(1)“¸ñʽ¿ØÖÆ”ÊÇÓÃ˫ƲºÅÀ¨ÆðÀ´µÄ×Ö·û´®£¬Ò²³Æ“ת»»¿ØÖÆ×Ö·û´®”£¬Ëü°üÀ¨Á½ÖÖÐÅÏ¢£º
&nbs ......
1.ÒýÑÔ
±¾ÎĵÄд×÷Ä¿µÄ²¢²»ÔÚÓÚÌṩC/C++³ÌÐòÔ±ÇóÖ°ÃæÊÔÖ¸µ¼£¬¶øÖ¼ÔÚ´Ó¼¼ÊõÉÏ·ÖÎöÃæÊÔÌâµÄÄÚº¡£ÎÄÖеĴó¶àÊýÃæÊÔÌâÀ´×Ô¸÷´óÂÛ̳£¬²¿·ÖÊÔÌâ½â´ðÒ²²Î¿¼ÁËÍøÓѵÄÒâ¼û¡£
Ðí¶àÃæÊÔÌâ¿´ËÆ¼òµ¥£¬È´ÐèÒªÉîºñµÄ»ù±¾¹¦²ÅÄܸø³öÍêÃÀµÄ½â´ð¡£ÆóÒµÒªÇóÃæÊÔÕßдһ¸ö×î¼òµ¥µÄstrcpyº¯Êý¶¼¿É¿´³öÃæÊÔÕßÔÚ¼¼ÊõÉϾ¿¾¹´ï ......