将注册信息mysql数据库_C程序将注册信息保存到数据库

#include

#include

#include

#include

#include

using namespace std;

string name;

string password1;

void Output()

{

char temp;

cout<

cin>>temp;

if(temp=='N')

{

cout<

cout<

cin>>name;

cout<

cout<

cin>>password1;

cout<

}

}

int GetCurTime(char *strTime,int type)

{

time_t t;

struct tm *tm = NULL;

t = time(NULL);

if(t == -1)

{

return -1;

}

tm = localtime(&t);

if(tm == NULL)

{

return -1;

}

if(type == 0)

sprintf(strTime,"系统运行时间为: %d-%d-%d %d:%d:%d\n",tm->tm_year + 1900,tm->tm_mon + 1,tm->tm_mday,tm->tm_hour,tm->tm_min,tm->tm_sec);

else if(type == 1)

sprintf(strTime,"%d-%d-%d %d:%d:%d",tm->tm_year + 1900,tm->tm_mon + 1,tm->tm_mday,tm->tm_hour,tm->tm_min,tm->tm_sec);

else if(type == 2)

sprintf(strTime,"%d-%d-%d",tm->tm_year + 1900,tm->tm_mon + 1,tm->tm_mday);

return 1;

}

int main()

{

MYSQL *conn;

MYSQL_RES *res;

MYSQL_ROW row;

char server[] = "localhost";

char user[] = "root";

char password[] = "123";

char database[] = "chat";

char time1[12]; //只要跟数据库有关的，定义都要以这种形式，不能char *time1不然会报错“段错误”

int num_row; //记录数

GetCurTime(time1,2);

Output();

conn = mysql_init(NULL);

cout<

if (!mysql_real_connect(conn, server,user, password, database, 0, NULL, 0))

{

fprintf(stderr, "%s\n", mysql_error(conn));

exit(1);

}

else

cout<

if(!(mysql_query(conn,"select * from user_infor")))

{

cout<

res=mysql_store_result(conn);

num_row=(int)mysql_num_rows(res);

}

else

cout<

char query[200];

sprintf(query,"insert into user_infor value(%d,'%s','%s','%s')",num_row,name.c_str(),password1.c_str(),time1);

if (mysql_query(conn, query))

{

fprintf(stderr, "%s\n", mysql_error(conn));

exit(1);

}

else

cout<

mysql_close(conn);

printf("finish! \n");

return 0;

}