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);¸ÄÎ
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬C/C++ÖеÄexeclÔõôµ÷ÓÃдºÃµÄjava³ÌÐò£¬
execl("/opt/java1.5/bin/java","MyClass",NULL);
ÕâÑùµÄ²»ÐÐŶ¡£
²»»á.
ÔËÐÐjava³ÌÐò
ÕÒ¹¤¾ß²é¿´Ò»ÏÂÄǸö³ÌÐòµÄÃüÁîÐÐ
ËÑË÷Ï£ºjni ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÓÐÒ»10*10¾ØÕ󣬳ýÈ¥µÚÒ»¸öµã£¨0£¬0£©ºÍ×îºóÒ»µã£¨9£¬9£©£¬»¹Óа˸öµãΪ1£¬ÆäËû¶¼Îª0£¬ÒªÇóÓöþάÊý×é±íʾ¡£°Ë¸öµãÊÇËæ»úÉú³ÉµÄ£¬±àдÏà¹Ø³ÌÐò±íʾ¾ØÕóËùÓпÉÄÜÇé¿ö¡£
ÕæÐÄÇó½Ì¸÷λ¸ßÊÖ£¬°¥£¡±¾ÈËÌ«²ËÁË£¡ºÇºÇ£¡
......