#include <winsock.h>
#include <stdio.h>
#include <mysql.h>
#pragma comment( lib, "libmysql.lib")
MYSQL *conn,*conn1;
MYSQL_RES *res,*res1;
MYSQL_ROW row,row1;
int i;
char dbpassword[6];
int main(int argc, char* argv[])
{
char sqlbuf[100];
for(i=0;i<6;i++)
scanf("%c",&dbpassword[i]);
if(argc!=2)
{
printf("You should input two paras;");
return 0;
}
sprintf(sqlbuf,"select Sname,Sno from student where Sno=%s",argv[1]);
conn=mysql_init(NULL);
/*res1=mysql_store_result(conn1);
row1=mysql_fetch_row(res1);
while(row1!=NULL)
{
if(strcmp(dbpassword,row1[0])!=0)
row1=mysql_fetch_row(res1);
}
if(row1==NULL)printf("error");*/
if(mysql_real_connect(conn,"localhost","root",dbpassword,"school",3306,NULL,0)==NULL)
{
printf("connect failed.\n");
};
if(mysql_query(conn,sqlbuf)!=0)
{
printf("query failed.\n");
}
else
{
res=mysql_store_result(conn);
if(res==NULL)
printf("get result failed.\n");
else
{
row=mysql_fetch_row(res);
while(row!=NULL)
{
printf("%s\n",row[0]?row[0]:"NULL");printf("%s\n",row[1]?row[1]:"NULL");
row=mysql_fetch_row(res);
}
}
}
mysql_close(conn);
return 0;
}
//"1 or true" "1 or 1=1"
评论0