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);¸ÄÎ
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÓÐÒ»10*10¾ØÕ󣬳ýÈ¥µÚÒ»¸öµã£¨0£¬0£©ºÍ×îºóÒ»µã£¨9£¬9£©£¬»¹Óа˸öµãΪ1£¬ÆäËû¶¼Îª0£¬ÒªÇóÓöþάÊý×é±íʾ¡£°Ë¸öµãÊÇËæ»úÉú³ÉµÄ£¬±àдÏà¹Ø³ÌÐò±íʾ¾ØÕóËùÓпÉÄÜÇé¿ö¡£
ÕæÐÄÇó½Ì¸÷λ¸ßÊÖ£¬°¥£¡±¾ÈËÌ«²ËÁË£¡ºÇºÇ£¡
......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......