数据库实验报告6

1、数据库原理实验报告题目：实验六:ODBC/JDBC数据库编程学号姓名班级日期xxxxxxxxxxxx2016.10.29一. 实验内容、步骤以及结果1.ODBC配置以及程序调试：（50分）(1)配置一个ODBC数据源，要求数据源名称：student，其中包含s(学生信息)表。1.用系统工具配置ODBC，点击“添加”：2.出现以下对话框，选中SQL Sever，点击完成3.在出现的对话框中设置属性，如图，点击下一步，点击下一步后出现如下，更改默认数据库，点击下一步。4.在出现的对话框中点击测试连接后出现测试成功的对话框，点击确定退出ODEC数据源管理器。(2)阅读并运行实验给出的例子程序，理解O

2、DBC编程，要求简单写出自己对这段程序的理解或者流程图，并且请给出程序运行结果示例图。l 定义句柄，变量l 初始化环境l 建立连接l 初始化语句句柄l 执行语句l 结果集中处理l 输出，释放句柄l 结果如下实例运行结果如下：2.参考给出的ODBC编程示例，使用ODBC技术，编写一个简单的程序，包含对数据库SPJ的连接，查询，插入，修改和删除。（50分）插入：查询：修改：删除：代码：#include "stdafx.h"#include<Windows.h>#include<iostream>#include <sql.h> #includ

3、e <sqlext.h> #include<sqltypes.h>#include<string>#include<cstdio>using 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_

4、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&

5、quot;, 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 " <<

6、"4.update " << "0.exit"<<endl;cin >> 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

7、)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 <<

8、"删除成功" << 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, 5

9、0, 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",

10、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 = S

11、QL_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_CHA