复件 cp.cpp

闲来无事写的一个七星彩的分析程序,数据库为mysql,在winxp与vc2005下编译通过

#include <windows.h>
#include <iostream>
#include <mysql.h>
#include <stdio.h>
#include <string.h>
#pragma comment(lib,"libmysql.lib ")
using namespace std;

int main()
{
    //connection params
    //FILE *file;
    char *host = "localhost";
    char *user = "root";
    char *pass = "xcqqcx";
    char *db = "cp";
    
    //sock
    MYSQL *sock;
    MYSQL_RES *results;
    MYSQL_ROW record;
	//int max_no1,max_no2,max_no3,max_no4,max_no5,max_no6,max_no7;
	//int min_no1,min_no2,min_no3,min_no4,min_no5,min_no6,min_no7;
	//int ave_no1,ave_no2,ave_no3,ave_no4,ave_no5,ave_no6,ave_no7;
	int i;
	char   sql[]="select no1 from tjno1 where tj=";
	char temp[255];
    sock = mysql_init(0);
    if (sock) 
        cout << "数据库初始化成功" << endl;
    else 
    {
        cout << "数据库初始化失败" << mysql_error(sock) << endl;
    }

    if (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0))
        cout << "数据库连接成功" << endl;
    else 
    {
        cout << "数据库连接失败: " << mysql_error(sock) << endl;
    }
    mysql_set_character_set(sock,"gb2312");
    
    //connection character set
    cout << "数据库连接字符设置: " << mysql_character_set_name(sock) << endl;

    //wait for posibility to check system/mysql sockets
/*    if(mysql_query(sock,"select * from lssj"))
    {
        cout<<"very good!"<<endl;                            
    }
    results=mysql_store_result(sock);
    printf(" 期数\t第一位\t第二位\t第三位\t第四位\t第五位\t第六位\t第七位\t\n");
    while(record = mysql_fetch_row(results))
    {
        printf("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s \n",record[0],record[1],record[2],record[3],record[4],record[5],record[6],record[7]);
    }*/
	mysql_query(sock,"drop table if exists tjno1");
	mysql_query(sock,"create table tjno1 select no1,count(no1) as tj from lssj group by no1");
    mysql_query(sock,"drop table if exists tjno2");
	mysql_query(sock,"create table tjno2 select no2,count(no2) as tj from lssj group by no2");
	mysql_query(sock,"drop table if exists tjno3");
	mysql_query(sock,"create table tjno3 select no3,count(no3) as tj from lssj group by no3");
	mysql_query(sock,"drop table if exists tjno4");
	mysql_query(sock,"create table tjno4 select no4,count(no4) as tj from lssj group by no4");
	mysql_query(sock,"drop table if exists tjno5");
	mysql_query(sock,"create table tjno5 select no5,count(no5) as tj from lssj group by no5");
	mysql_query(sock,"drop table if exists tjno6");
	mysql_query(sock,"create table tjno6 select no6,count(no6) as tj from lssj group by no6");
	mysql_query(sock,"drop table if exists tjno7");
	mysql_query(sock,"create table tjno7 select no7,count(no7) as tj from lssj group by no7");
	//取出第一位出现最多的数字的次数,和数字
	mysql_query(sock,"select max(tj) from tjno1");
	results=mysql_store_result(sock);
	i=0;
	 while(record = mysql_fetch_row(results))
    {
        printf("第一位最多的出现了%s次\n",record[0]);
		i= sprintf(temp,"%s", sql );
		i+=sprintf(temp+i," %s",record[0]);
    }
    mysql_query(sock,temp);
    results=mysql_store_result(sock);
	i=0;
	 while(record = mysql_fetch_row(results))
    {
        printf("第一位最多的是%s\n",record[0]);
		i=i+1;
    }

	mysql_free_result(results);
    mysql_close(sock);
	return EXIT_SUCCESS;
}