CÓïÑÔµ÷ÓÃmysql´æ´¢¹ý³Ì³ö´í ¼±¼±¼±£¡£¡£¡£¡
ÎÒÔÚmysqlÀïдÁËÒ»¸ö´æ´¢¹ý³Ì£¬ÔÚmysqlÀïµ÷ÓÃʱÕýÈ·µÄ£¬µ«ÊÇÎÒÏÖÔÚÏëÓÃCÓïÑÔµ÷ÓÃÕâ¸ö´æ´¢¹ý³Ì¡£´úÂëÈçÏ¡£
#include <windows.h>
#include <stdio.h>
#include <string.h>
#include <mysql.h>
//#include "winsock2.h"
void main()
{
MYSQL my_connection;
MYSQL_RES *res_ptr;
//MYSQL_RES *res;
MYSQL_ROW sqlrow;
mysql_init(&my_connection);
if(mysql_real_connect(&my_connection, "localhost", "root","0","abccs", 0, NULL, 0))
{
printf("Connection success\n");
if(mysql_query(&my_connection, "call sp(12)"))
{
printf("select error: %s\n", mysql_error(&my_connection));
}
else
{
res_ptr = mysql_store_result(&my_connection);
if(res_ptr)
{
printf("Retrieved %lu rows\n", (unsigned long)mysql_num_rows (res_ptr));
while (sqlrow = mysql_fetch_row(res_ptr))//ÿ´ÎÊä³öÿһÐÐ
{
unsigned int field_count;
field_count =0;
while(field_count < mysql_field_count(&my_connection))//ÁÐ
{
printf("%s ", sqlrow[field_count]);field_count++;
}
printf("\n");//»»ÐÐ
}
if(mysql_errno(&my_con
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒֻѧ¹ýÇ廪À¶·âÃæµÄCÓïÑÔ»ù´¡£¬Ïë¸üÉîÈëµÄѧϰ£¬¸Ã¿´Ê²Ã´ÊéºÃ£¿
C Primer Plus
C³ÌÐòÉè¼ÆÓïÑÔ(µÚ2°æÐ°æ)
CÓïÑÔ³ÌÐòÉè¼Æ_ÏÖ´ú·½·¨
CÓïÑԲο¼ÊÖ²áµÚÎå°æ
CÓïÑÔ´óÈ«
CºÍÖ¸Õë
CÏÝÚåÓëȱÏÝ
Cר¼Ò±à³Ì
......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎѡһ»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......