Linux C´´½¨MySQLÊý¾Ý¿â³öÏֶδíÎó
´ó¼ÒºÃ£¬ÏëÇë½Ìһϸ÷λ¼¸¸ö¶Î´íÎóµÄÎÊÌâ¡£´úÂëÈçÏ£º
createdb.c
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <mysql/mysql.h>
#include <syslog.h>
MYSQL mysql;
int main()
{
char *db=malloc(30),*user="root",*password="zxy2008",*host="localhost",*sql=malloc(300);
//char db_arr[30]={0};
db=NULL;
if(mysql_init(&mysql)==NULL)
{
printf("³õʼ»¯MySQLÊý¾Ý¿âʧ°Ü£¡\n");
return -1;
}
if(mysql_real_connect(&mysql,host,user,password,db,0,NULL,0)==NULL)
{
printf("Á¬½ÓMySQLÊý¾Ý¿âʧ°Ü£º%s!",mysql_error(&mysql));
return -1;
}
printf("ÇëÊäÈëÊý¾Ý¿âÃû£º\n");
scanf("%s",db);
//strcpy(db_arr,db);
sprintf(sql,"create database if not exists `%s`",db);
if(mysql_query(&mysql,sql))
{
printf("´´½¨Êý¾Ý¿âʧ°Ü£º%s!\n",mysql_error(&mysql));
return -1;
}
printf("³É¹¦´´½¨Êý¾Ý¿â!%s\n",db);
return 0;
}
±àÒ룺cc -o createdb $(mysql_config --cflags) createdb.c $(mysql_config --libs)
Ö´ÐУº./createdb
ÔËÐнá¹û£º
ÇëÊäÈëÊý¾Ý¿âÃû£º
zend
³É¹¦´´½¨Êý¾Ý¿â!(null)
Ϊʲô»á³öÏÖ¡°³É¹¦´´½¨Êý¾Ý¿â!(null)¡±ÄØ£¿
»¹ÓÐÒ»¸öÎÊÌ⣺½«//char db_arr[30]={0};ºÍ//strcpy(db_arr,db);µÄ×¢ÊÍÈ¥µô²¢½«printf("³É¹¦´´½¨Êý¾Ý¿â!%s\n",db);¸ÄÎ
Ïà¹ØÎÊ´ð£º
SHIFT¼ÓF10ÓëÄǸö¼üÓÒctrl±ßÉϵÄÄǸö¼ü¹¦ÄÜÒ»Ñù£¬ÏëÆÁÕâ¸ö
µ«²»ÖªÒªÔõôдÄǸö×éºÏ¼ü£¡
ÓÐûÄĸö´óÏÀ·ÅÒ»¶ÎÕâ¸öµÄ´úÂë»òдһ¶Î
http://topic.csdn.net/u/20090609/15/7dc9fb70-243f-4070-9cfd-34e48b66e6c6.html
......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎÑ¡Ò»»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......