Linux实验指导书(7)

______________________________________________________________________________________________________________________________________________________________ 步骤5：学习并使用C语言访问Mysql的基本方法，重新改写实验3步骤6要求的程序。要求使用数据库保存stu.info结构。

3、实验结论

_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

4、程序清单

//程序清单 7-1 #include #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 #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, \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

#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 #include #include #include #include #include

35

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Linux实验指导书(7)在线全文阅读。