数据库实验报告6.docx

数据库原理实验报告题目：实验六:ODBC/JDBC数据库编程学号姓名班级日期xxxxxxxxxxxx2016.10.29一. 实验内容、步骤以及结果1.ODBC配置以及程序调试：（50分）(1)配置一个ODBC数据源，要求数据源名称：student，其中包含s(学生信息)表。1.用系统工具配置ODBC，点击“添加”：2.出现以下对话框，选中SQL Sever，点击完成3.在出现的对话框中设置属性，如图，点击下一步，点击下一步后出现如下，更改默认数据库，点击下一步。4.在出现的对话框中点击测试连接后出现测试成功的对话框，点击确定退出ODEC数据源管理器。(2)阅读并运行实验给出的例子程序，理解ODBC编程，要求简单写出自己对这段程序的理解或者流程图，并且请给出程序运行结果示例图。l 定义句柄，变量l 初始化环境l 建立连接l 初始化语句句柄l 执行语句l 结果集中处理l 输出，释放句柄l 结果如下实例运行结果如下：2.参考给出的ODBC编程示例，使用ODBC技术，编写一个简单的程序，包含对数据库SPJ的连接，查询，插入，修改和删除。（50分）插入：查询：修改：删除：代码：#include stdafx.h#include#include#include #include #include#include#includeusing namespace std;int main()SQLHENV henv;/环境句柄SQLHDBC hdbc;/连接句柄SQLHSTMT hstmt; /语句句柄char sql_order100;SQLRETURN ret;SQLCHAR sno50, sname50, ssex50, sbirth50, sdept50;SQLINTEGER cbsno = SQL_NTS, cbsname = SQL_NTS, cbssex = SQL_NTS, cbsbirth = SQL_NTS, cbsdept = SQL_NTS;ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);ret = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);ret = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);ret = SQLConnect(hdbc, (SQLCHAR*)student, SQL_NTS, (SQLCHAR*)sa, SQL_NTS, (SQLCHAR*)123, SQL_NTS);if (!SQL_SUCCEEDED(ret)return -1;ret = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);int demo;while (1)cout 1.insert 2.select 3.delete 4.update 0.exit demo;if (demo = 0)break;else if (demo = 3)cout 输入删除语句 endl;getchar();gets_s(sql_order);ret = SQLExecDirect(hstmt, (SQLCHAR*)sql_order, SQL_NTS);if (ret = SQL_SUCCESS | ret = SQL_SUCCESS_WITH_INFO)cout 删除成功 endl;SQLFreeHandle(SQL_HANDLE_STMT, hstmt);else if (demo = 4)cout 输入更新语句 endl;getchar();gets_s(sql_order);ret = SQLExecDirect(hstmt, (SQLCHAR*)sql_order, SQL_NTS);if (ret = SQL_SUCCESS | ret = SQL_SUCCESS_WITH_INFO)cout 删除成功 endl;SQLFreeHandle(SQL_HANDLE_STMT, hstmt);else if (demo = 2)printf(输入SQL查询语句n);getchar();gets_s(sql_order);ret = SQLExecDirect(hstmt, (SQLCHAR*)sql_order, SQL_NTS);if (ret = SQL_SUCCESS | ret = SQL_SUCCESS_WITH_INFO)ret = SQLBindCol(hstmt, 1, SQL_C_CHAR, sno, 50, 0);ret = SQLBindCol(hstmt, 2, SQL_C_CHAR, sname, 50, 0);ret = SQLBindCol(hstmt, 3, SQL_C_CHAR, ssex, 50, 0);ret = SQLBindCol(hstmt, 4, SQL_C_CHAR, sbirth, 50, 0);ret = SQLBindCol(hstmt, 5, SQL_C_CHAR, sdept, 50, 0);while (ret = SQLFetch(hstmt) != SQL_NO_DATA_FOUND)printf(%s%s%s%s%sn, sno, sname, ssex, sbirth, sdept);SQLFreeHandle(SQL_HANDLE_STMT, hstmt);elseprintf(依次输入插入的学号，姓名，性别，生日，学院n);scanf(%s%s%s%s%s, sno, sname, ssex, sbirth, sdept);ret = SQLPrepare(hstmt, (SQLCHAR*)insert into S values(?,?,?,?,?), SQL_NTS);if (ret = SQL_SUCCESS | ret = SQL_SUCCESS_WITH_INFO)ret = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, sno, 0, &cbsno);ret = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, sname, 0, &cbsname);ret = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, ssex, 0, &cbssex);ret = SQLBindParameter(hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0, sbirth, 0, &cbsbirth);ret = SQLBindParameter(hstmt, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 50, 0,