56,679
社区成员
发帖
与我相关
我的任务
分享
myconnect = mysql_init(myconnect);
if (mysql_real_connect (myconnect, "localhost", (char*)(DB_USER), (char*)(DB_PWD),(char*)(DB_NAME), MYSQL_PORT,NULL,0)== NULL)
{
perror("未能连接上数据库");
}
struct timeval start, end;
long timeuse;
gchar query_buf[255];
sprintf(query_buf, "select * from DZJC_T_CSDM_B where DMLB = '1'");
gettimeofday(&start, NULL);
if(mysql_query(myconnect, query_buf)==0)
{
gettimeofday(&end, NULL);
timeuse = 1000000 * ( end.tv_sec - start.tv_sec ) + end.tv_usec - start.tv_usec;
printf("sql query time = %ld\n", timeuse);
sprintf(query_buf, "select * from DZJC_T_CSDM_B where DMLB = 1");
sprintf(query_buf, "select * from DZJC_T_CSDM_B where DMLB = 1");