#include?
#include?
#include?
#include?

#define?HOST?“127.0.0.1“
#define?USERNAME?“root“
#define?PASSWORD?““
#define?DATAbase?“phone_db“
#define?typedef?enum{false=0true=1}?bool;


?int?main（int?argc?char?*argv[]）?{
	char?op;
????????void?payForTel（）;
????????void?queryBalance（）;
????????void?menu（char*?tittlechar*?menu[]int?argc）;
????????printf（“--------------------------------\n“）;
	char*?mainMenu[]={“Exit?Now““PayForTel““queryBalance“};
	while（1）{
????????menu（“Pay?For?Telephone?System“mainMenu3）;
????????printf（“Please?choose?one?operation“）;
	op=getchar（）;
????????getchar（）;
	switch（op）{
	case?‘0‘:?return?0;
	case?‘1‘:?payForTel（）;break;
	case?‘2‘:?queryBalance（）;break;
	default:?printf（“Error?input!“）;
	}
	}
	return?0;?
?}
?
???void?menu（char*?tittlechar*?menu[]int?argc）{
????????int?i;
	printf（“\n\n\t\t\t----------%s----------\n“tittle）;
	for（i=0;i????????{
	?printf（“\t\t\t%d.--------%s\n“imenu[i]）;
	}
	printf（“\t\t\t--------------------------------------\n“）;
???????}




void?payForTel（）{
char?a[20];
char?b[20];
printf（“-----------------------“）;
printf（“Please?input?your?telephone?num“）;
scanf（“%s“a）;
printf（“Please?input?your?money:“）;
scanf（“%s“b）;

void?updatePhonePrice（char*?achar*?b）;
updatePhonePrice（ab）;
}


void?exe_sql（char*?sql）?{
?
????MYSQL?my_connection;
????int?res;?
?
????mysql_init（&my_connection）;
??

????if?（mysql_real_connect（&my_connection?HOST?USERNAME?PASSWORD?DATAbase
??????????????0?NULL?CLIENT_FOUND_ROWS））?{
??
??????????printf（“connect?success!\n“）;
??
??
??????????mysql_query（&my_connection?“set?names?utf8“）;

?????????res?=?mysql_query（&my_connection?sql）;
??
??????????if?（res）?{
??????????????printf（“Error:?mysql_query!\n“）;

??????????????mysql_close（&my_connection）;
??????????}?else?{
??????????????printf（“%d?row?effected!\n\n“?mysql_affected_rows（&my_connection））;
??????????????mysql_close（&my_connection）;
??????????}
??
??????}?else?{
??????????printf（“connect?failed!\n“）;
??????}
??}
void?query_sql（char*?sql）?{
??????MYSQL?my_connection;?
??????int?res;?
??????MYSQL_RES?*res_ptr;
??????MYSQL_FIELD?*field;
??????MYSQL_ROW?result_row;?
?
??????int?row?column;?
??????int?i?j;?
??????mysql_init（&my_connection）;
??????if?（mysql_real_connect（&my_connection?HOST?USERNAME?PASSWORD?DATAbase
??????????????0?NULL?CLIENT_FOUND_ROWS））?{
????????????????
????????????????/*Connection?success*/
????????????????printf（“database?connect?success!\n“）;
??
??????????mysql_query（&my_connection?“set?names?utf8“）;
??
??????????res?=?mysql_query（&my_connection?sql）;
??
??????????if?（res）?{???????????????
??????????????printf（“Error:?mysql_query!\n“）;
??????????????mysql_close（&my_connection）;
??????????}?else?{
??????????????
??????????????res_ptr?=?mysql_store_result（&my_connection）;
	??????if?（res_ptr）?{
??????????????????column?=?mysql_num_fields（res_ptr）;
??????????????????row?=?mysql_num_rows（res_ptr）;
??????????????????printf（“

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????5247012??2011-09-08?14:01??手機(jī)繳費(fèi)系統(tǒng)\mysql-3.23.54a-11.i386.rpm

?????文件?????580038??2011-09-08?14:01??手機(jī)繳費(fèi)系統(tǒng)\mysql-devel-3.23.54a-11.i386.rpm

?????文件??????16747??2012-06-20?19:24??手機(jī)繳費(fèi)系統(tǒng)\phone

?????文件???????6164??2012-06-20?04:40??手機(jī)繳費(fèi)系統(tǒng)\phone.c

?????文件???????5928??2012-06-20?19:22??手機(jī)繳費(fèi)系統(tǒng)\phone.o

?????文件?????165376??2012-06-21?15:41??手機(jī)繳費(fèi)系統(tǒng)\手機(jī)繳費(fèi)系統(tǒng).doc

?????文件????????446??2012-06-19?20:55??手機(jī)繳費(fèi)系統(tǒng)\數(shù)據(jù)庫腳本.sh

?????文件????????446??2012-06-19?20:55??手機(jī)繳費(fèi)系統(tǒng)\數(shù)據(jù)庫腳本.txt

?????目錄??????????0??2012-06-21?15:42??手機(jī)繳費(fèi)系統(tǒng)

-----------?---------??----------?-----??----

??????????????6022157????????????????????9