______________________________________________________________________________________________________________________________________________________________ 步骤5：学习并使用C语言访问Mysql的基本方法，重新改写实验3步骤6要求的程序。要求使用数据库保存stu.info结构。
3、实验结论
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
4、程序清单
//程序清单 7-1 #include
#include \
MYSQL my_connection; MYSQL_RES *res_ptr; MYSQL_ROW sqlrow;
int main(int argc, char *argv[]) { int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, \
\ printf(\
res = mysql_query(&my_connection, \age > 5\
if (res) {
printf(\ } else {
res_ptr = mysql_store_result(&my_connection);
31
if (res_ptr) {
printf(\ while ((sqlrow = mysql_fetch_row(res_ptr))) { printf(\ }
if (mysql_errno(&my_connection)) {
fprintf(stderr, \ } }
mysql_free_result(res_ptr); }
mysql_close(&my_connection);
} else {
fprintf(stderr, \ if (mysql_errno(&my_connection)) {
fprintf(stderr, \
mysql_errno(&my_connection), mysql_error(&my_connection)); } }
return EXIT_SUCCESS; }
//程序清单 7-2 #include
int main(int argc, char *argv[]) { MYSQL my_connection; int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, \
\ printf(\
res = mysql_query(&my_connection, \INTO children(fname, age) VALUES('Ann', 3)\
if (!res) {
printf(\long)mysql_affected_rows(&my_connection));
32
} else {
fprintf(stderr, \ mysql_error(&my_connection)); }
mysql_close(&my_connection); } else {
fprintf(stderr, \ if (mysql_errno(&my_connection)) {
fprintf(stderr, \
mysql_errno(&my_connection), mysql_error(&my_connection)); } }
return EXIT_SUCCESS; }
//程序清单 7-3 #include
#include \
int main(int argc, char *argv[]) { MYSQL my_connection; int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, \
\ printf(\
res = mysql_query(&my_connection, \'Ann'\
if (!res) {
printf(\long)mysql_affected_rows(&my_connection)); } else {
fprintf(stderr, \ mysql_error(&my_connection)); }
mysql_close(&my_connection);
33
} else {
fprintf(stderr, \ if (mysql_errno(&my_connection)) {
fprintf(stderr, \
mysql_errno(&my_connection), mysql_error(&my_connection)); } }
return EXIT_SUCCESS; }
34
实验八 Linux下网络编程
1、实验目的
学习和掌握socket函数的基本使用方法。 2、实验内容和步骤
步骤1：输入、编译并运行程序8-1和8-2，写出程序的执行结果。
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 步骤 2：学习并使用socket函数的基本使用方法，完善并重新改写前几个实验实现的程序。要求用户在客户端实现数据操作请求的输入，然后上传到服务器端完成对数据库的实际操作。同学在实现时应尽可能的使用前几个实验的成果，即应该包括多线程或多进程、数据库以及socket等。
3、实验结论
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
4、程序清单
//程序清单 8-1
/* Make the necessary includes and set up the variables. */
#include
35